Sr SQL Server Application DBA

Job Description:

• Client is seeking consultants that will participate on a Global' DBA team. The team will ensure that the new database code meets company standards for readability, reliability, and performance.
• Each week give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each.
• Design indexes for existing applications, choosing when to add or remove indexes.
• When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes.
• Conduct SQL Server lunch-and-learn sessions for application developers.
• Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc).
• Consultant must have experience:

1) Writing and improving SQL Server T-SQL queries for at least a year. You will be known amongst the office as the go-to person for T-SQL questions.

2) Designing tables and picking datatypes Using Profiler traces and other tools to find the most frequently run queries.

3) Using free tools like sp_BlitzIndex and DMV queries to answer questions about index usage.

5) On-call troubleshooting for SQL Server service outages.

6) Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.
Skills Need:

• These positions are for a Global unit. Consultants must have experience (Constantly and On Average) working with DB sizes of 30TB or more (Not Less).
• Experience working with large-scale enterprise application setup across Data centers.
• SSIS Package creation and debugging skills.
• Stored procedure development and tuning.
• Data replication exposure.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.