Responsibilities
- Administer and support 80+ SQL Server instances (2017–2022) across standalone, multi-instance, and clustered environments.
- Manage and optimise Azure SQL, Cosmos DB, and related services such as Azure Databricks and Power BI Reporting Services.
- Support and maintain SSRS, SSAS, and SSIS across hybrid environments.
- Participate in the migration of databases and data services to an Azure Landing Zone (ALZ)-aligned architecture.
- Implement private endpoints, network security groups, and role-based access controls (RBAC) in line with Microsoft security best practices.
- Develop and manage automation using PowerShell, Azure Runbooks, and integrate with Azure DevOps YAML pipelines.
- Maintain source-controlled scripts and infrastructure in Azure Repos.
- Use Terraform to provision and manage database-related infrastructure and cloud services (IaC).
- Build and maintain custom monitoring and alerting for both on-prem and Azure environments.
- Integrate with observability tools such as Azure Monitor, Log Analytics, and custom dashboards.
- Write and optimise Kusto Query Language (KQL) queries for diagnostics and analytics.
- Provide expert-level performance tuning, query optimisation, and incident troubleshooting.
- Lead SQL Server upgrades, migrations, and implementation of disaster recovery (DR) and high availability (HA) solutions.
- Conduct annual disaster recovery testing across platforms.
- Perform incident investigation, root cause analysis, and long-term remediation.
- Mentor junior DBAs and act as a subject matter expert on modern database practices.
- Participate in the on-call rota and support critical incidents and maintenance activities.
Requirements
- Strong experience with SQL Server 2017–2022 in enterprise environments.
- Expertise in HA/DR: Always On Availability Groups, replication, clustering.
- Experience managing Azure SQL, Cosmos DB, and Azure-based data services.
- Practical knowledge of Azure Landing Zone (ALZ) implementations, private networking, and cloud security.
- Advanced proficiency in T-SQL for complex database development and troubleshooting.
- Strong scripting and automation experience using PowerShell.
- Proficiency in Terraform for infrastructure provisioning and database-related IaC.
- Hands-on experience with Azure DevOps, Git, YAML pipelines, and CI/CD for database deployments.
- Experience writing Kusto queries (KQL) for Azure Monitor, Log Analytics, or diagnostics.
- Strong experience supporting SSRS, SSAS, and SSIS in hybrid environments.
- Ability to design and manage scalable monitoring solutions for both cloud and on-prem workloads.
- Demonstrated strength in problem-solving, root cause analysis, and cross-system diagnostics.
Nice to Have
- Microsoft certifications such as DP-300, AZ-104, AZ-305, or equivalent.
- Experience with Azure Databricks, Data Factory, or other analytics services.
- Familiarity with ARM templates, Bicep, or other IaC alternatives.
- Experience working in regulated or security-sensitive environments.
Work Arrangement
Hybrid
Additional Information
- Modern Office Environment – Located in central London, close to public transport links.
