Oracle Database Administrator

Overview

Key Responsibilities

• Administer the full lifecycle of Oracle Database (12c / 19c / 21c / 23ai) on Linux and Engineered Systems where deployed.
• Operate Oracle Real Application Clusters (RAC), Data Guard (physical and logical standby), and Active Data Guard topologies.
• Plan and execute backup, archive, and recovery using Oracle RMAN; validate recovery through scheduled restore drills.
• Perform performance tuning-SQL tuning, AWR/ASH analysis, index strategy, partitioning, parallel execution, and PGA/SGA sizing.
• Plan and execute Oracle patching-RU, RUR, PSU, and Critical Patch Updates (CPU)-within approved maintenance windows.
• Operate and maintain ASM (Automatic Storage Management), grid infrastructure, and OEM (Oracle Enterprise Manager) Cloud Control.
• Implement and maintain Oracle security-TDE, Database Vault, Data Redaction, Unified Auditing, and Advanced Security where licensed.
• Support database refresh, cloning, and data masking between production, UAT, and development environments.
• Lead L3 incident response for Oracle issues-ORA errors, RAC instance crashes, Data Guard gaps, performance degradation, and corruption.
• Plan and execute Oracle upgrades, migrations, and Engineered Systems lifecycle activities (Exadata, ZDLRA where applicable).
• Coordinate with application owners and ERP/clinical vendors on schema deployments, PL/SQL performance, and data layer issues.
• Maintain capacity forecasts, recommend storage and infrastructure scaling, and right-size Oracle workloads.
• Author and maintain Oracle runbooks, recovery playbooks, HA/DR procedures, and standard operating procedures.
• Participate in CAB for Oracle changes; present RFCs and execute approved changes with full back-out plans.
• Support DR drills-Data Guard switchover, failover, and reinstate operations with documented results.
• Provide audit evidence for ADHICS, DoH, ISO 27001, and internal audit on Oracle access, encryption, backups, and patch compliance.
• Participate in 24x7 on-call rotation and respond to clinical-impacting incidents within agreed SLAs.

3. Technical Responsibilities

• Install, configure, patch, and upgrade Oracle Database 12c / 19c / 21c / 23ai.
• Operate Oracle RAC, ASM, and Grid Infrastructure on Linux.
• Configure and operate Data Guard (physical, logical, Active Data Guard, far-sync).
• Execute RMAN backup, restore, and recovery-full, incremental, archivelog, block-level recovery.
• Operate Oracle GoldenGate where deployed for replication and zero-downtime migration.
• Perform SQL and PL/SQL tuning, AWR/ASH analysis, SQL Plan Management, and SQL Tuning Advisor.
• Operate OEM Cloud Control for monitoring, jobs, compliance, and lifecycle.
• Implement Oracle security-TDE, Database Vault, Data Redaction, Unified Audit, network encryption.
• Operate Engineered Systems (Exadata, ZDLRA) where deployed.
• Use scripting (Bash, Python, PowerShell) for operational automation and reporting.
• Support Oracle EBS / Fusion / WebLogic database tier where deployed.
• Integrate Oracle audit trails with the central SIEM.

4. Compliance and Governance Responsibilities

• Apply ADHICS v2 database controls-encryption, audit logging, access control, and data classification.
• Encrypt all PHI-containing databases at rest (TDE) and in transit (Oracle Native Network Encryption / TLS).
• Implement Unified Audit and forward audit events to the central SIEM with required retention.
• Maintain a documented database access matrix; review privileges quarterly with the cybersecurity team.
• Integrate privileged DBA access with the PAM platform; eliminate shared accounts and direct OS-level access where avoidable.
• Maintain backup retention aligned with DoH data retention guidance; produce monthly backup attestation reports.
• Track and remediate Oracle vulnerabilities (CPU, vulnerability scans, CIS benchmark gaps) within agreed SLAs.
• Maintain accurate CMDB records for every Oracle instance, including data classification (PHI/PII/financial).
• Support data subject access, e-discovery, and forensic requests in coordination with cybersecurity and legal teams.
• Provide audit evidence for DoH, ADHICS, ISO 27001, and internal audits on demand.

