Senior Oracle Apex Developer

Location: Harrisburg, PA

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