Position Type: Remote
Contract Length: Long-term with annual extensions
Position Overview:
This role supports a large-scale enterprise modernization initiative focused on transforming legacy Oracle Forms applications into modern Oracle APEX solutions running on Oracle Database 19c. The position plays a key role in improving system performance, security, and maintainability while supporting mission-critical regulatory applications through modern development and Agile practices.
Duties:
Analyze existing Oracle Forms applications to understand architecture, data structures, workflows, and system integrations.
Convert and migrate legacy Oracle Forms applications into Oracle APEX solutions.
Design and develop modern Oracle APEX user interfaces in collaboration with technical leadership.
Help establish UI/UX standards and development best practices for future APEX applications.
Develop and maintain PL/SQL stored procedures, functions, packages, and advanced SQL queries.
Perform data extraction, analysis, and scripting to support reporting and system enhancements.
Review and interpret technical and functional documentation to understand business and system requirements.
Implement and maintain application security, roles, and authorization models within Oracle environments.
Conduct performance profiling, tuning, and optimization to improve application responsiveness and maintainability.
Create and maintain technical, functional, and system documentation.
Participate in all phases of the SDLC including requirements analysis, development, testing, deployment, and production support.
Provide mentoring, knowledge transfer, and technical guidance to internal IT staff and development teams.
Support production deployments and release management activities.
Provide regular status updates and communicate progress to leadership.
Generate reports and deliverables for executive stakeholders, technical teams, and end users.
Required Skills:
5 years of experience developing in Oracle PL/SQL, including stored procedures, functions, packages, and advanced queries.
5 years of experience developing applications using Oracle APEX.
Strong knowledge of Oracle RDBMS, with preference for Oracle 19c environments.
Strong hands-on experience using SQL Developer and/or TOAD for database development and administration.
Solid understanding of data modeling principles and relational database design.
Experience integrating applications with web services.
Experience performing performance tuning, debugging, and testing of SQL queries, views, and stored procedures within Oracle (and SQL Server) environments.
Preferred Skills:
Previous experience supporting government or public-sector environments.
Experience modernizing and converting legacy Oracle Forms applications.
Exposure to XML, HTML, web services, Java, PL/SQL APIs, SOA architecture, and Agile/Scrum development methodologies.
2 years of experience working with and demonstrating strong understanding of Oracle 19c database features.