Oracle APEX & Forms Developer

S R International Inc; United States; Remote; USD 110,000 - 140,000; Full time

Job summary

Commonwealth of Pennsylvania – Department of Environmental Protection (DEP) seeks an experienced Oracle Developer to modernize legacy Oracle Forms applications and migrate them to Oracle APEX on Oracle Database 19c. You will develop and maintain PL/SQL components, improve performance and security, and support mission-critical environmental regulatory systems.

The role is remote, with the candidate residing within a 2-hour radius of Harrisburg, PA, and requires 5–7 years of Oracle PL/SQL and APEX

Qualifications

• 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.

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.

Skills

Oracle PL/SQL

Oracle APEX

Oracle Forms

Oracle DB 19c

SQL Developer

TOAD

Data Modeling

Web Services

Performance Tuning

SDLC

Agile/Scrum

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Developer

TOAD

Oracle 19c

Job description

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.