SQL Server Database Administrator

Chandigarh, India

Job Description

  • 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
  • Tuning T-SQL queries to improve performance
  • 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
  • When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
  • Conduct SQL Server lunch-and-learn sessions for application developers Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)
  • On-call troubleshooting for SQL Server service outages Deciding whether clustering, log shipping, mirroring, replication, etc are the right fit to solve a business problem

Work Experience Required

  • 3-6 years

Job Location(s)

  • Mohali

Qualification

  • Graduation