Senior Database Administrator
Blue Bird Group · Jakarta, Jakarta, Indonesia
Sekilas tentang pekerjaan ini
Blue Bird Group mencari Senior Database Administrator dengan pengalaman minimal 8 tahun di lingkungan produksi berskala besar dan high-traffic. Peran ini mengelola kinerja, keandalan, dan keamanan database serta memimpin respons insiden; kandidat harus bersedia bekerja dari kantor pusat Blue Bird di Mampang, Jakarta.
Tugas utama
- Merancang dan memelihara pemantauan metrik database dengan auto-alert.
- Menganalisis slow query dan memberi rekomendasi perbaikan kepada tim engineering.
- Mengelola replikasi, auto-failover, kapasitas, serta strategi partitioning atau sharding.
- Memimpin on-call 24/7 dan evaluasi pascainsiden untuk mencegah kejadian berulang.
- Menjaga keamanan data, kontrol akses, serta prosedur backup dan recovery.
Kualifikasi utama
- Minimal 8 tahun sebagai DBA di lingkungan produksi besar dan high-traffic.
- Menguasai SQL serta PostgreSQL, MySQL, Microsoft SQL Server, dan NoSQL.
- Berpengalaman menangani failover, disaster recovery, dan zero-downtime database migrations.
- Mampu berkomunikasi tegas dengan tim engineering tentang dampak query.
- Disiplin mendokumentasikan operasional dan mematuhi standar keamanan siber.
Ringkasan ini dibuat dengan AI dari deskripsi di bawah. Yang berlaku adalah deskripsi lengkapnya di situs Blue Bird Group.
Deskripsi pekerjaan
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.