Oracle Apex Engineer

Title: Oracle Apex Engineer

Hybrid – 2 days onsite

Location 100 Cambridge St. Boston MA 02114

Team Size: IT

Duration: 4 Months

Interview Process: 1 Tech phone screens 1 Skype or face to face if local.

SkillSets- Oracle APEX, swql, REST APIs, AWS

Background Check (if applicable): yes

Hours / Shift: Monday –Friday 9:00 to 5:00 40 hours

Notes: . 37.5 Hours a week. hybrid 2 days onsite

Our Housing Stabilization Team is looking for an experienced Business Analyst to support the emergency housing assistance Product Manager and support various projects within the portfolio. The Business Analyst will help our stakeholders administer emergency housing programs through strategic IT

Position Summary

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.

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.

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).