Senior Oracle APEX Consultant

Captiv Techno Solutions; Chennai; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Captiv Techno Solutions is seeking an experienced Oracle APEX Consultant to design, develop, and maintain enterprise applications using Oracle APEX, Oracle Database, PL/SQL, and REST APIs. The role involves building forms, reports, dashboards, and workflows while ensuring robust security and scalable performance.

You will design and optimize database objects, implement ORDS for REST APIs, and integrate with ERP and external systems.

Qualifications

• 6+ years of Oracle development experience with hands-on APEX expertise.
• Experience with APEX 22.x/23.x/24.x or later.
• Strong SQL, PL/SQL, packages, procedures, functions, and triggers.
• Experience with Oracle Database 19c or later.
• Proficiency in JavaScript, HTML5, CSS3, and dynamic actions.
• Experience with REST APIs, JSON, and ORDS.
• Experience with Interactive Reports, Interactive Grids, charts, dashboards.
• Knowledge of application security and RBAC.
• SQL tuning and performance optimization.

Responsibilities

• Design and develop enterprise web apps using Oracle APEX.
• Create interactive forms, reports, dashboards, and workflows.
• Optimize Oracle database objects, SQL queries, and PL/SQL.
• Develop and consume REST APIs with ORDS.
• Implement authentication, authorization, and RBAC.
• Integrate APEX with Oracle ERP and external systems.
• Troubleshoot issues and optimize performance.
• Support SIT, UAT, production deployment and post-production.
• Prepare technical documentation and follow best practices.

Skills

Oracle APEX

PL/SQL

Oracle SQL

REST APIs

JavaScript

HTML5

CSS3

SQL tuning

Education

Bachelor's degree in CS/IT

Tools

ORDS

Oracle Database

Job description

Job Summary

We are looking for an experienced Oracle APEX Consultant to design, develop, and maintain enterprise applications using Oracle Application Express (APEX), Oracle Database, PL/SQL, and REST APIs.

Key Responsibilities

• Design and develop enterprise web applications using Oracle APEX.
• Develop interactive forms, reports, dashboards, and workflows.
• Design and optimize Oracle database objects, SQL queries, and PL/SQL procedures.
• Develop and consume REST APIs using Oracle REST Data Services (ORDS).
• Implement authentication, authorization, and role-based access control.
• Integrate APEX applications with Oracle ERP and external systems.
• Troubleshoot application issues and optimize performance.
• Support SIT, UAT, production deployment, and post-production activities.
• Prepare technical documentation and follow development best practices.

Required Technical Skills

• 6+ years of Oracle development experience, with strong hands-on Oracle APEX expertise.
• Oracle APEX 22.x/23.x/24.x or later.
• Oracle SQL, PL/SQL, packages, procedures, functions, and triggers.
• Oracle Database 19c or later.
• JavaScript, HTML5, CSS3, and dynamic actions.
• REST APIs, JSON, and Oracle REST Data Services (ORDS).
• Interactive Reports, Interactive Grids, charts, and dashboards.
• Application security, authentication, and authorization.
• SQL query tuning and database performance optimization.

Preferred Skills

• Oracle E-Business Suite (EBS) integration experience.
• Oracle Cloud Infrastructure (OCI).
• Experience with enterprise workflow applications.
• Experience in data migration and application modernization.

Qualifications

Bachelors degree in computer science, Information Technology, or equivalent experience.