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
-
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 Kingdom11h ago
-
Senior Consultant, Data Engineering GBP 68K-74KAPI | AWS | Azure | Batch Processing | CI/CDCorporate Responsibility Days | Flexible working | Generous annual leave | Hybrid working | Paid Leave Recharge BenefitSenior-level Full TimeLondon, United Kingdom4d 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, GB14d 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) R24d 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 Kingdom29d 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
-
Senior Data Engineering Consultant GBP 70K-90KAgile project management | Apache Spark | Azure Data | Azure Data Factory | Azure Data LakeAnnual bonus scheme | Annual leave | Birthday leave | Charity leave | Electric car schemeSenior-level Full TimeUnited Kingdom, United Kingdom1mo ago
-
Lead Analytics Consultant GBP 75K-85KAzure Data | Azure Data Factory | Big Data | Cloud Computing | Data EngineeringCareer development program | Home working | Mentoring | Training plans | Work-life balanceSenior-level Full TimeLondon, England, United Kingdom1mo ago
-
Agile | Analytics Cloud | Autonomous Data Warehouse | Business Intelligence | CI/CDMid-level ContractLondon - CG1mo ago