Oracle Apex Consultant

Role Overview:

Oracle APEX Consultants

Core Technical Skills (Mandatory):

• Oracle SQL & PL/SQL

  :
• Advanced queries, stored procedures, functions, triggers, and packages.
• Performance tuning and database optimization.
• Strong understanding of relational database design and data modeling

• Oracle APEX Development (latest version 24.x preferred):

• Hands-on expertise in building

  forms, interactive reports/grids, dashboards, charts

• Experience in implementing

  Single Sign-On (SSO), Email and SMS integrations.

• Proficiency with

  Dynamic Actions, Shared Components, Plug-ins, LOVs, Collections

• Customization using

  JavaScript, CSS, and HTML

  within APEX
• Experience with

  Universal Theme & Theme Roller

  for responsive UI design
• Strong knowledge of

  APEX security features

  authentication, authorization, role-based/data-level security
• Integration with

  RESTful Web Services (REST APIs)

  and external systems
• Familiarity with

  Automations, REST Data Sources, and Data Loading features

• Proficiency in

  APEX Application Deployment, Export/Import, and performance tuning

• Familiarity with

  APEX Advisor and performance optimization

• Oracle 23AI Database :

• Awareness of

  AI-assisted development features, vector search, and autonomous database capabilities

• Integration Experience (Highly Preferred):

• Practical experience in

  integrating Oracle APEX with Oracle E-Business Suite (EBS) and/or Oracle Fusion Applications

• Ability to use

  REST/SOAP Web Services, ORDS, and APIs

  for seamless integration
• Understanding of

  security models and data flows between APEX and EBS/Fusion

• Experience in developing

  extensions, reports, or workflows

  that complement EBS/Fusion