Location: Harrisburg, PA (Remote)

Duration: 9+ months
Type: Contract

Job Description :

The client is seeking an experienced Oracle Developer to support the modernization and migration of legacy Oracle Forms applications to Oracle APEX running on Oracle Database 19c. The ideal candidate will have strong hands-on experience in Oracle PL/SQL development, Oracle APEX application development, database design, performance tuning, and legacy application modernization.

The selected candidate will play a key role in converting existing Oracle Forms applications into modern, secure, and maintainable Oracle APEX applications. Responsibilities include analyzing legacy application architecture, developing PL/SQL procedures and packages, designing user interfaces, integrating web services, optimizing database performance, and ensuring application security. The candidate will also participate throughout the software development life cycle (SDLC), including requirements gathering, development, testing, deployment, documentation, and production support, while collaborating with technical leads and Commonwealth IT staff.

Key Responsibilities

· Analyze existing Oracle Forms applications, including architecture, data structures, business logic, and system integrations.

· Support the migration and conversion of legacy Oracle Forms applications to Oracle APEX.

· Design, develop, and maintain Oracle APEX applications and modern user interfaces in collaboration with the technical lead.

· Assist in establishing UI/UX design standards for future Oracle APEX applications.

· Develop and maintain Oracle PL/SQL stored procedures, functions, packages, and complex SQL queries.

· Perform data extraction, data analysis, scripting, and reporting to support application enhancements and business requirements.

· Review existing technical and functional documentation to understand system requirements, architecture, reporting, and application functionality.

· Implement and support application security, roles, and authorization models within integrated Oracle systems.

· Perform database performance profiling, tuning, debugging, and optimization to improve application responsiveness and maintainability.

· Integrate web services and support application interoperability with existing enterprise systems.

· Prepare and maintain technical documentation, business functional documentation, system documentation, and user-related materials.

· Participate in all phases of the SDLC, 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, release management, and application maintenance activities.

· Provide weekly project status updates to management.

· Generate reports for executive management, end users, and Bureau of Information Technology (BIT) staff.

Required Qualifications

· Bachelor's degree in Computer Science or a related field.

· Minimum 5 years of experience developing applications using Oracle PL/SQL, including:

o Stored procedures

o Functions

o Packages

o Advanced SQL queries

· Minimum 5 years of experience developing applications using Oracle APEX.

· Strong knowledge of Oracle RDBMS, preferably Oracle Database 19c.

· Strong experience using Oracle SQL Developer and/or TOAD.

· Understanding of database design and data modeling principles.

· Experience integrating web services with enterprise applications.

· Experience with performance tuning, debugging, and testing SQL queries, views, and stored procedures in Oracle and SQL Server environments.

· Strong analytical, troubleshooting, and problem-solving skills.

· Strong written and verbal communication skills.

· Ability to develop technical documentation and collaborate effectively with technical teams and business stakeholders.

Preferred Qualifications

· Prior experience supporting Commonwealth of Pennsylvania or environmental systems.

· Experience modernizing legacy Oracle Forms applications to Oracle APEX.

· Exposure to the following technologies and methodologies:

o XML

o HTML

o Web services

o Java

o PL/SQL APIs

o Service-Oriented Architecture (SOA)

o Agile/Scrum development methodologies

· Strong understanding of Oracle Database 19c features and capabilities.

· Experience supporting regulatory, environmental, or other mission-critical enterprise systems.

· Ability to produce clear, comprehensive technical and functional documentation.

· Experience supporting application deployments, release management, and production troubleshooting.