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
  Requirements

TECHNICAL KNOWLEDGE AND SKILL:

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

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