MS SQL Server Migration Architect
LTIMindtree
München, Germany
3 days ago
Role details
Contract type
Temporary to permanent Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English, German Experience level
SeniorJob location
Remote
München, Germany
Tech stack
Microsoft Windows
Azure
Backup Devices
Cloud Computing
Databases
Subnetting
Log Shipping
Microsoft SQL Server
SQL Azure
Powershell
SQL Databases
T-SQL
Scripting (Bash/Python/Go/Ruby)
Database Performance
Database Migration
SQL Server Management Studio (SSMS)
Job description
- 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
Requirements
Do you have experience in Windows?, 15 years, of IT experience and minimum of 5 years of experience on Azure Database Migration with technically guided managed and governed the team., * 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 the company
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 www.ltimindtree.com, 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 https://www.ltimindtree.com/.
If you require alternative methods of application or screening, you must approach the employer directly to request this as Indeed is not responsible for the employer's application process.