Database Administrator (MSSQL & MongoDB) – Day 2 Operations

MINDTECK SINGAPORE PTE LTD; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

MINDTECK SINGAPORE PTE LTD in Singapore is seeking a hands-on Database Administrator (MSSQL & MongoDB) to support Day 2 operations in a secured environment, focusing on production stability, high availability, incident response, and disaster recovery for 24/7 services.

You will work with Day 2 Infra, System, and Software Engineers, handle Always On and replica sets, performance tuning, and security/compliance requirements for government-facing systems.

Qualifications

• 5–8+ years of DBA experience.
• Strong hands-on experience with Microsoft SQL Server (Always On/HA) and MongoDB.
• Experience supporting 24/7, mission-critical systems.
• Experience handling Severity 1 production incidents.
• Experience in deployment support (data patching, data seed etc.).

Responsibilities

• Provide L2/L3 production database support for MSSQL and MongoDB.
• Maintain Always On availability groups and replica sets; perform backups/restores.
• Monitor performance, conduct query plan analysis and index tuning.
• Lead DR drills and ensure disaster recovery readiness.
• Collaborate with Day 2 Infra/System engineers and security/compliance teams.

Skills

SQL Server

MongoDB

24/7 Operations

Incident management

Troubleshooting

Job description

Singaporean only

Database Administrator (MSSQL & MongoDB) – Day 2 Operations

Job Requirements

Role Overview

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 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 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 eligible for Government security clearance.