Naidu Vechalapu
Database Administrator
Hyderabad
Summary
Over 6.5 years of IT experience specializing in Microsoft SQL Database Administration for large and complex databases. Skilled in setting up SQL Server Configuration, Failover Clusters, High Availability solutions (Clustering, Log Shipping, Mirroring, Replication, Always On), performance tuning, and maintenance. Exceptional troubleshooting capabilities in MSSQL Database Administration on Production Servers. Knowledge of SQL Azure for database management.
Overview
7
7
years of professional experience
13
13
years of post-secondary education
Work History
IT Analyst
TATA Consultancy Services India Pvt Ltd
07.2023 - Current
- Reduced query execution time by 60% through advanced indexing and query refactoring.
- Worked closely with developers, analysts, and infrastructure teams to support application performance and scalability.
- Migrated a 1TB+ database with less downtime from SQL 2016 to SQL 2019.
- Implemented automated backup verification scripts, improving recovery reliability by 40%.
- Designed custom SSRS dashboards for real-time performance monitoring, reducing incident response time by 50%.
- Develop PowerShell and T-SQL scripts to automate routine tasks and alerts.
- Hands-on experience in installing, configuring, managing, monitoring, and troubleshooting Microsoft SQL Server standalone and SQL Failover cluster.
- Use tools like SQL Profiler, Redgate, and DMVs to monitor health, and resolve issues proactively.
- Design and maintain HA/DR solutions to ensure business continuity.
- Involved in migration from SQL Server 2012 to SQL Server 2017 and SQL 2016/2017 to SQL Server 2019.
Tech Lead
Cognizant Technology Solutions India Pvt Ltd
12.2021 - 03.2023
- Set up SQL Server instances across development, testing, and production environments.
- Analyze execution plans, optimize queries, and manage indexes to improve system responsiveness.
- Configure and maintain Always On Availability Groups, log shipping, and replication.
- Provide access to users based on their requirements.
- Daily activities include monitoring the database, checking error logs, checking the log file size and free space in the data drives, and connectivity of the databases.
- Checking the status of the backup, troubleshooting the failed backups, and restoring the databases.
Database Administrator
Medusind Solutions India Pvt Ltd
01.2019 - 12.2021
- Document database configurations, processes, and recovery plans.
- Installation, configuration, and upgrading of SQL Server 2008 R2, 2012, 2014, 2016, and applying service packs and hot fixes.
- Monitoring jobs, error logs, server space, and the health of databases and servers.
- Recovering the databases from backup in disasters. Implementing Point-in-Time Recovery solutions.
- Responsible for resolving and rectifying all production issues within service level agreements.
Education
B-Tech - CSE
Coastal Institute of Technology And Management
Vizianagaram, India 04.2001 - 01.2014
Skills
Databases: MS SQL Server 2008/2012/2014/2016/2017/2019
Operating Systems: Windows XP/NT, Windows server 2008/2008 R2/2012/2016/2019
Languages: T-SQL, SSIS, SSRS
Backup Tools: SQL lite speed, Commvault Backup, Service Now
Monitoring Tools: DPA, PRTG, IDERA
ITSM Tool: Service Now, Remedy, Fresh Works
Core Responsibilities
- Experience on Installing SQL Failover Cluster 2008/2008 R2/2012/2014 (Active-Passive/active-active).
- Hands on experience in installing, configuring, managing, monitoring and troubleshooting Microsoft SQL Server standalone and SQL Failover cluster.
- Hands on experience in Applying Service Packs and Security patches on standalone and Cluster environment.
- Involved in Migration from SQL Server SQL Server 2012 to SQL Server 2017 and SQL 2016/2017 to SQL Server 2019.
- Hands on experience in Implementation & Troubleshooting the Log shipping/Mirroring/Replication/Always on.
- Experienced in T-SQL, Performance Tuning, Query Optimization and Database Consistency Checks using DBCC Utilities and DMVs.
- Recovery of the database during crash or data Loss.
- Daily activities include monitoring the database, checking error logs, checking the log file size and free space in the data drives, connectivity of the databases
- Administering SQL Server High Availability and disaster Recovery strategies.
- Checking the status of Backup, troubleshooting the failed backups and Restoration of databases.
- Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
- Respond to incident/problem/request tickets assigned to our team and fix any database issues promptly.
- Experience on 3rd Party backup tools like lite speed, data keeper
- Involved in SSRS installation and configuration settings and troubleshooting performance issues during reports
- Experience in the business Intelligence (BI) like SSIS, SSRS.
- Knowledge on AWS and SQL Azure.
- Migrating SQL Databases from On Premise to Azure (Iaas) SQL Vms
- Backup Azure SQL DBs in Azure and Automation of SQL DB backups.
Disclaimer
(Demudu Naidu)
Timeline
IT Analyst
TATA Consultancy Services India Pvt Ltd
07.2023 - Current
Tech Lead
Cognizant Technology Solutions India Pvt Ltd
12.2021 - 03.2023
Database Administrator
Medusind Solutions India Pvt Ltd
01.2019 - 12.2021
B-Tech - CSE
Coastal Institute of Technology And Management
04.2001 - 01.2014