Senior Database Administrator

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

The Senior Database Administrator is responsible for the design, implementation, maintenance, performance optimization, and security of enterprise database systems. This role ensures high availability, data integrity, and optimal performance of databases, primarily using PostgreSQL and Oracle, while supporting complex SQL-based applications in a mission-critical environment.

Key Responsibilities

• Design, install, configure, and maintain PostgreSQL and Oracle database environments.
• Monitor database performance, identify bottlenecks, and perform tuning at the SQL, schema, and system levels.
• Develop, optimize, and review complex SQL queries, stored procedures, functions, and triggers.
• Ensure database availability, reliability, and scalability, including backup, recovery, replication, and failover strategies.
• Implement and manage database security, user access control, encryption, and compliance with internal and external regulations.
• Perform capacity planning, database upgrades, patching, and version migrations.
• Troubleshoot and resolve complex database issues in development, testing, and production environments.
• Collaborate closely with application developers, system architects, and infrastructure teams to support application performance and data integrity.
• Create and maintain database documentation, standards, and operational procedures.
• Provide technical leadership, mentoring, and guidance to junior DBAs and development teams.
• Support on-call and incident management activities for critical production systems.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 7+ years of hands-on experience as a Database Administrator, with strong exposure to enterprise systems.
• Proven expertise in PostgreSQL and Oracle Database administration.
• Advanced knowledge of SQL performance tuning, query optimization, and indexing strategies.
• Strong understanding of database architecture, data modeling, and normalization.
• Experience with backup and recovery tools (e.g., RMAN, pg_dump/pg_restore, replication solutions).
• Familiarity with high-availability and disaster recovery architectures.
• Experience with Linux/Unix environments and shell scripting.
• Strong problem-solving skills and ability to work under pressure in production environments.
• Good communication skills and ability to collaborate with cross-functional teams.

Preferred Qualifications

• Experience with database monitoring and performance tools.
• Exposure to cloud database services (AWS RDS, Oracle Cloud, Azure Database).
• Knowledge of data security, auditing, and compliance standards.
• Experience in banking, fintech, or high-transaction systems is a strong advantage.
• Relevant certifications (Oracle DBA, PostgreSQL Certification) are a plus.