Oracle APEX & Forms Modernization Engineer (Remote)

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

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