Azure SQL Database Administrator (DBA)

Job Title: Azure SQL Database Administrator (DBA)

Location: Toronto, ON-hybrid

long term contract

We are seeking an experienced Azure SQL Database Administrator (DBA) to manage| optimize| and secure our cloudbased SQL environments. The ideal candidate will have strong expertise in Azure SQL Database| SQL Server| automation| performance tuning| and high availability.

Role Descriptions:

• Install| configure| and maintain Azure SQL Database| Azure SQL Managed Instance| and SQL Server on Azure VMs.
• Manage database objects such as tables| indexes| views| stored procedures| and functions.
• Implement and maintain backup restore strategies| including automated Azure backups.

Performance Tuning Monitoring

Perform query optimization| index tuning| and resolving deadlocks or performance bottlenecks.

Monitor SQL workloads using Azure Monitor

• Azure SQL Insights
• Log Analytics

Query Store Security Compliance

• Implement best practices for data security| encryption (TDE| Always Encrypted)| and secrets management via Azure Key Vault.
• Manage RBAC roles| least-privilege access| and security auditing.
• Ensure compliance with organizational and regulatory standards.

High Availability Disaster Recovery

• Configure and maintain Azure SQL failover groups| availability zones| and georeplication.
• Validate disaster recovery plans and conduct failover tests.

Automation DevOps

• Automate administrative tasks using PowerShellAzure CLIAzure Automation RunbooksTerraform or ARMBicep templates
• Support CICD pipelines for database releases using Azure DevOps or GitHub Actions.

Maintenance Troubleshooting

• Apply patches and updates across Azure SQL and SQL Server infrastructure.
• Troubleshoot connectivity| performance| or configuration issues.
• Analyze logs| alerts| and capacity trends to ensure optimal database health.

Nice to have

• Proficiency in writing software in one or more languages - such as Java| Node| Python| .NET.
• Exposure to microservices.
• Experience in scripting language such as groovy| Python| shell.
• Grounding in DevOps principles| test-driven development| continuous integration| and continuous delivery.
• Experience in Microsoft Azure and AKS or other similar cloud technologies.
• Experience automating infrastructure provisioning with tools such as Terraform| Chef| and HELM charts.
• Experience with Jenkin| Artifactory| SonarCube.
• Familiarity with package management tools such as npm| pip.
• Familiarity with build processes and build tools such as maven| gradle.
• Familiarity with standard IT security practices.
• Familiarity with database technologies in cloud such as Azure SQL| Cosmos/Mongo.
• Job Type: Fixed term contract

Pay: $45.00-$48.00 per hour

Work Location: Hybrid remote in Toronto, ON (Toronto District)