Nagaraju Bandaru
Mobile: +91-917*******
Email- :***********@*****.***
Summary of Qualifications
An accomplished DBA with 5.8 years of hands-on experience as a SQL SERVER DBA in managing large-scale databases in production support environment on windows platform hosted in Hybrid Cloud environments. Primary focusing on DBA support and having good hands on experience in supporting different versions of SQL Server like SQL Server 2008,2008R2, 2012,2014 and 2016 in Hybrid cloud environment (AZURE/Azure and On-Prem).
Profile Summary
Having 5.8 years of experience in IT industry including the experience in Administration in Microsoft SQL server 2008/2008R2/2012/2014 and 2016 2016 in Hybrid cloud environment (AZURE/Azure and On-Prem).
Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008/2008R2/2012/2014 and 2016.
Good knowledge & experience on Cloud Computing like Azure/AWS
Good Experience in Backup & Recovery scenarios
Good experience in implementing High Availability & Disaster Recovery solutions using Always ON, Clustering, Replication, Mirroring and Log Shipping
Monitoring Database Mirroring and Always on Ensuring High Availability to the databases by testing the failover.
Creating and Monitoring the Maintenance plans – scheduling tasks to run daily and/or on weekends tasks like rebuilding indexes, defragmenting Databases, Shrink Database.
Experience in Troubleshooting, Optimization and Performance tuning of SQL Server database server (Ex., Query Tuning, Disk Performance Monitoring, Memory Pressure, CPU bottleneck etc.)
Maintained Database Authentication modes, Creation of user, configuring permissions and assigning roles to users.
Handling locking, Blocking & Deadlock Scenarios
Experience in DR activities
Experience in Data Centre Migration Activities
Provided 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging from 100s of GB to 10+ TB to achieve maximum performance and uptime in production environment.
Ability to upgrade skills continuously and flexibility to accomplish targets successfully.
Excellent interpersonal and communication skills. Work as part of a team member and work independently. Provide 24 7 supports when required.
Professional Experience
Worked as Database Administrator at ITC Infotech, Bangalore From May 2014 to April 2016
Worked as Database Administrator at Wipro Technologies, Chennai since June 2016 to Sep 2017.
Working as SQL DBA / Sr. Engineer at Guardian Life insurance company of America -Chennai, from Oct 2017 to present
Technical and Process Certifications:
MCTS (70-432): Microsoft SQL Server 2008 – Implementation and Maintenance
Education
Completed graduation in B.Tech [E.E.E] from Gitam University in 2014, Hyderabad.
Technical Skills
Operating Systems - Windows 98 / XP / Vista/Seven/Eight, Windows Server 2003, 2008 R2/2012
Programming Languages - T-SQL
Database - SQL Server 2008,2008R2,2012,2014,2016
Applications /Tools - MS-Office 2003,2007,2010,2012, SSMS, Power shell, AppDynamics, DMVs, DBCC Commands, Red Gate, Fog light, Zenoss
Development Tools -Visual Studio 2015,2017,2019
SQL Server Tools -SSMS, Profiler, Performance Monitor, DTA, extended events, query analyzer.
Backup Tools -Commvault, LightSpeed, TSM
Ticketing Tools -Service Now, IBM Remedy, SysAid
Professional Experience: Guardian Life Insurance company of America, Sr. Engineer
Client #1 : Guardian Life Insurance company of America (www.guardianlife.com)
Team Size : 7
Role : SQL Database L2 Administrator
Environment : SQL Server 2008R2/2012/2014 and 2016, windows server 2005/2008R2/2012
Duration : June 2016 to present.
Description:
The Guardian Life Insurance Company of America is one of the largest mutual life insurance companies in the United States. Based in New York City, it has approximately 8,000 employees in the United States and a network of over 3,000 financial representatives in more than 70 agencies nationwide. As of 2018, it ranks 239th on the Fortune 500 list of largest United States corporations by revenue. In 2015, Guardian achieved the highest earnings in its 155-year history with $7.3 billion in capital and $1.5 billion in operating costs. Founded in Manhattan in 1860, the company offers a wide range of insurance products and services, including life insurance, disability income insurance, annuities, investments, dental, and vision.
Roles & Responsibilities:
Supporting various databases and server level support on various database issues like backups, database restore, storage space maintenance and job scheduling and job failures.
Installation and configuration of MS SQL Server 2008R2, 2012, 2014 and 2016.
Design, implement and administer databases on MS SQL Server 2008r2/2012/2014/2016 platforms for OLTP
Upgrading of SQL Server Instances from 2008 R2 to,2014,2016
Migrating on-premises SQL Server Database to Cloud (AWS/Azure)
Implemented new SQL Server features by performing successful POCs
Experienced in providing analysis on High availability/Disaster recovery & scalability
Good Understanding & Knowledge on Cloud computing architecture, technical design and implementations including Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and Software as a Service (SaaS)
Experience in managing Very Large databases (VLDB) and troubleshooting problems
Use of Query Store feature for monitoring performance of database systems
Good knowledge on Networking concepts and Protocols
Have Good understanding & experience on different RAID levels and BLOB storages.
Configuring database instances for Development and Testing purpose.
Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking
Troubleshooting issues related to SQL connectivity, app pool configuration, password expiry, network issues, SQL log space, disk space issues, and performance issues like memory, processor usage on web and SQL servers.
Attending CAB meetings.
Execution DDL, DML commands in order to troubleshoot application related issues WRT tickets.
Creation of Logins, Roles and granting rights, Assigning Permissions and Mapping user databases as per the client’s requirements.
Proficient in using Dynatrace and Fog light to troubleshoot performance issues from Application layer to database layer
Good Knowledge in TFS 2015/2017/2019
Professional Experience:
Wipro Technologies, Chennai L1 and L2 SQL DBA
ITC infotech, Bangalore, -L1 level SQL DBA
Client #1 : MasterCard International [USA] (WWW.MASTERCARD.COM)
Client #2 : PecificLife Insurance [USA] (www.pacificlife.com)
Team Size : 12
Role : SQL Database L1 and L2 Administrator
Environment : SQL Server 2008R2/2012/2014 and 2016, windows server 2003/2005/2008R2
Duration : June 2016 to Oct 2017
Roles & Responsibilities:
Supporting various databases and server level support on various database issues like backups, database restore, storage space maintenance and job scheduling and job failures.
Installation and configuration of MS SQL Server 2008R2, 2012, 2014 and 2016.
Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects.
To reduce threat to the environment identified users having SYSADMIN rights and relegate them to the appropriate rights.
Planed phased implementation of security patches in coordination with application team to minimize downtime to end users.
Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking
Troubleshooting issues related to SQL connectivity, app pool configuration, password expiry, network issues, SQL log space, disk space issues, and performance issues like memory, processor usage on web and SQL servers.
Execution of select, update queries in order to troubleshoot application related issues.
Creation of Logins, Roles and granting rights, Assigning Permissions and Mapping user databases as per the client’s requirements.
Responsible for proper scheduling, running and monitoring various SQL server jobs using SQL server Agent.
Updating and maintenance of service account passwords for various SQL services.
Monitoring the Disk Space on the Microsoft Internal and External Servers based on Windows Server 2003 in production, Staging and Development environments.
Automating Administrative Tasks using SQL server Agent, SQL services
Monitoring and maintaining the optimum Disk spaces and log size of Databases, DBSS checks.
Involved in Migration and Up-gradation of SQL server.
Having good knowledge in checking application related errors using IIS & event viewer logs
Troubleshooting issues such as High CPU, Slow Queries, Server Slow, blockages etc
Personal Details:
Father’s Name : BANDARU SIVA KOTESWARA RAO
Mother Name : BANDARU SIVA DURGA
Date of Birth : 05-Jun-93
Marital Status : Single
PAN Number : BTCPB6722J
(Nagaraju Bandaru)