 Experience in strong administration, Installation, configuration, design, development, and implementation experience using MS SQL Server 2019/2016/2014//2012/DTS/SSIS, SSRS with T-SQL.  Experience in Database backup and disaster recovery procedures. Experience in Replication – Snapshot and Transactional. Experience setting up, configuring and administrating database clustering in Windows and VERITAS platforms. Hands on experience in Log shipping, Mirroring, Clustering and Always ON with SQL Server 2012/2014/2016. Experience in upgrading from MS SQL Server 2008 R2 to SQL 2012, and SQL 2016 Experience in migrating on-prem servers to AWS EC2. Experience in Creating linked server and troubleshooting linked server issues. Extensive experience in Capacity planning, Migration, Consolidation, Performance Tuning, Disaster Recovery, Troubles shooting and Automation. Experience in administrative tasks such as data loading and unloading, Backup, Recovery and scheduling backups.  Experience in Performance Tuning - Query Optimization (SQL, T-SQL) using Performance Monitor, SQL Profiler and Database Tuning Advisor etc. Experience in SSIS Packages, SSRS Reports design and Tuning including Troubleshooting Client/Server Connectivity issues. Experience in Creating packages, Scheduling Jobs, Sending Alerts using Database Mail. Experience in creation of Database authentication modes, configuring permissions and assigning roles to users.  Experience in SQL Server Reporting Services (SSRS).Developed 80 + SSRS Reports such as Tabler, Matrix, Drill-Down, Drill -Through, Sub-Reports, Chart and Dashboards reports during my developer period experience (Initial 16 Months worked as Developer).  Experience in SQL Server Integration Services (SSIS). Developed 15 + SSIS Packages and handled Excel, CSV, MySQL as source and destinations. Client interaction during development, deployment, QA and production elevation phases.

 Experience in migrating on-prem servers to AWS EC2. Experience in Creating linked server and troubleshooting linked server issues. Extensive experience in Capacity planning, Migration, Consolidation, Performance Tuning, Disaster Recovery, Troubles shooting and Automation. Experience in administrative tasks such as data loading and unloading, Backup, Recovery and scheduling backups.  Experience in Performance Tuning - Query Optimization (SQL, T-SQL) using Performance Monitor, SQL Profiler and Database Tuning Advisor etc. Experience in SSIS Packages, SSRS Reports design and Tuning including Troubleshooting Client/Server Connectivity issues.