Oracle APEX & Forms Developer

Job Title: Oracle APEX & Forms Developer

Job Code: PA 814659
Client: Commonwealth of Pennsylvania – Department of Environmental Protection (DEP)
Location: Remote – Candidate must reside within a 2-hour radius of Harrisburg, PA
Duration: Through June 30, 2027
Start Date: November 9, 2026
Work Hours: 8:00 AM–4:30 PM (37.5 hours per week)
Closing Date: October 30, 2026, at 4:00 PM

Position Overview

The Pennsylvania Conservation and Environment Delivery Center (CEDC), supporting DEP, is seeking an experienced Oracle Developer to modernize legacy Oracle Forms applications and migrate them to Oracle APEX on Oracle Database 19c. The candidate will develop and maintain PL/SQL components, improve application performance and security, and support mission-critical environmental and regulatory systems.

Required Skills

• Bachelor’s degree in Computer Science or a related field.
• 5–7 years of Oracle PL/SQL development experience, including stored procedures, functions, packages, and advanced queries.
• 5–7 years of Oracle APEX application development experience.
• Strong knowledge of Oracle RDBMS; Oracle 19c preferred.
• Experience with Oracle SQL Developer and/or TOAD.
• Understanding of data modeling principles.
• Experience integrating web services.
• Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle and SQL Server.
• Strong analytical, problem-solving, written, and verbal communication skills.

Preferred Qualifications

• Experience modernizing legacy Oracle Forms applications.
• Prior Commonwealth of Pennsylvania or environmental systems experience.
• Exposure to XML, HTML, Java, web services, PL/SQL APIs, and SOA architecture.
• Experience with Agile/Scrum methodologies.
• Knowledge of Oracle 19c database features.
• Experience supporting regulatory or mission-critical systems.
• Ability to prepare clear technical and functional documentation.

Key Responsibilities

• Analyze existing Oracle Forms application architecture, data structures, and integrations.
• Migrate and convert legacy Oracle Forms applications to Oracle APEX.
• Design and develop APEX user interfaces and help establish UI/UX standards.
• Develop and maintain PL/SQL procedures, functions, packages, and queries.
• Perform data analysis, scripting, and reporting.
• Implement application security, roles, and authorization models.
• Conduct performance tuning, debugging, and testing.
• Participate in the full SDLC, including requirements gathering, development, testing, deployment, and post-production support.
• Prepare technical, functional, and system documentation.
• Support production deployments, release management, and knowledge transfer.
• Provide weekly status updates and reports to management, end users, and BIT staff.

Primary Skills: Oracle APEX, Oracle Forms, Oracle PL/SQL, Oracle Database 19c, SQL Developer, TOAD, SQL, Stored Procedures, Web Services, Data Modeling, Performance Tuning, Application Security, Agile/Scrum, Legacy Application Modernization, Technical Documentation

This is a remote position.