Oracle 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:
• Stored procedures
• Functions
• Packages
• 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:
• XML
• HTML
• Web Services
• Java
• PL/SQL APIs
• SOA architecture
• 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.