Database Administrator, SQL

Borden Ladner Gervais LLP (BLG), a leading, innovative and client-focused law firm in Canada, is seeking a Database Administrator, SQL.
Purpose of the Role

We are seeking a highly skilled SQL Database Administrator to support the firm’s SQL environment (manage Microsoft SQL Server database servers, including routine maintenance, security auditing, backup and recovery, index tuning, and optimization).

This position will work with the DevOps team to ensure proper database design and optimal performance of products, and to enforce data governance standards.

Key Responsibilities

The key responsibilities of this role are:
Core responsibilities - You will be asked to support the day-to-day SQL operations and to work with the rest of the team to define our technology roadmap. The responsibilities include:

- Support and maintain an effective database environment to support all business systems
- Ensure proper security measures are enforced
- Installing, managing and optimizing MS SQL Server (In a SQL 2008 R2, SQL 2012, 2016, 2019 and Azure environment)
- Performance troubleshooting and optimizing MS SQL Servers
- Upgrading and enhancing MS SQL Server environment to latest versions and patches
- Participate in change control activities
- Development of SSIS scripts
- Firm projects as assigned, this role will act as the technical lead on many strategic firm initiatives
- Support firm data warehouse, SSRS and SSAS environment
- Perform integrity tests and data spot-checks
- Identify the necessary fixes needed to resolve those problems
- Provide the fixes to be implemented in production

Technical skills (Essential):

- Minimum 6 - 10 years of practical experience working as a database administrator.
- Experience with SQL Server installations and configurations for stand-alone and clustered instances (In a SQL Server 2008 R2, 2012 and 2016, 2019 and Azure environment).
- Experience with highly available architectures such as clustering, replication, Always-on of MS SQL Server.
- Experience in capacity and growth planning.
- Experience in defining migration plans, risk mitigation and execution of defined strategy.
- Strong understanding of SQL Server backup and restore concepts and implementations.
- Strong performance tuning and optimization skills.
- Strong understanding of index design and management.
- Strong understanding of SQL Server security concepts and implementations.
- Understanding of filegroups and data file layouts.
- Understanding of concurrency and locking concepts.
- Experience with SQL Server tools, including SSMS, Profiler, Tuning advisor, Business Intelligence Studio, and Configuration Manager.
- Experience creating and managing SQL Server Maintenance Plans and Jobs.
- Strong analytical skills for troubleshooting incidents and performing root cause analysis.
- Strong working knowledge of SSIS, SSRS and SSAS.
- Strong knowledge of T-SQL including enhancements introduced in SQL Server 2008, 2012 and 2016, 2019 Azure. Ability to create and maintain scripts, jobs, views, stored procedures, user-defined functions and triggers.
- Experience with TFS/DevOps.

Key Competencies
- Ability to communicate in a professional manner
- Strong organizational and time management skills
- Excellent multi-tasking skills with the ability to manage multiple assignments, both immediate and strategic, at the same time
- Strong attention to detail
- Ability to work independently, follow instructions with mínimal supervision and take initiative
- Ability to work in a multi-office dynamic team environment
- A team player with excellent interpersonal skills
- Availability to work overtime, when necessary
- Flexible and dependable, able to take the initiative
- Able to remain calm under pressure and work to tight deadlines
- Conscientious, approachable and enthusiastic
- Able to quickly build confidence, respect and trust with others
- Have a positive approach to daily tasks and have a solutions focused working method

How to Apply

Note - this role can be located in any of our regional offices.

We thank all applicants for their interest in this position, however, only applicants selected for an interview will be contacted.

At BLG, only those BLG members who are fully vaccinated against COVID-19 with a vaccine approved by Health Canada will be permitted to attend a BLG office or event. “Fully vaccinated” means having received the full series (usually 2 doses) of a vaccine approved by Health Canada, with more than 14 days having passed since the second dose was administered. “Attending a BLG office” includes attending social or business gatherings organized by the Firm, with limits on the number of attendees in accordance with public health guidelines. With respect to client meetings, only fully vaccinated members of the Firm can meet in person with clients (others can attend virtually), unless prior authorization has been obtained from BLG and the client. For any BLG member who is not fully vaccinated, and if