SQL Server DBA with Azure

Job title: SQL Server DBA with Azure

Job description: SQL Server DBA with Azure

Duration: 12 months

Location: Remote/Montreal once back to the office resumes

Be part of a team 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.

Responsibilities: * SQL Server plant’s health

• Perform day to day functions like managing security and access, backup and restores, upgrades, performance trouble shooting etc.
• Performance and tuning of user issues and code

Required skills: * 8+ years’ experience working with Microsoft SQL Server as an operations DBA.

• 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.
• Ability to work with Application team for Query Tuning, identifying performance issues in on-prem or Azure database and provide resolution.
• Ability to automate common database management tasks using PowerShell
• 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 user
• University degree in computer science or equivalent
• 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 monitoring.

Company: Modis

Expected salary:

Location: Montreal, QC

Job date: Thu, 22 Apr 2021 07:41:45 GMT