DBA (Database Administrator)

PT Amartha Mikro Fintek; Daerah Khusus Ibukota Jakarta; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

Sebuah perusahaan yang inovatif sedang mencari DBA berpengalaman untuk merancang dan mengelola sistem manajemen data. Dalam peran ini, Anda akan berkolaborasi dengan tim produk dan teknis untuk memastikan database berfungsi dengan optimal. Anda akan bertanggung jawab atas pemantauan, pemeliharaan, dan pengoptimalan database, serta memberikan bimbingan kepada insinyur junior. Jika Anda memiliki pengalaman dengan PostgreSQL dan CI/CD, serta keterampilan komunikasi yang baik, ini adalah kesempatan yang menarik untuk berkontribusi dalam perjalanan transformasi perusahaan menuju inovasi yang lebih besar.

Qualifications

• 4-6 tahun pengalaman di industri terkait dan pengalaman dengan PostgreSQL.
• Keahlian dalam CI/CD dan manajemen sistem pemantauan.

Responsibilities

• Mengelola semua aktivitas terkait database dan memastikan ketersediaan database produksi.
• Melakukan pemeliharaan database rutin dan mengoptimalkan kinerja kueri.

Skills

Komunikasi

Pemecahan Masalah Teknis

Pengalaman PostgreSQL

Pengalaman CI/CD

Tools

Google Cloud Platform (GCP)

Amazon Web Services (AWS)

Job description

Amartha is embarking on an exciting new journey and is seeking experienced engineers to collaborate with senior management, existing engineers, and product teams to shape the next wave of innovative product offerings. Our goal is to ensure Amartha leapfrogs into the next phase of its journey!

We are looking for candidates with strong communication skills who can actively participate in discussions, bridge the gap between product and technology, and coach, mentor, and guide junior engineers in best practices and technical problem-solving.

As a DBA, you will be responsible for designing, implementing, administering, and monitoring data management systems while ensuring their design, consistency, quality, and security.

Responsibilities

1. Serve as an individual contributor for all database-related activities.
2. Monitor and ensure the uptime and availability of all production databases.
3. Estimate PostgreSQL database capacities and develop methods for monitoring database usage and capacity.
4. Lead efforts to create and enhance automated monitoring and proactive intervention procedures, minimizing downtime.
5. Participate in the creation and migration of development, staging, and production database instances.
6. Conduct SQL code reviews for developers to ensure queries are optimized and tuned for efficiency before production deployment.
7. Perform regular database maintenance tasks, including vacuuming, reindexing, and archiving.
8. Proactively address database operational issues to ensure smooth performance.
9. Optimize query performance and perform preventative maintenance.

Minimum Requirements

1. Having at least 4–6 years of relevant industry experience.
2. Proven experience with PostgreSQL, including both VM-based and managed platforms on Google Cloud Platform (GCP) and Amazon Web Services (AWS).
3. Experience managing multiple databases and working with datastream technologies.
4. Hands-on experience with CI/CD pipelines for automated deployment and integration.
5. Proficiency in monitoring and alerting systems management, ensuring system reliability and quick issue resolution.