Oracle Apex Developer

Acadia Technologies, Inc.; United States; Remote; USD 96,000 - 152,000; Full time

Job summary

Acadia Technologies, Inc. is seeking an experienced Oracle APEX Developer for a remote 6-month contract.

You will lead modernization of Legacy Oracle Forms to APEX, design interactive reports, dashboards, and workflow automation, and ensure secure, DevSecOps deployments. The role requires 7–9 years in Oracle APEX with strong PL/SQL, REST/SOAP integrations, and experience with OIC, adapters, and EA governance reporting.

Qualifications

• 7–9 years of Oracle APEX development experience.
• Experience migrating Legacy Oracle Forms to APEX.
• Strong PL/SQL development skills.
• Experience developing and consuming REST and SOAP APIs.
• Experience integrating Oracle Fusion Applications with internal and third-party systems.
• Ability to design and build OIC orchestrations and integration flows.
• Experience with REST, SOAP, Database, FTP/SFTP, and Kafka adapters.
• Design and optimize APEX apps including reports, dashboards, and workflows.
• Write efficient, secure PL/SQL and SQL, including stored procedures and triggers.
• Experience with automated GitHub DevSecOps processes and security scanning.

Responsibilities

• Design, develop, and optimize APEX applications from the ground up.
• Create interactive reports, dashboards, forms, and workflow automation.
• Implement secure deployments with traceability and backups.
• Collaborate with stakeholders to translate requirements into technical solutions.

Skills

Oracle APEX

PL/SQL

REST APIs

SOAP APIs

OIC integration

DevSecOps (GitHub)

Security scanning

SQL tuning

Stakeholder comms

Front-end in APEX

Education

Bachelor's degree in mathematics, computer science, information systems, or related technical discipline

Tools

GitHub

Oracle Fusion Applications

Oracle APEX (dev environment)

Job description

Job Title: Oracle APEX Developer
Location: Remote

Duration: 6-month contract, with potential for extension

Required / Must-haves:

• 7 to 9 years of strong Oracle APEX development experience (Healthcare experience is a plus).

• Complete modernization and migration of all Legacy Oracle Forms Applications to APEX

• Front-end development experience within Oracle APEX,

• Strong PL/SQL development skills

• Experience developing and consuming REST and SOAP APIs.

• Experience integrating Oracle Fusion Applications with internal and third-party systems.

• Ability to design and build OIC orchestrations, integration flows, scheduled processes, and file-based integrations.

• Experience working with common OIC adapters such as REST, SOAP, Database, FTP/SFTP, and Kafka.

• Design, develop, and optimize APEX applications from the ground up, including interactive reports, dashboards, forms, and workflow automation supporting EA governance and reporting needs

• Write efficient, secure PL/SQL and SQL, including stored procedures, packages, triggers, and performance-tuned queries.

• Use fully automated GitHub-based DevSecOps processes for Oracle APEX applications to ensure consistent deployments, daily backups, automated repository maintenance, and improved traceability.

• Create and implement automated, continuous security scanning processes for APEX applications, APIs, and cloud-hosted assets to meet FISMA, NIST, and ARS requirements.

• Senior-level hands-on developer who is actively coding and troubleshooting complex technical issues, not solely serving in an architect or management role.
  Qualifications

• Bachelor's degree in mathematics, computer science, information systems, or a related technical discipline is required.

• Demonstrated hands-on experience building production APEX applications, including native components and custom PL/SQL logic

• Strong proficiency in SQL and PL/SQL performance optimization

• Experience with REST integration, interactive grids, and dynamic actions in APEX

• Ability to communicate technical concepts clearly to non-technical stakeholders