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.