Required Skills

SQL Server DBA

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

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 :- 10th Apr 2024

JOB DETAIL

looking for a SQL DBA with 2-5 years of experience to join their data platforms team (10 people on the team) as they strive to become more of a data-driven organization. Embarking on a large-scale migration to Azure, they are creating their strategy and identifying opportunities to consolidate databases as they migrate. This SQL DBA will be performing about 60-70% day to day operational work. Work with application owners, identify new requirements, build new servers, and build new databases. 30-40% of their time will be spent on the new projects. One of the big projects they have going on is migrating an on-prem SQL server to the cloud.

 

Strong experience in migrating on-prem SQL systems into Azure data platforms (PaaS & IaaS)

 

Experience in data migration tools / methods to migrate on-prem data to cloud with minimal downtime to applications

Experience in analysis, capacity planning, designing, and configuration of Azure SQL database systems

Extensive experience in automation tools like Terraform

Set up & manage SQL Server AlwaysOn Availability Groups (AAG) and Distributed AAG (DAAG) methods

Strong experience in performance tuning

Automate day-to-day migration related activities

Set up monitoring and alerting of Azure databases

Build and automate database maintenance jobs in Azure (Ex: backups, index maintenance, update stats, check db…)

Good to have some level of exposure to any one of these no-sql platforms – Cosmos DB, Mongo DB, Cassandra

Good to have some level of exposure to architecting / building containerized database solutions

Additional Skills & Qualifications:

 

1. Automation experience (PowerShell, terraform, shell scripting)

 

2. Need experience with complex systems. They have over 70 servers

Company Information