Home
Jobs
Yochana
Contract role: SQL Server DBA at Toronto, ON (Onsite – Hybrid Model)

Contract role: SQL Server DBA at Toronto, ON (Onsite – Hybrid Model)

On site

Toronto, Canada

Mid level

Freelance

10-09-2025

Share this job:

Score my CV

Skills

Communication Python SQL GitHub Ansible Problem-solving Databases Oral and Written Communication SQL Server AWS Shell Software Development SDLC

Job Specifications

MS SQL Server DBA

Toronto, ON (Onsite - Hybrid Model)

Long Term Contract

Job description

Would you like to be part of a collaborative and innovative data platform support team in BMO? In this role you will build and support enterprise data platform strategies for BMO.

Requirements:

5+ years of hands-on DBA experience and strong skills on MS SQL server
Nice to have sound knowledge of Oracle or AWS RDS, Redshift, preferable with 1+ year hands-on experiences
Solid understanding of the Software Development Life Cycle (SDLC)
Sound knowledge and 1+year experience with Database automation and DB DevSecOps (e.g. Ansible, AWS CDK, Github Action, Liquibase, shell scripting, python, SQL)
Excellent oral and written communication skills
In depth team and collaboration skills
In depth Analytical and problem-solving skills
Bachelor degree in computer science, engineering or related field or equivalent work experience

Responsibilities:

Design, engineer, and deploy on MS SQL Server. Nice to have experiences on Oracle or AWS RDS, Redshift DBMS technologies.
Design and develop optimal solutions to migrate or upgrade existing databases to new platform or DBMS versions
Build and leverage automation and DB DevSecOps pipelines to provision, upgrade, patch and maintain DB systems
Support DB change request and problem investigation and resolution of both production and non-production environments.
Monitor capacity, high-availability and performance for non-production and production databases to ensure they are highly reliable, efficient, cost effective, and provide the required functionality.
Seeks opportunities to improve database performance by identifying tuning measures and implementing them when appropriate.
Develops and maintains database backup and recovery strategy and procedures. Ensures that databases are properly backed up and recovered when necessary
Ensures databases are properly maintained, meeting security, audit and compliance requirements. Databases are reorganized/groomed when necessary and other DBA utilities run when appropriate.
Tests upgrades/new releases of database software and related products. Assesses impacts to application and the database environment.

Responds immediately to critical issues. On call and/or shift duty may be required

About the Company

Yochana: Your Trusted Workforce Partner Across North America & Beyond For over 15 years, Yochana has been a leading talent acquisition firm, connecting businesses with top professionals across industries. Headquartered in Farmington Hills, Michigan, we specialize in temporary workforce solutions, permanent placements, contract-to-hire, and recruitment process outsourcing (RPO) across the USA, Canada, Mexico, and India. At Yochana, we go beyond traditional hiring agencies--our customized recruitment strategies and AI-driven ... Know more