Job Description :
Essential Skills:
Overall 10 + Years of IT Experience
To debug, analyze and fix the performance issues in the SQL DB.
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
Configure SQL Server monitoring utilities to minimize false alarms
Ensure that 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
As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
Install and configure new SQL Servers
Deploy database change scripts provided by third party vendors
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
Document the company’s database environment
Roles:
On-call troubleshooting experience with at least one production SQL Server for a year. You don’t have to be the only DBA or have DBA in your job description, but you should have been the one person that the company would call if the SQL Server service stopped working.
Finding DMV queries to answer questions about server-level performance
Using free tools like sp_Blitz® and sp_WhoIsActive to diagnose server reliability and performance issues
Tuning T-SQL queries to improve performance
Troubleshooting hardware using tools like Dell OpenManage, HP System Insight Manager, and IBM Director
Writing and improving SQL Server T-SQL queries for at least a year. You may have technically had “C# Developer” or “Java Developer” on your job title, but you were known amongst the office as the go-to person for T-SQL questions.
Designing tables and picking datatypes
Using Profiler traces and other tools to find the most frequently run queries