Derangi Dhinesh Babu

Sql Database Administrator @Capgemini

Bengaluru, IN

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users. Rebuilding the indexes at regular intervals for better performance. Designed and implemented the comprehensive Backup plan and disaster recovery strategies. Involved in troubleshooting and fine-tuning of databases for their performance and concurrency Monitored and modified Performance using execution plans and Index tuning. Rebuilding the indexes at regular intervals for better performance. Troubleshoot performance problems and fine-tune databases. Involved in Index Analysis and Performance Tuning. Migrating SQL Server 2008R2 R2 bases into SQL Server 2012. Recovering the databases from backup in disasters. Monitoring Log shipping and troubleshooting of errors. To analyse long-running slow queries and tune them to optimise application and system performance. Execution of SSIS packages manually through SSDT. Involved in Bridge Calls on Crisis and attending the Calls from end users. Involved in migrating and upgrading the SQL Server from an older version to a newer version. Worked on end-user incidents. Initiating Proactive and Preventive DB maintenance and reacting well within SLA\'s Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) Test backups to ensure we can meet the business’s Recovery Time Objectives (RTO) Troubleshoot SQL Server service outages as they occur, including after-hours and weekends Configure SQL Server monitoring utilities to minimise false alarms As new systems are brought in-house, choose whether to use AlwaysON, clustering, log shipping, mirroring, Windows or other technologies.

Sri Venkateswara University

Bachelor's degree, Business/Commerce, General