Database Administrator - Production Support (4-6 Yrs) Noida (Systems/Product Software)

Urgently looking for Database Administrator for our renowned IT Client Required Skills : - Strong production support experience in Administration and Maintenance of relational databases using SQL Server 2008/2008R2/2012/2014/2016/2017 in OLTP/OLAP/BI environment - Working experience in Database installation, Database maintenance, Upgradation, Migration, Server/database Tuning, Backup & Recovery operations - Experience in Query Optimization and efficiency on database performance improvement using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor - Knowledge of SQL Server tools (DTA, SSMS, PerfMon,SSDT).
-Hands On Experience on writing complex queries/ stored procedures / triggers / tables / views / indexes / constraints and functions.
-Knowledge on High Availability (HA), AlwaysOn, DB mirroring, log shipping - Hands on Experience in user creation / access delegation / auditing.
-Hands on Experience in Tuning T-SQL queries to improve performance - Install and configure new SQL Servers - When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes Skills Nice to Have : - Knowledge of Windows Cluster - Server Management - Task automation and Scripting languages (PowerShell) - Good to have Certification - MCDBA, MCSA, MTA - Knowledge on SSRS, SSIS AND SSAS

Required Skills : English