Senior PostgreSQL & Oracle DBA — Performance & Security

Indivara Group; Jakarta Pusat; On-site; IDR 450,000,000 - 700,000,000; Full time

Job summary

Indivara Group is seeking a Senior Database Administrator to design, implement, and maintain enterprise PostgreSQL and Oracle databases, ensuring high availability and data integrity.

The role emphasizes SQL performance tuning, backup/recovery, replication, and security while supporting critical applications in a demanding environment. Collaboration with developers and infrastructure teams is essential.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 7+ years hands-on experience as a Database Administrator.
• Proven expertise in PostgreSQL and Oracle Database administration.
• Advanced knowledge of SQL performance tuning, query optimization, and indexing.
• Strong understanding of database architecture, data modeling, and normalization.
• Experience with backup and recovery tools (RMAN, pg_dump/pg_restore).
• Familiarity with high-availability and disaster recovery architectures.
• Experience with Linux/Unix environments and shell scripting.
• Strong problem-solving and collaboration skills.

Responsibilities

• Design, install, configure, and maintain PostgreSQL and Oracle database environments.
• Monitor performance, identify bottlenecks, and tune SQL, schema, and system levels.
• Develop and review complex SQL queries, stored procedures, functions, and triggers.
• Ensure availability, reliability, scalability, backups, replication, and failover strategies.
• Implement and manage database security, access control, encryption, and compliance.
• Plan capacity, upgrades, patches, and migrations.
• Troubleshoot production issues across development, test, and production.
• Collaborate with developers and infrastructure teams to support performance and data integrity.
• Create and maintain database documentation and procedures.
• Provide technical leadership and mentoring to junior DBAs.
• Support on-call and incident management for critical systems.

Skills

PostgreSQL

Oracle

SQL performance tuning

Linux/Unix

Shell scripting

Backup/recovery

High availability

Data modeling

Communication

Collaboration

Education

Bachelor's degree in Computer Science / IT

Tools

RMAN

pg_dump/pg_restore

Replication solutions

Job description

Indivara Group is seeking a Senior Database Administrator to design, implement, and maintain enterprise PostgreSQL and Oracle databases, ensuring high availability and data integrity.

The role emphasizes SQL performance tuning, backup/recovery, replication, and security while supporting critical applications in a demanding environment. Collaboration with developers and infrastructure teams is essential.