Senior Database Administrator (SQL Server & MongoDB)

Job Summary

The Senior Database Administrator (Level 9) is responsible for operational support, maintenance, and optimization of enterprise database platforms including Microsoft SQL Server and MongoDB. This role focuses on reliable production operations, incident resolution, and continuous improvement while working independently on complex systems.

Key Accountabilities

Administer and support enterprise SQL Server and MongoDB environments across distributed infrastructure
Perform day-to-day operational support including monitoring, patching, performance tuning, and capacity management
Actively participate in incident, problem, and change management processes
Lead root cause analysis (RCA) and implement preventative solutions
Support high availability (HA) and disaster recovery (DR) solutions (AGs, clustering, replica sets, sharding)
Execute and validate backup and recovery processes for both platforms
Utilize MongoDB Ops Manager for monitoring, patching, automation, and operational visibility




Develop and maintain automation scripts (PowerShell, Python, Bash, T-SQL, Mongo Shell)
Monitor system health using metrics, logs, and observability tools
Collaborate with Engineering and stakeholders to improve stability and performance
Support infrastructure deployments and workplace builds (on-prem and cloud)
Ensure adherence to security, audit, and compliance requirements

Technical Responsibilities

Manage:
SQL Server: backups, indexing, query tuning, clustering
MongoDB: replica sets, sharding, backups, performance tuning
Perform performance analysis and tuning across both platforms
Troubleshoot cross-layer issues (OS, network, storage, database)
Support cloud environments (Azure / MongoDB Atlas)
Maintain runbooks, SOPs, and technical documentation
Required Experience & Skills

8+ years of DBA experience (SQL Server and/or MongoDB)
Hands-on experience with:
SQL Server administration and T-SQL
MongoDB operations incl

📌 Database Administrator (India)
🏢 Cognizant
📍 India