1. 24/7 Production Database Operations
- Provide L2/L3 support for MSSQL and MongoDB in Production and DR environments.
- Participate in standby/on-call roster for critical incidents.
- Troubleshoot and resolve:
- Database outages
- Always On failover issues
- Blocking / deadlocks
- Performance bottlenecks
- Storage / IOPS constraints
- Perform root cause analysis
- (RCA) and impleme nt preventive measures.
2. High Availability & Reliability Management
Microsoft SQL Server (MSSQL)
- Manage Always On Availability Groups.
- Monitor replication and failover health.
- Perform database patching and cumulative updates.
- Maintain backup and restore strategy (Full, Differential, Log backups).
- Conduct periodic DR drills and restoration validation.
- Optimize indexing strategies and execution plans.
MongoDB
- Manage Replica Sets and automatic failover.
- Monitor memory, disk, and index performance.
- Manage backup/restore and periodic recovery validation.
- Maintain cluster health and shading (if applicable).
3. Performance & Capacity Management
- Conduct proactive health checks.
- Query execution plans (MSSQL)
- Slow queries and indexing (MongoDB)
- Perform database tuning and optimization.
- Forecast capacity growth and scaling requirements.
4. Change & Release Support
Review database scripts prior to production deployment.
Support data migration and release windows.
Validate database stability post-deployment.
Ensure proper rollback and recovery procedures are in place.
5. Security & Compliance (Government Environment)
- Implement database security hardening.
- Role-based access control
- Auditing and logging
- Support vulnerability assessment (VA) remediation.
- Ensure compliance with government security policies.
- Maintain proper documentation and SOPs for audit readiness.
Technical Requirements
- 5-8+ years of DBA experience.
- Strong hands-on experience in Microsoft SQL Server (Always On, HA, Performance Tuning), MongoDB (Replica Sets, Backup/Restore)
- Experience supporting 24/7 mission-critical systems.
- Experience handling Severity 1 production incidents.
- Experience in supporting application deployment (data patching, data seed etc.)
- Strong troubleshooting and analytical skills.
