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.

Roles & Responsibilities

• Lead functional activities for Oracle Fusion Cloud PPM implementations and support engagements.
• Gather business requirements and translate them into Oracle Fusion PPM solutions.
• Configure and maintain PPM modules based on business requirements.
• Perform fit-gap analysis and recommend standard Oracle solutions while minimizing unnecessary customizations.
• Configure project structures, templates, project types, classifications, organizations, roles, and task structures.
• Configure project budgeting, forecasting, financial plans, baselines, estimates, commitments, and actuals.
• Support Project Costing, Billing, Contracts, Management, and Resource Management processes.
• Analyze integration points between PPM and AP, AR, GL, Fixed Assets, and Payroll.
• Work with technical teams on RICE requirements and provide functional specifications.
• Review and validate reports, interfaces, conversions, and extensions from a functional perspective.
• Participate in CRP, SIT, UAT, and functional unit testing.
• Support FBDI/ADFDI-based data migration activities and validate migrated data.
• Troubleshoot functional issues, interface errors, ESS jobs, and integration failures.
• Raise, manage, and follow up on Oracle Support SRs where required.
• Prepare functional design documents, configuration documents, test scenarios, and user guides.
• Conduct end-user training and support business users during implementation and post-go-live.
• Provide production support and ensure timely resolution of PPM-related issues.
• Collaborate effectively with business stakeholders, technical teams, project managers, and other Oracle functional consultants.

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 seeking an experienced Fusion Receivables Functional Consultant with following skills:

• Designing Oracle Fusion Receivables process flows to handle data migrations, transformation and orchestration of Interfaces between third party systems and Oracle Cloud.
• Responsible for designing, developing, and maintaining expert level skills on Fusion Receivables.
• Demonstrated experience in gathering and documenting business requirements, leading fit-gap analysis, conference room pilots (CRPs) functional configuration, testing, client user training.
• Design and develop integrations to/from Oracle ERP Fusion receivables FBDI File Uploads.

We are looking for an experienced Oracle RMCS Functional Consultant to support ongoing Oracle Revenue Management Cloud Service (RMCS) implementation activities and production support. The ideal candidate should be a hands-on functional practitioner with strong RMCS experience and the ability to work independently with business and technical teams.

About the role

Key Responsibilities

• Support ongoing Oracle RMCS implementation and enhancement activities.
• Provide functional support for RMCS production issues, troubleshooting and resolution.
• Configure and maintain RMCS functional setups based on business requirements.
• Analyze business requirements and translate them into effective RMCS solutions.
• Support revenue recognition, transaction processing, performance obligations, and accounting-related processes.
• Coordinate with Finance, Accounting, Technical and Integration teams.
• Perform functional testing, issue analysis, UAT support and defect resolution.
• Prepare functional documentation and provide knowledge transfer where required.

Required Skills

• 5–10 years of relevant experience in Oracle ERP/Cloud Finance, with strong hands-on experience in Oracle RMCS.
• Proven experience in Oracle Revenue Management Cloud Service implementation and production support.
• Strong understanding of RMCS functional processes and configurations.
• Experience in requirement analysis, functional testing and issue resolution.
• Good understanding of integration touchpoints with Oracle Financials/ERP modules.
• Strong communication and stakeholder management skills.
• Ability to work independently in a remote delivery environment.We are looking for an experienced Oracle RMCS Functional Consultant to support ongoing Oracle Revenue Management Cloud Service (RMCS) implementation activities and production support. The ideal candidate should be a hands-on functional practitioner with strong RMCS experience and the ability to work independently with business and technical teams.

We are looking for an experienced Oracle ARCS Functional Consultant with strong hands-on expertise in Oracle Account Reconciliation Cloud Service (ARCS) and proven working knowledge of Cash Management. The candidate will support functional implementation, configuration, testing, issue resolution, and production support activities.

About the role

We are looking for an experienced Oracle ARCS Functional Consultant with strong hands-on expertise in Oracle Account Reconciliation Cloud Service (ARCS) and proven working knowledge of Cash Management. The candidate will support functional implementation, configuration, testing, issue resolution, and production support activities.

Key Responsibilities

• Provide hands-on functional support for Oracle ARCS implementation and production activities.
• Configure and maintain ARCS modules based on business requirements.
• Work on Account Reconciliation, Transaction Matching, Reconciliation Compliance, and related ARCS processes.
• Support integration and data flow between ARCS and other Oracle Financial applications.
• Apply working knowledge of Cash Management processes and reconciliation requirements.
• Analyze functional issues, identify root causes, and provide appropriate solutions.
• Support SIT/UAT, defect resolution, deployment, and post-production support.
• Prepare functional specifications, process documentation, test scenarios, and user guides.
• Collaborate with Finance, Accounting, IT, and other stakeholders to understand and translate business requirements.
• Provide ongoing production support and participate in continuous process improvements.

Required Skills

• 5–10 years of relevant functional experience.
• Strong hands-on experience with Oracle ARCS.
• Good understanding of Account Reconciliation and Transaction Matching.
• Proven working knowledge/experience in Oracle Cash Management.
• Experience in ARCS configuration, testing, troubleshooting, and production support.
• Understanding of financial reconciliation and accounting processes.
• Strong analytical, communication, and stakeholder-management skills.
• Ability to work independently as a mid-to-senior level functional practitioner.

Role Overview

We are looking for an experienced Oracle EBS PTM/SCM Functional Consultant with 8–10 years of experience in Oracle Supply Chain Management, with strong hands-on expertise in Oracle Cloud Inventory and secondary expertise in Oracle Cloud Costing.

The ideal candidate should have strong experience working in Oracle Cloud environments, with the ability to understand business processes, prepare functional documentation, support technical development teams, and work on integrations, migration objects, and reports. Prior experience in Oracle EBS is preferred, while strong and recent Oracle Cloud SCM experience is mandatory.

