Sql Sme

Sql Sme

Posted 2 weeks ago by Hays Technology

Apply
Negotiable
Inside
Remote
London
Apply
Azure Cloud Services Azure Data Factory Cloud Computing Cloud Services Cloud Technology Data Migration File Servers IBM DB2 Mapping Software Microsoft Azure Microsoft SQL Servers Python (Programming Language) Scripting Security Clearance SQL (Programming Language)

Summary: The role of SQL Database Specialist involves managing and administering DB2 databases and Azure SQL Managed Instance, with a focus on data migration projects. Candidates must possess strong SQL skills and experience with tools like SQL Server Migration Assistant and Azure Data Factory. The position is remote and requires UK residency for eligibility, with a contract duration of 6 months or more. The role is classified as inside IR35, necessitating BPSS clearance for onboarding and SC clearance thereafter.

Key Responsibilities:

  • Manage and administer DB2 databases and Azure SQL Managed Instance.
  • Utilize SQL Server Migration Assistant (SSMA) for DB2 and Azure Data Factory (ADF).
  • Map and transform data from DB2 schemas to Azure SQL schemas.
  • Optimize database performance and troubleshoot migration issues.
  • Understand Azure cloud services, including networking, storage, and security.
  • Address migration challenges with strong analytical and problem-solving skills.
  • Plan, execute, and monitor migration projects (not BAU).

Key Skills:

  • Proficiency in managing and administering DB2 databases and Azure SQL Managed Instance.
  • Experience with SQL Server Migration Assistant (SSMA) and Azure Data Factory (ADF).
  • Strong SQL skills and familiarity with scripting languages such as Python.
  • Data mapping and transformation skills.
  • Database performance optimization and troubleshooting skills.
  • Understanding of Azure cloud services.
  • Strong analytical and problem-solving skills.
  • Experience in migration projects.

Salary (Rate): undetermined

City: London

Country: UK

Working Arrangements: remote

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Seeking a SQL Database Specialist x2 - 6 months+ on-going contracts - remote working - Inside IR35

Please note clearance will be conducted - BPSS for onboarding and SC once joined. Need to be UK-based to be eligible.

Key skills and experience:

  • Proficiency in managing and administering DB2 databases and Azure SQL Managed Instance.
  • Experience with tools like SQL Server Migration Assistant (SSMA) for DB2 and Azure Data Factory (ADF).
  • Strong SQL skills and familiarity with scripting languages such as Python
  • Data Mapping and Transformation: Ability to map and transform data from DB2 schemas to Azure SQL schemas.
  • Skills in optimizing database performance and troubleshooting issues during migration.
  • Understanding of Azure cloud services, including networking, storage, and security.
  • Strong analytical and problem-solving skills to address migration challenges.
  • Experience in migration projects, including planning, execution, and monitoring (not BAU)

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at (url removed)

Apply
Similar Jobs
Loading data...