5. Required Technical Skills

• Expert Oracle Database 12c / 19c / 21c / 23ai administration
• Oracle RAC, ASM, and Grid Infrastructure
• Oracle Data Guard (physical, logical, Active Data Guard)
• RMAN backup, restore, and recovery
• Performance tuning-AWR/ASH, SQL Plan Management
• TDE, Database Vault, Data Redaction, Unified Audit

• Engineered Systems-Exadata / ZDLRA (preferred)

• Linux administration (RHEL / OEL)
• Shell / Python scripting
• Familiarity with Oracle EBS / Fusion / WebLogic database tier
• Cloud-Oracle Cloud Infrastructure (OCI), Azure for Oracle

6. Required Experience

• Minimum 7 years of dedicated Oracle Database administration experience.
• Minimum 3 years of operational experience with RAC and Data Guard in production.
• Demonstrable experience supporting mission-critical, 24x7 environments-healthcare, banking, telecom, or government preferred.
• Experience supporting EMR / HIS / ERP / supply-chain Oracle workloads strongly preferred.
• Prior service-transition or take-over experience desirable.
• Experience with Engineered Systems (Exadata, ZDLRA) is a plus.

Mandatory

• Oracle Certified Professional (OCP)-Oracle Database 19c or higher

• Oracle Certified Master (OCM)-Database

• Oracle Certified Expert-RAC and Grid Infrastructure
• Oracle Certified Expert-Data Guard / Performance Tuning

• ITIL 4 Foundation

• ADHICS Implementer training

• ISO 27001 Foundation

Requirements

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Equivalent diploma plus extensive Oracle DBA experience may be considered.

Competencies

• Deep ownership of database availability and data integrity
• Analytical, methodical approach to performance and incident issues
• Clear, evidence-based communication with application owners and clinical teams
• Disciplined documentation and change-management hygiene
• Composure under high-pressure outages and DR events
• Compliance-first mindset on data handling and PHI protection
• Readiness for shift coverage, weekend changes, and on-call
• Mentorship of junior DBAs and collaboration across teams

10. Key Interfaces

• Infrastructure Team-Linux, Wintel, storage, and virtualization engineers
• Cloud Team-OCI / Azure for Oracle
• Application Teams-HIS, EMR, ERP, supply-chain, analytics
• Cybersecurity Team-encryption, audit, access reviews

• Service Desk / NOC

• Backup and DR teams
• Oracle Support and OEM vendors
• Internal Audit, Risk, and Compliance
• Managed Service Provider (MSP) team during transition and steady-state

11. Success Measures and KPIs

• Database availability ≥ 99.95% for tier-1 clinical and ERP databases
• RMAN backup success rate ≥ 99% with monthly restore validation
• Zero data loss across Data Guard switchover / failover events
• CPU / RU patch compliance ≥ 98% within agreed maintenance window
• P1 incident response within 15 minutes
• RCA delivered within 5 business days for all P1 incidents
• Quarterly DR test execution with documented results
• Zero critical Oracle vulnerabilities open beyond agreed SLA
• Audit evidence completeness-100% within requested timelines
• Performance tuning impact-measurable reduction in top-N AWR wait events quarter-over-quarter

Category / Tool

OEM Cloud Control

PAM (CyberArk / Delinea / ManageEngine)

13. Working Conditions

• On-site at facilities and data centers in Abu Dhabi.
• Standard business hours with mandatory 24x7 on-call rotation.
• Weekend / overnight changes for patching, upgrades, RAC maintenance, and DR tests.
• Emergency response for clinical-impacting database incidents.
• Adherence to hospital data-protection and access protocols.

Salary