Ø Database administration for various SQL Server versions 2008R2/2012/2014/2016 and mitigating Production
support.
Ø 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 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