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.