Oracle Apps technical consultant

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 

Oracle Planning Functional Analyst

6 + years

Duration - 6 Months

Need min 6+ years of experience in implementing Oracle Fusion Cloud Planning solutions. Candidates should have strong expertise in Supply Planning, Demand Planning, and Supply Chain Planning (SCP), along with hands-on experience integrating Planning modules with other Oracle Fusion applications. The ideal candidate should have implementation experience, strong business process understanding, configuration and testing expertise, and the ability to translate business requirements into effective planning solutions. Exposure to SQL/PLSQL and Oracle SCM processes is preferred.

Planning roles:

2:00 PM to 11:00 PM IST during the U.S. Daylight Saving period (approximately March to early November each year) / 3:00 PM to 12:00 Midnight IST during the non-Daylight Saving period (approximately November to the end of February each year).

We are looking for an experienced Oracle Cloud RTR Lead with 7+ years of experience in Oracle Cloud Financials and strong knowledge of financial concepts. The role requires a hands-on professional who can lead client discussions, understand business requirements, and drive Oracle Cloud Finance solutions.

Role & Responsibilities

• Lead Oracle Cloud RTR (Record-to-Report) functional activities and client engagements.Strong hands-on knowledge of GL, Cash Management, FA (Fixed Assets), and CL (Cash/Collections-related processes).
• Good understanding of PPM and its interlocking/integration with financial processes.
• Translate business requirements into effective Oracle Cloud solutions.
• Drive functional discussions, workshops, and solution design with clients.Support configuration, testing, issue resolution, and implementation activities.
• Act as a functional lead and provide guidance to project teams.
• Sound knowledge of CL, FA, cash management, and GL
• some understanding of PPM as well and interlocking
• Hands on skills on oracle cloud and financial concepts