GANGARAJU

SUMMARY

Having around ** years of SQL Server Database Administration experience in production support environment.

Work experience in 24x7 Production support for SQL Server 2005/2008R2,2012/2014,2016,2019

Handled more than 4000 servers, and 2500 instances and 10000 Database of MS SQL Server.

Experience in Installation and Configuration in different versions like SQL Server 2005 and 2008 and 2008R2 and 2012,2014,2016,2017,2019.

Experience in service pack installation on SQL server always on environment.

Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options.

Experience in performing regular Backups and scheduling tasks

Checking the status of Backup troubleshooting the failed backups and Restoration of databases

Managing Security (Creating users, logins and roles, granting permissions)

Migration of databases between the servers

Fixing Orphaned users through Stored Procedures

Resolving the Disk space issues and finding the root cause and implementing the permanent fixes

Implementation of Database maintenance plan

Upgrading the environment from SQLSERVER 2012 to SQL SERVER2014 in AG

Worked on SQL Server high availability like Log Shipping, Mirroring, Always ON.

Experience in SQL Server high availability (Replication, Log Shipping and Mirroring, Clustering)

Experienced in Team management, Bug/Enhancement Tracking, Client correspondence, Support, Training, Work allocation, Task management.

Well versed in Application Performance tuning using Microsoft Technologies.

Extensive hands on experience in Incident Management, Problem Management, and Change Management on tools and escalation procedures, situations handling and on-call process.

Excellent analytical, communication skills, work ethics and ability to work in a team environment with strong determination and commitment to the deliverables

Self-motivated, creative team player with effective communication and Leadership qualities.

PROFESSIONAL EXPERIENCE:

Working as Senior SQL Database Administrator in Saudi Networkers Services, Riyadh from Jun 2019 to till date

Worked as SQL Database Administrator in Wipro Limited, Bangalore from Jan 2018 to Jun 2019

Worked as SQL Database Administrator in IBM India Pvt Ltd, Bangalore from June 2015 to Jan 2018

Worked as SQL Database Administrator at IDC Technologies Sol(i) Pvt Ltd, Noida from Nov2010 to May2015

ACADEMIC PROFILE:

MCA: Awarded in the year 2010 from JNT University, Hyderabad.

SKILLS PROFILE:

Organization

Saudi Networkers Services

Designation

SQL SERVER Database Administrator

Platform

SQL server 2008&R2, 2012, 2014, 2016,2019

Team Size

3

Description: An associate of the HSBC Group, SABB is a leading corporate and institutional international bank in the Kingdom, with a leading retail banking and wealth management proposition. SABB is also a leading player in trade finance, foreign exchange, equity and debt wholesale banking and advisory

Responsibilities:

Installation of SQL Server 2012,2014,2016,2019

Monitoring backups of all databases on daily basis troubleshoot the issue and get it resolved.

Worked on Security configuration.

Worked on SQL Server Up gradation 2012 to 2016, 2012 to 2019.

SQL Database refresh from production to Stage servers

Installing latest Service packs on the servers from time to time

Automating all tasks and SQL Database maintenance activities like Backups, Restoring, Re-indexing.

Worked on Jobs and maintenance plans.

Ensuring Data consistency in the database through DBCC commands

Configuring, Monitoring and troubleshooting DB Mirroring and ALWAYS ON AG, SRDF Replications.

Configuring, Monitoring and troubleshooting of Clustering.

Performing Health checks of all the servers in support Environment

Monitoring the Disk spaces and resolving the space issues on all the SQL Servers.

Analysing, Identifying and resolving performance issues Like Blocking & Deadlock.

Attending Meeting on Daily basis for upcoming tasks and Bottle necks.

Coordinating with onsite support team

Monitoring and sending health check reports to team

Providing 24X7 On-Call support for critical production database

Operating systems

Windows Server 2003/2008/2008R2 /2012&R2

SQL server

SQL server 2008&R2, 2012,2014,2016

Monitoring Tool

SCOM

