Senior PostgreSQL & Oracle DBA - Availability & Security

Indivara Group; Indonesia; On-site; IDR 420,000,000 - 700,000,000; Full time

Job summary

Indivara Group is seeking a Senior Database Administrator to design, implement, and optimize enterprise PostgreSQL and Oracle databases. You will ensure high availability, data integrity, and robust performance in a mission-critical environment, collaborating with developers and infrastructure teams.

The role focuses on advanced SQL tuning, backup/recovery strategies, and security controls, with leadership duties mentoring junior DBAs and driving best practices across the platform.

Qualifications

• 7+ years of hands-on Database Administrator experience in enterprise environments.
• Proven expertise in PostgreSQL and Oracle Database administration.
• Advanced SQL performance tuning, query optimization, and indexing strategies.
• Experience with backup, recovery, replication, and high-availability architectures.
• Experience with Linux/Unix environments and shell scripting.
• Strong problem-solving skills and collaboration across teams.

Responsibilities

• Design, install, configure, and maintain PostgreSQL and Oracle databases.
• Monitor performance and tune SQL, schema, and system bottlenecks.
• Develop and optimize complex SQL, stored procedures, and triggers.
• Ensure availability, backup, recovery, replication, and failover readiness.
• Implement database security, access controls, encryption, and compliance.
• Collaborate with developers, architects, and infra teams to support performance and integrity.
• Create and maintain DB documentation and operational procedures.
• Provide mentoring and technical leadership to junior DBAs.

Skills

PostgreSQL Admin

Oracle Admin

SQL Tuning

Linux Shell

Data Modeling

Cross-team Communication

Education

Bachelor's degree in CS/IT

Tools

RMAN

pg_dump / pg_restore

Replication

Job description

Indivara Group is seeking a Senior Database Administrator to design, implement, and optimize enterprise PostgreSQL and Oracle databases. You will ensure high availability, data integrity, and robust performance in a mission-critical environment, collaborating with developers and infrastructure teams.

The role focuses on advanced SQL tuning, backup/recovery strategies, and security controls, with leadership duties mentoring junior DBAs and driving best practices across the platform.