MS SQL Server DBA
Techgene Solutions LLC
Omaha, United States of America
3 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
EnglishJob location
Omaha, United States of America
Tech stack
Amazon Web Services (AWS)
Azure
Cloud Database
Cloud Engineering
Cluster Analysis
Databases
Continuous Integration
Data Recovery
Database Security
DevOps
Log Shipping
Microsoft SQL Server
SQL Azure
MongoDB
NoSQL
Online Transaction Processing
Performance Tuning
Powershell
Query Optimization
SQL Server Agent
T-SQL
Backup and Restore
Indexer
Amazon Web Services (AWS)
Kubernetes
SolarWinds (Software)
Cassandra
Cosmos DB
Data Management
Redgate
SQL Server Management Studio (SSMS)
Docker
Job description
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., * 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.
Requirements
- 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.