SR. SQL Server Production DBA

Plano, TX 75024

Posted: 04/19/2019 Industry: IT Job Number: 16171 Pay Rate: 120,000

SUMMARY:

The Senior SQL Server Production DBA will be responsible for:
  • 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, 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
  • Configure and support multiple AlwaysOn configurations with synchronous and asynchronous configurations
  • Configure and support transaction and merge replication

 

QUALIFICATIONS:
  • 8+ years of related SQL Server DBA, on-call troubleshooting experience with at least 5 production SQL Servers
  • Experience finding DMV queries to answer questions about server-level performance
  • Experience using free tools like sp_Blitz and sp_WhoIsActive to diagnose server reliability and performance issues
  • Azure SQL Database experience preferred
  • Tuning T-SQL queries to improve performance
  • Designing indexes for existing applications, choosing when to add or remove indexes
  • Ensure that new database code meets company standards for readability, reliability, and performance
  • When users complain about the performance of a particular query, ability to help developers improve the performance of that query by tweaking it or modifying indexes
  • Designing tables and picking datatypes

Erica Albert

Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.