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.
  • Conduct SQL Server lunch-and-learn sessions to improve developer knowledge.
  • 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.

Key Skills
Education

ANY GRADUATE

Back To Jobs