Deskripsi pekerjaan
This is a contract-based Database Administrator (DBA) role focused on managing Oracle and PostgreSQL environments. The position requires a professional capable of handling database infrastructure in both Linux and Windows environments. The DBA will be responsible for installation, configuration, and upgrades of database software, as well as routine maintenance such as patching and capacity monitoring. Key tasks include performance optimization (query tuning), ensuring data security, managing backup and recovery strategies, and maintaining high availability through replication and failover solutions. The role also involves serving as the primary contact for database incidents and performing root cause analysis.
Tanggung jawab: Perform installation, configuration, and upgrades of Oracle (12c/19c/21c) and PostgreSQL software in both Linux and Windows environments; Routine Maintenance: Execute patching management, monitor storage capacity, and conduct regular database health checks; Performance Optimization: Conduct query tuning, index optimization, and execution plan analysis to ensure low-latency application performance; Data Security: Manage user privileges, data encryption, and ensure strict compliance with corporate data security standards; Backup & Recovery: Develop and test Disaster Recovery (DR) strategies; perform routine backups using RMAN (Oracle) and pg_dump/Barman (PostgreSQL); High Availability: Manage data replication and failover utilizing Oracle Data Guard and PostgreSQL HA solutions (e.g., Patroni or Repmgr); Troubleshooting: Serve as the primary point of contact for database incidents and perform comprehensive Root Cause Analysis (RCA).
Kualifikasi: Bachelor's degree in IT or related fields; 3–5 years as a DBA; Certified OCP or PostgreSQL Professional; Experience with Cloud Databases (AWS RDS, Google Cloud SQL, or Azure); Oracle: SGA/PGA, RMAN, Data Guard, and RAC; PostgreSQL: Administration, Extensions, and Streaming Replication; Proficient in Linux (RHEL/Ubuntu) and Bash or Python automation; Deep knowledge of PL/SQL and PL/pgSQL; Strong analytical thinking, detail-oriented, and able to work under pressure.
Tanggung jawab
- Perform installation, configuration, and upgrades of Oracle (12c/19c/21c) and PostgreSQL software in both Linux and Windows environments
- Routine Maintenance: Execute patching management, monitor storage capacity, and conduct regular database health checks
- Performance Optimization: Conduct query tuning, index optimization, and execution plan analysis to ensure low-latency application performance
- Data Security: Manage user privileges, data encryption, and ensure strict compliance with corporate data security standards
- Backup & Recovery: Develop and test Disaster Recovery (DR) strategies; perform routine backups using RMAN (Oracle) and pg_dump/Barman (PostgreSQL)
- High Availability: Manage data replication and failover utilizing Oracle Data Guard and PostgreSQL HA solutions (e.g., Patroni or Repmgr)
- Troubleshooting: Serve as the primary point of contact for database incidents and perform comprehensive Root Cause Analysis (RCA)
Kualifikasi
- Bachelor's degree in IT or related fields
- 3–5 years as a DBA
- Certified OCP or PostgreSQL Professional
- Experience with Cloud Databases (AWS RDS, Google Cloud SQL, or Azure)
- Oracle: SGA/PGA, RMAN, Data Guard, and RAC
- PostgreSQL: Administration, Extensions, and Streaming Replication
- Proficient in Linux (RHEL/Ubuntu) and Bash or Python automation
- Deep knowledge of PL/SQL and PL/pgSQL
- Strong analytical thinking, detail-oriented, and able to work under pressure
Informasi lowongan
- Tipe pekerjaan
- Contract
- Pendidikan
- S1
- Gaji
- Negosiasi
Cara melamar
- Lamar melalui platform
- Kirim lamaran melalui email: Recruitment@simasjiwa.co.id
- Buka tautan lamaran resmi