Oracle Apex & Forms Developer

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

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