Morson Edge (Technology)
Data Warehouse Consultant
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
SQL Server Performance & Data Warehouse Consultant (Contract)
Cheshire based - 2 days onsite / 3 days WFH
£Market rates
Duration - 3 months + extensions
An established technology-driven organisation is seeking an experienced SQL Server Performance & Data Warehouse Consultant for an initial 3-month contract to optimise a large-scale, on-premises Microsoft SQL Server environment.
The successful consultant will lead a comprehensive review of a multi-terabyte SQL Server 2022 data warehouse platform, identifying and resolving performance, storage and capacity issues. Working closely with the Data Engineering team, you will assess the existing environment, implement performance improvements, and produce a prioritised roadmap for ongoing optimisation and scalability.
This role requires a holistic approach to performance tuning, investigating not only SQL Server but also the wider infrastructure including operating systems, virtualisation, compute, storage, networking and SAN technologies.
Key Responsibilities
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.
- Assess SQL Server architecture, storage configuration and maintenance strategies.
- Analyse workloads to identify performance, storage and capacity bottlenecks.
- Optimise query performance through indexing, execution plan analysis and statistics management.
- Troubleshoot complex SQL Server issues including blocking, deadlocks, TempDB contention, parallelism and memory management.
- Leverage SQL Server 2022 features such as Query Store, Intelligent Query Processing, partitioning, compression and columnstore indexing.
- Develop sustainable strategies for database growth, storage optimisation and capacity planning.
- Produce technical documentation, a prioritised remediation roadmap and deliver knowledge transfer to internal teams.
Essential Skills & Experience
- Extensive experience managing and optimising large-scale Microsoft SQL Server Enterprise environments.
- Expert knowledge of SQL Server internals, storage architecture and query optimisation.
- Strong experience diagnosing production performance issues using Query Store, DMVs, Extended Events and performance monitoring tools.
- Expertise in workload tuning, indexing strategies, statistics management and enterprise data warehouse optimisation.
- Proven ability to deliver complex SQL Server performance improvement programmes.
- Excellent communication, documentation and stakeholder engagement skills.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Desirable Experience
- ETL and enterprise reporting platform optimisation.
- Experience within Data Platform, Business Intelligence or Analytics teams.
- Previous consultancy or specialist technical delivery experience.
Expected Outcomes
By the end of the engagement, the consultant will have:
- Completed a full technical assessment of the SQL Server estate.
- Delivered measurable improvements to performance, scalability and storage efficiency.
- Produced a prioritised remediation roadmap and comprehensive technical documentation.
- Transferred knowledge to the internal Data Engineering team to support future optimisation and maintenance.
“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