- Develop coding, testing, and debugging to support existing extensions/tools such as IRT, De-Dup, OIA, Immunization Forecaster and PR Upload
- Conduct technical analysis, preparation of detailed programming specifications, program design, writing and/or generating code, and conduct unit tests
- Translate technical specifications for sustainment and upgrade into working, tested applications
- Undertake proof of technology with test data to simulate application load and performance tuning related applications
- Provide software expertise in various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
- Provide impact analysis, effort estimate and solution design/development for supported solutions due to DHIR solution upgrades, software upgrades or any new requirements (e.g. Panorama 4.4 upgrades, PHU merge and more)
- Provide application programming support for incident management, application functionality sustainment, performance tuning and technical documentation
- Work with Quality Assurance (QA) to code, test, and debug extensions/tools integration services
- Maintain Development environments and continue continuous Integration (CI) practice
- Improve the quality and accuracy of the data collected for the approximately 34 PHUs and 2282 PHU users
- Ensure availability of the DHIR extensions/tools for use by all Ontarians.
Must have Experience:
- Design and development of Oracle(12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedure, packages, functions, triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
- € Advanced SQL skills, optimized database queries, and data architecture, database design, database modeling
- Data Warehouse design and development, Database performance tuning, Automation
- •Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs
Technical Skills
10+ years of experience with:
· Design and development of Oracle(12c) for OLAP and OLTP applications, including PL/SQL, Oracle stored procedure, packages, functions, triggers, ref cursors, dynamic SQLs, DBMS packages, etc.
· Demonstrated ability to create normalized database schemas utilizing data modeling discipline. Understanding of normalization, de-normalization, and the difference between the two. Ability to create schemas for both OLTP and OLAP databases.
· Advanced SQL skills, optimized database queries, and data architecture, database design, database modeling
· Data Warehouse design and development, Database performance tuning, Automation
· Unix/Linux Shell Scripting
· Informatica for data extraction, transformation, and loading, initial setup and other data management purposes
· Cognos report design and development, Framework manager, Query Studio, Reports Studio, creation of dashboards, etc. Other reporting tools would also be an asset, particularly Crystal Reports and Business Objects
· Knowledge of Java, JSON, XML, API calls, HL7/FHIR, Restful web services
· Knowledge of the provincial immunization system.
Core Skills and Experience
10+ years of experience with:
- · Working with business analysts to translate the business requirements and functional specifications into an application design appropriate to meet the business and operational/IT needs
- · Working with technical systems specifications and translating them into working, tested applications for large, complex, mission critical applications
- · Analysis, design and development work on complex, multi-tier web-based applications, micro-services architecture, mobile, and off-the-shelf solutions
- · Proven technical leadership skills with ability to identify areas for improvement, and recommend solutions
- · Designing, developing and implementing applications that work across modern browsers and various platforms, and mobile devices
- · Using and applying extensive knowledge of User Interface (UI) design principles across a variety of applications, platforms and devices
- · Technical analysis, program code, detailed programming and reports specifications, program design, writing and/or generating code, and conducting tests
- · Developing and maintaining system design models, technical documentation and specifications
- · Conducting technical evaluation and assessment of options for technical design issues, application figuration aspects and integration capabilities, related tools and utilities, gap analysis of integration components to technical requirements/specifications/documentation
- · Developing medical and clinical based systems
- · Web performance optimization
- · Various computing platforms, operating systems, database technology, communication protocols, middleware and gateways
- · Conducting technical analysis, trouble-shooting, and issue resolutions for production operational support of reports, and other components and utilities
- · Knowledge of recognized accessibility laws, regulations, and standards (e.g., W3C, WCAG) or other specific accessibility standards, and experience in usability, accessibility and compliance testing
- · Ensuring compliance with architecture framework and system standards, and Agile Development Methodology
- · Project management practices, and ability to contribute to design/development project plans, including work breakdown, resource estimates, and status reports
- · Experience with Software Development Lifecycle (SDLC)
- · Continuous Integration (CI) practice and DEVOPS methodologies and technologies
- · Knowledge and experience with leading-edge technologies, design criteria including usability, security, and privacy for web and mobile applications.