Database Administrator/DBA

at  LGM Financial Services Inc

THE ORGANIZATION:

LGM is a national leader in providing warranty, finance and insurance services to the Canadian automotive industry. Since 1998, LGM has been successfully supplying quality products and leading training solutions with strategic partnerships with automotive manufacturing brands, which include BMW/MINI, Kia, Mazda, Volvo, Jaguar, LandRover, Mitsubishi Motors, Polestar and Motorrad.
Reporting to the Data Engineering Team Lead, the Database Administrator (DBA) is primarily responsible for the performance, availability, security, and recovery of local and cloud-based solutions for data storage, management, and retrieval. The DBA will focus extensively on managing databases in Azure SQL Managed Instances, On-premises SQL servers and Azure Data Factories, ensuring high availability and robust data pipeline architectures.
Salary Range: $80,000- 100,000
Hybrid role: 1-2 days a month in office.

DESIRABLE TECHNICAL SKILLS:

• Strong database management skills in a SQL Server cloud database environment, with extensive experience with Azure SQL Managed Instances.
• Extensive and proven T-SQL scripting skills.
• Experience using PowerShell in Azure and manage certain data administration tasks.
• Experience with always-on high availability technology.
• Good knowledge of IaaS, SaaS, and PaaS.
• Proficiency in managing and optimizing Azure Data Factories and developing data pipelines.
• Demonstrated working knowledge of unstructured data management principles.
• Experience with cloud infrastructure.
• Experience managing Azure resources is a plus.
• Experience monitoring database instances.

REQUIRED EXPERIENCE:

• Minimum of 5 years’ experience in a DBA role.
  S
  S

Please refer the Job description for details