SQL Server Performance & Data Warehouse Consultant
GBP 175K-175K Senior-level Full Time
Tasks
- Assess SQL Server estate performance
- Create technical documentation and knowledge transfer
- Develop remediation roadmap
- Diagnose root causes across SQL Server and infrastructure
- Identify storage capacity and performance constraints
- Implement query optimization using Query Store and Query Store Hints
- Improve indexing and statistics management
- Investigate blocking deadlocking concurrency and isolation levels
- Leverage SQL Server 2022 performance features
- Optimize TempDB and parallelism
- Optimize database storage configuration
- Tune query performance using execution plan analysis
Perks/Benefits
- N/A
Skills/Tech-stack
Autogrowth | Blocking | Cardinality estimation | Columnstore Indexes | Compression | Concurrency | Data Warehouse | Data Warehouse Architecture | Database Files | Deadlocking | Dynamic Management Views | ETL | Execution Plan | Execution Plan Analysis | Extended Events | Filegroups | Indexing | Intelligent Query Processing | Isolation Levels | Memory Grants | Parallelism | Parameter Sensitive Plan | Parameter Sniffing | Partitioning | Performance baselines | Plan analysis | Query Processing | Query store | Recovery models | SQL Server | SQL Server 2022 | Server 2022 | Statistics management | TempDB | Transaction log | Wait statistics | Warehouse Architecture
Education
N/A
Related jobs
-
Mid-level Full TimeLondon, LND, GB2d ago
-
Database Administrator Engineer GBP 50K-55KDMV | Database performance | Database performance tuning | Deadlock troubleshooting | Execution PlansFlexible work environment | Referral bonusMid-level ContractHybrid (United Kingdom); Remote (Poland) R12d ago
-
Data Platform Consultant GBP 45K-50KAnalysis Services | Apache Spark | Azure Data | Azure Data Factory | Azure SQLCompany pension scheme | Company social events | Employee assistance program | Employee benefits discounts | Gym membership discountMid-level Full TimeUnited Kingdom, United Kingdom23d ago
-
Data Visualisation Consultant GBP 40K-50KAlteryx | Dashboard Design | Data Analysis | Data Quality | Data VisualizationFlexible working | Free On Site Gym Membership | Health & wellness programs | Pension matching | Private health insuranceMid-level Full TimeLondon, England, GB1mo ago
-
Data Engineering Consultant GBP 45K-50KAWS Redshift | CI/CD | DBT | Data Modeling | Data WarehousingCareer growth support | Certification opportunities | Coaching mentoring buddy scheme | Hybrid work | Networking eventsMid-level Full TimeLondon, Greater London, United Kingdom (Hybrid) R1mo ago
-
Senior Data Engineering Consultant GBP 75K-90KAWS | Agile | Azure | BI Dashboards | Data Modeling25 days holiday | Company pension scheme | Cycle to work scheme | Employee assistance programme | Holiday buy & sellSenior-level Full TimeLondon, England, United Kingdom1mo ago
-
Senior Analytics Consultant GBP 74K-80KAzure Data | Azure Data Factory | Big Data | Data Factory | Data ModelingCareer development program | Mentoring | Training plan | Work from home | Work-life balanceSenior-level Full TimeLondon, England, United Kingdom1mo ago