SQL Server DBA - SQL 2003/2008 - London

Nexere Consulting Limited
United Kingdom
12 Nov 2017
18 Nov 2017
Contract Type
Full Time
SQL Server DBA - SQL 2003/2008 - London Purpose of role The role of the SQL Server DBA is to contribute to the administration and maintenance of the overall SQL Server Production, DR and Non-Production Architecture and also to provide technical guide for the ongoing development of SQL Server environments. Essential Technical Experience: Strong experience in Database Administration in SQL Server (5+ years). Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log 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 identify 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 and High Availability strategies for MS SQL environments. Experience in implementing operational solutions with SQL Server 2003/2008 onwards. SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints). SQL Development- experience in creating database architecture with associated schema as part of a software design process. Strong knowledge of how indexes, index management, integrity checks, configuration, patching. Familiarity with windows server, security delegation, SPNs, storage components. Ability to network with documentation and testing teams to accomplish creation of processes and procedures. SQL Server DBA - SQL 2003/2008 - London - provided by Dice CLUSTERING, REPLICATION, SQL, SQL SERVER, WINDOWS, WINDOWS SERVER