Required Skills

SQL DBA Technical Architect Azure SQL

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 4th Jan 2024

JOB DETAIL

Primary skills:

·         Understanding customer DB SQL, Windows, Linux 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.

·         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

·         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.

 

Certifications (Good to have):

·         Microsoft Certified: Azure Solutions Architect Associate

·         DP-300: Administering Microsoft Azure SQL Solutions

·         AZ-305: Designing Microsoft Azure Infrastructure Solutions.

Company Information