Oracle APEX & Forms Developer

S R INTERNATIONAL INC

4d•Remote

About The Position

The Pennsylvania Conservation and Environment Delivery Center (CEDC), supporting the Pennsylvania Department of Environmental Protection (DEP), is seeking an experienced Oracle Developer to modernize legacy Oracle Forms applications and migrate them to Oracle APEX on Oracle Database 19c. The role develops and maintains PL/SQL components, improves application performance and security, and supports mission-critical environmental and regulatory systems. This is a remote position, and candidates must reside within a two-hour radius of Harrisburg, Pennsylvania. The assignment runs through June 30, 2027, with a start date of November 9, 2026. Work hours are 8:00 AM–4:30 PM, 37.5 hours per week.

Requirements

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 is 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.
Must reside within a two-hour radius of Harrisburg, Pennsylvania.

Nice To Haves

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.

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.