SQL Server DBA

Job description

A fantastic new opportunity has become available SQL Server DBA with one of our Financial One of the world's leading financial institutions, serving individuals, small- and middle-market businesses, large corporations, and governments with a full range of banking, investment management and other financial and risk management products and services based in Camberley

Role : SQL Server DBA

Location : Camberley (3 days a week onsite)

Duration : 12 Months

Status : Inside IR35

Hours: 35-40/hours (Week)

Rate: Circa 550/Day

Implements data models and database designs, data access and table maintenance codes.

Experience and Skills required :

·  SQL Server Instance/Database Upgrade and Migration

·  Clustering, Database Mirroring, Log Shipping, AlwaysOn Replication (Implementation / Design / Support).

·  Working knowledge of PowerShell Scripting

·  Database Performance Tuning, Optimisation Diagnostics (using SQL Profiler/Server-side trace profiler, Extended Events, Database Engine Tuning Advisor, Execution Plan and Performance Monitor)

·  Should be able to write T-SQL code (Views, Functions, Stored Procedures Triggers) - Development and Optimisation

·  SQL Server Integrated Service (SSIS) or DTS -Administration

·  SQL Server Reporting Services (SSRS) -Administration

·  SQL Server Analysis Services (SSAS) -Administration

·  Backup Recovery, Index Design and Analysis

·  Experience of managing large databases

·  Monitor system's health and performance to ensure high levels of performance, availability, sustainability and security.

·  Should be able to work in focussed environment with applications sensitive to quick response to issues

·  Familiar with ITIL - Service Management (Change, Release, Problem and Incident Management)

·  Familiar with Windows Operating System Administration (Windows 2014)

Responsibilities:

·  Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database.

·  Implements data models and database designs, data access and table maintenance codes.

·  resolves database performance issues, database capacity issues, replication, and other distributed data issues.

·  Familiar with standard concepts, practices, and procedures within a particular field.

Candidates will ideally show evidence of the above in their CV to be considered.

Please be advised if you haven't heard from us within 48 hours then unfortunately your application has not been successful on this occasion, we may however keep your details on file for any suitable future vacancies and contact you accordingly.

Pontoon is an employment consultancy. We put expertise, energy, and enthusiasm into improving everyone's chance of being part of the workplace. We respect and appreciate people of all ethnicities, generations, religious beliefs, sexual orientations, gender identities,and more. We do this by showcasing their talents, skills, and unique experience in an inclusive environment that helps them thrive.