Oracle Apex & Forms Dev
About The Position
The client is seeking an experienced Oracle APEX and Forms Developer to modernize and migrate legacy Oracle Forms applications to Oracle Application Express (APEX) using Oracle Database 19c. The role includes analyzing existing applications, developing modern APEX interfaces, building and maintaining Oracle PL/SQL components, optimizing database performance, and supporting application security and integrations. The work supports mission-critical environmental and regulatory systems and must comply with enterprise development standards. The developer will participate in the software development lifecycle from requirements gathering and analysis through development, testing, deployment, and production support. They will collaborate with technical leads and cross-functional teams in an Agile/Scrum environment, contribute to consistent UI/UX standards, prepare documentation and reports, assist with releases and application maintenance, and mentor Commonwealth IT staff and other developers. The position is onsite for an eight-month duration. Candidates must reside within a two-hour radius of Harrisburg, Pennsylvania.
Requirements
- 5–7 years of hands-on Oracle APEX application development experience.
- 5–7 years of Oracle PL/SQL experience developing stored procedures, functions, packages, and advanced SQL queries.
- Strong knowledge of Oracle databases, preferably Oracle Database 19c.
- Strong experience using Oracle SQL Developer and/or TOAD.
- Ability to analyze and migrate legacy Oracle Forms applications to Oracle APEX.
- Experience optimizing, debugging, profiling, and testing SQL queries, views, and stored procedures in Oracle and SQL Server.
- Understanding of database structures, relationships, and data modeling principles.
- Experience integrating web services with enterprise applications.
- Understanding of roles, authorization models, and security in integrated Oracle systems.
- Experience across the SDLC, including requirements gathering, analysis, development, testing, deployment, and production support.
- Ability to prepare technical, functional, and system documentation.
- Bachelor's degree in Computer Science or a related field.
- Strong written and verbal communication, analytical, and problem-solving skills.
- Must reside within a two-hour radius of Harrisburg, Pennsylvania.
Nice To Haves
- 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.
Responsibilities
- Analyze legacy Oracle Forms applications, including architecture, data structures, business logic, and integrations.
- Migrate and convert existing Oracle Forms applications to Oracle APEX.
- Design, develop, and maintain 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 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 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 management reports.
- 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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
