3 of 3 Permanent Performance Tuning Jobs in Norfolk

hands-on Senior Data Architect who is equally comfortable designing the target state for a multi-system SQL data estate, writing and tuning the T-SQL that delivers it, and standing up the security, monitoring and operational practices that keep it running. You will own data architecture across … framework and PowerShell development at expert level — partition design and partition-aligned indexing, clustered/nonclustered index strategy, deduplication, parallel-run cutovers, schema migration, performance tuning of high-impact production queries. · Driving the in-flight ETL replatform — replacing legacy SSIS jobs with a table-driven, parallel ...

multiple research databases. Write historic correction scripts to fix data anomalies across large datasets. Implement validation and consistency checks during data ingestion and transformation. Performance & Database Engineering Optimise ETL queries and batch processes running against very large tables (billions of rows). Analyse and tune query execution plans, indexing … strategies, and partitioned tables. Improve performance of data loads and batch ETL processing. Operational Database Work Support operational SQL Server tasks including: Integrity checks Troubleshooting failed imports Manage file‐based data ingestion, including large CSV imports and server directory management. Maintain and improve SSIS packages and SQL‐driven import ...

processing. Design Delta Lake architectures including: Delta tables Medallion architecture (Bronze/Silver/Gold layers) Data quality frameworks Schema evolution andoptimization Perform Databricks performancetuning: Cluster optimization Spark job optimization Query tuning Cost optimization Implement Databricks governanceand security using: Unity Catalog Access controls Data lineage Audit capabilities Lead migration ...