Job Description

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.

Inclusion

We are committed to creating an inclusive environment where people from all backgrounds can thrive. Improving inclusion and equity is a collective responsibility. Lifemark promotes equal employment opportunities for all job applicants, including but not limited to those self-identifying as a member of the employment equity groups: Indigenous peoples, Newcomers to Canada, Women, and Visible minorities.

Accommodation

Accommodations are available on request for all candidates taking part in any aspect of the recruitment and selection process. Email us at talent at lifemark.ca