Oracle Technical And Apex Consultant

Job Description

Job Title: Oracle Technical & Apex consultant

Job Location- Dubai

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 & 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 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
  
  

• 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, integrity and follow oracle coding standards
• Enhance the organizations’ ability and improve customer satisfaction
  
  

• Bachelors degree in computer science or related field
  
  

• Master’s degree or relevant professional certification
  
  

• 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, Personalization’s, Oracle Alerts
  
  

• 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.
  
  

• Master’s degree or relevant professional certification
• 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, Personalization’s, Oracle Alerts
• Knowledge of Oracle R12 ideal with functional knowledge of core Oracle EBS Modules including Financials and Procurement
• Advantage: Web Adi, OA Framework and 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