Snowflake & SQL Server Support Engineer

Contract Length: 12 Months Day Rate: £420 per day IR35 Status: Inside IR35 Location: London Overview

We are seeking an experienced Snowflake and SQL Server Engineer to provide end-to-end support, maintenance, remediation, and governance across Snowflake and multiple SQL Server environments. The role involves operational support, incident handling, performance optimisation, migrations, observability, and ongoing improvement of data platforms and pipelines.

The contractor will work across Snowflake, SQL Server (ETL, RDM, RDRM, CRM, DPR, Arrear_RM, SSIS), Oracle, Kafka, and supporting tools to ensure stability, reliability, security, and performance of critical data systems. Key Responsibilities

Platform Support & Maintenance

• Provide full life cycle support, maintenance, remediation, and governance for Snowflake and SQL Server environments.
• Support daily operations and monitor data movement across Oracle, SQL Server, Snowflake, and Kafka.
• Manage and resolve incidents, service requests, and operational escalations.
• Maintain and support Legacy SQL and SSIS-based jobs and frameworks.
• Ensure database health is monitored and reported daily.

Database Administration & Performance

• Database provisioning, administration, tuning, and performance improvement for Snowflake and SQL Server.
• Manage storage space optimisation, reclamation, and cost optimisation initiatives.
• Implement table partitioning, indexing strategies, and database optimisation techniques.
• Oversee data archiving, purging frameworks, and retention governance.

Security, Access & Governance

• Implement and govern security, RBAC, and user access frameworks.
• Conduct user access management, auditing, and compliance checks.
• Support data protection, backup strategies, DR processes, and patching activities.

Deployments, Automation & Change

• Support change, problem, and deployment management processes.
• Manage deployments, releases, and RTL activities.
• Develop and maintain file-loading and automation frameworks.
• Execute and support SSIS packages, ETL processes, and parallel file-loading jobs.
• Configuration management and documentation maintenance.

Migrations & Integration

• Support ODS/Oracle to Snowflake migrations (including via ODI).
• Migrate DR and CRM data into Snowflake to remove Legacy reporting dependencies.
• Reduce Azure SQL DB dependency by transitioning data pipelines and workloads into Snowflake.
• Support CRM job migration, execution, and platform decommissioning.
• Assist with SSIS migration and SQL Server decommissioning where required.
• Support third-party integrations with multiple internal and external tools.

Observability & Cost Optimisation

• Build and maintain observability dashboards using Datadog.
• Monitor Snowflake and SQL Server compute/storage costs and drive optimisation.
• Oversee storage, file management, and capacity planning across environments.

Essential Skills & Experience

• Strong hands-on experience with Snowflake and SQL Server platforms.
• Solid understanding of database administration, performance tuning, and optimisation.
• Experience with ETL/SSIS, Legacy SQL processes, and parallel file-loading jobs.
• Experience supporting multi-system data ingestion and movement pipelines.
• Strong knowledge of incident, change, and problem management processes.
• Familiarity with Oracle, Kafka, and cloud data ecosystems.
• Experience in large-scale data platform migrations (Oracle/ODS/CRM to Snowflake).
• Understanding of security frameworks, RBAC, and access governance.
• Experience with observability tooling such as Datadog.

• Strong hands-on experience with Snowflake and SQL Server platforms.
• Solid understanding of database administration, performance tuning, and optimisation.
• Experience with ETL/SSIS, Legacy SQL processes, and parallel file-loading jobs.
• Experience supporting multi-system data ingestion and movement pipelines.
• Strong knowledge of incident, change, and problem management processes.
• Familiarity with Oracle, Kafka, and cloud data ecosystems.
• Experience in large-scale data platform migrations (Oracle/ODS/CRM to Snowflake).
• Understanding of security frameworks, RBAC, and access governance.
• Experience with observability tooling such as Datadog.