Chandra Shekhar

Experience

• 

  NIMSME (National Institute of Micro Small and Medium Enterprise)

  Jun 2012 - May 2013

  SQL Server Database Administrator (Trainded and worked as a Internship)

  Analyzing, trouble shooting, working with application connectivity and SQL Server issues. New SQL Server Installations of SQL Server 2005, 2008, 2012. Experienced in backups & restore. Applying Service packs and patches on regular intervals. Providing the SQL Server Security to the clients and end users. Experience on High availability and Disaster recovery concepts.Implementing Clustering and log shipping and mirroring. Executing the scripts in prod environment. Run profiler, trouble shoot and work with external partners. Performance Troubleshooting.Working on blocking and disk space related issues.Creating logins and providing the required permissions. Show less

• 

  OSoft Labs

  May 2013 - Jun 2015

  Associate Database Engineer.

  Installing, Supporting, maintenance, monitoring and testing SQL server 2008, 2008 R2 and 2012.Creating & maintaining the maintenance plans of the database for producing accurate results.Upgrading SQL server instances and its databases from lover version to higher versions (2008 to 2008 R2 version).Scheduling disk space alerts, Job failure alerts.Proficient with SQL Server tools, including Query Analyzer, Profiler and Data Tools.Performing the full backup, differential and Transactional-Log backup.Restoring the database if it necessary.Configuring DB mail alerts, created and Sent Alerts using DB mail feature.Configuring transaction replication and maintained in production environment.Creating and implementation of maintenance plans like re-organizing indexes and rebuilding indexes, update stats and check DB on daily and weekly basis to maintain and improve the database performance.Configuring and Monitoring the SQL Server High Availability features like Log Shipping and Mirroring for 24/7 production environment and troubleshooting. Show less

• 

  Unisys India

  Jun 2015 - Aug 2018

  Software Engineer as a Database Administrator(MS SQL Server DBA)

  Installing, Supporting, maintenance, monitoring and testing SQL server 2008, 2008 R2 and 2012.Creating Databases & maintaining the maintenance plans of the database for producing accurate results.Creating users and logins providing appropriate roles and permissions to servers.Creating linked servers and troubleshooting Upgrading SQL server instances and its databases from lover version to higher versions (2008 to 2008 R2 version).Scheduling disk space alerts, Job failure alerts.Proficient with SQL Server tools, including Query Analyzer, Profiler, SSMS.Performing the full backup, differential and Transactional-Log backup, Copy only Backup, File and File-group Backup, Partial Backup, Tail-Log Backup Taking Snapshot database backups and Restoring the database if it necessary.Using DB Mail Feature Creating and Configuring DB mail alerts, Troubleshooting DB Mail issues. Configuring transaction replication and maintained in production and UAT and Biz UAT environments.Performance Tuning and Monitoring SQL Server Profiler and windows performance monitor.Creating and implementation of maintenance plans like re-organizing indexes and rebuilding indexes, update stats and check DB on daily and weekly basis to maintain and improve the database performance.Configuring and Monitoring the SQL Server High Availability features like Log Shipping, Mirroring and Replication for 24/7 production environment and troubleshooting. Knowledge of implementing and managing Replication across sites. Show less

• 

  Infosys

  Sept 2018 - May 2024

  Technology Analyst

  .

• 

  HCLTech

  May 2024 - now

  Technical Lead