Oracle Technical Consultant

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

Job summary

A leading IT solutions provider is seeking an Oracle Technical & Apex consultant based in Dubai. The successful candidate will work closely with the ERP team to manage Oracle APEX application development, including design, customization, and integration. Qualifications include a Bachelor's degree in Computer Science and over 8 years of experience in Oracle Applications and OIC integrations. Strong skills in SQL, PL/SQL, and excellent communication and troubleshooting abilities are essential. Remote work is not available, and the role is full-time.

Qualifications

• 8 years of experience on Oracle Applications and OIC integrations.
• Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers, and other database objects.
• Expert in RICE components and Oracle workflows.

Responsibilities

• Design and develop robust web applications using Oracle APEX.
• Provide hands-on technical and development support for implemented Oracle ERP modules.
• Optimize processing costs while maintaining Oracle performance and security.

Skills

SQL and PL/SQL

Oracle ERP

REST/SOAP Services

Oracle Integration Cloud (OIC)

Oracle Forms and Reports

Documentation Skills

Communication Skills

Troubleshooting Skills

Education

Bachelor's degree in computer science or related field

Master's degree or related professional certification

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