MS SQL Server Migration Architect

Role description

About Us:

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries, LTIMindtree - a Larsen & Toubro Group company — combines the industry-acclaimed strengths of erstwhile Larsen and Toubro Infotech and Mindtree in solving the most complex business challenges and delivering transformation at scale. For more information, please visit

Job Title: MS SQL Server Migration Architect

Location: Munich, Germany(Hybrid/Remote)

Job Type: 6 Months contract with possible extension

15 years of IT experience and minimum of 5 years of experience on Azure Database Migration with technically guided managed and governed the team.

Responsibilities:

• Preforming DB SQL server landscape
• Configuring SQL Server HA/DR (FCI, AG) in Azure with multiple subnets and multiple regions, Availability set
• Configuring and Administering Security/Policies/Resource Governing/Azure Key Vault
• Migrating SQL Server from On-Premises to Azure Cloud using DMA, DMS, Azure Data Studio, Log shipping, Backup & restore and various other migration methods
• Plan Storage and Capacity Management and create logical models and build physical models
• Installing and configuring SQL Server all the version (200x to 2022)
• Design, implement and operate database systems for performance and reliability in Azure
• On-Prem/Cloud upgrade of SQL Server from Legacy version to latest versions in Azure
• Good knowledge in T-SQL scripting & PowerShell script

Primary skills

• Understanding customer DB SQL server landscape
• Configuring SQL Server HADR FCI AG in Azure with multiple subnets and multiple regions Availability set
• Configuring and Administering Security, Policies, Resource Governing Azure Key Vault
• Migrating SQL Server from On-Premises to Azure Cloud using DMA DMS Azure Data Studio Log shipping Backup restore and various other migration methods
• Work with Internal stakeholders Customer stakeholders and Project Managers to understand the migration requirements and provide solutions accordingly
• Driving the cloud Solutioning Azure activities for large complex migration
• Plan Storage and Capacity Management and create logical models and build physical models
• Installing and configuring SQL Server all the version 200x to 2022
• Hands on experience on Windows and SQL servers issues and troubleshooting

Secondary Skills:

• Design implement and operate database systems for performance and reliability in Azure
• OnPremCloud upgrade of SQL Server from Legacy version to latest versions in Azure
• Good knowledge in TSQL scripting PowerShell script
• Good understanding of Database Performance using various tools
• Conforming to client compliances and expectations

Certifications Good to have:

• Microsoft Certified Azure Solutions Architect Associate
• DP300 Administering Microsoft Azure SQL Solutions
• AZ305 Designing Microsoft Azure Infrastructure Solutions

Soft Skills:

• Good customer connects
• Positive attitude and excellent communication skills to manage customer calls
• Prepare solution presentations
• Ability to work well in a team and Excellent problemsolving skills with Good communication
• Candidate should be fluent in English and German language.

Skills

Mandatory Skills : MS SQL Server, Azure SQL, Migrating SQL Server from On-Premises to Azure Cloud, Windows

About LTIMindtree

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by 83,000+ talented and entrepreneurial professionals across more than 40 countries, LTIMindtree — a Larsen & Toubro Group company — solves the most complex business challenges and delivers transformation at scale. For more information, please visit