Oracle Database Administrator
TOG Indonesia
Lokasi
Jakarta Selatan
Tipe kerja
On-site
Gaji
Rp 10,000,000 - Rp 13,000,000
Deskripsi pekerjaan
- Administer Oracle databases, including database creation, configuration, migration, cloning, schema management, tablespace management, and user administration.
- Monitor database availability, performance, sessions, resource utilization, alert logs, archive logs, wait events, and blocking sessions.
- Manage Oracle backup and recovery activities using RMAN, including backup validation, recovery testing, restore support, and disaster recovery support.
- Support Oracle RAC, ASM, Grid Infrastructure, and cluster environments.
- Perform SQL performance tuning, query optimization, statistics maintenance, AWR/ASH analysis, and database parameter tuning.
- Manage database security, including user access reviews, privilege management, password policies, audit monitoring, and compliance activities.
- Plan and support Oracle database patching (PSU/RU), verification, rollback, and maintenance activities.
- Analyze database growth trends, capacity utilization, and provide optimization recommendations.
- Troubleshoot database incidents, investigate corruption issues, prepare RCA reports, and resolve performance bottlenecks.
- Produce operational documentation and reports, including health checks, backup reports, performance reports, and monthly service reviews.
Tanggung jawab
- Administer Oracle databases, including database creation, configuration, migration, cloning, schema management, tablespace management, and user administration.
- Monitor database availability, performance, sessions, resource utilization, alert logs, archive logs, wait events, and blocking sessions.
- Manage Oracle backup and recovery activities using RMAN, including backup validation, recovery testing, restore support, and disaster recovery support.
- Support Oracle RAC, ASM, Grid Infrastructure, and cluster environments.
- Perform SQL performance tuning, query optimization, statistics maintenance, AWR/ASH analysis, and database parameter tuning.
- Manage database security, including user access reviews, privilege management, password policies, audit monitoring, and compliance activities.
- Plan and support Oracle database patching (PSU/RU), verification, rollback, and maintenance activities.
- Analyze database growth trends, capacity utilization, and provide optimization recommendations.
- Troubleshoot database incidents, investigate corruption issues, prepare RCA reports, and resolve performance bottlenecks.
- Produce operational documentation and reports, including health checks, backup reports, performance reports, and monthly service reviews.
Kualifikasi
- Minimum 3 years of experience as an Oracle Database Administrator.
- Strong experience administering Oracle Database 11g/12c/19c.
- Experience with Oracle RAC, Oracle ASM, and Oracle Grid Infrastructure.
- Hands-on experience with RMAN backup and recovery.
- Strong understanding of SQL tuning, query optimization, and Oracle performance tuning.
- Experience analyzing AWR, ASH, ADDM, and execution plans.
- Good understanding of Oracle security, database patching, and disaster recovery.
- Familiarity with Linux operating systems.
- Excellent troubleshooting, analytical, and documentation skills.
Benefit & Fasilitas
competitiveSalarymedicalLeavebonusSystempaidSickDays
Keahlian
Oracle Database AdministrationORACLE RACOracle ASMRMAN Backup & RecoverySQL Performance Tuning