Oracle Apex & Forms Dev

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

Job Summary

The client 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

1. Oracle APEX: 57 years of hands-on application development experience.
2. Oracle PL/SQL: 57 years of experience developing stored procedures functions packages and advanced SQL queries.
3. Oracle RDBMS: Strong knowledge of Oracle databases preferably Oracle 19c.
4. Oracle SQL Developer / TOAD: Strong experience using one or both tools.
5. Oracle Forms Modernization: Ability to analyze and migrate legacy Oracle Forms applications to Oracle APEX.
6. SQL Performance Tuning: Experience with query optimization debugging profiling and testing SQL queries views and stored procedures in Oracle and SQL Server.
7. Data Modeling: Understanding of database structures relationships and data modeling principles.
8. Web Services Integration: Experience integrating web services with enterprise applications.
9. Application Security: Understanding of roles authorization models and security in integrated Oracle systems.
10. SDLC: Experience with requirements gathering analysis development testing deployment and production support.
11. Documentation: Ability to prepare technical functional and system documentation.
12. Education: Bachelors degree in Computer Science or a related field.
13. 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

Candidate Screening Priorities

For initial resume screening prioritize candidates in this order:

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