• US Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 6th Apr 2022

Deliverables:

This SQL Server DBA will assist on a large project to move from DB2 to SQL Server (on-prem.)  Tasks will consist of transferring data, performance tuning, setting up table partitioning, purging/archiving data, and debugging issues.  In addition, the DBA may assist the internal DBA team in daily support activities, including server/database administration, performance tuning, and handling support tickets.

Specifically, the senior-level contractor needs to have the following skills and experience:

1.            Strong SQL Server DBA skills:  T-SQL, Performance tuning, general SQL administration, replication, creation/configuration of new databases, and automation

2.            Experience with Powershell

3.            Experience with CommVault a plus

4.            Experience with performing data copies and refreshes

5.            Strong experience supporting business critical production databases

6.            Experience performing failovers

7.            Ability to troubleshoot under pressure

8.            Ability to tune complex SQL statements

9.            Backup/Recovery

10.          Alerts, monitoring and automation

11.          Experience following strict change management process

12.          Strong planning, time-management, and communication skills are required.

The contractor will be supporting production, business-critical, high-volume databases and performing “keep the lights on” activities.  The contractor will work with cross functional teams to troubleshoot and resolve issues. 

The contractor will also be working to identify applications and teams tied to individual databases that require patching or upgrades.  The contractor will then coordinate any testing or required/planned outages with those