Key Responsibilities

• Provide functional expertise in Oracle Cloud Inventory, with Oracle Cloud Costing as a secondary area.
• Analyze business requirements and translate them into Oracle Cloud SCM functional solutions.
• Work as a Functional / Techno-Functional Consultant across Oracle Cloud Supply Chain processes.
• Configure and support Oracle Cloud Inventory and Costing modules based on business requirements.
• Prepare detailed functional design documents for RICE objects, including reports, integrations, conversions, extensions, and other custom requirements.
• Collaborate closely with technical teams and provide functional specifications, clarifications, and development support.
• Support the design and implementation of custom integrations between Oracle Cloud and boundary applications such as WMS, 3PL, and other Supply Chain applications.
• Work on integration requirements specifically related to Inventory and Costing processes.
• Support data migration/conversion activities, including defining migration requirements, data mapping, validation, and reconciliation.
• Provide functional support for custom reports and interfaces, including requirement analysis and functional validation.
• Participate in solution design, testing, defect resolution, deployment, and post-production support.
• Understand end-to-end Oracle Cloud SCM business processes and their impact on Inventory and Costing.
• Collaborate with business stakeholders, technical teams, integration teams, and other functional teams to deliver solutions.
• Support SIT/UAT activities and assist in resolving functional and integration issues.
• Ensure proper documentation of business processes, functional specifications, configurations, test scenarios, and solution designs.

Mandatory Skills

• 8–10 years of overall experience in Oracle SCM / PTM.
• Strong hands-on experience in Oracle Cloud Inventory.
• Good working experience in Oracle Cloud Costing as a secondary module.
• Proven experience working as a Functional Consultant in Oracle Cloud environments.
• Strong experience in preparing functional design documents for RICE objects.
• Ability to work closely with technical/development teams and provide functional guidance during development.
• Experience with Oracle Cloud Supply Chain processes.
• Exposure to integrations with boundary applications such as WMS, 3PL, and other external Supply Chain systems.
• Ability to work in a Techno-Functional capacity.
• Exposure to custom integrations, migration/conversion objects, and reports.
• Strong analytical, problem-solving, communication, and documentation skills.

Good to Have

• Prior experience with Oracle EBS SCM and related Supply Chain modules.
• Experience transitioning or supporting solutions across Oracle EBS and Oracle Cloud environments.
• Strong understanding of end-to-end Supply Chain processes.
• Experience working on complex Oracle Cloud implementations, rollouts, or support engagements.
• Exposure to integration architecture and troubleshooting.
• Experience in preparing functional specifications, mapping documents, test scripts, and other project documentation.

Education

• Bachelor's degree in Computer Science, Engineering, Information Technology, Business, or a related field.
• Relevant Oracle certifications will be an added advantage.

I

Core Expertise: Oracle Cloud Inventory | Oracle Cloud Costing | Oracle SCM | Oracle EBS | RICE Objects | WMS/3PL Integrations | Functional Documentation | Techno-Functional Consulting

• Configure, maintain, and support Oracle RMCS (Revenue Management and Contract Management) based on business requirements.
• Analyze and independently resolve RMCS functional and technical issues, defects, and production incidents.
• Perform root-cause analysis, troubleshooting, configuration changes, and technical fixes for RMCS-related issues.
• Manage RMCS setup and configuration, including revenue contracts, performance obligations, allocation, revenue recognition, and accounting rules.
• Understand and troubleshoot the end-to-end data flow between Oracle EBS and RMCS across various business scenarios.
• Analyze EBS-to-RMCS interfaces, integrations, transaction flows, and data synchronization issues.
• Develop or modify technical solutions using SQL/PLSQL, APIs, interfaces, and other Oracle technical components where required.
• Support integration-related issues involving Oracle EBS, Oracle Fusion, RMCS, AR, GL, Order Management, and other upstream/downstream systems.
• Validate configuration and technical changes through unit testing, integration testing, and defect resolution.
• Work with functional and business teams to understand requirements and translate them into RMCS configuration or technical solutions.
• Perform impact analysis for RMCS enhancements, fixes, and configuration changes.
• Monitor RMCS processing and investigate failed transactions, incorrect revenue recognition, accounting discrepancies, and interface errors.
• Support implementation, enhancement, migration, and production support activities for RMCS.
• Prepare technical/functional documentation covering configuration, integrations, issue resolution, and business processes.
• Ensure solutions follow Oracle RMCS best practices while minimizing unnecessary customization.

Oracle Fusion Cloud PPM Functional Consultant – Onsite

We are seeking an experienced Oracle Fusion Cloud PPM Functional Consultant to implement, configure, and support Oracle PPM modules. You will gather business requirements, perform fit-gap analysis, and ensure seamless integration across Oracle financial systems.

Key Responsibilities

• Implement, configure, and support Oracle Fusion Cloud PPM modules including Project Costing, Billing, Contracts, and Financial Management.
• Gather business requirements, conduct fit-gap analysis, and prepare functional design and solution documents.
• Configure project accounting, budgeting, costing, billing, revenue recognition, and capitalization processes.
• Ensure seamless integration between Oracle PPM and Oracle Financials modules (GL, AP, AR, FA).
• Support end-to-end implementation activities including CRP, SIT, UAT, data migration, and cutover.
• Troubleshoot functional issues, provide production support, and perform impact analysis for quarterly updates.

Required Skills & Experience

• Strong expertise in Oracle Fusion Cloud PPM modules.
• Experience in gathering business requirements and writing functional designs.
• Knowledge of Oracle Financials integration and month-end activities.
• Familiarity with cross-charge processes between entities and project billing.