Senior Database Administrator

amIT Global Solutions Sdn Bhd; Indonesia; On-site; IDR 300,000,000 - 450,000,000; Full time

Job summary

amIT Global Solutions Sdn Bhd in Indonesia seeks an experienced Database Administrator to design, build, and maintain high-availability database platforms for production systems.

You will lead monitoring and auto-alerting, ensure zero-downtime migrations, capacity planning, and incident post-mortems, while enforcing data security and robust backups. Expert SQL across PostgreSQL, MySQL, MS SQL Server, and NoSQL is required; on-site work at Mampang Blue Bird Head Office.

Qualifications

• Minimum 8 years of DBA experience in large-scale, high-traffic production environments.
• Strong SQL expertise across PostgreSQL, MySQL, and MS SQL Server; NoSQL experience a plus.
• Experience with failover, disaster recovery, and zero-downtime migrations.
• Proactive monitoring, alerting, and capacity planning with security and backup discipline.
• WFO at Mampang Blue Bird Head Office in Indonesia.

Responsibilities

• Design, build, and maintain monitoring systems for critical database metrics with intelligent auto-alerting.
• Proactively monitor and analyze slow queries and provide actionable recommendations.
• Understand cardinality, index utilization, and partitioning/sharding for large tables.
• Own database replication, ensuring seamless auto-failover with zero data loss.
• Conduct capacity planning to avoid cost spikes and performance issues.
• Lead a 24/6 on-call rotation within the DBA team.
• Drive post-mortem culture to prevent recurrence and improve systems.
• Ensure data security, access control management, and tested backups and recovery procedures.

Skills

SQL

PostgreSQL

MySQL

MS SQL Server

NoSQL

Failover

Disaster recovery

Capacity planning

On-call

Data security

Job description

Responsibilities

• Design, build, and maintain monitoring systems for critical database metrics, equipped with intelligent auto-alerting mechanisms.
• Proactively monitor and analyze slow queries—beyond adding missing indexes, provide actionable recommendations to engineering teams to improve query structure and application logic.
• Demonstrate deep understanding of cardinality, efficient index utilization, and the ability to manage rapidly growing tables through effective partitioning or sharding strategies.
• Take full ownership of database replication mechanisms, ensuring seamless auto-failover processes with zero data loss during disruptions.
• Proactively conduct capacity planning to prevent unexpected infrastructure cost spikes and avoid sudden performance degradation due to data growth.
• Lead and uphold a 24/6 on-call rotation culture within the DBA team to ensure immediate response to production incidents.
• Drive a strong post-mortem culture following every incident, focusing on long-term systemic improvements to prevent recurrence.
• Ensure data security, proper access control management, and regularly tested backup and recovery procedures.

Requirements

• Minimum of 8 years of experience as a Database Administrator (DBA) in large-scale, high-traffic production environments.
• Strong technical expertise in SQL, with in-depth knowledge of database engines such as PostgreSQL, MySQL, Microsoft SQL Server, NoSQL, and others.
• Proven experience in handling failover scenarios, disaster recovery, and zero-downtime database migrations.
• Strong, assertive communication skills with the ability to challenge engineering teams when proposed query structures may negatively impact database performance or cost efficiency.
• High level of discipline in maintaining operational documentation and adhering to cybersecurity standards and best practices.
• Willing to work from office (WFO) at Mampang Blue Bird Head Office.