Harmony Data Integration Technologies Hiring for Sql Server Database Administrator (4-6 years) Job at Punjab Full Time

Skills: SQL Server DBA, Database Administration

Requirements:

• 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

Company Benefits:
1. Health Care Benefits for Employee and their family.
2. Dental Care Benefits for employee and their family.
3. Work from Home Workstation Furniture.
4. INR 10,000 on Life Event like Marriage and Child Birth.
5. Medical Emergency Leaves.