659RS – Oracle Developer
Job Description
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:
- 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.