Database Administrator CE-464

Database Administrator CE-464

The Health Services I⁢ Cluster, Emergency Health I⁢ Solutions & Technology Management Branch is seeking a Database Administrator to provide strategic data resource management including Database Administration (DBA) in MS SQL and Azure SQL database and related application

OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism:

We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.

We invite all interested individuals to apply and encourage applications from people with disabilities, Indigenous, Black, and racialized individuals,



as well as people from a diversity of ethnic and cultural origins, sexual orientations, gender identities and expressions.

Visit the OPS Anti-Racism Policy and the OPS Diversity and Inclusion Blueprint pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.

We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's Human Rights Code. Refer to the "How to apply" section if you require a disability-related accommodation.

What can I expect to do in this role?

In this role, you will:

• co-ordinate the development, maintenance and control of the Branch's Databases and Data Warehouse and related documented processes and procedures;

• monitor database performance, tuning the database environment, ensure best overall use of technology and optimum on-line systems performance;

• ensure appropriate integration and connectivity of a number of emergency health systems and applications with the Branch's Databases and Data Warehouse;

• manage the development,



maintenance and uninterrupted running of all interface processes feeding data to the Branch's Databases and Data Warehouse

• co-ordinate the development and provision of standard and ad hoc reports including configuring and deploying the report;

• • conduct capacity planning and system resource allocation;

• co-ordinate/provide technical support and resolve technical and operational problems;

• coordinate services with vendors and IT support specialists, including troubleshooting, resolution and determining root-cause of production incidents with vendors/IT support;

• provide expert advice on database, data warehousing and data management developments, technologies and methodologies;

• advise applications specialists/contractors regarding database design and data management issues;





• conduct cost/benefit analyses and feasibility studies, make recommendations and prepare business cases to support new or enhanced technologies

• lead projects for database design and development or to manage changes to hardware, software, applications or linkages; and

• conduct on-going liaison and consultation with clients, users and stakeholders regarding database and data warehouse needs, operations and changes.

How do I qualify?

Technical Knowledge and Skills

You have knowledge of the following:

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

Additional information

Address:

- 1 English Temporary, duration up to 12 months, 5700 Yonge St, North York, Toronto Region

Compensation Group:





Ontario Public Service Employees Union

Understanding the job ad - definitions

Schedule:

6

Category:

Information Technology

Posted on:

Friday, January 24, 2025

Note:

- C-HL-223192/24

How to apply:

Please apply online, only, at www.ontario.ca/careers, quoting Job ID 223192, by Friday, February 7, 2025. Please follow the instructions to submit your application. Faxes are not being accepted at this time.

Show more Show less

The original job offer can be found in Kit Job:
https://www.kitjob.ca/job/90406304/database-administrator-ce-464-north-york/?utm_source=html