D.PrasannaKumarReddy

(MicrosoftSQLDBA)

 

 

 

 

Career Objective:

• To pursue a highly rewarding career, seeking for a job in challenging and healthy work environment where I can utilize my skills and knowledge efficiently for organizational growth.

 

Career Summary:

• Havingaround 6 years of work experience as SQL Database Administration in 24*7 in Production environments
• Expertise in Installation, configuration and administration of SQL server
• Expertise in Designing and creating enterprise wide databases.
• Designing backup up strategies for Disaster Recovery purpose in Production environment.
• Well versed with regular/Monthly Patching along with Out of Band patches on PROD and DEV environments.
• Hardening of SQL Instance and Databases as per customer standards.
• Expertise in Customizing TSQL Coding for Regular Administration tasks like Backup/Restore, Index Creation, HA Configuration etc.
• Good knowledge on Powershell Basics
• Expertise in configuring enterprise-wide database backup/recovery plans using SQL Native methods and Symantec Backup Exec tool, Lite Speed and Commvault.
• Expertise in implementing Disaster recovery plan for SQL Servers such as Always-On, Clustering, Mirroring and Log shipping.
• Expertise in configuring and implementing SQL Server Security.
• Hands-on experience in SQL server Performance Tuning.
• Expertise in implementing space management, user management, performance tuning, database maintenance and security.
• Proficiency in documenting business requirements, technical specifications and closely interacting with the technical team to understand the problem, test, troubleshoot and debug the solution.
• Possess excellent communication skills, self-motivated, multi-task oriented with strong work ethics and ability to work efficiently.
• Experience in working on Microsoft  technologies like SSIS, SSRS, and SSAS.
• Backup Azure SQL DBs in Azure and Automation of SQL DB backups
• Experience in providing 24x7 Production Support.

 

 

 

 

 

Educational Details:

 

• Completed Degree(B.SC Com) fromSriKrishna DevarayaUniversity,Anantapurin 2017with 73%

 

TechnicalSkillSet:

 

Operating System

Windows 2016/2012/2008 R2 server, Windows 7, XP/Vista

Infrastructure

Hyper-V, Load balancing, Software Installation, Basics of AD

Databases

SQL Server 2017/2016/2014/2012/2008 R2/ 2005, SQL Azure

Database Administration

SQL Server DBA skills - Backup-recovery, DB Maintenance Tasks, High Availability concepts: Mirroring/Replication/Clustering.

 

Work  Experience:

 

• Worked as SQLDatabaseAdministratorwith Confidential, Mangalore from Aug 2023 to Feb 2024.
• Worked as SQLDatabaseAdministratorwith Confidential, Bangalore from Oct 2022 to May 2023.
• WorkedasSQLDatabaseAdministratorwith Confidential,HyderabadfromOct 2019toSep 2022.
• WorkedasSQLDatabaseAdministratorwithScope International,ChennaifromNov2017toSep 2019.

 

Project #1

Company                               :     Confidential

Client                                     :     Payments & Networks

Role                                        :     SQL DBA (L1 and L2)

Duration                                :     Aug 2023 to Feb 2024

 

NCR Atleos helps customers expand their reach, provide greater financial access for customers and reduce operational complexity through industry-leading technologies, unmatched global services capabilities, the largest surcharge-free network and expertise in running ATM networks.

 

Responsibilities:

• Installati