Oracle Apex and PLSQL Developer

Pyramid It Consulting; United States; Remote; USD 90,000 - 120,000; Full time

Job summary

Pyramid It Consulting is looking for an Oracle APEX Technical Developer to design and develop responsive web applications using Oracle APEX.

You will be responsible for creating interactive reports, optimizing queries, and implementing business logic. Familiarity with PL/SQL, various Oracle tools, application security, and Agile methodology is essential.

Qualifications

• Experience in Oracle APEX Development with responsive web applications.
• Proficient in writing complex PL/SQL procedures and triggers.
• Knowledge of Oracle Cloud technologies and integrations.

Skills

Oracle APEX Development

PL/SQL Programming

Oracle Visual Builder Cloud Service (VBCS)

REST/SOAP Web Services

Application Security

Agile/Scrum Methodology

Tools

SQL Developer

Postman

Oracle Integration Cloud

JDeveloper

Job description

Role & responsibilities

Oracle APEX Technical Developer

Remote - local to Pune

Required Skills

Oracle APEX Development

• Design and development of responsive web applications using Oracle APEX.
• Creation of interactive reports, dashboards, and REST-enabled components.
• Dynamic actions, page processes, and custom plug-ins.

PL/SQL Programming

• Writing complex stored procedures, triggers, and functions.
• Query optimization and performance tuning.
• Implementation of business logic and data validation layers.

Oracle Visual Builder Cloud Service (VBCS)

• Low-code development of web and mobile applications.
• Integration of VBCS apps with REST APIs and Oracle SaaS (ERP/HCM/SCM) modules.
• UI customization using JavaScript, HTML5, and CSS.

Integrations

• REST/SOAP Web Service design and implementation.
• Oracle Integration Cloud for app-to-app and B2B integration flows.
• Integration with Oracle ERP, HCM, and third-party systems.
• JSON/XML data handling and transformation.

Databases & Tools

• Oracle Database (11g/12c/19c)
• SQL Developer, APEX Workspace, Postman, Oracle Integration Cloud, JDeveloper.

Other Skills

• Application security and authentication (SSO, OAuth).
• Version control (Git, GitHub).
• Agile/Scrum methodology

Certifications

• Oracle Cloud SCM / Order Management Specialist (if applicable)
• Oracle APEX Developer Certified Professional
• Oracle Cloud Infrastructure Foundations
• Oracle Integration Cloud Specialist (optional)

Soft Skills

• Strong techno-functional bridging capability
• Excellent documentation and analytical skills
• Clear communicator across business and IT teams
• Experienced in Agile / Waterfall methodologies