Oracle Database Administration

Job Description — L2/L3 Oracle DBA and Oracle Apps DBA Experience: 5–10 years of relevant experience​Support coverage: Dubai customer business hours and on-call support as required Role Overview We are seeking an experienced Oracle DBA and Oracle Apps DBA to support customer Oracle Database and Oracle E-Business Suite (EBS) environments. The role involves L2 incident resolution, L3 troubleshooting, performance tuning, patching, upgrades, and maintaining database and application availability. Key Responsibilities Oracle Database Administration ∙Install, configure, administer, and maintain Oracle databases across production and non-production environments. ∙Monitor database health, availability, performance, storage, and capacity. ∙Troubleshoot database incidents, connectivity failures, locking, blocking, and resource issues. ∙Analyse AWR and ASH reports, SQL execution plans, and database wait events to resolve performance problems. ∙Configure and manage RMAN backups; perform recovery and restore validation. ∙Administer Oracle RAC, ASM, Grid Infrastructure, and Data Guard environments. ∙Perform database patching, upgrades, migrations, and refreshes through approved change procedures. ∙Manage database users, roles, privileges, auditing, and security controls. ∙Execute disaster recovery drills, Data Guard switchovers, and failovers. ∙Automate routine administration and monitoring using shell scripts and SQL. Oracle Applications DBA ∙Administer Oracle E-Business Suite R12.2 application and database tiers. ∙Monitor and troubleshoot concurrent managers, concurrent requests, Workflow Mailer, application services, and login issues. ∙Perform EBS online patching using ADOP and manage the associated  patching lifecycle. ∙Clone and refresh EBS environments using supported tools, including Rapid Clone. ∙Maintain application configuration using AutoConfig and context files. ∙Administer EBS-related WebLogic Server, Oracle HTTP Server, and Forms services. ∙Troubleshoot application-tier performance and coordinate with functional and development teams. ∙Support EBS upgrades, technology-stack patches, certificate renewals, and integration-related incidents. ∙Maintain operational procedures for application startup, shutdown, backup, recovery, and maintenance. L2/L3 Support and Customer Operations ∙Own incidents and service requests within agreed SLAs. ∙Provide L2 troubleshooting and escalate complex issues with complete diagnostic evidence. ∙Lead L3 investigation, root-cause analysis, and permanent corrective actions. ∙Support major incidents, communicate progress, and document recovery actions. ∙Raise and manage Oracle Support service requests. ∙Prepare change plans, risk assessments, validation steps, and rollback procedures. ∙Maintain runbooks, knowledge articles, configuration records, and shift handovers. ∙Coordinate with customer teams and internal infrastructure, storage, network, and application teams. ∙Mentor junior DBAs and identify opportunities to reduce recurring incidents. Required Skills and Experience ∙Hands-on production experience administering Oracle Database, including Oracle 10g, 11g, 12c, 18c and 19c. ∙Strong experience supporting Oracle EBS R12.2 as an Apps DBA. ∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and