Location
This is a hybrid position (4 days per week in office from 1 of our office locations below and 1 day remote).
Office Locations: 1 Presidents Choice Cir, Brampton, ON L6Y 5S5 (near hwy. 407 and Mississauga Rd)
Summary
Lifemark Health Group is seeking a skilled and motivated DevOps Engineer – Azure Cloud & SQL DBA to join our dynamic Application Development Team in a permanent full-time position. Re porting to the Development Manager, you will champion the DevOps process while managing and optimizing our database infrastructure.
You will drive initiatives that enhance automation, deployment, and operational efficiency across our application landscape.
In this hybrid role, you will manage, secure, and optimize (mainly) Microsoft SQL Server databases across both virtual machines and Azure PaaS environments. You’ll collaborate with development and infrastructure teams to automate deployments, monitor system health, and ensure high performance, availability, and scalability. Bridging the gap between DevOps and database administration, this role is ideal for someone with hands-on experience in T-SQL, performance tuning, Azure SQL, and infrastructure automation who thrives in a fast-paced, collaborative environment.
About You
You are a seasoned and technically skilled professional who thrives at the intersection of DevOps and database engineering. With several years of hands-on experience managing Microsoft SQL Server environments, you bring deep knowledge of T-SQL development, query optimization, and database performance troubleshooting. You’re passionate about working with SQL databases both in traditional VM-based environments and in modern Azure PaaS solutions like Azure SQL Database and Managed Instances.
You enjoy solving complex data challenges, optimizing slow-running queries, and automating routine tasks. You bring a thoughtful, systematic approach to DevOps and infrastructure management and are eager to contribute your expertise in a senior capacity, collaborating closely with developers, IT teams, and cloud architects to deliver scalable, secure, and high-performing systems.
Your Responsibilities

Database Administration and Maintenance

• Design, deploy, and maintain SQL Server databases supporting C#/.NET Core applications.
• Perform routine tasks such as backups, indexing, health checks, and disaster recovery drills.
• Monitor and optimize database performance using tuning and analytics tools.
• Lead incident resolution and root cause analysis for SQL-related issues

Azure Cloud Platform Management

• Administer and optimize Azure SQL Database, Managed Instances, and related Azure data services.
• Use services such as Azure Data Factory, Azure Blob Storage, and Azure Monitor for data workflows and observability.

• Plan and perform migrations of on-premise databases to Azure cloud environments.

  DevOps and Infrastructure Automation

• Build CI/CD pipelines integrating database deployment processes using tools like Azure DevOps, GitHub Actions, or Terraform.

• Develop automation scripts (PowerShell, Azure CLI, Terraform) to manage provisioning, scaling, and operational tasks.
• Implement infrastructure-as-code practices for database and cloud resource management.

Development Collaboration & Performance Tuning

• Work with software developers to design and refine database schemas, stored procedures, and queries.
• Review and optimize T-SQL code and provide performance recommendations.

• Contribute to version-controlled database change management strategies.

  Automation and Scripting

• Develop and maintain automation scripts for database management tasks using PowerShell, Azure CLI, or other scripting languages.

• Implement automated monitoring and alerting systems to proactively identify and resolve database issues.

Compliance, Security and Monitoring

• Enforce best practices for database security, including encryption, access control, and auditing.
• Support compliance with GDPR, HIPAA, and other regulatory frameworks.

• Perform regular vulnerability assessments and security reviews.

  Capacity Planning and Scaling and Documentation

• Monitor capacity and usage trends; forecast and plan for future scale requirements.

• Manage partitioning and sharding strategies for high-volume systems.

• Maintain documentation for database configurations, policies, and architectural decisions.

  Automation and Scripting

• Develop and maintain automation scripts for database management tasks using PowerShell, Azure CLI, or other scripting languages.

• Implement automated monitoring and alerting systems to proactively identify and resolve database issues.

Research and Innovation

• Stay up to date with the latest database technologies and best practices.
• Evaluate and recommend new tools, technologies, and methodologies to improve database performance, security, and manageability.

Required Skills and Qualifications

• Bachelor’s degree in computer science, Information Systems, or related field.
• 5+ years of experience in SQL Server database administration.
• 3+ years of experience in DevOps, infrastructure automation, or cloud operations.
• Deep expertise in T-SQL, performance tuning, and SQL Server internals.
• Hands-on experience with Azure SQL Database, Managed Instances, and Azure DevOps tools.
• Strong scripting skills in PowerShell, Terraform, or Azure CLI.
• Experience with Azure networking for databases (VNet service endpoints, private endpoints).

• Working knowledge of containerized SQL deployments (e.g., SQL Server in Docker for dev/test

  environments).

• Understanding of data governance principles including classification, retention, and masking policies.

• Knowledge of cloud-native tools and services for monitoring, logging, and alerting.
• Excellent problem-solving, collaboration, and communication skills.
• Experience with containerization (Docker/Kubernetes) and infrastructure as code (Terraform, Bicep).
• Familiarity with microservices architecture and CI/CD strategies.
• Familiarity with database change management tools like Flyway, Redgate, or Liquibase

• Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified:

  Azure Solutions Architect Expert or Azure DevOps Engineer Expert are a plus.
  Our Perks
  You will be issued a company developer laptop, headset and a home office monitor, keyboard, and mouse. You will have the chance to work on full stack projects and learn from our intelligent team of seasoned developers and consultants.

After your successful probation period, you will:

• Have access to a yearly education re-imbursement fund
• Receive 30% discount from Shopper Drug Mart purchases
• Contribute to an Employee Stock Ownership Plan (ESOP) with employer matching percentage
• Have paid vacation days as well as wellness days
• Have a choice to enroll in our Health & Dental Flex Life Benefits (or in lieu contribute to your RRSPs)
• Access to employee assistance program

Who We Are
Lifemark Health Group is a market leader in customized healthcare solutions. As one of the largest and most comprehensive providers in Canada, we continue to grow exponentially. With that growth, is a vision to be the most innovative healthcare providers in community rehabilitation, workplace health and wellness and medical assessment services. Lifemark was acquired by Loblaw Companies on May 10, 2022, you can read more about the acquisition here.

Please refer the Job description for details