SQL DBA

Location: Chicago, IL
Date Posted: 08-04-2015
This position’s job duties and responsibilities include:
  • 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
  • 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
To do a great job in this position, experience should include:
  • 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
The following skills aren’t strictly necessary, but will make you a well-rounded candidate for bonus points:
  • Tuning T-SQL queries to improve performance
  • Troubleshooting hardware using tools like Dell OpenManage, HP System Insight Manager, and IBM Director
or
this job portal is powered by CATS