• 7 years of experience in Database Administration for very large and complex databases in SQL Server 2016/2014/2012/2008R2/2008 and 2005.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expertise in MS SQL Server Installation, Configuration, Migration and Maintenance.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Having good knowledge and experience on two node active/active, active/passive cluster.
• Experience with SQL Server Security and SQL Server Auditing.
• Experience in handling Database performance issues, log shipping, Mirroring and other distributed data issues.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Having hands on experience in DR processes including Log shipping and Database Mirroring.
• Recovery of the database during crash or data loss.
• Expertise in defining Database Backup, Recovery and Disaster Recovery Procedures.
• Experience in Supporting Production Servers and Applications 24x7 to US, UK, Dubai, Canada users, on-call basis.
• Creating jobs and maintenance plans.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Configuring, scheduling and administering routine jobs, tasks, alerts and maintenance Plans.
• Implementing database change requests received from developers through change request.
• Excellent communication, analytical, interpersonal skills