Oracle APEX & PL/SQL Developer

Location: Harrisburg, PA (Remote - Must reside within 2 hours of Harrisburg)

Job Type: Contract | Full-Time (37.5 hours/week)

Client: Pennsylvania Department of Environmental Protection (DEP)

Company: Willan Technologies

Willan Technologies is seeking an experienced Oracle APEX & PL/SQL Developer to support a major application modernization initiative for the Pennsylvania Department of Environmental Protection (DEP).

This opportunity involves migrating legacy Oracle Forms applications to Oracle APEX, enhancing database performance, improving application security, and modernizing mission-critical environmental and regulatory systems.

The ideal candidate brings strong hands-on experience with Oracle APEX, PL/SQL, Oracle Database, and legacy application modernization, along with excellent analytical and problem-solving skills.

• Analyze existing Oracle Forms applications, including architecture, database structures, business logic, and system integrations.

• Migrate and modernize legacy Oracle Forms applications using Oracle APEX.

• Design, develop, and maintain responsive, user-friendly Oracle APEX applications.

• Develop and optimize complex PL/SQL stored procedures, functions, packages, and SQL queries.

• Work with Oracle databases, preferably Oracle 19c, to support enterprise applications.

• Perform SQL performance tuning, debugging, troubleshooting, and query optimization.

• Integrate web services, APIs, and external systems with Oracle applications.

• Implement application security, user roles, authentication, and authorization controls.

• Support data modeling, data analysis, reporting, and database scripting.

• Collaborate with technical leads to establish APEX UI/UX standards and development best practices.

• Participate in requirements gathering, design, development, testing, deployment, and production support.

• Prepare technical documentation, functional specifications, and system documentation.

• Support application releases, production deployments, and ongoing enhancements.

• Participate in Agile/Scrum activities and provide regular project status updates.

• Mentor developers and provide knowledge transfer to internal IT teams.

Technical Experience

• 5 years of hands-on Oracle PL/SQL development, including stored procedures, functions, packages, and advanced SQL queries.

• 5 years of Oracle APEX application development experience.

• Strong knowledge of Oracle RDBMS, preferably Oracle Database 19c.

• Proficiency with Oracle SQL Developer and/or TOAD.

• Solid understanding of relational database design and data modeling principles.

• Experience integrating web services and APIs with Oracle applications.

• Proven experience in SQL performance tuning, debugging, testing, and optimization.

• Experience working with SQL queries, views, stored procedures, and database objects in Oracle and SQL Server.

• Strong analytical, troubleshooting, and problem-solving abilities.

• Excellent written and verbal communication skills.

Education

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

Candidates with the following experience will receive additional consideration:

• Experience modernizing or migrating Oracle Forms applications to Oracle APEX.

• Previous experience supporting Pennsylvania Commonwealth agencies or other government organizations.

• Experience developing or maintaining environmental, regulatory, or mission-critical systems.

• Strong understanding of Oracle Database 19c features and capabilities.

• Experience with XML, HTML, Java, web services, and PL/SQL APIs.

• Familiarity with Service-Oriented Architecture (SOA).

• Experience working in Agile/Scrum development environments.

• Experience developing technical documentation and functional specifications.

• Knowledge of enterprise application security and role-based access controls.

• Work Arrangement: Remote.

• Residency Requirement: Candidates must currently reside within a 2-hour radius of Harrisburg, Pennsylvania.

• Schedule: 37.5 hours per week.

• Additional hours require prior client authorization.

Important: Candidates outside the required geographic radius will not be considered, even though the position is remote.