Senior SQL DBA - High Availability - SQL Performance Tuning
- Posted 02 July 2021
- Salary £75000.00 - £85000.00 per annum + plus excellent package
- LocationSurrey
- Job type Permanent
- ReferenceBBBH119772_1625232168
Job description
My client is currently looking for a MS SQL DBA.
The MS SQL DBA will need advanced hands on expertise in all aspect of MS SQL database administration, solve complex database related issues and lead in allocated implementation projects. To ensure operational stability of SQL Server and Oracle database environments located in private and public datacentres.
Technical Knowledge and Understanding
Advanced knowledge of all High Availability (HA) and Disaster Recovery (DR) options for MS SQL Server including Always On and clustering and options in Azure.
Advanced knowledge of SQL internals, indexes, index management, statistics and related tools and kits for performance troubleshooting.
Advanced knowledge of T-SQL demonstrated in deployments of advanced scripts, database and SSIS/SSAS objects changes
Knowledge of Oracle Backup and Recovery strategies, performing upgrades/migrations (12 or above).
Experience with enterprise level ticketing system such as Service Now.
Familiarity with GDPR regulatory/Data Security requirements.
Preferred but not essential:
Knowledge of Performance Tuning and Optimization of scripts/jobs running on Oracle
Familiar with TFS/Git for change control.
Experience with server monitoring tools such as Solarwinds or Azure Insights.
Experience
Bachelor's Degree in IT or related technical degree.
10+ years of working as a productive member of Database Support team supporting MS SQL on-premise and in Azure.
2 to 3 years of recent experience supporting Oracle databases.
Advanced hands on skills in performance monitoring and tuning of under performing OLTP/OLAP databases.
Advanced experience in automating data movement through backups, restores and other techniques.
Advanced scripting skills in PowerShell and MS-DOS applied to SQL automation and general data collection and parsing.
Advanced experience in configuring and performance support of SSRS, SSIS and SSAS. Experience in designing SSRS and SSIS deliverables.
Advanced experience of working with Windows Server, including Active Directory and disk configurations.
High proficiency in documenting practical 'how-to's as well as complex database configuration documentations.
Proven track of working within SLAs within ITIL Framework following change control best practices.
Key Accountabilities / Deliverables
Administration of MS SQL servers, SSIS, SSAS and SSRS from MS SQL Server versions 2008 to 2019 as well as Azure SQL Managed instance in MS Azure environment.
Administration of Oracle (12 or above) databases preferably on an IaaS setup.
Provides advanced expertise in support of all high-level technologies: AlwaysOn Availability Groups, Cluster, SQL Replication, Database Mirroring and Log Shipping.
Designs and implements advanced PowerShell scripts in automation of SQL and general server operations.
Demonstrates advanced level of performance tuning skills on OLTP/OLAP MS SQL on server and database level.
Provides automation solutions for data movement including database environment refreshes and rollouts of solutions.
Identifies critical areas in database administration in the database estate and provides proposals for improved database maintenance for reviews.
Regularly reviews monitoring of database/server maintenance jobs and alerts providing proposals for improvements in native SQL efficiencies.
Flexible in responding to database escalations and works with technical teams to come up with strategic solutions to recurring problems.
Owning, tracking and resolving database related incidents and requests within SLAs.
Participates in Disaster Recovery planning, processes, procedures, testing and execution for MS SQL.
Participates in upgrades, patching, backups/restore, monitoring, access control, change control, and audits on Oracle servers and databases.
Demonstrates ability to work on multiple BAU operational activities and projects simultaneously, prioritises as required and works to a very high standard.
Liaises with other IT Operations team members and suppliers to ensure support and operational activities can be carried out and handed over across geographically dispersed staff.
Carries out technical reviews and assists DBA manager in providing oversight to the work done by vendor/internal staff.
Ensures IT operational documentation, build documents, processes and procedures are completed and maintained to a high standard following database best practice.
Ensures IT standards, audit and compliance requirements and controls are understood and adhered to.
In addition to the above key responsibilities, you may be required to undertake other duties from time to time as the Company may reasonably require.
Due to the geographically dispersed nature of the company and IT teams it may require a degree of out of hours working including attending team meetings and interactive with other IT team members.
