Role: MS Sql DBA -

Location: Dallas Texas

onsite Day 1 - F2F interview Must 

10+ Must 

#h1b #c2c 

JD is as follows

Need senior in this role with strong communication & exhibit ownership and operate as a performance expert in MSSQL and TSQL stored procedures.

Responsibilities:

1. Responsible to deliver more performant MSQL database solutions along with implementation plan at enterprise level.
2. Ability to monitor database performance and optimize it through tuning and indexing
3. Review existing stored procedures, identify bottle necks and optimize them
4. Ensure data integrity, security and recovery processes
5. Trouble shoot database issues and perform timely resolutions
6. Ability to work with hybrid MSQL databases (on-prem and cloud )
7. Verify batch jobs and their performance impact on databases and think out of box solutions
8. Assist developers with query tuning and schema refinement

Technical Skills:

1.      Strong proven knowledge in tuning SQL queries

2.      Strong in writing MSQL stored procedures (TSQL)

3.      Review Database schema designs and provide suggestions from performance angle

4.      Helps the team in identifying key indexes and how they should be structure based on schema and frequent query patterns

5.      Identify run away queries and provide quick solutions

6.      Monitor system's health and performance using tools like Datadog.

7.      Analyze, solve, and correct issues in real time

 R