Harsh Bhatt

Experience

• 

  Pousse Management Services Pvt. Ltd

  Apr 2016 - Jun 2016

  Computer Operator
• 

  Renaissance Global LTD.

  Jul 2016 - Nov 2021

  SQL Database Administrator

  • Database Installation and Configuration for all MS SQL Database Versions.• Performed regular maintenance tasks such as updating database software, applying patches, and upgrading to new versions to ensure the database system remains up-to-date and secure.• Defined and implemented event triggers to alert potential database performance issues.• Designed database backup, archiving, and storage strategy.• Manage configuration of databases by installing, upgrading software, and maintaining documentation.• Developed and implemented optimized database structures including schemas, tables, and indexes to fulfill the organization's objectives.• Collaborated with developers to build and test scripts for database load testing on the Dev/Test server Show less

• 

  PMC Retail

  Nov 2021 - Jun 2024

  Database Administrator

  • Installation and configuration of SQL Server 2005, 2008, 2008R2,2012 and 2019 on remote systems and Cloud.• Performing Database maintenance activities like Backups, Restoring.• Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis. • Maintaining the Security of the Database, assigning responsibilities as part of Security.• Handling blocking and Deadlock issues and troubleshooting accordingly.• Performed Log Shipping and implemented Mirroring as High Availability techniques also working on AlwaysOn Availability Group.• Monitoring/Maintaining HA options being used in servers Log-Shipping, Replication, Mirroring and AlwaysOn Group.• Set up monitoring and alerting using AWS CloudWatch.• Monitored SQL Server Logs, OS Logs for Troubleshooting the Issue.• Trouble shooting database and Space management issues to maintains the SQL Server to provide maximum availability.• Responsible for ensuring that storage, archiving, backup, and recovery procedures are functioning correctly and Transaction log files.• Provided 24*7 Production support for the database and application issues.• Working with SSRS/SSIS And T-SQL.• Backup and recovery of Databases on daily and weekly basis and tracking the processes.• Database Purging Activities Based on Client Requirement and Production Database Archiving. Show less