Overview
Skills
Job Details
Title: Oracle Apex Developer
Position Type: Contract
Location: New York, NY
Description:
***This role is a remote position that will require on-site work as needed***
Responsibilities:
The Department of Buses (DOB) is driving several modernization initiatives to upgrade critical workforce applications and expand mobile capabilities. One of the key projects underway is the DOB Deviation Slips modernization, with several additional initiatives in the pipeline (see attached for details).
Resource Request
To ensure timely delivery and support broader modernization goals, DOB is requesting an experienced Oracle APEX developer.
Why This Resource Is Critical
Accelerates development timelines and supports evolving priorities.
Delivers high-impact features and enhances user experience.
Supports scalability and integration with legacy systems.
Key Responsibilities
Migrate Oracle Forms/Reports to APEX.
Develop responsive APEX apps with secure, scalable architecture.
Write and optimize SQL/PLSQL code.
Build reports and dashboards (Power BI, BI Publisher).
Integrate APEX with REST APIs and Oracle Forms (until decommissioned).
Implement security (auth/auth), performance tuning, and CI/CD.
Collaborate with stakeholders and document solutions.
Provide training and knowledge transfer.
Required Skills
5+ years in Oracle APEX and PL/SQL development.
Expertise in APEX 22.x or later (preferably 24.2).
Strong SQL/PLSQL, Oracle 19c, REST API, JSON/XML.
Experience with Oracle Forms 12c and Fusion Middleware.
Familiarity with Git, Azure DevOps, and responsive UI design.
Strong communication, troubleshooting, and analytical skills.
Project Deliverables
Hands-on development and testing of APEX and Power BI solutions.
Ensure compliance with QA, change control, and DR procedures.
Support production issues and performance tuning.
Develop and maintain Oracle Apex/ Power BI.
Provide technical documentation and user support.
Conduct impact analysis and capacity planning.
Collaborate with module leads and ensure successful UAT.
::
Additional Skills and Information: Key Responsibilities
Modernize / Migrate Oracle Forms to APEX.
Build secure APEX apps.
Write/optimize PL/SQL code.
Create reports (Power BI, BI Publisher).
Integrate with Oracle DB & legacy apps.
Use Git/DevOps for deployments.
Collaborate with business/IT teams.
Provide training & documentation.
Required Skills
5+ years Oracle dev (APEX, PL/SQL).
APEX 22.x+ (REST, Dynamic Actions).
Strong SQL/PLSQL tuning.
Power BI & BI Publisher experience.
Oracle Forms migration experience.
Oracle DB 12c/19c knowledge.
REST API, JSON/XML handling.
APEX security best practices.
Git/Azure DevOps.
Strong problem-solving & communication.
Skills: Category Name Required Importance Experience
Software Skills PLSQL No 1 4 - 6 Years