Oracle Technical Consultant

Ghobash Group; Dubai; On-site; AED 180,000 - 260,000; Full time

Job summary

Ghobash Group is seeking an Oracle Technical & Apex consultant to work closely with the ERP Functional & Technical team. You will design, customize, and implement Oracle APEX web apps, develop PL/SQL procedures, and support ERP operations using Oracle tools and best practices.

You will also build integrations in Oracle Integration Cloud (OIC) to Oracle ERP, including REST and SOAP calls, and provide post‑implementation support through the software lifecycle.

Qualifications

• Bachelor's degree in computer science or related field.
• Masters degree or relevant professional certification.

Responsibilities

• Design and develop robust web applications using Oracle APEX.
• Develop and implement PL/SQL procedures packages and triggers.
• Provide day-to-day technical assistance to ERP operations.
• Design and develop integrations in OIC to Oracle ERP including REST and SOAP calls.
• Provide hands-on technical and development support for Oracle ERP modules.
• Gather and document business requirements on IT incidents and change work.
• Document and manage technical specifications and software packages.
• Manage on-time changes delivery and customer satisfaction.
• Provide hands-on analysis design testing implementation and post-implementation support (AIMS/OUM).
• Complete development tasks based on requirements and follow Oracle best practices.
• Troubleshoot process issues and liaise with Oracle as required.

Skills

Oracle APEX

PL/SQL

REST APIs

SOAP

OIC Integration

Oracle EBS R12

RICE Components

Form & Reports

Multi-Org

Education

Bachelor's in CS or related field

Masters or professional certification

Tools

Oracle Integration Cloud

Job description

Oracle Technical & Apex consultant is responsible to work closely with the Oracle ERP Functional & Technical team to successfully manage the designing customizing implementing development support testing using Oracle tools and technologies and preparing technical documentation.

Duties and Responsibilities:

• Design and develop robust web applications using Oracle APEX ensuring high performance and compliance with business requirements.
• Develop and implement PL/SQL procedures packages and triggers.
• Responsible for providing day-to-day technical assistance to ERP operations from a technical perspective
• Design and develop integrations in OIC to Oracle ERP including making REST and SOAP calls
• Provide hands‑on technical and development support for implemented Oracle ERP modules.
• Gather and document business requirements on IT incidents and change work.
• Document and manage technical specifications and software packages.
• Manage on‑time changes delivery and business expectations and ensure customer satisfaction.
• Provide hands‑on analysis design testing implementation and post‑implementation support utilizing prescribed software design lifecycle techniques and system documentation techniques (AIMS/OUM).
• Complete development tasks based on requirements submitted by business partners and follow Oracle best practices.
• Troubleshoot process issues and provide remedial actions whether functional or technical in nature liaising with Oracle where required.

Accountabilities:

• Ensure cost‑effective use of Oracle service subscriptions and other Oracle development tools.
• Optimize processing costs while maintaining Oracle performance and security.
• Maintain data quality and integrity and adhere to Oracle coding standards.
• Enhance the organizations ability and improve customer satisfaction.

Qualifications :

• Bachelors degree in computer science or related field
• Masters degree or relevant professional certification

Additional Information :

Experience:

• 8 years of experience on Oracle Applications and OIC integrations
• Experience building integration unit testing and migration of integration components in OIC using REST/SOAP Services.
• Expert in Oracle ERP R12.x Oracle Integration Cloud and Oracle E-Business support.
• Expert in customizing and developing Oracle forms and reports.
• Expert in RICE components Oracle Interface tables in financial and procurement modules.
• Expert in Oracle Workflows Personalizations Oracle Alerts.

Skills & Abilities:

• Strong programming experience in creating Procedures APIs Packages Functions Triggers views collections nested tables and arrays records sequences views Constraints and other database objects using SQL and PL/SQL
• Hands‑On development of packages and functions using SQL/PLSQL and exposing them as REST
• Strong knowledge of Oracle development tools some e‑Business application functionality system administration database structure and knowledge of multi‑Org architecture.
• Knowledge of Oracle R12 ideal with functional understanding of core Oracle EBS Modules including Financials and Procurement
• Advantage: Web Adi OA Framework customization and Personalization of JSP pages APEX.
• Must have good experience translating business requirements and design into technical solutions.
• Ability to research learn troubleshoot and support complex system customizations.
• The ability to multi‑task and prioritize across concurrent workloads may be required.
• Excellent written and verbal communication.
• Ability to work independently and manage multiple project timelines effectively.
• Excellent teamwork and collaboration capabilities.

Remote Work :

No

Employment Type :

Full-time