Oracle APEX / Forms Developer

Oracle APEX / Forms Developer

Location

Regional Remote - Greater Harrisburg PA Area

Work Arrangement

100% Remote; candidates must reside within a 2-hour radius of the Harrisburg region; in-person equipment inventory required at start and end of the contract

Schedule

7.5 hours/day; 5 days/week (37.5 hours/week); overtime requires prior approval

Interview

Virtual; valid state or federal photo ID required during the interview

Contract

Nov 9, 2026 - Jun 30, 2027. Historically, these roles are extended for an additional year.

Visas Accepted

USC, GC, GC EAD, H1B

Role Overview

Our client is seeking an Oracle APEX / Forms Developer to help modernize legacy Oracle Forms applications by converting them into secure, maintainable Oracle APEX applications running on Oracle Database 19c. The position supports mission-critical environmental and regulatory systems, with an emphasis on application performance, security, maintainability, and modern development practices.

This is a regional remote position requiring candidates to reside within a 2-hour radius of the Harrisburg, PA region. The contract follows a 37.5-hour workweek. In-person reporting at the beginning and end of the assignment is required for Commonwealth equipment inventory and condition verification; equipment will not be shipped.

Primary Responsibilities

• Analyze existing Oracle Forms application architecture, data structures, and integrations.
• Support the migration and conversion of Oracle Forms-based applications to Oracle APEX.
• Design and develop modern Oracle APEX user interfaces in collaboration with the technical lead.
• Help establish UI/UX design standards for future APEX applications.
• Develop and maintain PL/SQL stored procedures, functions, packages, and advanced queries.
• Perform data pulls, data analysis, and scripting for reporting and system enhancements.
• Review existing system requirements, architecture, reporting, functionality, and documentation.
• Implement and support application security, user roles, and authorization models within integrated Oracle systems.
• Perform performance profiling and tuning to improve maintainability and responsiveness.
• Create technical, business-functional, and system documentation.
• Participate throughout requirements gathering, analysis, coding, testing, deployment, and post-production support.
• Mentor Commonwealth IT staff and other developers and transfer application knowledge.
• Assist with production deployments and release management.
• Provide weekly status updates to management.
• Generate reports for executive management, end users, and IT staff.

Required Technical Skills

• Advanced hands-on development experience in Oracle PL/SQL, including stored procedures, functions, packages, and advanced queries.
• Advanced experience developing applications using Oracle APEX.
• Strong knowledge of Oracle RDBMS, with Oracle 19c preferred.
• Practical experience using SQL Developer and/or TOAD.
• Understanding of data modeling principles.
• Experience integrating web services.
• Experience tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle and SQL Server.
• Strong analytical and problem-solving abilities with clear written and verbal communication skills.

Education

Required

Bachelor's degree in computer science or a related field.

Preferred Qualifications

• Prior Commonwealth or environmental systems experience.
• Experience modernizing legacy Oracle Forms applications.
• Exposure to XML, HTML, web services, Java, PL/SQL APIs, SOA architecture, and Agile/Scrum development methodologies.
• Strong understanding of Oracle 19c database features.
• Experience supporting regulatory or mission-critical systems.
• Ability to produce clear, comprehensive technical and functional documentation.