Oracle Apex & Forms Dev

Title: TAS1: Oracle Apex & Forms Dev
Location : Remote
Duration : 8 months

Job Summary

The Pennsylvania Department of Environmental Protection (DEP) is seeking an experienced Oracle APEX & Forms Developer to modernize and migrate legacy Oracle Forms applications to Oracle Application Express (APEX) using Oracle Database 19c.

The selected candidate will analyze existing applications, develop modern APEX interfaces, build and maintain Oracle PL/SQL components, optimize database performance, and support application security and integration. The role involves working on mission-critical environmental and regulatory systems while ensuring compliance with enterprise development standards.

The ideal candidate will have strong hands-on experience with Oracle APEX, Oracle PL/SQL, Oracle RDBMS, legacy application modernization, and Agile/Scrum methodologies.

Mandatory Skills

- Oracle APEX: 5–7 years of hands-on application development experience.
- Oracle PL/SQL: 5–7 years of experience developing stored procedures, functions, packages, and advanced SQL queries.
- Oracle RDBMS: Strong knowledge of Oracle databases, preferably Oracle 19c.
- Oracle SQL Developer / TOAD: Strong experience using one or both tools.
- Oracle Forms Modernization: Ability to analyze and migrate legacy Oracle Forms applications to Oracle APEX.
- SQL Performance Tuning: Experience with query optimization, debugging, profiling, and testing SQL queries, views, and stored procedures in Oracle and SQL Server.
- Data Modeling: Understanding of database structures, relationships, and data modeling principles.
- Web Services Integration: Experience integrating web services with enterprise applications.
- Application Security: Understanding of roles, authorization models, and security in integrated Oracle systems.
- SDLC: Experience with requirements gathering, analysis, development, testing, deployment, and production support.
- Documentation: Ability to prepare technical, functional, and system documentation.
- Education: Bachelor's degree in Computer Science or a related field.
- Communication: Strong written, verbal, analytical, and problem-solving skills.

Highly Desired Skills

- Previous experience with Pennsylvania Commonwealth or environmental systems.
- Experience migrating legacy Oracle Forms applications to Oracle APEX.
- Strong understanding of Oracle Database 19c features.
- Experience with XML, HTML, Java, and PL/SQL APIs.
- Knowledge of Service-Oriented Architecture (SOA).
- Experience with Agile/Scrum development methodologies.
- Experience supporting regulatory, government, or mission-critical enterprise systems.
- Experience with production deployments, release management, and post-production support.
- Ability to mentor developers and transfer technical knowledge to client IT staff.
- Experience developing reports for executive management, end users, and IT teams.

Roles and Responsibilities

- Analyze legacy Oracle Forms applications, including their architecture, data structures, business logic, and integrations.
- Migrate and convert existing Oracle Forms applications to Oracle APEX.
- Design, develop, and maintain modern Oracle APEX user interfaces.
- Collaborate with technical leads to establish consistent UI/UX standards for future applications.
- Develop and maintain PL/SQL stored procedures, functions, packages, and complex SQL queries.
- Perform data extraction, data analysis, and scripting to support reporting and application enhancements.
- Review existing technical and functional documentation to understand application requirements and system architecture.
- Implement and maintain application security, user roles, and authorization models.
- Perform database performance tuning, debugging, profiling, and testing.
- Participate in all phases of the software development lifecycle, including requirements analysis, coding, testing, deployment, and production support.
- Prepare technical, functional, and system documentation.
- Assist with production deployments, release management, and application maintenance.
- Provide mentoring and knowledge transfer to Commonwealth IT staff and other developers.
- Prepare weekly project status updates and reports for management.
- Generate reports for executive management, end users, and Bureau of Information Technology (BIT) staff.
- Collaborate with cross-functional teams in an Agile/Scrum environment to deliver secure, reliable, and maintainable applications.

Key Technical Requirements

- Application Development: Oracle APEX
- Legacy Application Migration: Oracle Forms to Oracle APEX
- Database Programming: Oracle PL/SQL, Stored Procedures, Functions, and Packages
- Database Management: Oracle RDBMS, preferably Oracle 19c
- Database Tools: SQL Developer and/or TOAD
- SQL Development: Advanced SQL Queries, Views, Debugging, and Testing
- Performance Optimization: SQL Tuning and Database Profiling
- Data Modeling: Data Modeling Principles and Database Structures
- Integration: Web Services and PL/SQL APIs
- Web Technologies: HTML and XML
- Programming Languages: Java
- Architecture: Service-Oriented Architecture (SOA)
- Development Methodology: Agile/Scrum
- Additional Database Experience: SQL Server

Candidate Screening Priorities

For initial resume screening, prioritize candidates in this order:

- Oracle APEX – 5–7 years: Verify hands-on application development experience.
- Oracle PL/SQL – 5–7 years: Verify development of procedures, functions, packages, and advanced queries.
- Oracle Forms-to-APEX migration: Look for direct project experience converting legacy applications, rather than general Oracle development alone.
- Oracle Database 19c: Verify database development and optimization experience.
- SQL Developer / TOAD: Confirm practical use in development and debugging.
- Performance tuning and web services: Look for specific implementation examples.
- Location requirement: Confirm the candidate resides within a 2-hour radius of Harrisburg, Pennsylvania.
- Work authorization: Confirm eligibility under the stated USC/GC/GC-EAD requirement.