MS SQL Server DBA

Role: MS SQL Server DBA

Location: Omaha, NE

Duration: Contract

MS SQL Server DBA SME Transactional & NoSQL Data Platforms

Job Summary

Seeking an experienced SQL Server DBA SME to manage enterprise transactional and NoSQL data platforms. The role involves SQL Server administration, performance tuning, HA/DR, database security, automation, cloud support, and production support for mission-critical applications.

Key Responsibilities

• Administer and support SQL Server 2016/2019/2022 environments.
• Manage OLTP transactional databases and optimize performance.
• Configure HA/DR solutions including Always On, Clustering, Log Shipping, and Replication.
• Perform backup, recovery, patching, migration, and database upgrades.
• Troubleshoot slow queries, blocking, deadlocks, and performance issues.
• Implement database security, encryption, and access controls.
• Support NoSQL platforms such as MongoDB, Cassandra, or Cosmos DB.
• Automate DBA activities using T-SQL, PowerShell, and SQL Agent Jobs.
• Support Azure SQL / AWS RDS environments.
• Monitor database health, capacity, and availability.
• Provide production support and participate in incident resolution.

Required Skills

• Strong SQL Server DBA experience
• T-SQL and query optimization
• Performance tuning and indexing
• HA/DR implementation
• Backup & recovery strategies
• SQL Server security and auditing
• NoSQL database exposure
• Cloud database experience (Azure/AWS)
• Scripting and automation skills

Preferred

• Experience with Docker/Kubernetes
• DevOps/CI-CD exposure
• Enterprise transactional systems experience

Tools & Technologies

• SQL Server, T-SQL, SSMS, Always On, Replication, PowerShell, Azure SQL, AWS RDS, MongoDB, Cassandra, Cosmos DB, SQL Agent, Redgate, SolarWinds.