Negotiable
Inside
Remote
Remote
Summary: The role is for a SQL Database Specialist, focusing on managing and administering DB2 databases and Azure SQL Managed Instances. The position involves working on migration projects, requiring strong SQL skills and familiarity with tools like SQL Server Migration Assistant and Azure Data Factory. The role is remote and classified as inside IR35, with a contract duration of 6 months or more.
Key Responsibilities:
- Manage and administer DB2 databases and Azure SQL Managed Instance.
- Utilize tools like 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 issues during migration.
- Plan, execute, and monitor migration projects.
- Address migration challenges using strong analytical and problem-solving skills.
- Understand Azure cloud services, including networking, storage, and security.
Key Skills:
- Proficiency in managing and administering DB2 databases and Azure SQL Managed Instance.
- Experience with SQL Server Migration Assistant (SSMA) for DB2 and Azure Data Factory (ADF).
- Strong SQL skills and familiarity with scripting languages such as Python.
- Ability to map and transform data from DB2 schemas to Azure SQL schemas.
- Skills in optimizing database performance and troubleshooting migration issues.
- Understanding of Azure cloud services, including networking, storage, and security.
- Strong analytical and problem-solving skills.
- Experience in migration projects, including planning, execution, and monitoring.
Salary (Rate): undetermined
City: undetermined
Country: UK
Working Arrangements: remote
IR35 Status: inside IR35
Seniority Level: undetermined
Industry: IT
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)
title: SQL SME
salary: Negotiable
location: Remote
misc1:
misc2: