• 3+ years of experience in SQL Server Database Administration, Database Design and Support of MS SQL Server 2016/2014/2012/2008R2/2008/2005 in Production, Test & Development environments. • Performed Database migrations from SQL server 2005/2008 to 2012/2014/2016. • Worked on Database refresh and DB refresh without disturbing views as well. • Performed Database migration from on-premises to AWS EC2 Server. • Deployed SQL Server in AWS RDS. • Handled Monitoring and Tuning SQL Server and database performance using SQL Profiler, Database Tuning adviser and Windows Performance Monitor. • Worked on Query performance tuning and index tuning. • Implemented Mirroring, Log Shipping and reverse log shipping. • Implemented always on availability groups in SQL server 2016 and SQL Server failover clustering. • Performed SQL server installation and patching in test and prod environment. • Implemented table Partition by creating Partition function, Partition scheme and multiple file groups and files to host the table data for Data partitioning. • Worked on SQL Server and Database security activities by creating logins, users and assigning permission to them. • Configured Maintenance plan for Backups, Database Integrity checks, Rebuild index, update statistics and clean up task. • Good knowledge of MS SQL Server 2016 implementing new features like Query store, Dynamic data masking, Row level security, Stretch database and in memory OLTP. • Performed SSIS package deployments and created SQL agent job to run SSIS packages. • Created linked servers, synonyms, Schemas and Worked on database deployments in test and prod. • Created Database mail, alerts and notifications. • Knowledge of SQL Server t-sql DML, DDL, Joins, views, stored procs, table variables and temp tables.