Rohit Kumar

Having experience in Microsoft SQL Server Database Administrator on SQL Server , 2008, 2005, 2000

 Proficient in Database Backup, Recovery and Disaster Recovery procedures.
 Familiarity with SQL server 2005
 Installation of SQL Server 2000,2005 /SQL Server 2008
 Plan and implement backup, recovery strategy.
 Backups and Restoration of production databases.
 Performance tuning and troubleshooting
 security privileges,automation of maintenance plans,jobs,
 Hands on Experience in log-shipping.
 Involved in configuration of log-shipping in DC - DR server
 Hands on Experience in DC - DR Drill.
 Involved in configuration of cluster.
 Hands on Experience in clustering.

ROLES

 Monitoring and troubleshooting sql server 2008R2
 checking the error logs and sqlserver error logs
 using sql server profiler, database engine tuning advisor tool for better tuning
 Troubleshoot performance problems, fine-tuning of databases and index Analysis
 database mirroring
 updating and fixing patches if required
• Responsible for performance tuning and index tuning.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Responsible for change managements, created the documentation for SQL Server and Service packs installations.
• Complete documentation about the database.