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