Senior Database Administrator

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

Senior DBA :

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.