Oracle Database Administrator (DBA)

Coforge; Muntinlupa; Presencial; PHP 1.200.000 - 3.000.000; Jornada completa

Descripción de la vacante

Coforge is seeking an experienced Oracle Database Administrator in the Philippines to manage Exadata environments and optimize performance across on-prem and cloud deployments. The role emphasizes patching, upgrades, health checks, and DR planning with GoldenGate replication and OEM monitoring.

Candidate will handle RAC, Data Guard, and ZDLRA, perform SQL tuning, and automate maintenance using Shell scripting and Ansible. Strong problem-solving and security awareness are essential.

Formación

• Hands-on with Exadata X9M-2, ExaCC and ExaCS.
• Expertise in managing Exadata compute, storage, networking, and firmware.
• Patching, firmware upgrades, and health checks on Exadata systems.
• Optimize Exadata configurations for performance and scalability.
• Oracle DB administration for 12c and 19c.
• Advanced SQL tuning with AWR/ASH/ADDM analysis.
• Partitioning, indexing, and query optimization.
• Troubleshoot performance and capacity issues.
• Implement RAC, Data Guard, and GoldenGate replication.
• Install/configure GoldenGate; real-time replication and DR.
• Migration/upgrade across platforms; cross-cloud migration.
• OEM 13c monitoring, alerts, and automation.

Responsabilidades

• Manage Exadata compute, storage, and networking components.
• Perform patching, firmware upgrades, and health checks.
• Tune SQL and optimize performance for workloads.
• Configure and monitor Oracle GoldenGate replication.
• Plan and execute migrations and upgrades to 19c+.
• Implement RAC, Data Guard, and ZDLRA DR strategies.
• Administer OEM 13c monitoring and diagnostics.
• Automate maintenance tasks with scripts/Ansible.
• Ensure data integrity and rollback plans during migrations.
• Support security/compliance with OKV, TDE, and audits.
• Deliver high-availability solutions across multi-region setups.

Conocimientos

Oracle Exadata

Performance tuning

Automation scripting

Security awareness

Herramientas

Exadata X9M-2

ExaCC

ExaCS

Oracle GoldenGate

OEM 13c

Data Guard

RMAN

Datapump

ZDLRA

Ansible

Shell scripting

Descripción del empleo

1. Exadata & Oracle Infrastructure Management

• Hands-on experience with Oracle Exadata X9M-2, ExaCC, and ExaCS.
• Expertise in managing and troubleshooting Exadata compute, storage, networking, and firmware components.
• Perform patching, firmware upgrades, and health checks on Exadata systems.
• Optimize Exadata configurations for performance and scalability.

2. Database Administration & Performance Tuning

• Strong expertise in Oracle Database 12c and 19c administration.
• Perform advanced SQL tuning, AWR, ASH, and ADDM analysis for performance optimization.
• Hands-on experience with Partitioning, Indexing, and Query Optimization.
• Troubleshoot and resolve database performance and capacity issues.
• Implement RAC, Data Guard, and GoldenGate replication strategies.

3. Oracle GoldenGate (OGG) Experience

• Expertise in installing, configuring, and managing Oracle GoldenGate (OGG) 12c/19c.
• Design and implement real-time replication, high-availability, and disaster recovery solutions using GoldenGate.
• Experience in bidirectional, unidirectional, and heterogeneous replication.
• Performance tuning and troubleshooting of Extract, Pump, and Replicat processes.
• Implement GoldenGate monitoring and automation using OEM or third-party tools.
• Upgrade GoldenGate environments with minimal downtime strategies.

4. Migration & Upgrade Experience

• Hands-on experience in migrating databases across different platforms, on-premises to cloud (OCI, AWS, Azure), and within Exadata environments.
• Plan and execute database upgrades from 11g/12c to 19c and beyond, ensuring minimal downtime.
• Perform cross-platform migration using Data Pump, Transportable Tablespaces (TTS), RMAN, GoldenGate, and ZDM (Zero Downtime Migration).
• Conduct Oracle Grid Infrastructure and Oracle Home migrations/upgrades.
• Migrate Oracle workloads from legacy hardware to Exadata, ExaCC, or ExaCS.
• Ensure data integrity and rollback strategies are in place before performing migrations.

5. Patch & Upgrade Management

• Perform Oracle Home, Grid Infrastructure, and OS patching and upgrades.
• Manage OS VM updates and OS upgrades for Oracle environments.
• Automate patching and upgrade processes using scripts and Ansible.

6. Storage & ASM Administration

• Expertise in managing ASM (Automatic Storage Management).
• Configure and maintain disk groups, disk group rebalance, and redundancy strategies.
• Troubleshoot ASM-related issues and optimize storage performance.

7. Backup & Recovery

• Expert-level knowledge of backup and recovery in all possible scenarios.
• Experience with RMAN, Data Pump, Flashback, and ZDLRA (Zero Data Loss Recovery Appliance).
• Plan and execute disaster recovery (DR) drills and failover scenarios.
• Implement automated backup strategies and validate recovery points.
• Deep understanding of ZDLRA, RMAN, Data Guard, and backup strategies.

8. Oracle Enterprise Manager (OEM) 13c & Monitoring

• Strong hands-on experience in Oracle Enterprise Manager (OEM) 13c.
• Configure and maintain monitoring, alerts, and diagnostics.
• Implement compliance, security policies, and automation in OEM.
• Optimize OEM agent and repository performance.

9. Security & Compliance

• Implement and maintain Oracle Key Vault (OKV) for encryption and key management.
• Perform vulnerability assessments and patch compliance checks.
• Secure databases using TDE, VPD, and database auditing.
• Work with security teams to mitigate database security risks.

10. Scripting & Automation

• Develop automation scripts using Shell scripting and database scripting.
• Automate daily health checks, backup verification, and database maintenance tasks.
• Create scripts for log analysis, system monitoring, and self-healing mechanisms.

11. High Availability & Disaster Recovery

• Hands-on expertise in Data Guard, Active Data Guard, and RAC failover scenarios.
• Implement and manage disaster recovery (DR) solutions for mission-critical systems.
• Design and maintain multi-region and cloud DR strategies.

12. Other Skills

• Experience in vulnerability management and security hardening.
• Strong knowledge of Linux (OL, RHEL) and OS-level troubleshooting.
• Strong scripting skills in Shell scripting

Certifications:

• Oracle Certified Master (OCM) or Oracle Certified Professional (OCP) in Exadata, GoldenGate, and Database Administration.