Junior Associate - Oracle APEX Developer (Pennsylvania candidates only)

Forest Pond Associates•State College, PA

About The Position

Forest Pond Associates is seeking an Oracle APEX Developer to support modernization of legacy Oracle Forms applications to Oracle APEX on Oracle Database 19c. The work supports environmental and regulatory systems and focuses on improving 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 associate 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. In addition to the Oracle modernization assignment, the associate may support other Forest Pond Associates projects as business needs and workload permit. This may include research, data review, analysis, documentation, project coordination, requirements gathering, testing, quality review, issue tracking, and business development support.

Requirements

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.
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.

Nice To Haves

Oracle 19c experience.
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.

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 with the technical lead and 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.
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.
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 skills and experience.