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
Follow Cutshort