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
- Valuable 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

📌 Oracle Apps Technical & APEX Developer (Uttarakhand)
🏢 Gold Plus Glass Industry
📍 Uttarakhand