Oracle Database Administrator

The Oracle DBA owns the integrity, availability, performance, and security of all Oracle database systems supporting Healthcare's clinical, ERP, financial, supply-chain, and clinical research workloads. Oracle databases typically underpin HIS / EMR back-ends, ERP (Oracle EBS / Fusion), revenue cycle, supply-chain, and high-volume reporting platforms. The role exists to ensure that every Oracle instance is highly available (RAC / Data Guard), fully recoverable (RMAN, Data Guard, Flashback), performance-tuned, securely configured, and continuously compliant with DoH Abu Dhabi, ADHICS v2, and internal cybersecurity controls. Because hospital revenue cycle, clinical reporting, and operational continuity depend on these databases, the role carries direct accountability for clinical service availability and patient-care continuity.

2. 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
• Oracle GoldenGate (preferred)
• OEM Cloud Control
• 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.

7. Required Certifications

Mandatory

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

Preferred

• Oracle Certified Master (OCM)-Database
• Oracle Certified Expert-RAC and Grid Infrastructure
• Oracle Certified Expert-Data Guard / Performance Tuning
• Oracle Cloud Infrastructure (OCI) Architect Associate
• ITIL 4 Foundation
• ADHICS Implementer training
• ISO 27001 Foundation

8. Education Requirements

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

9. Soft Skills and Behavioural 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

12. Tools and Technologies

Category / Tool

Category / Tool

Oracle Database 12c / 19c / 21c / 23ai

Oracle RAC, ASM, Grid Infrastructure

Oracle Data Guard / Active Data Guard

RMAN / ZDLRA

Oracle GoldenGate

OEM Cloud Control

Exadata (where applicable)

RHEL / Oracle Linux

TDE / Database Vault / Unified Audit

Oracle Cloud Infrastructure (OCI)

ServiceNow / Remedy / ManageEngine

SIEM (Splunk / Sentinel / QRadar)

PAM (CyberArk / Delinea / ManageEngine)

Veeam / Commvault for Oracle-aware backups (where used) / Cohesity

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-Market standard