Oracle Apex (Application Express)

Oracle APEX (Application Express)

Location: NYC NY 10002

On-site/Remote/Hybrid: Hybrid 3 days onsite/2 days remote.

Duration: 12 Months Work Hours: 37.5 Hours/Week.

Interview Process: 1-2 Rounds

NEEDS TO BE A LOCAL CANDIDATE ONLY. Initial 1-2 Months candidate has to work onsite, later as per the Hiring Manager's decision it could be Hybrid schedule (3 days onsite/2 days remote) ***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.

About Us: InterSources Inc

InterSources Inc, is a Small, Woman, and Minority-Owned Business Enterprise, ISO/IEC 27001, SOC 2 Type 2 certified company with massive 18+ years of diversified experience in providing IT Consulting Services, Artificial Intelligence, Data Analysis, Application Development, Cloud Services, Cybersecurity, Digital Marketing, ERP Management, Custom Software Development, Web Development, UI/ UX Design, System Integration, QA Support etc. We make reasonable accommodations for clients and employees, and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud and Oracle partner company.