Oracle Apex & Forms Developer

KEY RESPONSIBILITIES:

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

REQUIRED EXPERIENCE:

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