Oracle APEX, Forms Developer

This is a fully remote position, open to applicants in Pennsylvania.

📋 Description

• Analyze the architecture, data structures, and integrations of current Oracle Forms applications.

• Migrate and transform legacy Oracle Forms applications into Oracle APEX.

• Design and create APEX user interfaces while helping to establish UI/UX standards.

• Develop and maintain PL/SQL procedures, functions, packages, and queries.

• Conduct data analysis, scripting, and reporting tasks.

• Implement application security measures, roles, and authorization frameworks.

• Execute performance tuning, debugging, and testing activities.

• Engage in the complete Software Development Life Cycle (SDLC), which includes requirements gathering, development, testing, deployment, and post-production support.

• Create technical, functional, and systems documentation.

• Assist with production deployments, release management, and knowledge transfer initiatives.

• Provide weekly status updates and reports to management, end users, and BIT staff.

⛳️ Requirements

• A Bachelor’s degree in Computer Science or a related discipline.

• 5–7 years of experience in Oracle PL/SQL development, including expertise in stored procedures, functions, packages, and advanced queries.

• 5–7 years of experience in Oracle APEX application development.

• Extensive knowledge of Oracle RDBMS; Oracle 19c is preferred.

• Familiarity with Oracle SQL Developer and/or TOAD.

• Understanding of data modeling concepts.

• Experience with the integration of web services.

• Proven experience in performance tuning, debugging, and testing SQL queries, views, and stored procedures in both Oracle and SQL Server.

• Strong analytical and problem-solving abilities, along with excellent written and verbal communication skills.

• Candidates must live within a 2-hour radius of Harrisburg, Pennsylvania.

• Preferred: experience in modernizing legacy Oracle Forms applications.

• Preferred: prior experience with the Commonwealth of Pennsylvania or environmental systems.

• Preferred: exposure to XML, HTML, Java, web services, PL/SQL APIs, and SOA architecture.

• Preferred: familiarity with Agile/Scrum methodologies.

• Preferred: knowledge of features in Oracle 19c database.

• Preferred: experience supporting regulatory or mission-critical systems.

• Ability to produce clear technical and functional documentation.

🏝️ Benefits

• Full-time employment.

• Remote work arrangement.

• Work hours from 8:00 AM to 4:30 PM, totaling 37.5 hours per week.

• Contract duration extends through June 30, 2027.