We are seeking a highly skilled Senior Oracle PaaS Developer Technical Consultant for our multination technology client. The ideal candidate will be responsible for designing, developing, and implementing Oracle Platform as a Service (PaaS) solutions that meet client requirements.
Technology Stack: Oracle ATP, Oracle APEX, Oracle Integration Cloud (OIC), Oracle Process Automation (OPA), Oracle Fusion Cloud
Role SummaryWe are seeking an experienced Oracle PaaS Developer with a minimum of 9 years of overall Oracle development experience, including strong hands-on expertise in building enterprise applications using Oracle Autonomous Transaction Processing (ATP), Oracle APEX, Oracle Integration Cloud (OIC), and Oracle Process Automation (OPA).
The candidate will be responsible for designing and developing secure, scalable PaaS applications with APEX as the UI layer, ATP as the application database, OIC as the integration and orchestration layer, and OPA for business workflows and approvals.
The role requires strong experience integrating PaaS applications with Oracle Fusion Cloud ERP/HCM/SCM and other enterprise applications through REST/SOAP APIs.
Key Responsibilities
- Design and develop enterprise applications using Oracle APEX on ATP.
- Design relational database objects including tables, views, packages, procedures, functions, triggers, sequences, and indexes.
- Develop efficient SQL and PL/SQL components following performance and security best practices.
- Build responsive APEX applications including:
- Interactive Reports and Grids
- Forms and dashboards
- Dynamic Actions
- Shared Components
- Authorization and authentication schemes
- REST-enabled functionality
- Design synchronous and asynchronous integration patterns between APEX/ATP, Oracle Fusion Cloud, OPA, and external applications.
- Develop and consume REST and SOAP web services.
- Integrate with Oracle Fusion using available REST/SOAP APIs and business events.
- Implement transformation, orchestration, error handling, logging, retry, and monitoring mechanisms within OIC.
- Develop business workflows and human approval processes using Oracle Process Automation (OPA).
- Integrate APEX applications with OPA for approvals, task management, escalation, and workflow-status tracking.
- Design application audit trails and operational monitoring capabilities.
- Implement appropriate authentication, authorization, and application security controls.
- Troubleshoot production issues across the APEX ATP OIC OPA Fusion technology stack.
- Participate in solution architecture, technical design, code reviews, testing, deployment, and production support.
- Prepare technical design documents, integration specifications, deployment documentation, and support procedures.
The successful candidate will possess strong problem-solving skills, excellent communication abilities, and a proven track record of delivering high-quality Oracle PaaS solutions on time and within budget.
