- SQL DBA Developer

Experience: 5+ Years

Job Location: Noida

- Job Description

  • Database archiving, coordinating backups and restores with system administrators
  • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
  • Configure SQL Server monitoring utilities
  • 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
  • Ensure that new database code meets company standards for readability, reliability, and performance
  • Work with the development team to identify resource-intensive queries and suggest ways to improve performance
  • Design indexes for existing applications, choosing when to add or remove indexes
  • Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)
  • Document the company’s database environment

- Must have experience

  • On-call troubleshooting experience with at least one production SQL Server for a year
  • Using tools to diagnose server reliability and performance issues
  • Tuning T-SQL queries to improve performance
  • Designing tables and picking datatypes
  • Writing complex database queries
  • Using Profiler traces and other tools to find the most frequently run queries
  • SQL Server load balancing, merging, splitting,
  • Should have experience in migrating data from SQL 2008 R2 to higher SQL Server version like (2014, 2016, 2017)