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 

We are looking for an experienced Oracle EPM Technical Consultant with strong hands-on expertise in Oracle EPM Cloud Planning / EPBCS technical components. The candidate will be responsible for configuring, developing, migrating, and supporting EPM applications across implementation, enhancement, and AMS engagements.

The ideal candidate should have practical experience with Forms, Business Rules, Groovy Calculations, Reports, Data Maps, Data Management, metadata management, and application artifact migration, along with a good understanding of Oracle EPM SaaS products.

Job Summary

We are looking for an experienced Essbase Developer / Consultant with strong hands-on experience in Oracle Essbase OLAP (ASO/BSO) and financial reporting solutions. The candidate will be responsible for designing, developing, testing, supporting, and optimizing Essbase applications and reporting solutions.

The role requires strong technical expertise in Essbase, financial reporting, database modeling, Unix/Linux scripting, and production support.

Key Responsibilities

• Design, develop, test, debug, document, and maintain Essbase solutions using Agile development practices.
• Manage the complete lifecycle of multidimensional financial reporting and analytical applications, including requirements gathering, design, development, testing, deployment, and maintenance.
• Develop and support Oracle Essbase ASO/BSO applications.
• Work extensively with:
• Essbase Outline Design
• Load Rules
• MaxL Scripts
• Calculation Scripts
• Partitions
• Security
• Performance Tuning and Optimization
• Smart View / Excel Add-in
• Design and maintain financial reporting and analytical solutions.
• Work with Star Schema design and relational database modeling using Oracle or SQL Server.
• Source hierarchy and fact data from file-based and relational data sources.
• Work with metadata management systems such as DRM (Data Relationship Management).
• Develop Unix/Linux shell scripts to automate Essbase database outline builds, data loads, and aggregations.
• Build and maintain automation processes using CA AutoSys.
• Troubleshoot and resolve complex technical issues in Essbase applications.
• Provide production and on-call support when required.
• Ensure quality, security, and compliance requirements are met.
• Collaborate with business users, finance teams, and technical stakeholders.
• Document technical solutions, processes, and application changes.

Mandatory Skills

• 7+ years of overall IT/application development experience.
• 5–7 years of hands-on experience with Oracle Essbase OLAP.
• Strong experience with Essbase ASO and BSO.
• Hands-on experience with Outline Design, Load Rules, MaxL, Calc Scripts, Partitions, Security, and Performance Tuning.
• Strong experience with Smart View / Excel Add-in.
• Experience with financial reporting and multidimensional analytical applications.
• Experience with Oracle or SQL Server databases.
• Strong knowledge of Star Schema and relational database modeling.
• Experience with Unix/Linux Shell Scripting.
• Experience with CA AutoSys.
• Experience supporting production environments and providing on-call support.
• Strong communication and stakeholder management skills.

Full-time, permanent position implementing, supporting, and optimizing enterprise ERP systems for clients, with a focus on supply chain, manufacturing, and planning modules. The role is client-facing first: success depends as much on clear, polished communication as on functional expertise.

Required

Polished client communication: able to run status calls, present findings, and manage escalations with professionalism and composure

Ability to translate technical concepts — configurations, integrations, system behavior — into plain language for business and executive audiences

Career at an IT services company, systems integrator, ERP vendor, or consulting firm (e.g., Accenture, NTT Data, Wipro, Infosys, ERP-partner boutiques) — required; candidates whose ERP experience is exclusively in-house at a single employer will not be a fit

5–8 years in enterprise ERP (any major platform: Oracle, SAP, Workday, Dynamics, NetSuite)

At least one full-cycle implementation: requirements, configuration, testing, cutover, post-go-live support

Functional depth in SCM-adjacent modules: inventory, order management, procurement, costing, or planning

Integration exposure: REST/SOAP APIs, third-party system connections, data migration

Clear written deliverables: documentation, status reports, and issue summaries that nontechnical stakeholders can act on

Preferred

Experience presenting to steering committees or client leadership

Multi-industry client exposure

Experience automating support or testing workflows

Reporting/analytics tooling (BI, embedded ERP analytics)

Role Overview

We are looking for a dynamic and detail-oriented ERP Functional Consultant / Implementation & Support Engineer who will be responsible for ERP implementation, user training, and ongoing client support.

Key Responsibilities

● Implement ERP applications at client locations

● Provide user-wise and department-wise training

● Understand and analyze client business requirements and map them in ERP

● Coordinate with internal and external stakeholders for data setup and documentation.

● Prepare user-defined reports and maintain proper documentation

● Handle end-to-end ERP implementation lifecycle.

● Provide post-implementation support and troubleshooting

● Work on modules like Sales, Purchase, Production, Inventory, Finance, HR, etc.

● Manage multiple projects simultaneously in a fast-paced environment

● Ensure timely project delivery and meet utilization targets

Required Skills & Competencies

● Strong analytical, functional, and communication skills

● Understanding of business processes, preferably in the manufacturing industry

● Basic knowledge of SQL (ability to write simple queries).

● Knowledge of ERP modules (Sales, Purchase, Inventory, Finance, HR, etc.)

● Ability to quickly learn new technologies and tools

● Strong problem-solving and multitasking abilities

● Ability to work independently as well as in a team

Eligibility Criteria

● Freshers or candidates with up to 2 years of experience

● Candidates with 2–3 ERP implementation projects preferred (for experienced roles)

● Good communication skills in English and Hindi & Tamil, Telugu, Kannada (regional language is an advantage).

Important Notes (Mandatory Conditions)

1. This is a 100% Work From Office role (No Hybrid / Remote option available)

2. Candidates must be open to travel across India and internationally based on project requirements (Male candidates preferred for travel roles).

3.Accommodation and food are not provided (except during client-site implementation).