Anil Ramanaboyena

About Anil Ramanaboyena

I have 12 years of experience in SQL Server DBA | Windows PowerShell |Power Automate | SSIS | SSRS | Azure SQL DBA | PowerBI. Hands on experience in installation, managing, monitoring, and troubleshooting of MS SQL Servers and 2014 and 2106 & 2017,2019 Versions. Hands on experience in interaction with business users, end users to gather requirements, clarify issues, training and coordinate with them in various phases of projects to provide end-to-end solutions. Hands on Experience in performing regular Backups, scheduling tasks, and restoring the databases. Strong troubleshooting, solving problems skills and strong ability to prioritize multiple tasks. Experience in Performance Tuning, Query Optimization, Indexing and Database Consistency Checks using DBCC. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support. Using tools like SQL Server Profiler, perfmon and other tools for trace analysis. Strong working experience in building log-shipping between the servers and troubleshooting the issues. Hands on experience in configuring Database Mirroring and Ensuring High Availability to the databases by testing the failover. Configuring, administering, and troubleshooting HADR processes like Clustering and Always On. Hands on experience in Cluster Failover & Failback. Hands on experience 2012 to 2019 migration. Strong working experience in Configuring, Deploying & Troubleshooting for SSIS packages. Strong working experience in Configuring, Deploying & Troubleshooting for SSRS RDL files. Strong working experience in Windows PowerShell scripting. Strong working experience in Power Automate workflows. Strong working experience in Azure SQL DBA. Strong working experience in Veeam Replication Console. Strong working experience in PowerBI Reports. Strong working experience in DBATOOLS Commands. Strong working experience in Solar Winds(DPA) & SQL SentryOne tools. Good knowledge in AWS. Ability to Adopt quickly to the environment and Ready to work in shifts. Incident Management – Day-to-Day DBA Operations and troubleshooting.

Experience

1. Senior Technical Lead

   HCLTech

   Dec 2024 — Present · Bengaluru, IN

   Total 12+ years of experience in SQL Server DBA in Production Support of MS SQL Servers 2005/2008/2008 R2/ 2012/ 2014 /2016 and 2017,2019 Versions. Experience in installation, managing, monitoring, and troubleshooting of MS SQL Servers and 2014 and 2106 & 2017,2019 Versions. Hands on experience in Database Backup and Recovery procedures Experience in performing regular Backups, scheduling tasks, and restoring the databases. Good experience in troubleshooting failed backups & restores databases. Good experience in moving system databases and troubleshooting system databases issue. Creating and Configuring SQL Jobs & Maintenance plans. Troubleshooting Linked server’s connectivity issues. Strong troubleshooting, solving problems skills and strong ability to prioritize multiple tasks. Experience in Performance Tuning, Query Optimization, Indexing and Database Consistency Checks using DBCC. Troubleshooting Sproc performance issues. Monitoring the Disk spaces on all the servers & Troubleshooting Disk space issues Good experience in Configuring log-shipping between the servers and troubleshooting the issues. Hands on experience in configuring Database Mirroring and Ensuring High Availability to the databases by testing the failover. Configuring, administering, and troubleshooting HADR processes like Clustering and Always On. Implemented Always-ON (AG) on SQL Server 2012/2014/2016. Performing weekly deployments and maintenance activities. Hands on experience 2012 to 2019 migration. Good experience in PowerShell Scripting. Good experience in Azure SQL databse Good experience in SSIS & SSRS Good experience in Power Automate Desktop. Good experience in PowerBI

Education

• Jawaharlal Nehru Technological University, Anantapur

  B-tech, Electrical, Electronics and Communications Engineering

  2005 — 2009