Oracle APEX & PL/SQL Developer — Forms Modernization Remote

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

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.