Oracle APEX Developer

Codetech•Phoenix, AZ

About The Position

The Arizona Department of Environmental Quality is modernizing its legacy application portfolio, including converting a large Oracle Forms-based application to Oracle APEX. Approximately 40% of that conversion is complete, with a target completion date of December 2026, and the project is primarily supported by an external vendor. The department is seeking a contractor to support newly deployed APEX modules and help build in-house APEX capabilities. The Oracle APEX Developer will provide production support, including troubleshooting, bug fixes, performance tuning, and minor enhancements. The role will also lead the conversion of existing Microsoft Access applications to APEX, work with program areas to translate business needs into solutions, and transfer knowledge to the internal development team to foster independent APEX development. The developer will contribute to coding standards and documentation, participate in code reviews, collaborate with database administrators on schema changes and performance optimization, and work effectively with the external vendor team.

Requirements

At least 7 years of hands-on professional Oracle Application Express (APEX) development experience.
Strong proficiency in SQL and PL/SQL, including advanced querying, stored procedures, functions, packages, and triggers.
Demonstrated experience developing complex APEX applications from inception through production deployment.
Experience developing APEX components, including pages, regions, items, dynamic actions, reports, forms, themes, and templates.
Proficiency designing and optimizing APEX security, including authentication and authorization schemes.
Solid understanding of Oracle Database concepts and architecture.
Familiarity with HTML, CSS, and JavaScript as they relate to APEX development.
Demonstrable experience converting or migrating applications from other platforms, such as Microsoft Access or Oracle Forms, to APEX.
Ability to diagnose, troubleshoot, and resolve complex production application issues.
Experience tuning APEX applications and underlying SQL/PL/SQL code for performance.
Excellent written and verbal communication skills, including the ability to explain technical concepts to technical and non-technical audiences.
Strong interpersonal and collaboration skills, with willingness to mentor and share knowledge with an internal team.
Ability to work effectively in a team-oriented environment and with external vendors.
Strong analytical and problem-solving skills to understand business requirements and translate them into effective technical solutions.
Bachelor's degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and professional experience.

Nice To Haves

Experience with version control systems such as Git in an APEX development context.
Familiarity with Oracle Forms or Microsoft Access application structures and conversion challenges.
Experience in a government or public-sector environment.
Knowledge of Agile/Scrum methodologies.

Responsibilities

Provide expert-level support for production Oracle APEX applications, including troubleshooting, bug fixes, performance tuning, and minor enhancements.
Monitor APEX application health and proactively identify and resolve issues.
Collaborate with end-users and product owners to understand and address production support needs.
Lead the conversion of Microsoft Access applications to Oracle APEX, including requirements gathering, design, development, testing, and deployment.
Work with program areas to translate business needs into APEX solutions.
Provide Oracle APEX guidance, best practices, mentoring, and knowledge transfer to the in-house development team.
Help build the internal team's capability to independently support and develop APEX applications.
Contribute to APEX coding standards and documentation.
Participate in code reviews to ensure quality, security, and compliance with established standards.
Collaborate with database administrators on schema changes, performance optimization, and data migration as needed.
Work with the external vendor team involved in the Oracle Forms-to-APEX conversion project.