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.