Oracle Technical Consultant

Ghobash Group; Dubai; On-site; AED 120,000 - 160,000; Full time

Job summary

A leading technology solutions provider in Dubai is seeking an Oracle Technical & APEX Consultant. You will design and develop Oracle applications and provide technical support for ERP operations. The ideal candidate has at least 8 years of experience with Oracle applications, expertise in APEX development, and strong knowledge of SQL/PLSQL. This is a full-time position with no remote work option.

Qualifications

• 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.
• Excellent written and verbal communication skills.

Responsibilities

• Design and develop robust web applications using Oracle APEX.
• Provide day-to-day technical assistance to ERP operations.
• Gather and document business requirements.

Skills

Programming in SQL and PL/SQL

Oracle APEX Development

Integration with OIC

Oracle ERP R12.x

Expertise in customization of Oracle forms

Education

Bachelor's degree in computer science or related field

Master's degree or relevant professional certification

Tools

Oracle Integration Cloud

Oracle E-Business Suite

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