Oracle Apex & Forms Developer
Remote position-Candidate must reside within 2-hour radius of Harrisburg region.
Time Policy: All positions are 37.5-hour work weeks (7.5 hour days, 5 days a week).
Key Responsibilities:
• Analyze and understand the architecture, data structures, and integrations of existing Oracle Forms applications.
• Support the migration and conversion of Oracle Forms-based applications to Oracle APEX.
• Design and develop modern APEX user interfaces in collaboration with technical lead.
• Assist in establishing 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 to support reporting and system enhancements.
• Review existing documentation to understand system requirements, architecture, reporting, and functionality.
• Implement and support application security, roles, and authorization models within integrated Oracle systems.
• Conduct performance profiling and tuning to improve maintainability and system responsiveness.
• Generate technical documentation, business functional documentation, and system documentation.
• Participate in all phases of the system development lifecycle including requirements gathering, analysis, coding, testing, deployment, and post-production support.
• Provide mentoring and knowledge transfer to Commonwealth IT staff and other developers.
• Assist with production deployments and release management activities.
• Provide weekly status updates to management.
• Generate reports for executive management, end-users, and Bureau of Information Technology (BIT) staff.
Required experience:
• Bachelor's degree in computer science or related field.
• 5-7 years of experience developing in Oracle PL/SQL, including:
o Stored procedures
o Functions
o Packages
o Advanced queries
• 5-7 years of experience developing applications using Oracle APEX.
• Strong knowledge of Oracle RDBMS (Oracle 19c preferred).
• Strong experience using SQL Developer and/or TOAD.
• Understanding of data modeling principles.
• Experience integrating web services.
• Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle (and SQL Server).
• Strong analytical and problem-solving skills.
• Strong written and verbal communication skills.
Preferred qualifications
• Prior Commonwealth or Environmental systems experience (preferred but not required).
• Experience modernizing legacy Oracle Forms applications.
• Exposure to:
o XML
o HTML
o Web Services
o Java
o PL/SQL APIs
o SOA architecture
o 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.
Required / Desired Skills
• Required-5 yrs experience developing in Oracle PL/SQL, including: Stored procedures, Functions, Packages, Advanced queries
• Required-5 yrs experience developing applications using Oracle APEX.
• Required-Strong knowledge of Oracle RDBMS (Oracle 19c preferred).
• Required-Strong experience using SQL Developer and/or TOAD.
• Required-Understanding of data modeling principles.
• Required-Experience integrating web services.
• Required-Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle (and SQL Server).
• Required-Bachelor's degree in computer science or related field.
• Desired-Prior Commonwealth or Environmental systems experience
