SQL Server Database Administrator (DBA)

Desjardins Group; Montreal; On-site; CAD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a skilled SQL Server Database Administrator to enhance and manage their database systems. In this pivotal role, you will design, configure, and optimize SQL Server databases both on-premises and in the cloud, ensuring their security and performance. Your expertise will guide the development of automation solutions and database management strategies, making a significant impact on the organization's data integrity and operational efficiency. Join a team that values collaboration and innovation, and enjoy competitive benefits including flexible vacation and a defined benefit pension plan, all while contributing to meaningful projects in a dynamic environment.

Benefits

Competitive salary

Annual bonus

4 weeks of flexible vacation

Defined benefit pension plan

Group insurance including telemedicine

Reimbursement of health and wellness expenses

Telework equipment reimbursement

Qualifications

• 4+ years of relevant experience in database management and administration.
• Strong knowledge of SQL Server versions 2012 to 2022 and Azure SQL.

Responsibilities

• Deploy and support SQL Server database services in IaaS and PaaS modes.
• Conceptualize and implement database structures ensuring integrity and performance.

Skills

Database Management

SQL Server

T-SQL

PowerShell

Azure SQL

DevOps

CI/CD Practices

Interpersonal Skills

Education

Bachelor's degree in a related field

Tools

Azure DevOps

GitHub

CosmosDB

Flyway

Ansible

VMware

Job description

As an SQL Server database administrator (DBA), you design, configure, administer and improve SQL Server databases and data structures on premises and on the cloud. You prepare recommendations, solutions and action plans based on the organization’s objectives and priorities. You ensure the optimal use, security, integrity and maintenance of Desjardins Group’s databases. Your initiatives require extensive, in-depth knowledge of your line of work. More specifically, you will be required to:

• Deploy, configure and support SQL Server database services in IaaS and PaaS modes for the environments and applications concerned, ensuring their integrity, security and performance

• Conceptualize, implement and update database structures

• Advise parties involved on database management, use and access

• Help develop automation solutions for the ongoing configuration, installation, maintenance, delivery and rollout of SQL Server and Azure SQL services

• Draft and update system and database documents.

What we offer*

• Competitive salary and annual bonus

• 4 weeks of flexible vacation starting in the first year

• Defined benefit pension plan that provides predictable, stable income throughout retirement

• Group insurance including telemedicine

• Reimbursement of health and wellness expenses and telework equipment

*Benefits apply based on eligibility criteria.

What you bring to the table

• Bachelor's degree in a related field

• A minimum of four years of relevant experience

• Please note that other combinations of qualifications and relevant experience may be considered

• Experience working on projects in large organizations

• Knowledge of French is required

• Knowledge of Azure SQL, SQL Server 2012 to 2022, AlwaysOn, T-SQL, PowerShell, Windows Server

• Knowledge of VMware and Azure environments

• Knowledge of Azure DevOps, GitHub, CosmosDB, Flyway, Ansible

• Knowledge of DevOps and CI/CD practices

• Availability to work evenings and weekends on request during rollouts

Action oriented, Business insight, Collaborates, Communicates effectively, Complexity, Customer Focus, Interpersonal Savvy, Plans and aligns