Sreenivasarao Abburi
Senior Consultant
Bangalore,India
Summary
Seasoned Database Administrator with 8 years of extensive experience designing, coding and testing database solutions in Lower and Production environments. Proficient in working with diverse technologies such as SQL Server t-sql, Powershell and Python. Motivated to stay informed of latest industry innovations to provide users with most up-to-date solutions.
Overview
9
9
years of professional experience
5
5
years of post-secondary education
Work History
Senior Consultant
Capgemini Technology Services India Limited
Bangalore, India
06.2020 - Current
- Monitoring ticket management and ensuring team’s adherence to SLA
- This is for inventory of almost 320 servers and 180 of them being production
- Installing, configuring, managing, monitoring and troubleshooting SQL Server
- Working closely with application development and support team to understand their requirements and provide timely solutions, for both current and future projects
- Configured Mirroring, Log-shipping, Always On and Clustering setup between database servers/instances
- Monitoring Clusters and troubleshooting Clustering Issues, performed failover/ fail back activities.
- Troubleshooting performance issues and tuning database for better performance
- Monitoring issues related to database locks/blockings/deadlocks
- Configuring SQL Server Reporting Server, Database Mails to send notification for alerts
- Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking
- Migrate application content from old server to new server with better hardware to improve performance
- Migrating servers from SQL 2005,SQL 2008,SQL 2008 R2,SQL 2012 to 2016 / 2017/2019
- Automated, Refreshing Lower environment with Production data monthly.
- Provided 24 x 7 Production support for database and application issues.
- Applying SQL Standards on all SQL server landscape, according to prescribed standards.
- Repetitive issues analysis and proposals for permanent resolutions
- Training new employees in team on domain and technical skills required for project.
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Produced high-standard database solutions to meet stability, reliability and performance metrics.
Senior Support Engineer
Microsoft Technologies
Bangalore, India
09.2019 - 06.2020
- Was responsible to attend client call/cases to solve their problems
- Used to provide support and suggestions to them for their environment
- Was responsible to share knowledge on new features of product with customers.
Database Administrator
Fidelity Investment
Chennai, India
09.2017 - 09.2019
- Installing, configuring, managing, monitoring, and troubleshooting of various SQL versions like 2019, 2017, 2016, 2014, 2012 and 2008 R2
- Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking
- Configured 3 node always On with multi subnet cluster to server both high availability and Disaster recovery
- Troubleshooting performance issues and tuning database for better performance
- Running SQL Server trace to troubleshoot data issues reported by users
- Provided 7 x 24 Production support for database and application issues
- Applying SQL Standards on all SQL servers according to prescribed standards
- Repetitive issues analysis and proposals for permanent resolutions
- Created optimal technical solutions to user needs with in-depth system analysis.
- Participating in weekly and monthly meetings
- Performing daily check list
- Developed custom database objects, stored procedures and delivered application support.
Senior Analyst
HCL Technologies
Chennai, India
07.2014 - 09.2017
- Provided inputs and documented regular activities of Team to Automation team, to build tool for these tasks.
- Tested new automated tools designed for DBA tasks and helped to improve more functionalities and robustness of tools.
- Published Incident/Request/Change Requests reports to management for tracking of resolution quality and trend analysis.
- Designed customized Database health checks reports based on customer requirement for special events ( like UPFRONT, Olympic Games, etc. )
Analyst
Mphasis
Bangalore, India
02.2013 - 09.2013
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Utilized RDBMS tools and utilities to monitor, tune and optimize system performance.
- Set up and controlled user access levels across databases to protect important data.
Education
Bachelor of Science - Computer Science
SSN Engineering College
Ongole 10.2007 - 04.2011
High School Diploma -
UMR Junior College
Ongole 06.2005 - 03.2007
Skills
SQL Server Database Administration
Accomplishments
- Certified ITIL v4 Foundation
- AZ 104 – Azure administrator (Capgemini Internal)
- GTO – Extra Miler for extraordinary support in Pandemic second wave.
- Above & Beyond award – 2021
- Received R&R for completion of Pilot project in Culture of Coding program.
- Received On the Spot award for automation of Health checks of SQL Server Instance.
Timeline
Senior Consultant
Capgemini Technology Services India Limited
06.2020 - Current
Senior Support Engineer
Microsoft Technologies
09.2019 - 06.2020
Database Administrator
Fidelity Investment
09.2017 - 09.2019
Senior Analyst
HCL Technologies
07.2014 - 09.2017
Analyst
Mphasis
02.2013 - 09.2013
Bachelor of Science - Computer Science
SSN Engineering College
10.2007 - 04.2011
High School Diploma -
UMR Junior College
06.2005 - 03.2007
Similar Profiles
Roopa NandakumarRoopa Nandakumar
Senior Consultant (Talent Acquisition) at Capgemini Technology Services India LimitedSenior Consultant (Talent Acquisition) at Capgemini Technology Services India Limited
Vasu Sagar AbishettiVasu Sagar Abishetti
Finance Controller at Capgemini Technology Services India LimitedFinance Controller at Capgemini Technology Services India Limited
Mrunmayee MehtaMrunmayee Mehta
Associate Consultant – Finance Controller at Capgemini Technology Services India LimitedAssociate Consultant – Finance Controller at Capgemini Technology Services India Limited
Anish DograAnish Dogra
Manager UK Bid Management at Capgemini Technology Services India LimitedManager UK Bid Management at Capgemini Technology Services India Limited
Anurag TiwariAnurag Tiwari
Quality Manager, Global Pay Services at AmazonQuality Manager, Global Pay Services at Amazon