Database Administrator

ASCENDION ENGINEERING SOLUTIONS SINGAPORE PTE. LTD.; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

ASCENDION ENGINEERING SOLUTIONS SINGAPORE PTE. LTD. is seeking a hands-on Operations DBA to support a mission-critical environment.

The role centers on 24/7 production stability, high availability, incident response, and disaster recovery for MSSQL Server and MongoDB. You will collaborate with Day 2 Infra Engineers, System Engineers, Software Engineers, and Security teams, participate in on-call rotations, and perform performance tuning, health checks, and security-compliant practices in a

Qualifications

• 5–8+ years of DBA experience.
• Strong MS SQL Server (Always On/HA) and MongoDB expertise.
• Experience with 24/7 mission-critical systems.
• Experience handling Severity 1 production incidents.
• Experience supporting application deployment (data patching, data seed).
• Strong troubleshooting and analytical skills.

Responsibilities

• 24/7 Production Database Operations with L2/L3 support for MSSQL and MongoDB in production and DR environments.
• High Availability & Reliability Management for MSSQL Always On and MongoDB replica sets.
• Performance & Capacity Management: health checks, slow queries, indexing, and capacity forecasting.
• Change & Release Support: review scripts, data patching, migrations, and rollback procedures.
• Security & Compliance (Government environment): RBAC, auditing, vulnerability remediation, audit readiness.

Skills

MS SQL Server

MongoDB

Always On

On-call support

Performance tuning

Troubleshooting

Security & Compliance

Job description

Role

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

Focus Areas

This role focuses 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.

Collaboration

The DBA will work closely with Day 2 Infra Engineers, Day 2 System Engineers, Day 2 Software Engineers, and Security & Compliance teams.

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 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 patching and cumulative updates; maintain backup and restore strategy; conduct DR drills; optimize indexing and execution plans.
   • MongoDB: Manage Replica Sets and automatic failover; monitor memory, disk, and index performance; manage backup/restore and validation; maintain cluster health and sharding (if applicable).

3. Performance & Capacity Management

   • Conduct proactive health checks.
   • Analyze query execution plans (MSSQL) and slow queries & indexing (MongoDB).
   • Perform 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.

5. Security & Compliance (Government Environment)

   • Implement database security hardening.
   • Manage role‑based access control, auditing and logging.
   • Support vulnerability assessment remediation.
   • Ensure compliance with government security policies.
   • Maintain documentation and SOPs for audit readiness.

Required Skills

• 5–8+ years of DBA experience.
• Strong hands‑on experience in MS SQL Server (Always On, HA, performance tuning) and MongoDB (Replica Sets, backup/restore).
• Experience supporting 24/7 mission‑critical systems.
• Experience handling Severity 1 production incidents.
• Experience supporting application deployment (data patching, data seed etc.).
• Strong troubleshooting and analytical skills.