Ticketing Tool

E-Helpline, Service Now, BMC ready

PROJECT PROFILE:

Organization

WIPRO LTD

Designation

Senior SQL SERVER Database Administrator

Platform

SQL server 2008&R2, 2012, 2014, 2016

Team Size

25

Description:

Wells Fargo & Company is an American international banking and financial services holding company headquartered in San Francisco, with "hub quarters" throughout the country. It is the world's second-largest bank by market capitalization and the third largest bank in the U.S. by assets. In July 2015, Wells Fargo became the world's largest bank by market capitalization.

Responsibilities:

Installation of SQL Server 2008,2008R2, 2012,2014,2016

Worked on SQL patching with Automation tools.

Worked on Security level configuration like database permission.

Worked on SQL Server Up gradation 2012 to 2014 and 2014 to 2016 in AG Environment.

Installing latest Service packs on the servers from time to time on 2012, 2014, 2016 servers.

Worked on Jobs and maintenance plans.

Configuring, Monitoring and troubleshooting DB Mirroring and ALWAYS ON AG.

Performing Health checks of all the servers in support Environment

Monitoring the Disk spaces and resolving the space issues on all the SQL Servers.

Analysing, Identifying and resolving performance issues Like Blocking & Deadlock.

Attending Meeting on Daily basis for upcoming tasks and Bottle necks.

Organization

IBM PVT LTD

Designation

SQL SERVER Database Administrator

Platform

SQL server 2008&R2, 2012, 2014

Team Size

11

Description:

Wolters Kluwer Tax & Accounting is one of the world’s largest providers of tax, accounting, and audit information, solutions, and services. The division delivers solutions that integrate deep local knowledge with leading workflow technology solutions; helping professionals worldwide navigate complex regulations and requirements to ensure compliance with accuracy and efficiency.

Responsibilities:

Installation of SQL Server 2008,2008R2, 2012,2014

Monitoring backups of all databases on daily basis troubleshoot the issue and get it resolved.

Worked on Security configuration.

Worked on SQL Server Up gradation 2012 to 2014 in AG Environment.

Installing latest Service packs on the servers from time to time

Automating all tasks and SQL DB maintenance activities like Backups, Restoring, Re-indexing etc.

Configuring, Monitoring and troubleshooting ALWAYS ON AG.

Performing Health checks of all the servers in support Environment

Monitoring the Disk spaces and resolving the space issues on all the SQL Servers.

Analysing, Identifying and resolving performance issues Like Blocking & Deadlock.

Attending Meeting on Daily basis for upcoming tasks and Bottle necks.

Organization

IDC Technologies Sol(i) Pvt Ltd

Designation

SQL Database Administrator

Platform

SQL server 2005, 2008

Team Size

6

Description:

Max Life Insurance, one of the leading life insurers, is a joint venture between Max India Ltd. and Mitsui Sumitomo Insurance Co. Ltd. Max India is a leading Indian multi-business corporate, while Mitsui Sumitomo Insurance is a member of MS&AD Insurance Group, which is amongst the top general insurers in the world. Max Life Insurance offers comprehensive life insurance and retirement solutions for long-term savings and protection to thirty lakh customers. It has a country-wide diversified distribution model including the country's leading agent advisors, exclusive arrangement with Axis Bank and several other partners.

Responsibilities:

Installation of SQL Server 2000, 2005, 2008 and 2008R2;

Refreshing the UAT/Dev databases from production as per request basis.

Installing latest Service packs on the servers from time to time.

Worked & managed support to Environment of more than 150 Database Servers;

Worked on Fixing Orphaned users.

Requested refreshes pre or post restore activities

Managed security by defining roles and rights;

Worked on high availability Log shipping

Troubleshoot system issues, monitor scheduled jobs and set up maintenance plans for proactively monitoring the performance of all SQL Server databases including monitoring failed and long running MS SQL Server jobs.

Certifications:

70-462 Administering Microsoft SQL Server 2012

Contact this candidate