a close up of a person using a laptop

Database Administrator, SQL

Reference #: DA_-_07-29-22
Calgary , Montreal , Ottawa , Toronto , Vancouver
No File Selected

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
  • Daily production support of the database application servers
  • 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

Maintenance - Part of the responsibilities includes the maintenance of existing applications. You will receive some requests to:

  • Perform integrity tests and data spot-checks
  • Perform performance tests on applications and analyse the results to prevent or correct potential problems

Support - You will be asked to provide a second level support to the users of internally developed application. The responsibilities include:

  • Troubleshoot problems found in existing applications with the collaboration of the operation team.
  • 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 minimal 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

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

Effective June 27, 2022, BLG has suspended its current vaccine policy mandate, As the pandemic is not over, the safety of Firm members and the BLG community remains our top priority. Given the ever-evolving nature of the situation, we will continue to closely monitor health conditions and if necessary implement new measures to protect Firm members. While is it not a condition of employment, we would appreciate reviewing your most recent proof of vaccine if available.

Everyone at BLG is required to carry out the duties of their role while upholding the important principles of our respectful workplace policies, and treating everyone with respect, regardless of position. At BLG, valuing diversity and inclusion is key to a respectful workplace.

BLG is committed to building and fostering a workplace that is reflective of our communities, where all firm members feel included, valued, and heard. We welcome applications from all qualified candidates but acknowledge the systemic and structural barriers that have, historically, marginalized and barred certain groups from accessing employment opportunities. As part of our commitment to removing barriers to employment, we strongly encourage applications from members of these historically marginalized groups including, but not limited to, Indigenous peoples, racialized individuals, members of the LGBTQ+ community, people with disabilities and women. Accommodations are available, upon request, in all aspects of the recruitment process.

* Please note that relatives of current BLG employees and partners are not eligible for consideration.