Oracle APEX Developer - Oracle Forms Modernization //Local to PA

Engagement Type

Contract

Short Description

DEP - Oracle Developer





Full-time role (40 hrs/week)

Remote position (Local candidates preferred)

Complete Description

BRIEF DESCRIPTION:





The Pennsylvania Conservation and Environment Delivery

Center (CEDC), supporting the Department of Environmental Protection (DEP), is

seeking an experienced Oracle Developer to assist in the modernization and

migration of legacy Oracle Forms applications to Oracle APEX running on Oracle

Database 19c.





As part of an enterprise modernization initiative, legacy

systems built on older Oracle Forms technology are being upgraded to modern,

secure, and maintainable Oracle APEX applications. This effort supports

mission-critical environmental and regulatory systems and ensures long-term

sustainability, improved performance, and alignment with current BIT standards.





The selected candidate will play a key role in converting

Oracle Forms applications to Oracle APEX, enhancing system performance and

security, and ensuring alignment with modern development practices. This

position requires strong Oracle PL/SQL development skills, deep knowledge of

Oracle RDBMS, and experience working in Agile/Scrum environments.



















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.

Required/Desired Skills

Skill	Required/Desired	Amount	of Experience
Experience developing in Oracle PL/SQL - Stored procedures, functions, packages, advanced queries	Required	5.0	Years
Experience developing applications using Oracle APEX	Required	5.0	Years
Strong knowledge of Oracle RDBMS (Oracle 19c preferred)	Required
Strong experience using SQL Developer and/or TOAD	Required
Understanding of data modeling principles	Required
Experience integrating web services	Required
Experience with performance tuning, debugging, and testing SQL queries, views and stored procedures in Oracle (and SQL Server)	Required
Previous Commonwealth Experience	Desired
Experience modernizing legacy Oracle Forms applications	Desired
Exposure to XML, HTML, Web Services, Java, PL/SQL APIs, SOA architecture, Agile/Scrum methodologies	Desired
Strong understanding of Oracle 19c database features	Desired	2.0	Years