Required Skills

SSIS SSRS

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 :- 7th Dec 2023

JOB DETAIL

The SQL Server Database Administrator will provide technical support of database environments, including installation, database creation, upgrades, patches, problem diagnosis, performance monitoring, database maintenance, process automation, evaluation, and tuning recommendations. Develop, implement, and support backup/restore, disaster recovery and data replication procedures and exercises.

Expectations:

Manage daily DB Administration activities, installation, and configuration of SQL Servers

Configure and monitor Always On/Clustering/Log Shipping/Replication

Install, configure, and manage SQL clusters (FCI, AG, DAG)

Manage backup and restores (Native and via third party tools like Rubrik)

Proficient in using T-SQL, troubleshooting queries and stored procedures. 

Performance Tuning and problem resolution for root cause

Code migration among different environments

Implement DB security

Support and participate in 24x7 on call rotation

 

Qualifications:

5+ years’ experience in SQL 2014/2016/2017/2019 administration

Bachelor's degree or equivalent combination of education/experience

Good working knowledge with SSIS, SSRS (bonus with PowerBI)

In-depth understanding of SQL architecture

Experience with replication topologies and components

Expert knowledge in SQL clustering and availability groups

Experience in both OLTP and Data warehousing environments

Good experience implementing operational automation through SQL tools and PowerShell

Experience troubleshooting Kerberos issues

Experience with TDE encryption of databases

Good experience with Azure Cloud support \ migration tasks (preferred)

Company Information