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.