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/7 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.