Experience in installation of different version of SQL SERVER (2016, 2014, 2012, 2008R2 / 2008) in both OLTP and OLAP lower regions and Production environments.
Disaster Recovery techniques like Always on Availability Groups, Clustering (Both Active-Active and Active-Passive) Database Mirroring, Transactional Replication and Log Shipping.
Upgraded and Migrated of SQL Server databases from SQL Server 2000 / 2005 / 2008 / 2008R2 / 2012 to SQL Server 2014 / 2016.
Daily routine DBA tasks like handling user s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
Hands on experience in working with MSSQL SERVER 2005, 2008, 2008R2, 2012, 2014 features and extensive knowledge on SQL 2016 new features.
Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup / Recovery of databases, Replication, Linked Servers, and databases Maintenance, Database Mails Experience in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client / Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
Monitoring the different server including backup, disk space, Job failures, connectivity, and performances. Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I / O, Memory bottlenecks.
Working knowledge in Integration Services (SSIS), Reporting Services (SSRS) and Clustering. Experience in using DMV and dynamic management function for finding out long running Queries.
Adept at proving database troubleshooting issues like Locking, Blocking and Deadlocking, fail over maintenance and database recovery.
Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
Experience in creating Jobs, Alerts, and schedule DTS / SSIS Packages. Identifying waits and bottlenecks at the database and OS level.
Strong analytical abilities and strong communication skills 3 to 4+ years of experience as SQL server DBA Knowledge of ITIL framework
Mandatory Skills : MS SQL Admin
Desirable Skills : Cloud-SQL Azure
Language Skills : English Language