Job Description
Role Descriptions : Database AdministrationInstall| 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 MonitoringPerform query optimization| index tuning| and resolving deadlocks or performance bottlenecks.Monitor SQL workloads usingAzure MonitorAzure SQL InsightsLog AnalyticsQuery StoreSecurity ComplianceImplement 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 RecoveryConfigure and maintain Azure SQL failover groups| availability zones| and georeplication.Validate disaster recovery plans and conduct failover tests.Automation DevOpsAutomate administrative tasks usingPowerShellAzure CLIAzure Automation RunbooksTerraform or ARMBicep templatesSupport CICD pipelines for database releases using Azure DevOps or GitHub Actions.Maintenance TroubleshootingApply 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.
Essential Skills : 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.
Desirable Skills : 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.
Keyword : ~Data Engineer~
Skills : Digital : Microsoft Azure~Agile Way of Working
Experience Required : 4-6
Azure SQL Database Administrator • Toronto, ON, ca