Senior SQL DBA

Senior SQL DBA

The SQL DBA will provide full lifecycle production assistance to development, infrastructure, testing and ultimately production. The SQL DBA will be managing and maintaining the SQL Server database environments across IaaS and PaaS platforms, ensure development and testing database environments are kept up to date, work on performance tuning and enhancements, troubleshooting, maintenance, health checks and investigations of production system problems, carrying out peer review and enforcing coding standards whilst being conversant in the automation approach associated in a DevOps environment. The SQL DBA will also be required to provide support and assistance to the wider Data Services team across alternate database technologies to support the day to day operation through BAU activities, ensuring data integrity is maintained and the best possible service available to support business processes, including the provision of out of hours on call.

Overview

The SQL DBA will provide full lifecycle production assistance to development, infrastructure, testing and ultimately production. The SQL DBA will be managing and maintaining the SQL Server database environments across IaaS and PaaS platforms, ensure development and testing database environments are kept up to date, work on performance tuning and enhancements, troubleshooting, maintenance, health checks and investigations of production system problems, carrying out peer review and enforcing coding standards whilst being conversant in the automation approach associated in a DevOps environment.

The SQL DBA will also be required to provide support and assistance to the wider Data Services team across alternate database technologies to support the day to day operation through BAU activities, ensuring data integrity is maintained and the best possible service available to support business processes, including the provision of out of hours on call.

Key Accountabilities and Main Responsibilities

Accountable:

For the operational support and continuous improvement of the SQL estate, processes for Development and Test environments (System, Load, Performance, UAT) up to, and including Production;

Automation, process efficiency and appropriate tooling (Code/Branch Management and Deployment/Configurations) is utilised to reduce cycle times, and improve reliability, audit and traceability for all system deployments across multiple applications;

Process, best practice and database build standards are consistently applied and constantly improved upon;

Database health checks, backups and implementation of DBA best practise.

Responsible:

Development and merging process/methodology is correctly defined and applied to software and systems to minimise risk in Production environments caused by poor code management techniques/skills;

Provide strong governance for the management, and access, of live data in environments where required (Client Data Take Up) and to ensure obfuscation technologies/practice is embedded;

Ensuring that, working with DevOps, the Development Team has the right environment to maximise their efficacy and obstacles are removed and automation introduced where appropriate;

Production environments are protected by governance, good practice/process, design and fit for purpose environments, to the left of Pre-Prod, supporting all project and change activity;

Ensuring project and change release(s) are packaged to the right quality, repeatable between environments without change or modification and deployed to the target environments - ultimately to Production without detriment or issue in agreed timescales;

Weak points in Process, Technology and Service is addressed through a culture of continual improvement;

Software and processes are correctly documented to ensure single points of knowledge do not become a problem and skills are distributed across the team and department;

Ensuring that software Deliverables/Artefacts, as part of any Change/Project, are progressed providing appropriate status reporting and updates as requested by the Line/Project/Change Manager;

Experience & Personal Attributes:

Demonstrable knowledge of database administration (design, installation & troubleshooting) of current MS SQL Server and Windows Server Enterprise platforms

Comprehensive knowledge and experience of Current Microsoft SQL Server versions, IaaS and PaaS

Proven knowledge and experience of Database Mirroring, Log Shipping, Clustering, Availability Groups, Transactional Replication, ETL

Desirable:

Database performance and optimisation experience

Experience working with automation deployment tools.

Ability to develop and implement data security guidelines while making data available to those authorised to have access

Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies

Ability to database design, implementation and performance tune

Experience in automated testing of all database releases

Experience in support for all database releases.

Experience of supporting large scale critical production databases.

Competencies

Innovation, change and continuous improvement

Communication

Results focused

Technical awareness

Commercial awareness

Desirable

Leadership and performance

Customer service

Team working

Risk and conduct management