Senior Data Engineer (Azure SQL Server DBA)

Pour obtenir une traduction en français de loffre demploi suivante veuillez envoyer un courriel à . Les demandes seront traitées dans un délai de trois jours ouvrables et la période de dépôt des demandes sera prolongée de trois jours.

To obtain a French translation of the following job posting please email . Requests will be addressed within three business days and the application window will be extended by three business days.

At Ontario Health we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes experiences and value. How we work together is reflected through our five values: integrity inspiration tenacity humility and care.

• Fully paid medical dental and vision coverage from your first day

• a health care spending or wellness spending account

• a premium defined benefit pension plan

• three personal days and two float days annually

• three weeks vacation to start (for individual contributors) increasing to four weeks after two years

• career development opportunities

• a collaborative values-based team culture

• a wellness program

• a hybrid working model

• participation in Communities of Inclusion

Want to make a difference in your career Consider this opportunity.

The Azure SQL Server DBA (Data Engineer II) is responsible for the design development administration and support of SQL Server databases and related data platforms.

This includes building and maintaining schemas stored procedures ETL processes archival routines and performance optimization. The role also involves monitoring troubleshooting and ensuring high availability security and disaster recovery of SQL Server environments both on-premises and in Azure.

The DBA will gather and review requirements lead solution design implement efficient and scalable database solutions and proactively identify risks performance issues and potential impacts. The position also supports testing productization and release processes.

Here is what you will need to be successful

• Provides mentoring and technical guidance to junior Data Engineers on engineering practices and problem-solving.

• Shares insights on design decisions and business requirements to support implementation clarity.

• Ensures timely and consistent execution of work assignments.

• Owns tasks initiatives and service quality within assigned scope.

• Recommends and leads improvements to engineering practices that enhance team efficiency.

• Collaborates with product teams to suggest features that improve user experience and maintainability.

• Operates independently within defined project scope guided by Lead Engineers and Product Managers.

• Aligns work with broader roadmaps stays current with evolving technologies and engages with cross-portfolio stakeholders when needed.

Education and Experience

• Bachelors or Masters degree in Computer Science Information Technology Computer Engineering or related field or equivalent experience.

• 57 years of hands-on experience administering and managing SQL Server databases in on-premises and Azure environments.

• In-depth knowledge of software development and software development Life Cycle (SDLC).

• Strong expertise in SQL Server installation configuration patching and -depth knowledge of data models data mining and segmentation techniques.

• Proven experience with high availability (Always On Failover Clustering) disaster recovery and backup/restore knowledge of relevant data query languages (e.g. SQL KQL etc.).

• Experience with automation and scripting (PowerShell Azure CLI or similar).

• Strong operational knowledge of Azure SQL Database Azure Managed Instance and related Azure data services.

• Strong knowledge of database security encryption auditing and compliance best practices.

• In-depth knowledge of relevant data manipulation techniques.

• Strong knowledge of data analytics techniques.

• Strong knowledge of data processing platforms (Spark ADF etc.).

• In-depth knowledge of database design using relational document object big data tabular and other platform types.

• Strong operational knowledge of relevant data platforms in on-premises environments and cloud platforms.

• Excellent knowledge of best practices related to product deployment operations and support of databases and pipelines.

• Excellent knowledge of data security and data protection mechanisms.

• Strong knowledge and understanding of data management authorities and legislation relevant to health care in Ontario.

Knowledge and Skills

• Demonstrates strong written and verbal communication skills to mentor staff convey technical direction incorporate stakeholder feedback and document data processes.

• Applies advanced debugging analytical and problem-solving skills to gather requirements optimize data pipelines and assess solution impacts and risks.

• Utilizes modern tools and platforms to build and maintain on-premises and cloud-based data systems aligned with business and architectural needs.

• Conducts quality assurance testing validates data integrity and performs risk assessments to ensure reliable data operations.

• Implements data security and protection mechanisms and develops control documentation and run books to support product operations.

• Designs and develops complex scalable multi-platform data environments and architectures including entity relationships and transformation solutions.

• Collaborates across teamsincluding product IT Operations Cloud Centre of Excellence Architecture and Securityto deliver secure and efficient data services.

• Maintains deep knowledge of data engineering technologies communicates clearly across teams and makes high-impact decisions with emotional intelligence and stakeholder awareness.

Employment Type:

Contract Length:

Salary Band:

External Application Deadline Date: