PostgreSQL Database Administrator

PT Inovasi Informatika Indonesia; Jakarta Utara; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

PT Inovasi Informatika Indonesia membuka posisi Database Administrator di Jakarta. Anda akan mengelola PostgreSQL di lingkungan produksi, memantau kinerja, dan melakukan operasi backup/recovery serta migrasi.

Posisi ini menuntut Diploma D3, penguasaan Linux, SQL, serta pengalaman dengan administrasi PostgreSQL, backup, replikasi, dan keamanan database. Kolaborasi dengan tim aplikasi & infrastruktur diperlukan, dengan fokus pada stabilitas sistem.

Qualifications

• Diploma (D3) di bidang Teknologi Informasi/Ilmu Komputer/Elektro/Matematika.

Responsibilities

• Mengembangkan, mengelola, dan memelihara basis data PostgreSQL di lingkungan produksi.
• Memantau kesehatan basis data, mengidentifikasi masalah, dan melakukan troubleshooting.
• Melakukan backup, recovery, migrasi, replikasi, dan switchover/failover basis data.
• Mengoptimalkan kinerja melalui monitoring, tuning query, dan konfigurasi.
• Menjamin ketersediaan, integritas, dan keamanan basis data.
• Bekerja sama dengan tim aplikasi dan infrastruktur untuk menyelesaikan isu terkait basis data.

Skills

PostgreSQL administration

SQL

Linux

Problem solving

Analytical thinking

Communication

Education

Diploma (D3) in IT/CS/EE/Math

Tools

PostgreSQL tools

Grafana

Prometheus

Zabbix

Patroni

Pgpool-II

HAProxy

Apache Airflow

Job description

ADVANCE YOUR CAREER WITH US!

We don't just work; we innovate. If you're ready to contribute to major projects and create solutions, i3 is the best place for you!

See the information below for more information:

Database Administrator

Responsibilities

Develop, administer, and maintain PostgreSQL databases in production environments.

Monitor database health, identify issues, and perform troubleshooting.

Perform database backup, recovery, migration, replication, and switchover/failover activities.

Optimize database performance through monitoring, query tuning, and configuration tuning.

Ensure database availability, integrity, and security.

Collaborate with application and infrastructure teams to resolve database-related issues.

Requirements

Minimum Diploma (D3) in Information Technology, Computer Science, Electrical Engineering, Mathematics, or a related field.

Strong knowledge of Linux operating systems.

Proficient in SQL.

Hands-on experience with PostgreSQL administration (mandatory).

Good understanding of backup & recovery, replication, performance tuning, and database security.

Excellent analytical, troubleshooting, and problem-solving skills.

Strong communication skills and willingness to learn new technologies.

Experience with Apache Airflow.

Basic knowledge of Oracle Database.

Familiarity with database monitoring tools (Grafana, Prometheus, Zabbix, etc.).

Experience with HA solutions such as Patroni, Pgpool-II, or HAProxy.

• Berapa gaji bulanan yang kamu inginkan?
• Kualifikasi mana yang kamu miliki?
• Berapa tahun pengalaman kerjamu sebagai administrator database?
• Berapa tahun pengalaman kerjamu menggunakan query SQL?
• How many years' experience do you have as a PostgreSQL Administrator?
• Berapa lama waktu yang kamu butuhkan untuk memberi tahu perusahaanmu saat ini?