Oracle APEX & PL/SQL Developer

Willan Technologies group; Harrisburg (Dauphin County); Remote; USD 110,000 - 150,000; Full time

Job summary

Willan Technologies seeks an experienced Oracle APEX & PL/SQL Developer to support a major modernization project for the Pennsylvania Department of Environmental Protection. The role focuses on migrating legacy Oracle Forms to APEX, enhancing performance, strengthening security, and modernizing mission-critical systems.

Ideal candidates bring strong hands-on Oracle APEX, PL/SQL, and Oracle Database skills, plus the ability to collaborate in an Agile environment and mentor junior developers.

Qualifications

• 5+ years of hands-on Oracle PL/SQL development
• 5+ years of Oracle APEX application development
• Strong knowledge of Oracle RDBMS, preferably 19c
• Proficiency with SQL Developer and/or TOAD
• Solid understanding of relational database design
• Experience integrating web services and APIs with Oracle apps
• SQL performance tuning, debugging, and optimization
• Experience with SQL Server
• Strong analytical and problem-solving abilities
• Excellent written and verbal communication skills

Responsibilities

• Analyze existing Oracle Forms applications and architecture
• Migrate legacy forms to Oracle APEX
• Design, develop, and maintain responsive Oracle APEX apps
• Develop and optimize complex PL/SQL procedures and SQL queries
• Work with Oracle databases (19c preferred)
• Perform SQL performance tuning and debugging
• Integrate web services and APIs with Oracle apps
• Implement application security, roles, and authentication controls
• Support data modeling, reporting, and scripting
• Collaborate on UI/UX standards and best practices
• Participate in requirements, design, development, testing, deployment, and support
• Prepare technical and system documentation
• Support releases and production enhancements
• Participate in Agile/Scrum activities
• Mentor and transfer knowledge to internal teams

Skills

PL/SQL

Oracle APEX

Oracle Database 19c

SQL Developer

TOAD

Data modeling

Web services integration

SQL performance tuning

Analytical thinking

Communication skills

Education

Bachelor's degree in CS/IT

Tools

Oracle SQL Developer

TOAD

Job description

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

About the Opportunity

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.

Key Responsibilities

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

Required Qualifications

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.

Preferred Qualifications

• 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 Location & Schedule

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