Summary
Overview
Work History
Education
Skills
Timeline
Generic

Madhu Thella

Hyderabad

Summary

Hands on experience with over 12 years of experience in managing complex database systems.
Expert in SQL Server with a strong focus on ensuring data integrity, performance tuning, and disaster recovery planning and Azure SQL databases

Overview

12
12
years of professional experience

Work History

Lead Database Administrator

TechMahindra
Hyderabad
11.2016 - Current
  • Handling of 80+ Servers (2 Clustered servers) to provide DBA responsibilities, which includes Production, Disaster Recovery servers, Test, DW servers in the environment.
  • Handled DBA team on assigning tasks at regular intervals and meets project deadlines on time
  • Configured, installed, and administered from SQL 2012 to SQL 2022 version in terms of security, server settings, and DB settings as per Microsoft standards.
  • Documented processes related to installation, configuration, upgrades, migrations of various versions of SQL Server environments.
  • Assisted in the migration of legacy systems into current SQL Server environment while ensuring data integrity throughout process.
  • Identified opportunities for improving query execution time through indexing strategies or other tuning approaches.
  • Performed capacity planning activities such as estimating future storage requirements based on projected growth rates.
  • Monitored system performance, identified potential issues and provided recommendations to improve system efficiency.
  • Developed successful Backup strategies based on Client requirement/ Recovery models
  • hands on experience on trace events through SQL Profiler for blocking and deadlocks
  • Always-on availability configuration for SQL databases, administration of databases to ensure databases are healthy.
  • Configured DB mail, triggers to notify (DDL/DML) executions on databases.
  • Created custom, specific roles and alerts for jobs.
  • Created Shrinklog job on server based on recovery models.
  • Successfully set up disaster recovery for SQL databases and tested on sandbox environment with application team.
  • worked on Azure SQL databases for creating login, users and mapping permissions in the environment

Junior Database Administrator

Dhanush Infotech Pvt Ltd
Hyderabad
07.2012 - 10.2016
  • Installed, configured, and administered SQL databases of 2005/2008 version
  • Performed backups of databases by setting up backup schedules at regular intervals, and restored databases whenever required.
  • Created SQL logins and database users, and mapped permissions based on requirements.
  • Created stored procedures, triggers, indexes, views and other database objects as needed.
  • Created maintenance plans – scheduling tasks like rebuilding indexes, defragmenting databases, shrinking databases, and backing up databases.
  • Created Windows-level users at Active Directory and delegated appropriate permissions to users at SQL level.
  • Ensured high availability of the databases with options of DB mirroring, Log Shipping, and replication methods.
  • Created, Monitored, and Troubleshot SQL server agent jobs.

Education

Computer Science Engineering -

Vivekananda Institute of Tech & Science - JNTU
HYDERABAD
05-2009

Skills

  • Microsoft SQL
  • Disaster Recovery Planning
  • Database migration
  • Performance Tuning
  • Capacity Planning
  • Database Management
  • Database analysis
  • Database Administration
  • Azure SQL database

Timeline

Lead Database Administrator

TechMahindra
11.2016 - Current

Junior Database Administrator

Dhanush Infotech Pvt Ltd
07.2012 - 10.2016

Computer Science Engineering -

Vivekananda Institute of Tech & Science - JNTU
Madhu Thella