SQL Developer

SQL Developer

Posted 4 days ago by iXceed Solutions

Apply
Negotiable
Undetermined
Hybrid
London Area, United Kingdom
Apply
Access Controls Apache Kafka Auditing Business Continuity And Disaster Recovery Constituent Relationship Management Customer Relationship Management (CRM) Software Datadog Data Migration Data Protection Strategy Deployment Support Disaster Recovery External Auditing Extract Transform Load (ETL) File Servers Management Management Process Microsoft Azure Microsoft SQL Servers Performance Tuning Snowflake (Data Warehouse) Software Development SQL (Programming Language) SQLDB Technical Documentation User Provisioning

Summary: The role of Snowflake & SQL Server Developer involves providing comprehensive support for Snowflake and SQL Server environments, focusing on maintenance, governance, and operational enhancements. The candidate will be responsible for managing ETL processes, incident management, and database performance tuning within enterprise data ecosystems. The position requires a strong background in database development and data migrations. This is a hybrid contract role based in London for a duration of 12 months.

Key Responsibilities:

  • Provide support, maintenance, remediation, and governance for Snowflake and SQL Server environments.
  • Manage ETL and legacy systems including RDM, RDRM, CRM, DPR, Arrear, and SSIS packages.
  • Monitor daily data operations and pipelines across Oracle, SQL Server, Snowflake, and Kafka.
  • Handle incident management and troubleshoot issues promptly.
  • Manage service requests including user provisioning, data requests, auditing, reporting, and security updates.
  • Support patching activities, DR (Disaster Recovery) events, and change/problem management processes.
  • Oversee database provisioning, performance tuning, maintenance, and health monitoring.
  • Implement table partitioning, storage optimization, and performance improvements.
  • Develop and maintain alerting and monitoring frameworks (Datadog dashboards preferred).
  • Implement and maintain security frameworks, user access controls, and audit compliance.
  • Manage data protection standards, retention, and archival processes.
  • Support migration of tables from ODS/Oracle to Snowflake using ODI.
  • Manage DR and CRM data migration into Snowflake to reduce dependency on legacy systems.
  • Maintain and enhance file-loading automations, SSIS jobs, and third-party tool integrations.
  • Lead initiatives around cost optimization, storage reclamation, and Azure SQL DB dependency reduction.
  • Support server decommissioning and SSIS migration activities.
  • Maintain accurate configuration and technical documentation.
  • Provide RTL and deployment support across environments.
  • Deliver daily health reports and ensure continuous improvement of database stability.

Key Skills:

  • Strong background in database development and performance tuning.
  • Experience with Snowflake and SQL Server environments.
  • Proficiency in ETL processes and legacy systems management.
  • Incident management and troubleshooting skills.
  • Knowledge of data migrations and integrations.
  • Familiarity with security frameworks and compliance standards.
  • Ability to develop monitoring frameworks and health reports.
  • Experience with Azure SQL DB and cost optimization initiatives.

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job Title: Snowflake & SQL Server Developer

Location: London, UK

Work Mode: Hybrid

Contract Duration: 12 Months

Job Description

We are seeking an experienced Snowflake & SQL Server Developer to provide end-to-end support across Snowflake and SQL Server environments, including maintenance, remediation, governance, and operational enhancements. The ideal candidate will have a strong background in database development, performance tuning, data migrations, and incident management within enterprise data ecosystems.

Key Responsibilities

  • Snowflake & SQL Server Operations
  • Provide support, maintenance, remediation, and governance for Snowflake and SQL Server environments.
  • Manage ETL and legacy systems including RDM, RDRM, CRM, DPR, Arrear, and SSIS packages.
  • Monitor daily data operations and pipelines across Oracle, SQL Server, Snowflake, and Kafka.
  • Incident, Service & Change Management
  • Handle incident management and troubleshoot issues promptly.
  • Manage service requests including user provisioning, data requests, auditing, reporting, and security updates.
  • Support patching activities, DR (Disaster Recovery) events, and change/problem management processes.
  • Database Administration & Performance
  • Oversee database provisioning, performance tuning, maintenance, and health monitoring.
  • Implement table partitioning, storage optimization, and performance improvements.
  • Develop and maintain alerting and monitoring frameworks (Datadog dashboards preferred).
  • Security, Access & Governance
  • Implement and maintain security frameworks, user access controls, and audit compliance.
  • Manage data protection standards, retention, and archival processes.
  • Data Migration & Integration
  • Support migration of tables from ODS/Oracle to Snowflake using ODI.
  • Manage DR and CRM data migration into Snowflake to reduce dependency on legacy systems.
  • Maintain and enhance file-loading automations, SSIS jobs, and third-party tool integrations.
  • Optimization & Cost Management
  • Lead initiatives around cost optimization, storage reclamation, and Azure SQL DB dependency reduction.
  • Support server decommissioning and SSIS migration activities.
  • Documentation & Support
  • Maintain accurate configuration and technical documentation.
  • Provide RTL and deployment support across environments.
  • Deliver daily health reports and ensure continuous improvement of database stability.
Apply
Similar Jobs
Loading data...