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 Ontarios Mission Critical Air Quality I and amp;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 Ontarios 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 and nbsp;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. and nbsp;The role requires experience with the full software development lifecycle including data architecture development maintenance and support. and nbsp;
- 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: and nbsp;Designing developing and implementing web applications using Oracle APEX a low-code development platform. and nbsp;Proven experience in developing applications using Oracle APEX. and nbsp;Experience with advanced APEX features like interactive reports charts and dynamic actions. and nbsp;
- Backend Integration: and nbsp;Utilizing Oracle REST Data Services (ORDS) to create RESTful APIs for accessing and manipulating data in the Oracle database. and nbsp; and nbsp;Solid understanding of Oracle REST Data Services (ORDS) and its capabilities. and nbsp;
- Database Management: and nbsp;Working with the Oracle database including data modeling SQL and PL/SQL development. and nbsp;Strong knowledge of Oracle databases including SQL PL/SQL and data modeling. and nbsp;
- Full SDLC: and nbsp;Participating in all phases of the software development lifecycle from requirements gathering and design to testing deployment and ongoing maintenance. and nbsp; and nbsp;Experience with HTML CSS JavaScript and other web technologies. and nbsp;
- Security: and nbsp;Ensuring the security of the Oracle APEX platform and the applications built upon it. and nbsp; and nbsp;Knowledge of security best practices for web applications. and nbsp;
- Solution Architecture Analysis and recommendations: and nbsp;Ability to assess as is state of legacy applications and assist in providing recommendations to a supported to be state.
- Performance tuning: and nbsp;Experience with optimizing application performance. and nbsp;
- Cloud experience: and nbsp;Familiarity with cloud platforms like Oracle Cloud Infrastructure (OCI). and nbsp;
Analytical Problem Solving Communication and Collaboration: 30%
- Working closely with other developers designers and stakeholders to build high-quality applications. and nbsp;
- 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: and nbsp;Designing developing and implementing web applications using Oracle APEX a low-code development platform. and nbsp;Proven experience in developing applications using Oracle APEX. and nbsp;Experience with advanced APEX features like interactive reports charts and dynamic actions. and nbsp;
- Backend Integration: and nbsp;Utilizing Oracle REST Data Services (ORDS) to create RESTful APIs for accessing and manipulating data in the Oracle database. and nbsp; and nbsp;Solid understanding of Oracle REST Data Services (ORDS) and its capabilities. and nbsp;
- Security: and nbsp;Ensuring the security of the Oracle APEX platform and the applications built upon it. and nbsp; and nbsp;Knowledge of security best practices for web applications. and nbsp;
- Cloud experience: and nbsp;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.