Senior Oracle APEX Consultant

Job Description

Role Overview

We are looking for a highly skilled Senior Oracle APEX Consultant to design, develop, and support Oracle APEX applications integrated with Oracle Fusion Cloud. The consultant will build dashboards, review workflows, audit functionality, and API integrations while ensuring high performance, usability, and compliance requirements are met.

Key Responsibilities

Application Development

• Develop Oracle APEX applications using best practices.
• Build role-based dashboards and interactive reports.
• Develop drill-down reporting and analytical views.
• Create forms, workflows, and approval-driven functionalities.
• Configure export features and dashboard visualizations.

Oracle Fusion Integration

• Develop integrations with Oracle Fusion REST APIs.
• Consume and process Oracle Procurement and PO data.
• Implement error handling and reconciliation mechanisms.
• Support automated transaction and workflow execution.

Database Development

• Develop PL/SQL packages, procedures, functions, and triggers.
• Create efficient SQL queries and database objects.
• Implement audit trail tables and historical tracking.
• Optimize performance for large-volume transactional data.

Security & Compliance

• Implement role-based security models.
• Support audit logging and traceability requirements.
• Ensure compliance with SOX and internal controls.
• Maintain data integrity and segregation of duties requirements.

Testing & Deployment

• Prepare unit test cases and support SIT/UAT.
• Resolve defects and performance issues.
• Support deployments across environments.
• Participate in production support and hypercare activities.

Qualifications

Required Technical Skills

Oracle Technologies

• Oracle APEX
• Oracle Database
• PL/SQL
• SQL Tuning
• Oracle REST Data Services (ORDS)
• Oracle Fusion REST APIs
• Oracle Autonomous Database / ADW

Development Skills

• REST API Integration
• JSON Processing
• JavaScript
• HTML/CSS
• Interactive Reports & Dashboards
• Dynamic Actions
• Application Security

Functional Skills

• Oracle Procurement
• Purchase Orders
• Accounts Payables
• Financial Accrual Processes
• Month-End Reporting
• Audit Controls

Preferred Qualifications

• Oracle APEX Certification
• Oracle Cloud ERP Exposure
• Experience integrating APEX with Oracle Fusion
• Experience working in agile delivery teams

Key Competencies

• Strong problem-solving skills
• Stakeholder communication
• Solution-oriented mindset
• Attention to detail
• Ownership and accountability
• Ability to work independently and within distributed teams

Ideal Experience Profile

• Delivered enterprise Oracle APEX applications.
• Integrated APEX with Oracle Fusion Cloud using REST APIs.
• Worked on finance, procurement, audit, or compliance-related applications.
• Experience implementing audit trails, approval workflows, and role-based security models.