Database Administrator

PT Inovasi Informatika Indonesia; Jakarta Selatan; On-site; IDR 180,000,000 - 240,000,000; Full time

Job summary

PT Inovasi Informatika Indonesia is looking for a PostgreSQL Database Administrator to manage production PostgreSQL databases in Jakarta. You will optimize performance, ensure security, and drive backup/recovery and HA strategies.

collaborate with application and infrastructure teams, implement monitoring with Grafana/Prometheus, and leverage Apache Airflow for workflow orchestration. Prior experience with Patroni or Pgpool-II is a plus.

Qualifications

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

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.

Skills

PostgreSQL administration

SQL

Linux

Troubleshooting

Analytical thinking

Communication skills

Learning mindset

HA concepts

Oracle knowledge

Education

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

Tools

Grafana

Prometheus

Zabbix

Apache Airflow

Patroni

Pgpool-II

HAProxy

Oracle Database

Job description

• * 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 avallability, integrity, and security.
• * Collaborate with application and infrastructure teams to resolve database-related issues.

• * 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.