Nagaraju Madhava

• 5 Years experienced analytical Senior-level software developer with deep expertise in SQL DBA.
• Database Administrating with proficiency in SQL Server, 2008 and 2008R2, 2012, 2014 in Production/UAT Environment.
• Involved in Installation, configure MS SQL Server versions in Windows environment.
• Migrating databases from SQL server 2008 R2à2012à2014.
• Implementing and managing Transactional/Snapshot/Peer to Peer Replication across multiple sites
• Performing and maintaining all types of Database backups and recovery operations.
• Performing Maintenance tasks like rebuilding/reorganizing indexes and update statistics and checking database integrity on regular intervals.
• Identifying and monitoring Memory usage, CPU utilization, Cache hit, Physical reads counters required for Performance Tuning using Performance Monitor.
• Proficiency in Query optimization and improve Performance using SQL Profiler, Execution Plan, Tuning Advisor and DBCC.
• Resolving Space management issues like Database and Temp DB space issues
• Identifying and resolving fragmentation and index-statistics issues
• Proficient in coding and developing the new applications.
• Exceptional communication skills feeding an ability to understand and interpret the operational needs of businesses at all levels.
• Moving data using Import & Export wizard, BCP and Bulk-insert.
• Creating and managing User/Groups and Logins.
• Experience in high availability options – Clustering, Replication, Log shipping, Mirroring etc.
• Working with new SQL Server 2014 features.
• Working with traces, analyzing trace data.
• Experience in Index Fragmentation Internals, Analysis, and Solutions.
• Experience in Deadlock Analysis and Prevention.
• Work experience in Detecting and Correcting Database Corruption.