SQL Server DBA - Manchester - £40-50K

SQL Server DBA - Manchester £40-50K.

Our growing client based in Manchester is currently looking for an experienced SQL Server database administrator (DBA).

Unlike other companies you will not be a tiny cog in a corporate machine, but a key part of the business and instrumental in its growth.

Main activities:

, Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO)
, Test backups to ensure we can meet the business' Recovery Time Objectives (RTO)
, Monitor database servers to ensure overall resilience and integrity
, Maintain transactional replication
, Ongoing index maintenance and tuning
, Monitor application stored procedures to proactively identify performance issues and tune these issue where necessary
, Provide SQL coding/database design advice to the development team
, Troubleshoot SQL Server service outages as they occur
, As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
, Install and configure new SQL Servers
, Review all SQL code from the development team
, Deploy database change scripts provided by internal Development team
, When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
, Document the company's database environment

In delivering these responsibilities, your focus will be to:

, Have immediate responsibility for all live database servers
, Be the first point of contact for database related errors
, Drive technical excellence into all SQL coding
, Provide visibility to senior management on server performance and possible improvements

, Minimum 1 year troubleshooting experience on a production SQL Server.
, Strong T-SQL coding experience
, Experience in installation and patching of SQL Server 2008/2012
, Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
, Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
, Ability to detect and troubleshoot SQL Server related CPU,memory,I/O, disk space and other resource contention.
, Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
, Expert experience in implementing operational automation.
, Strong knowledge of how indexes, index management, integrity checks, configuration, patching.

How statistics work, how indexes are stored, how they can be created and managed effectively.
, Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
, SQL Development - ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
, Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
, SQL Database Operational support to tech users

, Knowledge of Powershell scripting to assist in SQL maintenance tasks
, Experience in producing SSRS reports
, Experience of working with Agile development methodologies;
, Acquaintance with windows server, security delegation, SPNs, storage components.

SQL Server DBA - Manchester £40-50K.

If you are interested in this position, please send your CV in word format to daniel.hargreaves@adriasolutions.co.uk or call 01625 874399 for more information.

SQL Server DBA - Manchester £40-50K.

Share Job