Lorien
SQL Server Performance & Data Warehouse Consultant
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
SQL Server Warehouse Consultant (Contract)
3-Month Initial Contract
Pay up to £595/day
Hybrid - Manchester Area
Outside IR35
The Role
We're looking for a SQL Server Performance & Data Warehouse Consultant to lead a critical optimisation programme across a large-scale Microsoft SQL Server estate.
This is a hands-on consultancy engagement focused on identifying and resolving performance, storage, and scalability challenges within an enterprise data platform. The headline environment is an 80TB SQL Server 2022 Data Warehouse, and we're looking for someone who can quickly assess the landscape, identify root causes, implement improvements, and leave the team with a clear roadmap for the future.
This isn't a role for someone who only looks at SQL Server in isolation. You'll be expected to investigate performance across the entire stack, including infrastructure, storage, virtualisation, networking, and operating systems, ensuring bottlenecks are identified wherever they exist.
The Opportunity
The platform continues to grow rapidly, bringing new challenges around performance, storage consumption, maintenance windows, and operational efficiency. The team needs a consultant who can bring structure, expertise, and pragmatic recommendations that deliver measurable improvements.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
You'll take ownership of a full technical assessment, implement agreed optimisation initiatives, and produce a prioritised remediation roadmap that supports long-term platform growth and scalability.
What You'll Be Doing
- Reviewing database architecture, filegroup design, storage configuration, and maintenance strategies
- Analysing workload characteristics to identify performance, capacity, and storage bottlenecks
- Optimising query performance through execution plan analysis, indexing, statistics management, and workload tuning
- Diagnosing complex SQL Server issues including blocking, deadlocking, parameter sensitivity, TempDB contention, memory grants, parallelism, and execution plan instability
- Leveraging modern SQL Server 2022 capabilities including Query Store, Intelligent Query Processing, Parameter Sensitive Plan Optimisation, partitioning, compression, and columnstore technologies
- Producing a prioritised remediation roadmap balancing risk, effort, and technical value
- Delivering documentation and knowledge transfer to ensure the internal team can continue the optimisation journey
What We're Looking For
- Extensive experience supporting and optimising large-scale, multi-terabyte SQL Server environments
- Deep expertise in SQL Server performance tuning, query optimisation, indexing, and statistics management
- Strong understanding of SQL Server internals, storage architecture, transaction logs, and capacity planning
- Proven experience using Query Store, DMVs, Extended Events, wait statistics, and performance baselining techniques
- Experience optimising data warehouse environments, including partitioning, compression, and columnstore strategies
- A consultant mindset with the ability to assess, recommend, implement, and communicate effectively with both technical and leadership stakeholders
Get help with your application
Your very own career expert that helps elevate your application to the next level.
What Success Looks Like
By the end of the engagement, you'll have delivered a comprehensive technical assessment, implemented key performance improvements, created a prioritised optimisation roadmap, and equipped the Data Engineering team with the knowledge and documentation needed to support future growth.
If you're an experienced SQL Server specialist who enjoys solving complex performance challenges at enterprise scale, we'd love to hear from you.
Guidant, Carbon60, Lorien & SRG - The Impellam Group Portfolio are acting as an Employment Business in relation to this vacancy.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills