Jagadeesh Babu Sql Server Dba

Mobile: +91- 8985583646 Mail Id: ivjbdba@gmail.com

Objective:

As SQL Server DBA, My primary goal is to develop innovative and effective database solutions that will meet the technical objectives of the company and support the execution of the company's projects. 

Summary of Experience:

I have 4.2 years of experience in 24/7 SQL server production support environment. Handling Change Management and Incident Management tickets and Resolving tickets

within SLA’s. Experience in installing, configuring, monitoring and trouble-shooting SQL Server

2005, 2008R2 and 2012. Experience in database Backup, Restoration, Disaster Recovery, Database

Maintenance Planning. Expertise in planning and implementing Database Security by creating users, Roles,

and assigning permissions to them Experience in high availability features, Log shipping, Database Mirroring and

Replication. Involved in improving efficiency of databases by re-indexing, updating statistics and

reorganizing indexes. Experience in Maintenance of data using various utilities like Import and Export,

Attach/Detach, Copy database wizard etc... Checking the consistency of Databases by using DBCC Commands. Checking the general Health of the servers for identifying Bottlenecks Monitoring SQL server performance using profiler, Performance Monitor and SQL

Diagnostic Manager. Experience in developing backup strategies and scheduling Alerts, Jobs. Coordinating with internal teams as per the team requirement.

Academic credentials:

Bachelor of Engineering in Information Technology

o Studied in Gates Institute of Engineering &Technology, JNTU Anantapur, AP.

Diploma from State Board of Technical Education and Training.

o Studied in Loyola Polytechnic College, Pulivendula, Kadapa, AP.

Secondary School from State Board of Secondary Education.

o Studied in Nalanda Vidya Bhavan High School, Hyderabad, AP.

Technical Expertise

RDBMS MS SQL Server 2005/2008R2/2012.

ToolsManagement Studio, Configuration Manager, SQL Server Profiler, Performance MonitorHPServiceManagement, and Remedy

Database SQL Server 2005/2008R2/2012

Career Highlights:

Working as a SQL Server Database Administrator for Sahitya Technologies Pvt Ltd, Hyderabad from August 2013 to till date.

Experience:

Project#1:

Client : Axa Insurance Singapore Private Limited (SINGAPORE)Team Size : 9 membersRole : Team Member

Roles and Responsibilities:

Involved in the process of Installation and Upgradation of SQL Server 2005 / 2008 R2 / 2012 followed by hot fixes, sp’s.

Implementation of Logins, creating Users, assigning responsibilities as a part of Security Policies for various categories of User Support.

Monitoring scheduled jobs of backup and restore procedure. Experience in performing regular Backups and troubleshooting the failed backups of

databases. Monitoring free space of database and disk space of all servers. Fixing Orphaned users through stored Procedures. Maintaining the Database Consistency with DBCC commands Involved in SQL Server Database Log shipping and troubleshooting. Involved in SQL Server Database Mirroring and troubleshooting. Involved in doing refresh between different domains and in Database mirroring. Troubleshoot long running Queries and Stored Procedures Checking Fragmentation and Resolving Fragmentation issues. Rebuilding and rebuilding the indexes, update statistics at regular intervals for better

performance. Experience in resolving blockings and Deadlock Issues. Troubleshooting transaction logs and tempdb when full.

Experience#1:

Organisation : Allen Reinforced Plastics Pvt. Ltd.Role : Database Analyst Environment : SQL Server 2008R2 / 2012Duration : Dec 2010 to July 2013

Responsibilities:

Installation and Configuration of SQL Server 2008R2 / 2012. Upgrading the server and applying the service packs and hot fixes. Creating logins and mapping the logins to the databases/roles, providing permissions. Creating and maintaining the SQL jobs and responsible for all the maintenance jobs alerts. Monitoring scheduled jobs of backup and restore procedure. Performing Database maintenance activities like Backups, Restoring, Re indexing etc. Analyzing, Identifying and Resolving performance issues of the server. Experience in high availability features, Log shipping and Database Mirroring. Tuning the slow performance queries and supported the development team. Identifying long running queries and taking appropriate action against them based on the

client permission. Monitoring log file space/data file space and shrinking whenever required. Fixing Orphaned users through stored Procedures. Involved in server decommission process.

Personal details:

Name : JagadeeshFathers Name : I MallikarjunaSiblings : 2 brothersNationality : Indian Date of birth : 14-04-1985Languages known : English, Hindi & Telugu.Passport Number : L1258309 (Valid Up to 22nd April 2023)Interests : listening Music, Making FriendsAddress : HNo 8-3-1108, Plot No 30, Near Saraswathi Vidhya Mandir School, Near HP Gas, Sri Nagar Colony,

Hyderabad - 500073.