MSSQL Database Admin

Apptoza Inc.; Montreal; On-site; CAD 120,000 - 150,000; Full time

Job summary

Apptoza Inc. is seeking an experienced MSSQL Database Administrator to manage, optimize, secure, and support enterprise databases in a primarily Azure-based environment. The role focuses on SQL Server across on-premises and cloud, with emphasis on performance tuning, security, and disaster recovery.

The candidate should have 8+ years of MSSQL experience, strong skills in T-SQL, PowerShell, and Azure CLI, and be comfortable with production incident management and cloud modernization initiatives.

Qualifications

• 8+ years of MSSQL Database Administration experience.
• Strong expertise in SQL Server and Azure SQL Database.
• Experience with Always On, HA/DR, and disaster recovery.

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.
• L3 production support and incident management.

Skills

MSSQL DBA

SQL Server

Azure SQL

Azure CLI

PowerShell

T-SQL

Query Store

Performance Tuning

HA/DR

Always On

Incident Management

Tools

Azure CLI

PowerShell

SQL Server Management Studio

Job description

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.
• 8–14 years of MSSQL Database Administration experience.
• Strong 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.