Oracle Technical Consultant

Black & Grey HR Consultancy FZE; Dubai; On-site; AED 120,000 - 200,000; Full time

Job summary

A regional manufacturing and engineering organization in Dubai is seeking an experienced Oracle Technical Consultant to manage technical delivery and support for Oracle applications. Responsibilities include developing and customizing Oracle technical objects and supporting integrations in live environments. Ideal candidates should have 3–7 years of experience in Oracle technical consulting with strong SQL and PL/SQL skills. The position comes with a competitive salary and benefits package.

Benefits

Competitive Salary

Benefits Package

Qualifications

• 3–7 years of hands-on Oracle Technical Consulting experience in live ERP environments.
• Strong expertise in SQL and PL/SQL development and performance tuning.
• Experience building and supporting RICE objects, reports, and integrations.

Responsibilities

• Design, develop, and support Oracle technical objects.
• Build and maintain reports using BI Publisher.
• Own technical incidents and support business-critical operations.

Skills

Oracle Technical Consulting Experience

SQL Development

PL/SQL Development

RICE Components Support

ERP Environments

Tools

BI Publisher

Oracle EBS R12

Oracle Fusion

Job description

Black & Grey HR is recruiting for a well‑established regional manufacturing and engineering organization with a strong footprint across the Middle East and international markets. The company specializes in large‑scale engineered building solutions and operates complex manufacturing and project‑driven ERP environments. Our client is seeking a hands‑on Oracle Technical Consultant who will take ownership of technical delivery, integrations, reporting, and production support across Oracle applications. This role requires someone comfortable working in live environments, supporting business‑critical systems, and delivering practical solutions rather than purely theoretical designs.

Key Responsibilities

Oracle Technical Development & Customization

• Design, develop, customize, and support Oracle technical objects, including RICE components (Reports, Interfaces, Conversions, Extensions).
• Develop, debug, and performance‑tune SQL and PL/SQL code in production environments.
• Build and maintain reports using BI Publisher and related Oracle reporting tools.
• Support deployments, fixes, enhancements, and rollback procedures in live systems.
• Prepare and maintain technical documentation, including design documents, technical specifications, and support runbooks.

Integrations & Interfaces

• Design and support integrations using REST and SOAP APIs and web services.
• Ensure data accuracy, reliability, and proper error handling across interfaces.
• Troubleshoot integration failures and coordinate resolution with internal and external stakeholders.
• Implement logging, monitoring, and recovery mechanisms for interfaces and batch jobs.

Production Support & Collaboration

• Own and resolve technical incidents, service requests, and enhancement tickets.
• Work closely with functional consultants and business users to convert requirements into buildable technical solutions.
• Support business‑critical operations across procurement, inventory, costing, order‑to‑cash, and project‑based processes.
• Operate effectively under pressure in a manufacturing and projects‑driven ERP environment.

Requirements

• 3–7 years of hands‑on Oracle Technical Consulting experience in live ERP environments.
• Strong expertise in SQL and PL/SQL development and performance tuning.
• Proven experience building and supporting RICE objects, reports, and integrations.
• Working knowledge of REST and SOAP services and standard integration patterns.
• Experience supporting production users and managing tickets independently.

Nice to Have

• Exposure to Oracle Integration tools and cloud‑based integrations.
• Experience in manufacturing, projects, engineering, or construction industry ERP systems.
• Experience with Oracle EBS R12, Oracle Fusion, or hybrid environments.

Key Performance Indicators (KPIs)

• Timely and high‑quality ticket resolution
• ERP system stability and uptime
• On‑time delivery of technical enhancements
• Quality and completeness of technical documentation and handovers

Benefits

Competitive Salary + Benefits Package