At a Glance
- Tasks: Manage and optimise SQL databases while collaborating with DevOps teams.
- Company: Dynamic tech company in Leeds, focused on innovation and collaboration.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Exciting role with potential for career advancement in a supportive environment.
- Why this job: Join a forward-thinking team and enhance your skills in cloud technologies.
- Qualifications: Experience with Microsoft SQL Server and Azure services is essential.
The predicted salary is between 45000 - 55000 £ per year.
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 DevOps, Visual Studio and Octopus Deploy. The successful candidate will be responsible for database administration, performance optimization, automation, and supporting DevOps practices to ensure secure, highly available, and scalable database environments.
Key Responsibilities
- Database Administration
- Install, configure, upgrade, and maintain Microsoft SQL Server (On‑Prem & Azure) through Azure Pipelines (Azure DevOps and Octopus Deploy).
- Automate backup, restore, disaster recovery, and high availability (Always On, Failover Groups, Log Shipping).
- Monitor database health, capacity, and performance.
- Performance & Optimization
- 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.
- Azure & Cloud Responsibilities
- 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.
- CI/CD & DevOps Integration
- Design and maintain CI/CD pipelines for database deployments using Azure DevOps Pipelines / GitHub Actions and Octopus Deploy.
- Automate schema changes, version control, and deployment approvals.
- Work closely with development teams to enable Database DevOps (DBOps).
- Implement automatic rollback, validation, and release strategies for database changes.
- Security & Compliance
- Manage user access, roles, and permissions.
- Implement auditing, encryption, and compliance standards.
- Support vulnerability assessments and security reviews.
- Collaboration & Support
- Partner with application, infrastructure, and DevOps teams.
- Provide L3 support for production issues and root‑cause analysis.
- Create and maintain documentation, runbooks, and SOPs.
Essentials Skills & Qualifications
- Technical Skills
- 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 DevOps and Octopus Deploy).
- Scripting skills: PowerShell and T-SQL.
- Experience with version control systems (Git).
- Azure Skills
- Azure SQL Database / Managed Instance.
- Azure Monitor & Log Analytics.
- Azure Key Vault & Security features.
- ARM/Bicep or Terraform (good to have).
- Preferred Qualifications
- Azure certifications (e.g., AZ‑104, DP‑300).
- Knowledge of Infrastructure as Code.
- Exposure to Agile/Scrum environments.
SQL Database Administrator in Bradford employer: Stratacent
Join our dynamic team in Leeds as a SQL Database Administrator, where we prioritise innovation and collaboration in a supportive work environment. We offer competitive benefits, opportunities for professional growth, and a culture that values continuous learning and development, making it an ideal place for those looking to advance their careers in database management and cloud technologies.
StudySmarter Expert Advice🤫
We think this is how you could land SQL Database Administrator in Bradford
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and join online forums. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your SQL projects, automation scripts, and any CI/CD pipelines you've built. This gives potential employers a tangible look at what you can do.
✨Tip Number 3
Prepare for interviews by brushing up on common SQL DBA questions and scenarios. Practice explaining your past experiences with performance tuning and Azure services clearly and confidently.
✨Tip Number 4
Don't forget to apply through our website! We love seeing candidates who are proactive and engaged. Plus, it makes it easier for us to keep track of your application and get back to you quickly.
We think you need these skills to ace SQL Database Administrator in Bradford
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with Microsoft SQL Server and Azure cloud services. We want to see how your skills match the job description, so don’t be shy about showcasing your relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for the SQL DBA role. We love seeing enthusiasm and a bit of personality, so let us know what excites you about working with us.
Showcase Your Technical Skills:Be specific about your technical expertise in T-SQL, CI/CD tools, and Azure services. We’re looking for someone who can hit the ground running, so highlight any relevant certifications or projects that demonstrate your capabilities.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy – just follow the prompts!
How to prepare for a job interview at Stratacent
✨Know Your SQL Inside Out
Make sure you brush up on your Microsoft SQL Server knowledge, especially the features from 2016 onwards. Be ready to discuss your experience with performance tuning, indexing strategies, and how you've tackled bottlenecks in the past.
✨Show Off Your Azure Skills
Since this role involves Azure cloud services, be prepared to talk about your hands-on experience with Azure SQL Database and Managed Instances. Highlight any projects where you've implemented CI/CD pipelines using Azure DevOps and Octopus Deploy.
✨Demonstrate Automation Know-How
Automation is key for this position, so come equipped with examples of how you've automated backup, restore, and disaster recovery processes. Discuss your experience with scripting in PowerShell and T-SQL to show your technical prowess.
✨Collaboration is Key
This role requires working closely with various teams, so be ready to share examples of how you've partnered with development and DevOps teams in the past. Emphasise your communication skills and how you’ve contributed to a collaborative environment.
