Oracle APEX Developer / Oracle PL/SQL Developer

Location: Pennsylvania
Department: Department of Environmental Protection (DEP)
Contract: Contract position
Work Schedule: 37.5 hours per week
Work Arrangement: Onsite attendance required at the beginning and end of the contract for Commonwealth equipment inventory and condition verification.

Position Overview

The Pennsylvania Conservation and Environment Delivery Center (CEDC), supporting the Department of Environmental Protection (DEP), is seeking an experienced Oracle Developer to support the modernization of legacy Oracle Forms applications and their migration to Oracle Application Express (APEX) on Oracle Database 19c.

The selected candidate will contribute to modernizing mission-critical environmental and regulatory systems by developing secure, maintainable, and high-performing applications. This role requires strong Oracle PL/SQL development skills, Oracle APEX expertise, database knowledge, and the ability to work collaboratively in an Agile/Scrum environment.

Key Responsibilities

• Analyze existing Oracle Forms applications, including their architecture, data structures, functionality, and integrations.

• Support the migration and conversion of legacy Oracle Forms applications to Oracle APEX.

• Design and develop modern APEX user interfaces in collaboration with the technical lead.

• Help establish UI/UX standards for future APEX applications.

• Develop and maintain PL/SQL stored procedures, functions, packages, and advanced SQL queries.

• Perform data extraction, analysis, and scripting to support reporting and system enhancements.

• Review existing technical and functional documentation to understand system requirements and application architecture.

• Implement and support application security, user roles, and authorization models.

• Conduct performance profiling, debugging, and tuning to improve application responsiveness and maintainability.

• Prepare technical, business-functional, and system documentation.

• Participate throughout the software development lifecycle, including requirements gathering, analysis, development, testing, deployment, and production support.

• Assist with production deployments and release management.

• Provide mentoring and knowledge transfer to Commonwealth IT staff and other developers.

• Prepare weekly status updates for management.

• Generate reports for executive management, end users, and Bureau of Information Technology (BIT) staff.

Required Qualifications

• Bachelor's degree in Computer Science or a related field.

• At least 5 years of experience developing Oracle PL/SQL applications, including:

  • Stored procedures

  • Functions

  • Packages

  • Advanced SQL queries

• At least 5 years of experience developing applications using Oracle APEX.

• Strong knowledge of Oracle RDBMS; Oracle Database 19c is preferred.

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

• Previous experience supporting Commonwealth of Pennsylvania or environmental systems.

• Familiarity with:

  • XML and HTML

  • Web services

  • Java

  • PL/SQL APIs

  • Service-Oriented Architecture (SOA)

  • Agile/Scrum methodologies

• Strong understanding of Oracle Database 19c features.

• Experience supporting regulatory or mission-critical systems.

• Ability to produce clear, comprehensive technical and functional documentation.