Job Description:
Role Summary
We are seeking a Senior Oracle Database Administrator with deep expertise across on-premises and OCI-hosted database environments supporting mission-critical Oracle application stacks. This role spans the full DBA lifecycle installation, patching, performance engineering, high availability, disaster recovery, security hardening, and automation with hands-on accountability for databases underpinning Oracle E-Business Suite, Siebel CRM, Billing & Revenue Management (BRM), and Fusion Cloud applications.
Key Responsibilities
On-Premises Database Administration
Install, configure, and manage Oracle Database (19c, 21c, 23ai) on Linux (OL/RHEL) and Solaris/AIX environments.
Administer Oracle RAC and RAC One Node clusters including clusterware, voting disks, OCR, and SCAN listeners.
Manage ASM disk groups, rebalancing, failure groups, and storage allocation across database workloads.
Plan and execute database patching (RU/RUR, one-off patches) using OPatch and opatchauto with minimal downtime windows.
Administer Oracle Grid Infrastructure, TNS networking, listener configurations, and database link management.
Manage Oracle Multitenant architecture (CDB/PDB) including provisioning, cloning, plugging/unplugging, and resource management.
OCI Database Services Administration
Provision and manage OCI DB Systems (VM/BM), Exadata Cloud Service (ExaCS), and Exadata Cloud@Customer (ExaCC).
Administer Oracle Autonomous Database (ATP/ADW) including scaling, cloning, refreshable clones, and workload management.
Manage OCI Database tooling: Database Management, Operations Insights, Performance Hub, and Management Agent.
Automate database provisioning and lifecycle operations using Terraform (OCI provider) and OCI CLI.
Configure and manage OCI networking for database tier: private subnets, NSGs, service gateways, and private endpoints.
Manage database backups to OCI Object Storage and configure automatic backup policies.
Oracle Application Database Support
Administer databases underpinning Oracle E-Business Suite (EBS) including EBS-specific schemas, concurrent managers, AD utilities, and database-tier patching aligned with EBS release cycles.
Manage databases for Siebel CRM Siebel schema optimization, table space management, index maintenance, and Siebel-specific parameter tuning.
Support Oracle BRM (Billing & Revenue Management) databases pipeline-intensive workload tuning, BRM schema management, partition strategies for CDR/event data, and purge/archive automation.
Administer databases for Oracle Fusion Cloud integrations managing landing/staging databases, OIC connectivity, and hybrid database links between on-prem and Fusion SaaS.
Coordinate with application teams on release deployments, schema changes, data migrations, and application-driven database changes.
High Availability & Disaster Recovery
Implement and maintain Oracle Data Guard (Physical/Logical Standby, Active Data Guard) for on-prem and OCI.
Design and execute switchover/failover runbooks including cross-platform DR scenarios (on-prem ↔ OCI).
Manage RMAN backup and recovery strategies including backup to disk, tape (OSB), OCI Object Storage, and ZDLRA.
Configure and maintain Oracle Flashback technologies (Flashback Database, Flashback Table, Restore Points).
Implement Oracle GoldenGate for real-time replication, zero-downtime migration, and active-active configurations.
Performance Engineering & Tuning
Perform proactive performance analysis using AWR, ASH, ADDM, SQL Tuning Advisor, and SQL Plan Management.
Tune SQL workloads, execution plans, and optimizer statistics for application-specific patterns (EBS, Siebel, BRM).
Configure and optimise Resource Manager plans for multi-workload consolidation and PDB-level resource isolation.
Monitor and tune I/O, memory (SGA/PGA), and concurrency across RAC instances.
Conduct capacity planning and trending analysis to inform scaling and consolidation decisions.
Security & Compliance
Implement Transparent Data…