Snowflake and SQL Server Developer

Summary: The role of Snowflake and SQL Server Developer involves supporting, maintaining, and governing Snowflake and SQL Server environments. The position requires monitoring daily operations, managing incidents, and implementing security frameworks while optimizing database performance and storage costs. The developer will also handle data migrations and integrations with various tools, ensuring efficient data management and reporting. This is a contract position based in London with hybrid working arrangements.

Key Responsibilities:

• Good Knowledge on Snowflake, SQL Server.
• Support in incident management.
• Monitor daily operations and data movements (Oracle, SQL Server, Snowflake, Kafka).
• Service request handling (user creation, data requests, audit, reporting etc.).
• Implement security and user access framework.
• Support in patching and DR events.
• Change and problem management.
• Deployments and RTL Support.
• Database provisioning, maintenance, and administration.
• Database and server performance improvement.
• Data archiving and purging framework.
• Database monitoring and alerting.
• Configuration management and documentation.
• Data protection procedures.
• Cost monitoring and optimization initiatives.
• Third-party integrations with multiple tools.
• Migration of tables from ODS/Oracle to Snowflake (via ODI).
• DR and CRM data migration to Snowflake (to avoid legacy reporting).
• File loading and file creation frameworks.
• Storage space and cost optimization.
• Observability with Datadog dashboards.
• Minimize Azure SQL DB dependency by moving data to Snowflake.
• User access management and auditing.
• Maintenance and monitoring of database health - daily reports.
• Table partition implementation.
• File loading and automation framework.
• SSIS packages for ETL and parallel file loading jobs.
• Maintenance and support of legacy jobs.
• SSIS migration and server decommissioning.
• ODS to Snowflake migration support.
• CRM job migration and execution.
• Storage space optimization and reclamation.

Key Skills:

• Proficiency in Snowflake and SQL Server.
• Experience with ETL processes and SSIS.
• Knowledge of database provisioning and administration.
• Familiarity with data migration and integration tools.
• Understanding of security frameworks and user access management.
• Ability to monitor and optimize database performance.
• Experience with data archiving and purging strategies.
• Knowledge of cost optimization techniques.
• Experience with incident management and problem resolution.
• Familiarity with Datadog for observability.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT