Database Administrator (SQL Server)

• Administer, maintain, develop, and implement policies and procedures for database security and integrity
• Design and implement data models, database designs, and table maintenance codes
• Resolve database performance, capacity, replication, and distributed data issues
• Manage SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS) effectively
• Implement high availability and disaster recovery solutions using clustering, database mirroring, log shipping, and AlwaysOn replication
• Perform database performance tuning and diagnostics using SQL Profiler, Extended Events, and Database Engine Tuning Advisor
• Write and optimise T-SQL code, including views, functions, stored procedures, and triggers
• Handle backup recovery, index design, and analysis
• Upgrade and migrate SQL Server instances/databases as needed
• Monitor system health and performance, ensuring high levels of availability and security
• Analyse, troubleshoot, and correct database issues in real-time
• Collaborate with developers for query tuning and schema refinement
• Document changes and automate regular processes for efficiency
• Work in a controlled access environment, adhering to industry baselines
• Familiarity with ITIL service management processes (Change, Release, Problem, and Incident Management) is a plus
• Engage with various teams and stakeholders, showcasing strong communication skills

Technologies:

• ITIL
• PowerShell
• SQL
• Security
• SSAS
• SSIS
• Windows
• Support, We are a dynamic organization seeking an experienced SQL Database Administrator to join our team for a 12-month contract. This hybrid role allows for work in Chester 3 days a week and remote work 2 days a week, offering flexibility while maintaining a focus on the security, integrity, and performance of our database systems. We are committed to building a supportive and inclusive environment for all candidates.

• 10 years of relevant industry experience as a SQL DBA
• Proficient in PowerShell scripting and Windows Operating System Administration (Windows 2014+)
• Familiarity with BMC Remedy IT Service Management and different storage systems
• Proven ability to manage large databases effectively
• Excellent team player with the ability to work in a focused environment, responsive to urgent issues