Oracle Application developer

Location : Boston, MA

Duration : 12 +Months contract

Pay rate : Open

Client : Massachusetts Executive Office of Housing and Livable Communities

The client is looking for an 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).