Gadiparthi Ajay babu

Database Administrator
Contact: +49-15510607211 , ajay.gadiparthi1525@gmail.com

PROFILE SUMMARY

SQL DBA with over 5 years of successful experience in IT industry designing and managing database solutions
for industry verticals like healthcare, banking and Public domain. Enthusiastic professional eager to contribute to
team success through hard work, attention to detail and excellent organizational skills.

PROFESSIONAL SUMMARY

 Provided 24x7 production support for SQL Server databases on standalone and Clustered Servers with
sizes ranging from 100s of GB to 20+ TB to achieve maximum performance and uptime in production
environment
 Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2019, 2017,
2016, 2014, 2012, 2008R2, 2005.
 Good experience in Database design & architecture.
 Good Experience in Backup & Recovery scenarios.
 Good experience in implementing High Availability & Disaster Recovery solutions using Always ON,
Clustering, Replication, Mirroring and Log Shipping.
 Expert in Troubleshooting, Optimization and Performance tuning of SQL Server database server (Ex.,
Query Tuning, Server Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.).
 Handling locking, Blocking & Deadlock Scenarios.
 Expertise in Index tuning, rebuild, reorg strategies.
 Experience in Data Centre Migration Activities.
 Good knowledge and understanding of Virtualization
 Good knowledge & experience on Cloud Computing in Azure.
 Hands on experience in virtual machines, virtual network, Azure storage, Azure active directories,Azure
Subscriptions, azure polices, Azure DNS, Azure Load Balancer and AutoScaling.
 Extensively worked on system analysis, design, development, testing and implementation of projects
(SDLC) with different methodologies like Agile, Scrum & Waterfall etc. and capable of handling
responsibilities independently as well as a proactive team member
 Performing the Failover and Failback operations in the cluster environment and adding the new
Disks and troubleshooting activities.
 Configuring and Maintaining and troubleshooting the Database mirroring and experience in Mirroring
DR activities.
 Configuring and Maintaining and troubleshooting the Database Log Shipping, always-on and Replication
 Closing the tickets within the SLA time and Monitoring the SLA.
 Experience Disaster recovery procedures, point-in-time recovery on request
 Troubleshooting various problems that arise in a day-to-day work and fixing the issues
 Performing Integrity checks of databases and Index optimization
 Interacting with different teams for good communication
 Worked as a database administrator for MS SQL Server databases, and supported applications with
efficient back-end processing.
  Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan,
Performance Monitor and DBCC Commands.

TECHNICAL SKILLS:

 Database Version: SQL Server 2000,2005, 2008R2, 2012, 2014, 2016, 2017
 Windows Platform: Windows 2012, 2008 R2, Windows 2003
 Cloud: Azure
 Tools Used: SSMS, ServiceNow, BMC Remedy, Avamar.

WORK EXPERIENCE
Database Administrator SEP 2019-PRESENT
TATA CONSULTANCY SERVICES
ICS,Drysign UK
Responsibilities:
 Providing 24*7 Database production support to the customer which includes following activities.
 Installation and configuration of MS SQL Server 2008R2, 2012,2014,2016.
 Migrating databases from SQL Server 2008R2 to 2012 and 2016.
 Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database
integrity, identifying missing Indexes, handling blocking
 Configuring and troubleshooting high availability scenarios like Log Shipping.
 Implemented Database Mirroring with High Availability Mode in SQL 2008R2
 Maintained & Monitored Alert/Schedule to make smooth replication process.
 Ensure and maintain sound backup and recovery policies and procedures.
 Database performance monitoring and tuning when required as per application and business
requirements.
 Performing the Cluster installation and adding the nodes in the respective servers in SQL Server 2008R2,
2012,2014,2016.
 Handling requests like database creation/deletion, table creation/deletion, database reorganization, user
management, permissions, backup/restore, job scheduling etc.
 Provisioning new SQL server installation, configuration, optimization, performance tuning, clustering,
high availability configuration (AOAG).
 Providing SQL support to application to troubleshoot production issues.
 Database maintenance like index rebuild/reorganize, data integrity verification, disk capacity planning,
shrink/expand transaction logs.
 Applying latest patches/service packs/cumulative updates to production SQL servers and monthly service
restarts / AOAG failover – failback.
 Monitoring SQL health (deadlocks, long running queries, page life expectancy, parallelism, cost of
threshold, memory, etc.)
  Database migration from lower version of SQL server to higher version of SQL servers.
 Performing the Failover and Failback operations in the cluster environment and adding the new Disks and
troubleshooting activities.
 Backup and restoring the databases from production to test environment.
 Identifying and Resolving the issues like blocking, dead lock, disc space, database corruption and file
growth related.
 Monitoring of server performance using profiler and perfmon tools.
 Configuring and monitoring the Database Mirroring and Log Shipping.
 Trouble shooting and resolving blocking, deadlock, and disk space issues.
 Ensuring Data consistency in the database through DBCC commands.
 Migration and up gradation of servers and databases
 Repetitive issues analysis and proposals for permanent resolutions.
 Working on ISight ticketing tool for ticket management.
 Taking backups from production servers and restoring them on Stage& dev servers.

ASSOCIATE CONSULTANT
MAY 2017- SEP 2019
INFOSYS LIMITED
Eli Lilly, USA.

Responsibilities:

 Design, implement and administer databases on MS SQL Server 2012/2014 platforms for OLTP.
 Managed over 200+ database servers monitoring, working on incidents and providing support.
 Fine Tuning Server/Database level setting for optimal performance.
 Involved in data center migration activities for SQL Server.
 Experienced in designing database and code with proper Isolation level to avoid locking and deadlock
scenarios. Implemented SSRS in SharePoint Integration mode for content & document management.
 Implemented SQL Server OLAP services(SSAS) for building data cubesImplemented Columnar Data
Store Index for faster response.
 Extensive experience in Troubleshooting and Query Tuning complex SQL Code, Stored Procedures,
Triggers, Views etc., by analyzing wait stats, Execution plan & updating statistics.
 Proficient in analyzing I/O, CPU, Memory issues and providing fix using Ignite tool and DMVs.
 Troubleshooting log file space issues, tempDb contention.
 Ensuring Database security by restricting and following corporate standards.
 Perform query optimization & performance tuning using tools like SQL Profiler, SQL Query Analyzer,
Index Tuning Wizard, Database Engine Tuning Advisor, DBCC commands, DMVs
 Migrated & Configured SSIS in 2012 version using environmental variables
 Setup and maintain documentation and standards
EDUCATION
B.sc:- Computers , from Acharya Nagarjuna University 2010-
2013