This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

The top job offers in Canada!

To post a job, login or create an account |  Post a Job   

A simple jobs board with daily updated offers from Canada

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

Alltech Consulting Services, Inc.: Sql Server Dba (Preferred Local Candidates)

Alltech Consulting Services, Inc.

This is a Full-time position in Montreal, QC posted April 22, 2021.

Position Overview Sr SQL Server DBA with Azure and minimum 7 years of experience working on SQL Server database platform.

Job Title SQL Server DBA Description The team is responsible for SQL plant’s administration, security, performance, upgrades and manages day-to-day functions like performance troubleshooting, patches and tasks like backup recovery and changes to the environment.

This is a CONTRACT position for a senior level SQL Server operation DBA.

Applicant will be responsible for SQL Server plant’s health and must be able to perform day to day functions like managing security and access, backup and restores, upgrades, performance trouble shooting etc.

Candidate must have worked on Microsoft SQL Azure Technology (IAASPASS), good verbal and written communication skills and should be able to work with others within and outside of the team.

Performance and tuning of user issues and code is must have skill.

Required skills Candidate should have at least 8 yearsrsquo experience working with Microsoft SQL Server as an operations DBA.

University degree in computer science or equivalent Experience working on migrating existing SQL Server instances to Azure SQL or provision a new Azure SQL database.

Backup and restore Azure SQL databases and configure High Availability in Azure VM.

Configure, monitor and optimize the performance of Azure cloud database to meet the business needs.

Work with Application team for Query Tuning, identifying performance issues in on-prem or Azure database and provide resolution.

Automate common database management tasks using PowerShell A demonstrated proficiency in supporting the database platform of a large organization Prior experience with SQL Server Clustering, strong Transact SQL skills are highly desired Ability to quickly troubleshoot and resolve complex problems in a live environment Experience in handling Production Outage calls and taking necessary actions to mitigate the issue Excellent interpersonal skills and ability to articulate complex ideas and solutions to users Self-motivation with the ability to work independently and as a strong team player Flexibility to support the operations of our businesses, from time to time, on call on a rotation basis Nice to have Prior experience with Always ON, Replication, Backup and recovery methods including 3rd party tools like nexGen, Database Mirroring, Database capacity planning and Users and Role creation and