Junior Associate - Oracle APEX Developer (Pennsylvania candidates only)

Candidate must reside within Central Pennsylvania, though this is a remote position. The firm is seeking a Oracle APEX Developer to modernize legacy Forms applications. The role includes PL/SQL development, APEX migration, performance tuning, security, testing, documentation, and knowledge transfer.

Junior Associate - Oracle APEX Developer

Position Summary

Forest Pond Associates is seeking an experienced Oracle APEX Developer to support the modernization of legacy Oracle Forms applications to Oracle APEX on Oracle Database 19c. The work supports important environmental and regulatory systems and aims to improve their security, performance, maintainability, and long-term sustainability.

The developer will analyze existing applications, data structures, integrations, and documentation, then help convert and enhance functionality in APEX. Working with a technical lead and cross-functional team, the consultant will contribute throughout the development lifecycle, from requirements analysis and design through coding, testing, deployment, and production support. The role also includes developing PL/SQL components, supporting application security and reporting, documenting solutions, and transferring knowledge to client staff.

Key Responsibilities

• Analyze existing Oracle Forms application architecture, data structures, integrations, and functionality.
• Support migration and conversion of Oracle Forms applications to Oracle APEX.
• Design and develop APEX interfaces in collaboration with the technical lead; help establish reusable UI/UX standards.
• Develop and maintain PL/SQL procedures, functions, packages, and advanced queries.
• Perform data analysis, data extracts, and scripting for reporting and system enhancements.
• Review existing materials to understand requirements, architecture, reports, and application behavior.
• Implement and support roles, authorization, and application security within integrated Oracle systems.
• Profile and tune applications and database components to improve performance and maintainability.
• Participate in requirements analysis, design, coding, testing, deployment, release management, and post-production support.
• Prepare technical, functional, and system documentation.
• Produce reports for management, end users, and IT teams.
• Provide weekly status updates, mentoring, and knowledge transfer to client staff and developers.

Firmwide Associate Responsibilities

In addition to the Oracle modernization assignment, the associate may support other Forest Pond Associates projects as needs and workload permit. Responsibilities may include:

• Assist with research, data review, analysis, and documentation for client projects.
• Prepare and update project plans, meeting materials, status reports, procedures, and presentations.
• Attend client and internal meetings, take notes, and track decisions, action items, and follow-ups.
• Support requirements gathering, testing, quality review, and issue tracking across project work.
• Help organize project files and maintain accurate, current documentation.
• Coordinate with colleagues and clients to clarify tasks, share progress, and meet deadlines.
• Contribute to proposals, work plans, and other business development materials as appropriate.
• Learn and follow firm practices for client communication, confidentiality, quality, and project delivery.
• Take on additional project support duties consistent with the associate’s skills and experience.

Required Qualifications

• Bachelor’s degree in computer science or a related field, or equivalent experience.
• Five to seven years of Oracle PL/SQL development experience, including stored procedures, functions, packages, and advanced queries.
• Five to seven years of Oracle APEX application development experience.
• Strong knowledge of Oracle RDBMS; Oracle 19c experience is preferred.
• Experience with Oracle SQL Developer and/or TOAD.
• Understanding of data modeling principles and web service integration.
• Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle and/or SQL Server.
• Strong analytical, problem-solving, written, and verbal communication skills.

Preferred Qualifications

• Experience modernizing legacy Oracle Forms applications.
• Experience with environmental, regulatory, or other mission-critical systems.
• Familiarity with XML, HTML, web services, Java, PL/SQL APIs, or SOA architecture.
• Experience working in Agile/Scrum environments.
• Ability to produce clear technical and functional documentation.