Ø 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