MSSQL DB Administration

 5-9 years of Microsoft SQL Server Database Administration experience in SQL Server 201220142016201720192022

 Installed SQL Server 201220142016201720192022 on x64bit Operating System

 Experience in Migrating from SQL Servers

 Experience in upgrading SQL server software to new versions and applying service packs and patches

 Proficient with SQL Management Studio Enterprise Manager Query Analyzer rescheduling jobs with SQL Server

 Creating DB Maintenance plans rebuildreorganize indexes  performing integrity checks

 Highly proficient in database Backup Restore Recovery Linked servers and Database Maintenance Plans

 Experience with High Availability and Disaster Recoveries like Replication Log Shipping Mirroring and Clustering

 Proficient in implementing different types of Replication Models like Snapshot Transactional and Merge

Experience in Implementing Always On in SQL Server 2016201720192022

 Involved in Installing Configuring and Maintaining of SQL Server 2016201720192022

 Auditing database configuration and security configurations

 Actively involved in System Performance by tuning SQL queries and stored procedures by using SQL Profiler Database Engine Tuning Advisor Windows performance monitor DMVs Resource Governor Data collection Reports crystal reports DBCC and Custom Script Builtin performance Report and Activity Monitor

 Experience with Database Backup and Restore

 Customer management and teaming skills supporting customers on phone and written correspondence regarding technical questions and issues

 Logical and Critical thinking skills

 Deep technical and troubleshooting skills

 Passion for technology and learning

 Communicate efficiently both written and verbally with a wide variety of customers