Location: Camberley (3 days a week onsite)
Duration: 12 Months
Status: Inside IR35
Hours: 35-40 hours per week
Job Description:
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)
* Ability to write T-SQL code (Views, Functions, Stored Procedures, Triggers) - Development and Optimisation
* SQL Server Integrated Services (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
* Ability to work in a focused 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
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 that 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.
To speak to a recruitment expert, please contact us.
#J-18808-Ljbffr