Role : MSSQL Database Administrator – L3 (Azure & On-Premises)

Location:
Montreal ,QC

Experience:
8+ Years Role Overview: We are seeking an experienced MSSQL Database Administrator with strong L3 expertise in SQL Server and Azure database environments to manage, optimize, secure, and support enterprise databases.

Key Responsibilities
• Administer SQL Server across on-premises, Azure SQL Database, Managed Instance, and Azure VMs.
• Perform database performance tuning, query optimization, indexing, and troubleshooting.
• Manage Always On Availability Groups, clustering, replication, backup, and disaster recovery.
• Handle database migrations, upgrades, patching, and cloud modernization.
• Optimize T-SQL, stored procedures, execution plans, and database workloads.
• Implement database security, access controls, encryption, and compliance.
• Automate database administration using PowerShell, T-SQL, and Azure CLI.
• Handle P1/P2 production incidents, root cause analysis, and resolution.




• Maintain database documentation, monitoring, and operational procedures. Essential

Skills:
• 8–14 years of MSSQL Database Administration experience.
• Robust expertise in SQL Server and Azure SQL Database.
• Azure SQL Managed Instance and SQL Server on Azure VMs.
• Performance tuning, Query Store, execution plans, indexing, and T-SQL.
• Always On, HA/DR, replication, clustering, backup, and recovery.
• Database migration, upgrades, and patching.
• PowerShell, T-SQL, and Azure CLI automation.
• L3 production support and incident management. Good to Have:
• Azure SQL Automatic Tuning, Database Advisor, and Elastic Pools.
• Azure Geo-Replication and cost optimization.
• Microsoft Entra ID, Managed Identities, and database security.
• Infrastructure as Code and compliance management.
• Team mentoring and stakeholder communication.

📌 MSSQL Database Admin (Montreal)
🏢 apptoza
📍 Montreal