Database Administrator (MSSQL & MongoDB) – Day 2 Operations

Ascendion Engineering Solutions Singapore Pte. Ltd; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

Ascendion Engineering Solutions Singapore Pte. Ltd is seeking an experienced Operations DBA to ensure 24/7 production stability for MSSQL and MongoDB in a secured government environment.

The role focuses on high availability, incident response, performance tuning, and DR readiness across SQL Server and MongoDB platforms. The role requires strong troubleshooting, root-cause analysis, and the ability to manage on-call rotations and deployment-related changes while maintaining strict security

Qualifications

• 5–8+ years of DBA experience in production environments.
• Strong hands-on experience in MSSQL Always On, high availability, and performance tuning.
• MongoDB replica sets, backup/restore operations.

Responsibilities

• 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 outages, blocking/deadlocks, performance bottlenecks, and storage/IOPS constraints.
• Manage Always On Availability Groups, monitor replication and failover health, perform patching, backups, and restore strategy, and conduct DR drills with validation.
• Conduct proactive health checks, analyze query plans and slow queries, perform database tuning and capacity forecasting.
• Review database changes prior to production deployment, support data migrations and release windows, ensure rollback procedures.

Skills

Microsoft SQL Server

MongoDB

Job description

We are seeking a hands-on Operations DBA to support the mission-critical system operating in a secured environment. This role focuses primarily on Production (Day 2) stability, high availability, incident response, performance tuning, and disaster recovery readiness for Microsoft SQL Server and MongoDB platforms supporting 24/7 operations.

The DBA will work closely with:

Day 2 Infra Engineers

Day 2 System Engineers

Day 2 Software Engineers

Security & Compliance teams

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 Perform root cause analysis (RCA) and 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. 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 sharding (if applicable).

3. Performance & Capacity Management

Conduct proactive health checks. Analyze: 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 s 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

Implement database security hardening. Manage: 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 Mandatory:

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.

Preferred:

Experience in Singapore Government projects. Familiarity with: Virtualized or containerized environments Microservices architecture Integration-heavy systems (Kafka, REST APIs, ETL) Experience in structured ITIL-based incident management environments. Soft Skills: Calm and decisive during major incidents. Strong communication skills during incident bridge calls. Proactive in identifying operational risks. Comfortable working in audit-heavy and compliance-driven environments.

Security Requirement:

Must be a Singapore Citizen to be eligible for Government security clearance.