[Remote] SQL Architect
Note: The job is a remote job and is open to candidates in USA. Confidential is seeking a SQL Architect with extensive experience in Azure Database Migration. The role involves configuring SQL Server, managing migrations from on-premises to Azure Cloud, and collaborating with stakeholders to provide solutions for complex migration projects.
Responsibilities
- Understanding customer DB SQL,Windows, Linux server landscape , Azure to Azure Migrations
- 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
- 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
- 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
- Good understanding of Database Performance using various tools
- Conforming to client compliances and expectations
Skills
- 13+ years of IT experience
- Minimum of 5+ years of experience on Azure Database Migration
- Willing to provide 24x7 support
- Flexible to work in shifts
- Understanding customer DB SQL, Windows, Linux server landscape, Azure to Azure Migrations
- 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
- 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
- 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
- Good understanding of Database Performance using various tools
- Conforming to client compliances and expectations
- Good customer connects
- Prepare solution presentations
- Migration Planning preparations
- Ability to work well in a team
- Excellent problem-solving skills
- Good communication
- Excellent analytical skills
- Microsoft Certified: Azure Solutions Architect Associate
- DP-300: Administering Microsoft Azure SQL Solutions
- AZ-305: Designing Microsoft Azure Infrastructure Solutions
- Advantage fluency in Spanish or Portugese or French speaking
Company Overview
- Centralizing All Types Of Next Opportunities For You In One Place. It was founded in undefined, and is headquartered in Vancouver, US, with a workforce of 2-10 employees. Its website is .
Apply tot his job Apply To this Job