Oracle Technical Consultant

Company DescriptionOver 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 DescriptionResponsible for designing, developing, customizing, and supporting Oracle E-Business Suite (R12.x) technical components to meet business requirements. This role focuses on the development of RICE objects, Oracle forms, reports, workflows, and PL/SQL-based solutions. The consultant ensures system stability, supports functional teams in resolving technical issues, and contributes to delivering enhancements, technical designs, and complex customizations across Oracle Financials and Procurement modules.Technical Responsibilities:Develop and maintain RICE components including reports, interfaces, conversions, and extensions. Customize and support Oracle Forms, Reports, Workflows, Alerts, and Personalizations. Create APIs, Procedures, Packages, Functions, and SQL/PLSQL programs to support system processes. Build and maintain database objects such as tables, views, sequences, constraints, and indexes. Develop and expose PL/SQL packages as REST services when required. Perform technical troubleshooting, performance tuning, and issue resolution across Oracle ERP. Support integration efforts involving Oracle Integration Cloud (OIC) when needed. Ensure all development meets organizational coding standards and best practices. Functional & Operational Responsibilities:Work with functional consultants to understand business requirements and translate them into technical designs. Support Oracle Financials and Procurement modules from a backend and technical perspective. Provide detailed technical documentation, including technical specifications and test cases. Participate in SIT, UAT, and production deployment cycles. Support incident management, problem resolution, and change requests. Ensure system security and proper migration through controlled environments. Project & Collaboration Responsibilities:Collaborate with cross-functional teams to deliver technical enhancements and projects. Provide effort estimations for technical tasks and support planning activities. Assist with root cause analysis on recurring issues and propose long-term fixes. Participate in code reviews to maintain quality and consistency. Deliver technical knowledge transfer to internal IT teams when needed. QualificationsBachelor's degree in computer science or related fieldMaster’s degree or relevant professional certificationAdditional InformationExperience:4+ years of experience in Oracle Applications and OIC integrationsSkills & Abilities:Expert in Oracle ERP R12.x and Oracle E-Business supportExpert in customizing and developing Oracle forms and reportsExpert in RICE components, Oracle Interface tables in financial and procurement modulesExpert in Oracle Workflows, Personalizations, and Oracle AlertsStrong programming experience in creating Procedures, APIs, Packages, Functions, Triggers, views, collections, nested tables and arrays, records, sequences, constraints, and other database objects using SQL and PL/SQLHands-On development of packages and functions using SQL/PLSQL and exposing them as RESTStrong knowledge of Oracle development tools, some e-Business application functionality, system administration, database structure, and knowledge of multi-Org architecture. Must have good experience translating business requirements and design into technical solutionsAbility to research, learn, troubleshoot, and support complex system customizationsThe ability to multitask and prioritize across concurrent workloads may be required. Knowledge of Oracle R12 ideal with functional knowledge of core Oracle EBS Modules including Financials and ProcurementAdvantage: Web Adi, Oracle Integration Cloud, OA Framework, and customization and Personalization of JSP pages, APEXExperience building integration, unit testing of integration components in OIC using REST/SOAP Services. Excellent written and verbal communicationAbility to work independently and manage multiple project timelines effectivelyExcellent teamwork and collaboration capabilities