Sql database administrator
Resume:
NAGASIRISHA DANDE
Email : ************.***@*****.***
Mobile : +91-798*******
Profile Summary:
Having around 4.6 Years of Professional experience as a SQL server DBA in Production Environment and supporting L1 & L2 Support.
Currently working with Bharat Financial Inclusion Limited BFIL- Hyderabad.
Primarily working with SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017. Having hands on experience in administering SQL Server activities like Installation, Upgradation, Migration, Backup and Recovery, Log shipping, DB Mirroring, Performance tuning.
Key Responsibilities:
Work experience in 24x7 Support for SQL Server 2008/2008R2/2012/2014/2016/2017.
Experience in Installing, Configuring of SQL server 2008/2012/2014/2016/2017.
Experience in Day-to- Day Monitoring, Troubleshooting and Maintaining of SQL Server as a part of Pro Active Analysis and Approach.
Experience in implementation of SQL Logins, Roles and Authentication modes as a part of Database Security.
Experience in implementing, Scheduling & Troubleshooting of Database Maintenance Plans and Automation Jobs.
Implementing Backup Strategy for Production Databases.
Experience in Database Recovery, Restoration and Disaster Recovery Plans.
Experience in Up-gradation/Migration from MS SQL Server 2008 R2 to 2017.
Experience in finding and Fixing of orphaned users.
Experience in Implementing and Troubleshooting of High Availability Techniques like Log Shipping and Database Mirroring.
Exposure in Maintaining and Troubleshooting the Always-On High availability.
Analyzing the Disk space growth and preparing the Report.
Perform Index Tuning, Query Tuning and performance monitoring,.
Verifying and resolving the SQL Server Blocking issues; Finding and fixing the root cause.
Experience in usage of DBCC commands and DMV’s for troubleshooting.
Experience in supporting different Applications.
Capable of handling responsibilities independently as well as a proactive team member.
Professional Experience:
Currently Working With Bharat Financial Inclusion Limited BFIL- Hyderabad from April 2019 to till Date.
Worked With Unisys India Pvt Ltd from March 2018 – April 2019.
Worked With 3i Infotech as a SQL DBA from December 2015 to Feb 2018.
Academic Qualification:
Master of Computer Applications (MCA) from JNTUK in 2014.
Technical Skill Set:
Operating Systems : WINDOWS SERVER 2008, 2008R2, 2012, 2019
Programming languages : T-SQL
Database Technologies : MS SQL Server 2008, 2008R2, 2012, 2014,2016,2017
Tools : Service Now, Remedy, TSM, Redgate.
Hardware : IBM compatible PCs/Servers
Client- 1:
Client : IndusInd Bank
Duration : April 2019 to till date.
Roles & Responsibilities:
Working as part of a team and will provide 24x7 support.
Resolving the Customer Requests which are created in the form of Tickets within the SLA.
Monitoring SQL Server alerts at regular intervals.
Reporting and resolving serious SQL Server alerts.
Working with the Issues related to Configuration, Installation of SQL Server.
Working with the Issues related to Login/Access
Monitoring, Troubleshooting and Maintaining of SQL Server.
Working with Implementation of SQL Logins, Roles and Authentication modes.
Implementing, Scheduling, Troubleshooting of Database Maintenance Plans and Automation Jobs.
Implementing Backup Strategy for Production Databases.
Recovery of database.
Experience in Up-gradation/Migration from MS SQL Server 2008 R2 to 2017
Experience in Implementing and Troubleshooting of High Availability Techniques like Log Shipping and Database Mirroring.
Analyzing the Disk space growth and preparing the Report.
Perform Index Tuning, Query Tuning and performance monitoring.
Verifying and resolving the SQL Server Blocking issues; Finding and fixing the root cause.
Providing the On-Call support during business hours.
Mentoring Team members and writing documentation
Client- 2:
Project Name : MSIT
Client : MICROSOFT
Duration : March 2018 to April 2019.
Roles & Responsibilities:
Supporting different applications.
Working as part of a team and will provide 24x7 support.
Resolving the Customer Requests which are created in the form of Tickets within the SLA.
Monitoring SQL Server alerts at regular intervals.
Reporting and resolving serious SQL Server alerts.
Working with the Issues related to Configuration, Installation of SQL Server.
Working with the Issues related to Login/Access to the application.
Monitoring, Troubleshooting and Maintaining of SQL Server.
Working with Implementation of SQL Logins, Roles and Authentication modes.
Implementing, Scheduling and Troubleshooting of Database Maintenance Plans and Automation Jobs.
Implementing Backup Strategy for Production Databases.
Recovery of database.
Updating Service packs and Security patches for the Servers.
Providing the On-Call support during business hours.
Mentoring Team members and writing documentation.
Client -3:
Project Name : Data Center Services
Client : Pricewaterhouse Coopers (UK)
Technology Landscape : SQL server 2005, 2008, 2008 R2 & 2012
Duration : Dec 2015 to Feb 2018.
Joined in the Data center operations team as a SQL DBA L1 Resource and geared up as dedicated SQL DBA L2 to work on all Performance issues and handling complex break fix Incidents, Tuning and optimizing SQL Instances.
Roles & Responsibilities:
Provided 7 x 24 Production support for the database.
Installing, Configuring, Patching, Managing, Monitoring and Troubleshooting of SQL Server in a clustered & Standalone environment.
Maintaining of over 20 DB servers.
Resolving the tickets within SLAs.
Resolving Tickets like Creating, Maintaining databases, Monitoring Disk Space, Database Integrity, identifying missing Indexes, handling Blocking.
Monitoring SQL Server alerts at regular intervals.
Maintaining SQL Server & DB Security which ensures data Security.
Managing backups & restoring DB's whenever required.
Monitoring SQL Server agent jobs/maintenance plans.
Monitoring jobs and finding the cause for failure of a job and doing the necessary.
Monitoring the state of SQL Server by going through the error logs, NT event logs.
Involved in migration and up gradation of databases.
Monitoring high availability options configured across several servers like DB Mirroring, Log Shipping, Clustering and Always ON Availability Group.
Troubleshooting & Fixing Blocking, Dead Locking issues.
Resolving Space issues for Data and Log files.
Working on poor performance queries.
Executing scripts in production environment.
Personnel Information:
Gender : Female
DOB : 05-FEB-1991
Nationality : Indian
Pan No : CHMPD8352H
Declaration:
I hereby declare that the information furnished above is true to the best of my knowledge.
Place: Hyderabad
Date:
(NAGASIRISHA D)
Contact this candidate