Life Insurance Engineer

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)

Contact this candidate