Software Developer Full Stack 9421-2113

HM Note: This contract role is remote, and candidates can work remotely. Candidates must reside in Ontario, Canada. Candidates resume must include first and last name.

Description

'Air Quality Suite Evergreening' - The goal of the Air Quality suite evergreening initiative is to upgrade the full technical stack for Ontario's Mission Critical Air Quality I&IT solutions. The current suite is built with Oracle database, APEX/ORDS, and Red Hat Linux OS software which are all at end-of-life support with the manufacturer. To stay secure and compliant with Ontario's Digital and Data Strategy, the systems software and hardware technical components must be upgraded - A process known as Evergreening . Cloud hosting is targeted as part of this evergreening.

Skills

Experience and Skill Set Requirements

Responsibilities

• An Oracle APEX and ORDS Developer is needed to design, develop, and maintain web applications using the Oracle APEX platform, with a focus on utilizing Oracle REST Data Services (ORDS) for backend integration and API development. The role requires experience with the full software development lifecycle, including data architecture, development, maintenance, and support.
• Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.
• Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.
  
  

General Skills

• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Experience with middleware and gateways
• Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging
• Ability to provide post-implementation support and resolve any post-implementation technical issues
• Experience conducting design walkthrough sessions with project team
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
• Ability to provide user and system documentation as required
  
  

Evaluation Criteria

Technical Knowledge and Skill - 70%

10+ years experience with/related to the following:

• Application Development: Designing, developing, and implementing web applications using Oracle APEX, a low-code development platform. Proven experience in developing applications using Oracle APEX. Experience with advanced APEX features like interactive reports, charts, and dynamic actions.
• Backend Integration: Utilizing Oracle REST Data Services (ORDS) to create RESTful APIs for accessing and manipulating data in the Oracle database. Solid understanding of Oracle REST Data Services (ORDS) and its capabilities.
• Database Management: Working with the Oracle database, including data modeling, SQL, and PL/SQL development. Strong knowledge of Oracle databases, including SQL, PL/SQL, and data modeling.
• Full SDLC: Participating in all phases of the software development lifecycle, from requirements gathering and design to testing, deployment, and ongoing maintenance. Experience with HTML, CSS, JavaScript, and other web technologies.
• Security: Ensuring the security of the Oracle APEX platform and the applications built upon it. Knowledge of security best practices for web applications.
• Solution Architecture Analysis and recommendations: Ability to assess 'as is' state of legacy applications and assist in providing recommendations to a supported 'to be' state.
• Performance tuning: Experience with optimizing application performance.
• Cloud experience: Familiarity with cloud platforms like Oracle Cloud Infrastructure (OCI).
  
  

Analytical, Problem Solving, Communication and Collaboration: 30%

• Working closely with other developers, designers, and stakeholders to build high-quality applications.
• Strong ability to work with technical and non-technical team mates.
• Troubleshooting and Support: Identifying and resolving issues within the application and its underlying infrastructure.
• Self starter with ability to track activities and update work/deliverables on team boards Kanban/DevOps
• Strong verbal, written and interpersonal skills
• Strong ability to document technical procedures and facilitate transition to operations knowledge transfer sessions.
• Strong record keeping and documentation skills
  
  

Must Haves

• Application Development: Designing, developing, and implementing web applications using Oracle APEX, a low-code development platform. Proven experience in developing applications using Oracle APEX. Experience with advanced APEX features like interactive reports, charts, and dynamic actions.
• Backend Integration: Utilizing Oracle REST Data Services (ORDS) to create RESTful APIs for accessing and manipulating data in the Oracle database. Solid understanding of Oracle REST Data Services (ORDS) and its capabilities.
• Security: Ensuring the security of the Oracle APEX platform and the applications built upon it. Knowledge of security best practices for web applications.
• Cloud experience: Familiarity with cloud platforms like Oracle Cloud Infrastructure (OCI)
• Strong ability to work with technical and non-technical teammates.
• Troubleshooting and Support: Identifying and resolving issues within the application and its underlying infrastructure.