Database Administrator

**Back to search results**- **Database Administrator**:

- **Job ID**:

- 232009
- **Posting status**:

- Open
- **Organization**:

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

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
- 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
- perform feasibility studies and cost-benefit analyses, making recommendations and preparing business cases for new or enhanced technologies
- 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:

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