Oracle APEX & Forms Developer

S R INTERNATIONAL INC; Oregon; Hybrid; USD 90,000 - 120,000; Full time

Job summary

The Commonwealth of Pennsylvania - Department of Environmental Protection (CEDC) is seeking an experienced Oracle Developer to modernize legacy Oracle Forms and migrate to Oracle APEX on Oracle Database 19c. The role focuses on PL/SQL development, performance improvements, and security to support critical environmental systems.

Remote position with residency in the Harrisburg, PA area within a 2-hour radius, 37.5 hours per week. Start date November 9, 2026, and duration through June 30, 2027.

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 RDBMS

Data modeling

Web services integration

Performance tuning

Debugging & testing

Communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Developer

TOAD

Job description

Job Title: Oracle APEX & Forms DeveloperJob 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, 2026Work 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.