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.

∙Robust experience supporting Oracle EBS R12.2 as an Apps DBA.

∙Practical knowledge of RAC, ASM, Data Guard, RMAN, Data Pump, and

Skills:- Oracle DBA, oracle ebs 12, Oracle RAC, Oracle ASM, Oracle Data Guard, Oracle RMAN, ADOP, Autoconfig, Rapid clone, SQL tuning and Linux/Unix

📌 Oracle Database Administration (Indore)
🏢 Sapical Consulting Services Private
📍 Indore