Job Title: Oracle Developer (Oracle APEX & PL/SQL) Client: Commonwealth of Pennsylvania – Department of Environmental Protection (DEP) Location: Remote (Local to Harrisburg, PA Preferred) Duration: Long-Term Contract (40 hrs/week) Rate: $60/hr on C2C Interview Type: Webcam Position ID: 796386 Job Overview The Department of Environmental Protection (DEP), through the Conservation and Environment Delivery Center (CEDC), is seeking an experienced Oracle Developer to support a critical enterprise modernization initiative. The selected candidate will assist in migrating legacy Oracle Forms applications to modern Oracle APEX applications running on Oracle Database 19c. This role requires strong expertise in Oracle PL/SQL, Oracle APEX development, database design, and application modernization. The candidate will contribute to developing secure, scalable, and high-performance applications supporting environmental and regulatory systems.

Key Responsibilities

• Analyze existing Oracle Forms applications, including architecture, data structures, and integrations.
• Support migration and modernization of legacy Oracle Forms applications to Oracle APEX.
• Design, develop, and maintain Oracle APEX applications and user interfaces.
• Develop and maintain PL/SQL stored procedures, functions, packages, and complex queries.
• Perform data analysis, data extraction, and scripting to support reporting and enhancements.
• Implement application security, user roles, and authorization controls.
• Perform performance tuning, debugging, and optimization of database objects.
• Participate in all phases of the Software Development Life Cycle (SDLC), including:
• Requirements gathering
• Development
• Testing
• Deployment
• Production support
• Integrate Oracle applications with web services and external systems.
• Create technical, functional, and system documentation.
• Assist with deployment, release management, and production support.
• Provide mentoring and knowledge transfer to internal teams.
• Deliver regular status updates and reports to management.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 5+ years of experience developing with Oracle PL/SQL, including:
• Stored procedures
• Functions
• Packages
• Advanced SQL queries
• 5+ years of experience developing applications using Oracle APEX.
• Strong experience with Oracle Database (Oracle 19c preferred).
• Experience using SQL Developer and/or TOAD.
• Strong understanding of data modeling concepts.
• Experience integrating web services (REST/SOAP).
• Experience with performance tuning, debugging, and query optimization.
• Experience working in Agile/Scrum environments.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent written and verbal communication skills.

Preferred Qualifications

• Experience modernizing legacy Oracle Forms applications to Oracle APEX.
• Experience with Oracle Forms.
• Knowledge of:
• XML
• HTML
• Java
• PL/SQL APIs
• SOA architecture
• Experience supporting government or regulatory systems.
• Strong understanding of Oracle 19c features.
• Prior experience with Commonwealth of Pennsylvania projects (nice to have).

Additional Information

• Remote role; local candidates preferred.
• Must be available for full-time contract work (40 hours/week).
• Candidates must have strong Oracle APEX and PL/SQL development experience.
• Excellent opportunity to work on large-scale government modernization projects.

Apply To This Job