Ministry of Public and Business Service Delivery and Procurement
Division:
GovTechON - Health Services I&IT Cluster / Emergency Health I&IT Solutions & Technology Management Branch
City:
North York
Position(s) language:
English
Job term:
1 Temporary - up to 12 months with possible extension
Job code:
17160 - Systems Officer 5
Salary:
$1,628.82 - $2,104.14 Per week
*Indicates the salary listed as per the OPSEU Collective Agreement.
Are you a skilled Database Administrator with a passion for strategic data management and innovative technology? We're looking for a dedicated professional to support real-time data dashboards, reporting solutions, and critical 9-1-1 applications through expert administration of MS SQL and Azure SQL databases.
In this role, you will play a key part in supporting Ontario's emergency health system by maintaining and optimizing databases that power mission-critical 9-1-1 operations. You'll design, deploy, and support both cloud-based and on-premise solutions--ensuring systems are secure, high-performing, and built for reliability. Your work will enable real-time insights, enhance mobile application functionality, and ensure data is accurately captured, processed, and presented to first responders when it matters most.
As a senior technology specialist, you'll apply your expertise in On-Prem, Azure or AWS to modernize critical services that directly impact the lives of Ontarians. This is a dynamic, high-impact environment where your skills in automation, cloud engineering, and system integration will help drive innovation and transformation across Ontario's emergency health network.
Join a team that's transforming Ontario's emergency health system through cutting-edge digital solutions.
Click here to learn more about the Emergency Health I+IT Solutions & Technology Management Branch (EHSTMB).
About the job
-----------------
In this role, you will:
coordinate the development, maintenance, and control of the Branch's databases, data warehouse, and related documentation
monitor and tune database performance to ensure optimal operation of 9-1-1 tools and applications
ensure system integration and connectivity across multiple emergency health systems and applications connected to the Branch's databases and data warehouse
manage data interfaces to maintain the seamless and uninterrupted flow of data feeding into Branch systems
develop and deliver reports, both standard and ad hoc, including configuration and deployment to support operational and analytical needs
conduct capacity planning and allocate system resources to ensure efficient performance and scalability
provide technical support by identifying and resolving technical and operational issues affecting database systems
collaborate with vendors and IT specialists to troubleshoot incidents, determine root causes, and implement lasting resolutions
offer expert advice on database, data warehousing, and data management best practices, emerging technologies, and methodologies
support application teams and contractors with guidance on database design and data management considerations
perform feasibility studies and cost-benefit analyses, making recommendations and preparing business cases for new or enhanced technologies
lead database projects involving design, development, or infrastructure changes to hardware, software, and application linkages
engage with clients and stakeholders to gather input, share updates, and ensure solutions meet operational and strategic needs
What you bring to the team
------------------------------
Technical Knowledge and Skills
You have knowledge of:
current and emerging technologies, methodologies and tools associated with databases (administration), data management, data warehousing, data modelling and design, the full systems life cycle, IT security, Internet applications and IT connectivity
PC-based and server-based systems technologies, networks, and data management tools such as Microsoft Power BI, SSRS (SQL Server Reporting Services), SSMS (SQL Server Management Studio), and SSDT (SQL Server Data Tools).
provides detailed expertise in SQL Server databases (2016-2022), experience with queries, database synchronization, Azure/Azure SQL administration, and High Availability (HA) solutions like Always-On
disk architecture and expertise in tuning the database for performance - monitoring, analyzing and tuning the databases for performance in all related layers
user environments, client support issues, and client data access tools
administration of both on-prem and Azure databases and using pipelines for cloud and local deployments
Leadership and Project Management Skills
you have knowledge of project management methodologies and procurement policies and practices
you have project management and technical leadership skills to advise on technical requirements of the databases and data warehouse and lead database development and change management projects.
Analytical, Problem-Solving and Organizational Skills
you have analytical skills in assessing the data management requirements of the Branch and clients
you can lead the development of standards and processes for the databases and data warehouse
you can analyze user needs in a multi-client environment and develop client access systems, processes and procedures that support user requirements while protecting the security of the system and integrity of data.
you have analytical and problem-solving skills to ensure the smooth running of all aspects of the databases and Data Warehouse by monitoring performance, tuning the environment and providing timely technical support to resolve problems
you can provide advice and identify new technologies and tools on data management strategies and standards to branch management and applications developers
you have organization, co-ordination and administration skills to guide and manage database and data warehouse administration
Communication and Interpersonal Skills
you have oral communication skills to: liaise and consult extensively with clients regarding data management requirements in both technical and non-technical language, provide direction to staff and vendors, and provide training to clients
you have written communication skills to: prepare reports, technical analyses, and recommendations for Branch management; develop business cases; prepare systems documentation; and prepare informational materials for clients.
you have consultation, negotiation and interpersonal skills to consult extensively with clients and stakeholders and to negotiate contracts with vendors of services, equipment and hardware/software within established
parameters
Other Essential Abilities and Knowledge:
you have the ability to learn the policies, standards and objectives relating to information technology, and emergency health services
you have the ability to interpret policy and legislative requirements affecting data processing and freedom/privacy of information
you have knowledge of training techniques to co-ordinate the development and delivery of training for Branch staff and clients.
Don't meet every qualification?
-----------------------------------
If you are excited about this position and meet most, but not all, of the listed qualifications, please still consider applying. We recognize that no one person might have every qualification in this job ad, and you just might be the right candidate!
How we support diversity, inclusion and accessibility
We are building an inclusive workforce that reflects the communities we serve. We encourage everyone interested in working with us to apply, including people with disabilities, Indigenous, Black and racialized individuals, as well as people from all ethnicities, cultures, sexual orientations, gender identities and gender expressions.
Our hiring process is accessible, consistent with Ontario's Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005. We are working to prevent and remove barriers in our hiring processes and can offer accommodation to address specific needs related to Code-protected grounds such as disability, family status and religion. For more information about accommodation during the hiring process please contact us.
Learn more about the work the OPS is doing to create an inclusive, anti-racist, accessible and diverse workplace:
diversity, equity and inclusion initiatives
accessibility
Anti-Racism Policy
What we offer
-----------------
The Ontario Public Service is one of Ontario's largest employers. Employees work for a wide range of ministries, with offices in more than 70 cities across the province. We offer:
a career that can grow across ministries and job functions
flexible learning and developmental opportunities, including education and mentorship programs
a comprehensive compensation and benefits package
base salary that aligns to market trends with performance-based pay and scheduled salary progression
tailored work arrangements, including opportunities like flex hours, self-funded leave and more
a modern, friendly and accessible physical work environment
Additional information:
---------------------------
Apply by:
Thursday, November 6, 2025 11:59 pm EST
Position details:
1 English Temporary, duration up to 12 months, 5700 Yonge St, North York, Toronto Region
Compensation group:
Ontario Public Service Employees Union
Work hours:
Schedule 6
Category:
Information Technology
Posted on:
Thursday, October 23, 2025
Note:
The information that you provide for the purpose of this competition and the results from this competition may be used to fill other positions. These positions may be of various tenures including short-term assignments. Your information and the results from this competition will be retained for the purpose of filling vacancies in accordance with the applicable collective agreement or policy provisions.
C-MG-232009/25
How to apply:
-----------------
You must apply online.
Your cover letter and resume combined should not exceed five (5) pages. For tips and tools on how to write a concise cover letter and resume, review the Writing a Cover Letter and Resume: Tips, Tools and Resources.
Customize your cover letter and resume to the qualifications listed on the job ad. Using concrete examples, you must show how you demonstrated the requirements for this job. We rely on the information you provide to us.
Read the job description to make sure you understand this job.
OPS employees are required to quote their WIN EMPLOYEE ID number when applying.
If you require a disability related accommodation in order to participate in the recruitment process, please Contact Us to provide your contact information. Recruitment services team will contact you within 48 hours.
Language requirements and assessment:
All external Ontario Public Service (OPS) job ads are posted in English and French. Check the "position(s) language" section at the top of each job ad for the language requirements. For all roles, candidates are assessed in English, the business language of the OPS. If the position is bilingual (English/French), you'll also need to pass a French-language proficiency test.
Exigences en matiere de langue et evaluation:
Toutes les offres d'emploi externes de la fonction publique de l'Ontario (FPO) sont affichees en francais et en anglais. Consultez la section Langue du ou des postes en haut de chaque offre d'emploi pour connaitre les exigences linguistiques. Pour tous les postes, les candidats sont evalues en anglais, la langue d'affaires de la FPO. Si le poste est bilingue (anglais/francais), vous devrez egalement passer un test de competences linguistiques en francais.
Strengthening Ontario, together
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.