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
SQL Server Installation & Patching
Database Migration
Migration from On-Premise to Azure SQL/ AWS RDS / AWS EC2
Database Upgradation to SQL Server 2016/2017/2019
Log Shipping, Mirroring, Failover Cluster, Always On
Database Backup & Restore
User Management
NetBackup, Tivoli, SSMS, SQL Profile, Database engine tuning advisor, Database Migration Assistant
PowerShell , Python, HTML, CSS, t-SQL
SSIS Deployment
SSRS/Power BI Basic report development & Deployment
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