Job Description

• Experience in Database administration activities like Installation, Configuration, Backup & Recovery, database security, troubleshooting the MSI and MSP files missing and SQL Server Performance.
• Experience in SYSPREP SQL Server installation in production servers & Non-prod servers.
• Experience in creating of logins, user administration.
• Hands on Experience in VERITAS Net Backup, COMMVAULT and EMC Networker for SQL online Backups and restorations.
• Implementation of Log Shipping, Clustering and Hands on Experience with Always On high availability on WSFC.
• Hands on with Linked Servers(SQL to SQL & SQL to Oracle) from remote SQL Server and also other Data sources from SQL server ODBC connectors.
• Experience in working with SQL Server Upgradation, SQL Server Migration and SQL Server Patching.
• Having Experience in creating of clustered, Non-clustered Indexes and creating of Maintenance plans for the Index Rebuild and Reorganize, Backup maintenance plans, update statistics, Checking database integrity check and their retention period.
• Work exposure on Windows Failover cluster with multi nodes/Multiple SQL Instances on Cluster.
• Having experience in SSIS & SSRS.
• Work experience on AzureScheduling Jobs, Creating databases, various SQL server versions migration on Azure.
• Reading SQL error log and event log for initial investigation.
• Working with DMVS and DMF’S in retrieving the information from the server.
• Monitor system's health and performance, Ensure high levels of performance, availability, sustainability and security
• Provide 24x7 support for critical production systems and on call support.
• Perform scheduled maintenance and support release deployment activities after hours
• Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs and resolve issues in a timely manner.

Skills Required: Cluster Setup, Clustering, SQL Server