Description

You will act as a technical consultant to ensure database code meets standards for readability, reliability, and performance.

Responsibilities

• Analyze resource-intensive queries weekly and provide specific optimization recommendations to developers.
• Design and manage indexes for existing applications, determining when to add or remove them to optimize performance.
• Collaborate with developers to troubleshoot and tune specific queries based on user feedback.
• Advise engineering teams on efficient database designs, including tables, datatypes, stored procedures, and functions.
• Participate in on-call troubleshooting for SQL Server service outages.

Required Skills

• 5+ years of experience in database administration or related roles.
• Proven expertise in writing and improving SQL Server T-SQL queries.
• Experience designing tables and selecting appropriate datatypes.
• Proficiency using Profiler traces to identify frequently run queries.
• Ability to use sp_BlitzIndex and DMV queries to analyze index usage.
• Experience implementing clustering, log shipping, mirroring, or replication to solve business problems.
• Strong understanding of SQL Server performance tuning.

Preferred Skills

• Experience conducting SQL Server lunch-and-learn sessions to improve developer knowledge.

Key Skills

Education

ANY GRADUATE