SQL DBA

Job Title:

SQL DBA |

Location:

Leeds, UK | Job Type: FTC (6 Months)

We are seeking an experienced SQL DBA with strong expertise in Microsoft SQL Server and Azure cloud services
, including CI/CD pipeline implementation using Azure Dev Ops
, Visual Studio and Octopus Deploy
. The successful candidate will be responsible for database administration, performance optimization, automation, and supporting Dev Ops practices to ensure secure, highly available, scalable database environments.

• Install, configure, upgrade, and maintain Microsoft SQL Server (On‑Prem & Azure) through Azure Pipelines (Azure Dev Ops and Octopus Deploy)
• AUTOMATE backup, restore, disaster recovery and high availability (Always On, Failover Groups, Log Shipping)
• Monitor database health, capacity and performance

• Identify and resolve performance bottlenecks using execution plans, indexing strategies and query tuning
• Optimize database schemas, stored procedures and SQL queries
• Implement proactive monitoring and alerting

• Manage databases using Azure Portal
  , Azure Monitor
  , Log Analytics and Azure Advisor
• Ensure security best practices using Azure AD authentication,
  TDE
  , Key Vault and firewall rules
• Support scalability, cost optimization and resource governance in Azure

• Design and maintain CI/CD pipelines for database deployments using:
  • Azure Dev Ops Pipelines / Git Hub Actions
  • Octopus Deploy
  • DBA Tools
  • Power Shell
  • T‑SQL
• Automate schema changes, version control and deployment approvals
• Work closely with development teams to enable Database Dev Ops (DBOps)
• Implement AUTOMATIC rollback, validation and release strategies for database changes

• Manage user access, roles and permissions
• Implement auditing, encryption and compliance standards
• Support vulnerability assessments and security reviews

• Partner with application, infrastructure and Dev Ops teams
• Provide L3 support for production issues and root‑cause analysis
• Create and maintain documentation, runbooks and SOPs

• Strong experience with Microsoft SQL Server (2016+)
• Hands‑on experience with Azure SQL services
• Strong knowledge of:
  • T‑SQL
  • Backup & Recovery
  • HA/DR solutions (Always On Availability Groups, Log Shipping)
  • Indexing & performance tuning
• Strong experience with CI/CD tools (Azure Dev Ops and Octopus Deploy)
• Scripting skills:
  Power Shell and T‑SQL
• Experience with version control systems (Git)

• Azure SQL Database / Managed Instance
• Azure Monitor & Log Analytics
• Azure Key Vault & Security features
• ARM/Bicep or Terraform (good to have)

• Azure certifications (e.g., AZ‑104, DP‑300)
• Knowledge of Infrastructure as Code
• Exposure to Agile/Scrum environments