Job summary:
Title:
SQL Server Application DBA
Location:
Indianapolis, IN, USA
Length and terms:
Long term - W2 or C2C
Position created on 04/05/2021 05:54 pm
Job description:
**** Webcam interview; *** Long term project *** Initial remote due to covid then onsite ***
Roles and Responsibilities
- Must have experience in Writing optimized Stored Procedures and UDF functions.
- Must Write Stored Procedure, queries to process XML data.
- Must Create Views, Index, Tables and update statistics.
- Proficient with Use Query Store, Query plans.
- Ensure high levels of performance, availability, sustainability and security for the SQL server.
- Analyse, solve, and correct issues in real time.
- Assist developers with query tuning and schema refinement.
Required Qualifications:
- Experience as a SQL Server Application DBA application with large (Tens and million of rows) database and involving XML data.
- Experience writing optimized Stored Procedures and User defined functions.
- Experience in creating Views, Indexes, Tables.
- Experience in using Query Store, forcing Query plan.
- Experience handling issues with indexing, Updating statistics.
- Experience with Performance Tuning and Optimization (PTO).
- Critical thinker and problem-solving skills.
- Great interpersonal and communication skills.
Mandatory Skills:
- SQL Server experience with large database (Tens and millions of rows).
- Stored Procedures.
- Performance turning.
- Troubleshooting.
- Triaging.
- Using Query Store.
Additional Information:
- Approach to tuning stored procs.
- Issues related to indexes.
- Understanding execution plans.
- Data Management Objects.
- Wait types.
- Query Store.
- SQL XML.
- Use of Common Table Expressions.
- Pros/cons of table variables and temp tables.
Contact the recruiter working on this position:
The recruiter working on this position is Rajendra Reddy
His/her contact number is +(1) (202) 4706751
His/her contact email is rajr@msysinc.com
Our recruiters will be more than happy to help you to get this contract.