Application Developer

Worksite Address:

Remote work allowed? Yes No

100% remote work allowed? Yes No

If other remote work arrangements, specify: 2 days per week in office

Engagement Length: Through 4 months or end of project

Renewable: Yes No

Project(s) Duration: < 4 months>

Hours per Week: 37.5

Detailed Description of Services:

The Executive Office of Housing and Livable Communities (EOHLC) is seeking an experienced Application Developer to design, develop, and maintain enterprise web applications using Oracle Application Express (APEX). The ideal candidate will have demonstrated experience building scalable, secure, and user-friendly solutions in Oracle APEX, along with strong JavaScript, SQL, and PL/SQL skills. This position reports to the Director of Information Technology Development. The project is expected to last four months, with the possibility of extension. Pursuant to any additional instructions, policies, or guidance that EOHLC may provide, the candidate will be responsible for the duties listed below:

Description of Duties

• Design, Develop, and Deploy Oracle APEX applications that meet business requirements and follow best practices.
• Collaborate with end-users, and IT teams to gather requirements, design solutions, and implement features.
• Maintain and enhance existing Oracle APEX applications, troubleshoot issues, and provide timely resolutions.
• Develop database objects such as tables, views, procedures, and triggers using SQL and PL/SQL.
• Integrate Oracle APEX applications with other enterprise systems and data sources as needed (REST/SOAP APIs, Web Services, etc.).
• Document technical solutions, data models, processes, and user guides.
• Participate in code reviews, QA, and deployment activities to ensure high-quality deliverables.
• Support end-users by resolving application issues, providing training, and gathering feedback for improvements.
• Stay current with Oracle APEX updates, features, and best practices.
• Additional related tasks or services that EOHLC may request.

Qualifications:

• Minimum 5 years of experience working with Oracle APEX and Oracle Database products.
• Proven application development experience with Oracle APEX, version 18.2 or higher.
• Strong knowledge of APEX Universal Theme and its use for various UI requirements.
• In-depth experience with logical and physical database design; expert in creating PL/SQL packages, procedures, functions, triggers, views, and exception handling for complex data sets in Oracle.
• Advanced skills in writing and optimizing SQL and PL/SQL.
• Experience with modern web development technologies, including HTML5, JavaScript, jQuery, Ajax, XML, and CSS.
• Proficient in REST API concepts, and experience developing and consuming REST APIs with Oracle REST Data Services (ORDS).
• Familiarity with all phases of the Software Development Life Cycle, including code implementation, unit testing, and ongoing support.
• Excellent listening, interpersonal, written, and verbal communication skills.
• Basic understanding of cloud platforms (preferably AWS).