SQL Server Application DBA Location of The Job: Baltimore, MD Job Type: Full Time/ Contract Hours: 9:00AM – 5:00PM, 40 Hours/Week Travel: Must be willing to relocate and work anywhere in the US. No telecommuting. Company Description:http://www.valuemomentum.com/about/ 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)