Greg White

An accomplished Microsoft SQL Server Database Administrator with nine years of experience gained delivering first-class database estates for the commercial and public sector. Specialising in database performance and troubleshooting not just a bog standard DBA! Understanding of SQL server internals and passionate about learning, technical author for redgate.

SQL Server Senior Database Administrator - Saga

(2022-03)

Responsible for architecting new SQL Servers support escalation and performance troubleshooting. Training team members and developers on relational database design principals and overseeing performance improvements.

• Leading large migrations to latest versions of sql server 30+ Instances
• Decommission and consolidation resulting in £800K licence savings.
• Architecting databases for performance reduced customer search from 4 seconds down to 2ms.
• Regular speaker delivering internal workshops on database performance.
• Deployed TDE using azure key vault across sensitive databases on premise
• Support Azure SQL databases
• Designing databases and tables structures for high performance and concurrency on the 7Tb customer hub database with high throughput. Every millisecond counts.
• Agreeing design principals and standards and buddy checking developers code and deployments into production

Database Dev Ops Engineer - Saga

(2021-11 - 2022-03)

Responsible for performance on the business critical customer hub database. The database was underperforming when I started and was on an unsupported sql server version. Fast track promotion to Senior DBA.

• Coordinated migration to SQL 2019 with minimal downtime
• Supported a number of performance fixes to improve stored procedure runtime including code refactors, using tempdb and filtered indexes
• Rolled out compression to save 300Gb of disk space
• Wrote a script to automate patches to always on availability group cluster using powershell (DBA Tools)

Senior Database Administrator - Integrated Care 24 (NHS)

(2015-10 - 2021-10)

Responsible for leading a team of DBAs to keep the missions critical sql server databases running 24/7/365 to support NHS 111 services. Capacity planning/monitoring and proactively validating database restores.

• Designed and built new physical sql servers using always on availability groups improved performance x 10 which improved patient outcomes.
• Migrated to new cluster with minimal downtime
• Automated restores and running consistency checks
• Supported large 15tb databases
• Developed and Built Realtime ETL using service broker

Database Administrator - Integrated Care 24 (NHS)

(2014-10 - 2015-10)

first full-time DBAs within IC24 my responsibility was to provide a stable database platform so the company could build a new system to improve patient care.

• the infrastructure needed a complete review and patching cycle
• Stabilize performance and stop blue screen of death on server
• Prevent inadvertent failovers
• Supported the BI team to write performance code to reduce CPU pressure on the server

Data Warehouse Consultant - Cabot Financial

(2013-06 - 2014-10)

Responsible for maintaining the group data warehouse and related data-flow processes built on SQL 2008R2 Enterprise using SSIS. These processes are built to support many data-flow-based tasks including the population of the key strategic data repositories for reporting and the business strategy process – this includes the data-mart used by the SAS Marketing Automation systems (IDM).

• Improve data warehouse ETL Load times
• Created full ETL mapping document

Diploma of Higher Education - Computing Studies - Canterbury Christ Church University College (2003)