Database Administrator (MSSQL & MongoDBL) - Part-Time

Role Overview

We are seeking a hands-on Operations DBA to support the mission-critical system operating in a secured environment.

Key responsibilities
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 and Perform root cause analysis (RCA) & implement 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
• Optimise indexing strategies and execution plans

MongoDB

• Manage Replica Sets & automate failover
• Monitor memory, disk and index performance
• Manage backup/restore and periodic recovery validation
• Maintain cluster health and sharding (if applicable)

3. Performance & Capacity Management

• Conduct proactive health checks
• Analyse: Query execution plans (MSSQL), Slow queries and indexing (MongoDB), Perform database tuning & optimisation and 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.
• Manage: Role-based access control & auditing and logging
• Support vulnerability (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: 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

Interested candidates, please send your CVs on [email protected]

Regret to inform that only shortlisted candidates will be notified.

CEI: R1988671

EA License: 14C7275