Summary: The role of SQL SME involves performing mainframe data migration for a client, specifically transforming various database formats to the Microsoft SQL Server Platform. The position requires expertise in SQL Server Migration Assistant and Azure Data Factory, along with experience in IBM Mainframe migrations. The role is remote and classified as inside IR35, requiring SC clearance.

Key Responsibilities:

• Perform mainframe data migration, transforming DB2, IDMS, VSAM, and flat-files to Microsoft SQL Server.
• Utilize SQL Server Migration Assistant (SSMA) and Azure Data Factory (ADF) for migration tasks.
• Script in Python for data migration processes.
• Troubleshoot issues related to data conversion between mainframe databases and Azure SQLMI.
• Administer databases and manage complex migrations to the Azure platform.

Key Skills:

• In-depth knowledge of SQL.
• Experience with Azure Platform Systems and SQLMI.
• Proficiency in using Microsoft SSMA and Azure Factory Tools for DB2 migration.
• Basic knowledge of Python and scripting in SQL.
• Database administration experience.
• Experience with complex migrations to Azure Platform.
• SC Clearance required.

Salary (Rate): undetermined

City: London Area

Country: United Kingdom

Working Arrangements: remote

IR35 Status: inside IR35

Seniority Level: undetermined

Industry: IT