Oracle Technical Consultant

Company Description

Over the many years of its pursuit for investment diversification, the Ghobash Group has capitalized on opportunities in sectors with encouraging growth potential by either buying out established operating companies or founding new businesses to extend value into those markets. As the portfolio of these fully, or majority-owned operating companies grew and became more diversified, the Group established ABAN INVESTMENT in 2008 to administer and facilitate its smooth operation. Each operating company general manager reports into the CEO of Aban Investment and as such it is an actively managed portfolio of companies.

ABAN Investment currently has stakes in Technology, Oil & Gas, Pharmaceuticals, Industrial Chemicals and Supplies, Hospitality, Healthcare, and Consumer Services. It is committed to building high-value businesses, from start-ups and early stage ventures to mergers and acquisitions for more mature businesses.

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 organization’s ability and improve customer satisfaction.

Qualifications

• Bachelor's degree in computer science or related field
• Master’s 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.