Top Benefits
About the role
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.
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).
• 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
Address:
- 1 English Temporary, duration up to 12 months, 5700 Yonge St, North York, Toronto Region
Please apply online, only, at www.ontario.ca/careers , quoting Job ID 232009, by Thursday, November 6, 2025 . Please follow the instructions to submit your application. Faxes are not being accepted at this time.
If you require accommodation in order to participate in the recruitment process, please contact us at www.gojobs.gov.on.ca/ContactUs.aspx to provide your contact information. Recruitment Services staff will contact you within 48 hours. Only those applicants selected for an interview will be contacted.
The Ontario Public Service is an inclusive employer. Accommodation will be provided in accordance with Ontario’s Human Rights Code .
About Government of Ontario
Ontario Government | Gouvernement de l'Ontario
The Ontario Government works to serve the public interest and uphold the public trust by providing Ministers with objective advice and expert guidance. The Ontario Public Service carries out the decisions and policies of the elected government with integrity and accountability and administers public services to the highest professional standards.
Le gouvernement de l'Ontario sert l'intérêt public et conserve la confiance du public en fournissant aux ministres des conseils objectifs et spécialisés. La fonction publique de l'Ontario applique les décisions et les politiques du gouvernement élu. En respectant le principe de reddition des comptes et avec intégrité, elle administre les services à la population selon les normes professionnelles les plus rigoureuses.
Top Benefits
About the role
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.
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).
• 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
Address:
- 1 English Temporary, duration up to 12 months, 5700 Yonge St, North York, Toronto Region
Please apply online, only, at www.ontario.ca/careers , quoting Job ID 232009, by Thursday, November 6, 2025 . Please follow the instructions to submit your application. Faxes are not being accepted at this time.
If you require accommodation in order to participate in the recruitment process, please contact us at www.gojobs.gov.on.ca/ContactUs.aspx to provide your contact information. Recruitment Services staff will contact you within 48 hours. Only those applicants selected for an interview will be contacted.
The Ontario Public Service is an inclusive employer. Accommodation will be provided in accordance with Ontario’s Human Rights Code .
About Government of Ontario
Ontario Government | Gouvernement de l'Ontario
The Ontario Government works to serve the public interest and uphold the public trust by providing Ministers with objective advice and expert guidance. The Ontario Public Service carries out the decisions and policies of the elected government with integrity and accountability and administers public services to the highest professional standards.
Le gouvernement de l'Ontario sert l'intérêt public et conserve la confiance du public en fournissant aux ministres des conseils objectifs et spécialisés. La fonction publique de l'Ontario applique les décisions et les politiques du gouvernement élu. En respectant le principe de reddition des comptes et avec intégrité, elle administre les services à la population selon les normes professionnelles les plus rigoureuses.