Junior Associate - Oracle APEX Developer (Pennsylvania candidates only)

Forest Pond Associates; United States; Remote; USD 110,000 - 140,000; Full time

Job summary

Forest Pond Associates, Inc. is seeking an experienced Oracle APEX Developer to modernize legacy Oracle Forms applications on Oracle Database 19c. The role emphasizes PL/SQL development, APEX migration, security, and performance enhancements within environmental and regulatory systems.

You will analyze existing applications, design migrations, and contribute across the lifecycle from requirements to production support, including documentation and knowledge transfer to client staff.

Qualifications

• Bachelor's degree in computer science or related field or equivalent experience.
• 5–7 years Oracle PL/SQL development including stored procedures, functions, packages, and advanced queries.
• 5–7 years Oracle APEX application development experience.
• Strong knowledge of Oracle RDBMS; Oracle 19c experience preferred.
• Experience with Oracle SQL Developer and/or TOAD.

Responsibilities

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

Skills

Oracle PL/SQL

Oracle APEX

Performance tuning

Security

Testing

Education

Bachelor's degree in computer science or related field

Tools

Oracle SQL Developer

TOAD

Job description

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.

About Forest Pond Associates, Inc.

Forest Pond Associates is a consulting firm that provides technology, data, and operational support to government and life sciences organizations. We help clients address complex challenges through practical expertise, thoughtful collaboration, and hands-on delivery. Our work includes supporting secure, reliable systems and helping teams strengthen the processes and capabilities they depend on.

Description

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.