Oracle Technical Consultant

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