HM Note: This hybrid contract role is three (3) days in office
Responsibilities:
- Dive deep into the legacy systems to understand the HealthcareDomainSpecificDataPoints which are used to determine funding allocation in Ontario and provide inputs to the PBF and TPON projects on data model analysis and data model changes to accommodate the data requirements for MOH MLTC and MSAA;
- To extract the HealthcareDomainSpecificFundingAllocationBusinesslogics captured in the programming code in the legacy systems so they can be replicated in the TPON and PBF implementation;
- To extract historical data from the legacy systems to be feed into TPON and PBF and to build ETL scripts for data extraction and data loading;
- Provide technical expertise with technologies including IIS Web Server Microsoft SQL Server and nbsp;ASP.Net and nbsp;VB.Net and nbsp;Web Form MVC Crystal Reports DevExpress and and nbsp;ASP.Net and nbsp;Cloud Computing to design and develop sound solutions to business requirements;
- Install / configure / administer IIS web server and MS SQL server in distributed platform;
- Design and development develop and maintain system design models technical documentation and specification;
- R and amp;D for solutions proposal to rewrite/migrate onto Azure Cloud provide research and development to assist Ministries to move onto our next strategic platform: a common business solution platform using Azure Cloud Azure DevOps Power Apps Power Automate Power BI and the integration with online Office 365 and SharePoint Online to orchestrate realtime government business workflow changes to ultimately automate government business processes through extensive integration;
- Maintenance support and provide operational warranty for the transition from the legacy systems onto PBF and TPON;
- Provide maintenance and support;
- Provide operational warranty.
- Provide documentation and knowledge transfer to FTE provide training to FTE as needed to improve team skills and knowledge.
Skills
Experience and Skill Set Requirements
Public Sector Experience: 5 points
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Demonstrated knowledge and experience with Public Sector governance methodologies (e.g. UPM architecture gating);
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Demonstrated understanding of Public Sector/ministries I and amp;IT strategies plans policies directives best practices and standards to ensure compliance in the development coordination and implementation of projects.
Solution Design Experience: 40 points
10 years of experience in the following:
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Reverse engineering data models from existing applications and databases;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Designing and developing ETL scripts for data extraction and data loading from MS SQL database to target Oracle database using Python SQL stored procedure and and nbsp;SQL Server Integration Services (SSIS);
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;UI/UX Design to comply with WCAG 2.1 or AODA;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Building enterprise level software automation process using CI/CD pipelines and tool chains on DevOps platform.
Hands on Technical Experience / Knowledge Areas: 30 points
10 years of experience in the following:
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Handson experience with relational database design and development in MS SQL Server environment;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Designing and developing RESTful web services JSON and XML;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Project development experience with Azure Boards Azure Git and Azure DevOps;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Designing and developing user authentication using MS Active Directory online or within corporate domain
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Experience with Cloud Platform using PaaS such as Azure Managed Application Services Docker and Kubernetes;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Postimplementation support.
Project Experience Team Collaboration Communication and General Skills: 25 points
10 years of experience in the following:
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Continuous deployment methods and procedures;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Agile methodologies for the analysis design development and implementation of applications in large complex environments;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Knowledge and understanding of objectoriented analysis and design techniques;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Experience leading a team of developers assigning tasks mentoring junior developers coordinating components for successful delivery;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Excellent analytical troubleshooting problemsolving and decisionmaking skills;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Conducting research and assessment of options for technical design issues;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Contributing to design/development of project plans including work breakdown and resource plans;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Good verbal and written communications skills;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Interpersonal and negotiation skills;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;A good team player with a track record for meeting deadlines;
and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp; and nbsp;Experience with the projects related to businesscritical environments and operations.
Must Haves:
10 years Experience:
- Handson and nbsp;ASP.Net and nbsp;VB.Net and nbsp;Web Form MVC development experience install and configure MS IIS Dot Net Framework SQL Server environment;
- Handson experience with relational database design and development in MS SQL Server environment; Reverse engineering data models from existing applications and databases;
- Designing and developing ETL scripts for data extraction and data loading from MS SQL database to target Oracle database using Python SQL stored procedure and and nbsp;SQL Server Integration Services (SSIS)