Senior Oracle Backend DBA
Core
Administer and optimize Oracle databases supporting Oracle E-Business Suite (EBS) 12.2.12 in RAC and standalone environments, ensuring high availability, performance, and disaster recovery.
Role type
Senior Oracle Backend DBA
Builds
Oracle EBS 12.2.12 backend infrastructure, database tiers, and high-availability clusters
Domain
Enterprise Resource Planning (ERP), Oracle Database
Required skills
Oracle Database 12c/19c, Oracle EBS R12.2.x, SQL tuning, ASM, OEM, RAC, RMAN, Data Guard, Linux/Unix shell scripting, ADOP, EBR, editioned objects
Preferred skills
OCI-hosted EBS, hybrid cloud environments, OIC-integrated environments, ERP modernization architecture
Technologies
Oracle, Linux, Unix, SQL, RMAN, Data Guard, RAC, ADOP, EBR, OIC
Responsibilities
Administer Oracle databases supporting EBS 12.2.12 in RAC and standalone environments; Tune SQL, instances, memory, storage, and indexes to maintain application performance; Manage tablespaces, partitions, statistics, and segment housekeeping; Diagnose and resolve database failures, locking issues, and performance degradation; Support EBS backend components including application and workflow schemas; Apply Oracle CPU, PSU, and RU patches as well as EBS technology stack updates; Manage backend activities for EBS 12.2 online patching with ADOP; Develop and maintain RMAN backup strategies and retention policies; Implement disaster-recovery solutions and take part in DR planning and testing; Maintain high availability through RAC and DG/ADG configurations and monitoring; Apply database security controls including access management, auditing, encryption, SSL, and patch compliance; Monitor database health, growth, performance, and key operational metrics; Handle incident management including P1/P2 break-fix issues involving the database or EBS backend.