SQL Server & Data Warehouse Consultant

About Us

Our mission is to dominate the betting and gaming industry on a global scale and we need the very best Tech Talent to help us achieve this. With our proprietary platform powering everything we do, its an exciting time to join us. We're pioneering new products and driving more advanced, creative technologies. The result? Unrivalled experiences for millions of customers worldwide.

We are seeking an experienced SQL Server Performance & Data Warehouse Consultant to join the Data Platform team on an initial three-month contract to lead a comprehensive performance, capacity and storage optimisation programme for a large-scale, on-premises Microsoft SQL Server estate, the main focus will be an 80 TB SQL Server 2022 Data Warehouse platform.

Working closely with the Data Engineering team, the successful consultant will undertake a comprehensive technical assessment of the existing platforms, identify performance, storage and capacity constraints, determine their root causes, and implement agreed improvements that deliver measurable gains in performance, scalability, operational resilience and long-term maintainability.

The successful consultant will be expected to investigate performance holistically across the entire technology stack, recognising that enterprise database performance challenges frequently originate outside of the SQL Server engine. This includes the operating system, virtualisation platform, compute, storage, SAN, networking and associated infrastructure, requiring the ability to identify and resolve bottlenecks wherever they exist.

The engagement will conclude with a prioritised remediation roadmap, comprehensive technical documentation and knowledge transfer to enable the Data Engineering team to confidently support and evolve the SQL Server estate.

The Microsoft SQL Server estate supports several business-critical platforms, including an 80 TB SQL Server 2022 Data Warehouse. Continued growth in data volumes and workload complexity has introduced performance, storage and capacity challenges that now require specialist investigation and remediation.

Current challenges include

• Database and transaction log files that are inefficiently sized and configured
• Limited available storage capacity constraining maintenance operations and future growth
• Database shrink operations causing fragmentation, blocking and unnecessary performance overhead
• Inefficient indexing strategies and statistics maintenance affecting query performance
• Increasing maintenance windows and operational overhead as the platform continues to grow
• Opportunities to better leverage SQL Server 2022 performance capabilities and modern data warehouse optimisation techniques
• Potential infrastructure constraints within the compute, storage and network layers impacting overall database performance

Review database architecture, storage configuration, filegroup design and maintenance strategies

Analyse workload characteristics to identify performance, storage and capacity constraints

Develop and implement sustainable strategies for database growth, storage optimisation and capacity management

Optimise query performance through execution plan analysis, indexing strategies, statistics management and workload tuning

Diagnose complex SQL Server performance issues including parameter sensitivity, cardinality estimation, blocking, deadlocking, concurrency, memory grants, TempDB contention, parallelism and execution plan instability

Assess opportunities to leverage SQL Server 2022 capabilities including Query Store, Intelligent Query Processing, Query Store Hints, Parameter Sensitive Plan optimisation, partitioning, compression and column store indexing where appropriate

Produce a prioritised remediation roadmap balancing technical benefit, operational risk and long-term maintainability

Produce comprehensive technical documentation, operational recommendations and knowledge transfer for the Data Engineering team.

• Extensive experience administering and optimising large-scale (multi-terabyte) Microsoft SQL Server Enterprise environments across multiple SQL…