Sr SQL Server Funtional /Application DBA

The JOB: • 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: a. 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. b. Designing tables and picking datatypes i. o Using Profiler traces and other tools to find the most frequently run queries. c. Using free tools like sp_BlitzIndex and DMV queries to answer questions about index usage. d. On-call troubleshooting for SQL Server service outages. e. Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem.