Oracle Apps Technical & APEX Developer

Key Responsibilities

Oracle Apps Technical

• Knowledge of data modelling and database design
• Develop and maintain PL/SQL packages, procedures, functions, triggers
• Design and optimize complex SQL queries and database objects
• Performance tuning using Explain Plan, AWR, Indexing
• Develop Reports, Interfaces, Conversions, and Extensions (RICE) in Oracle EBS if applicable
• Work on Oracle EBS / custom ERP integrations
• Handle data migration, validation, and reconciliation
• Support production issues and perform root cause analysis

Oracle APEX

• Design, develop, and deploy web applications using Oracle APEX
• Build forms, interactive reports, dashboards, and workflows
• Implement Dynamic Actions, Validations, and Page Processes
• Integrate APEX with ORDS / REST APIs
• Implement authentication, authorization, and role-based security
• Customize UI using HTML, CSS, JavaScript
• Manage application deployment across DEV / TEST / PROD
• Understand the integrations between Oracle EBS and Oracle APEX

Required Skills

• Strong hands-on experience in Oracle SQL & PL/SQL
• Expertise in Oracle APEX (19.x / 20.x / 21.x / 22.x+)
• Experience with ORDS
• Good understanding of Oracle Database (12c / 19c / 21c)
• Knowledge of database performance tuning
• Experience with RESTful services (JSON/XML)
• Knowledge and experience in Oracle EBS technical architecture and TRM in Financial, SCM and OPM modules
• Exposure to Linux and basic shell scripting

Good to Have

• Migration experience from Oracle Forms to APEX
• Experience with OCI / On-Prem APEX deployments
• Knowledge of RFID, Visitor Management, or Workflow systems
• Version control tools (Git)
• Basic DevOps exposure