Database administration for various SQL Server versions 2008R2/2012/2014/2016 and mitigating Productionsupport. Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2008R2/2012/2014/2016/2017. Analyzing query structure and performance related issues, Worked on various query optimization tasks with application teams, worked on clustered and non-clustered indexes. Worked on various issues for servers in Always on , analyzing sync up issues. Have skills to deploy package through ETL, troubleshooting job failure issues. Trouble shooting database consistency problems after analyzing logs and fixing those errors. Designed packages in ETL to automate and put sql server queried data to FTP server. Analyzing dead lock issues with help of trace and rectified them to improve performance. Worked on various replication technology i.e snapshot ,Merge and Transactional . Configured Mirroring and Log shipping for migrating large databases in shorter span of time. Worked on different issues Related to DB mail , SMTP server. Managing security related request with minimal rights to databases . Worked on different SQL Server hardening parameters. Migration of log shipped database server to new server