Srinivasa Rao
Bangalore
Summary
- Total 8 years of experience in SQL Server Data Base Administration (SQL Server 2016, 2014, 2012, 2008, 2008R2 and 2005) and Oracle 10g, 11g, 12c and 19c.
- Experience on 24x7 Production support on rotational basis on call support.
- Experience in Installation and Configuration of MS SQL Server 2005, 2008, 2008 R2, 2012, 2014 and 2016 versions on Cluster and Stand-alone Environment.
- Experience on Active – Active and Active – Passive Production Cluster Environment.
- Expertise in Applying SQL SERVER patches on production Cluster Environment and Stand-Alone Environment through business approved patching processes.
- Extensively worked on Migration and Up-gradation projects of SQL SERVER 2005 to 2008, 2008R2, 2012, 2014 and 2016 for large number of databases along with application migration.
- Tuning the SQL Environments by identifying, understanding and requirement of INDEX Strategies, resolving Deadlocks and Blocking.
- Good understanding on INDEX implementation and Maintenance.
- Capability to understanding the SQL SERVER Issues at infrastructure, Instance Level and Database Level with help of Performance Monitor tools like Sql Profiler, Perfmon.
- Experience in tuning and troubleshooting the issues using Dynamic Management Views (DMV’s).
- Involved in Implementing Supporting for High Available and Disaster Recovery Infrastructure for SQL Servers based on the business requirements. Logshipping, Mirroring, Replication, Always On, Clustering Configured and Scheduled the Maintenance plans, SQL SERVER backups strategy based on recovery model and critical of the databases.
- Full, Differential and Log Backups and Updating Statistics.
- Performs database refresh activities from Production to Dev, Staging, test environments using database backup and restore.
- Regularly Monitors Backup Jobs, Windows Logs and SQL Logs in Maintenance plan History.
- Experience on Oracle L1 tasks.
- Starting and shutting down the database instance.
- Creating and managing the table space for data files.
- Performing health checks on the Oracle Instances/databases. Identify and resolving the blockings locks on the databases.
- Password reset for the Oracle databases. Worked on postgres build setup on Linux Servers.
- Implemented strong security policy on production servers to restrict unauthorized access of SQL SERVERS.
- Responds to monitoring alerts and high security problem tickets, applying analytical, problem solving and resolution skills.
Overview
8
8
years of professional experience
Work History
Senior SQL Database Administrator
GXO LOGISTICS INDIA PRIVATE LIMITED IBM India Pvt.Ltd.
12.2020 - 01.2025
- Experience in Installation and Configuration of MS SQL Server 2014, 2016 and 2019 versions on Cluster and Stand-alone Environment
- Managing ticket queues basis of risk level and help them to team member for resolving the issues
- Configuring and Administrating Log shipping, Database Mirroring, Snapshot and Transactional Replication, Backup Jobs.
- Troubleshooting performance issues.
- Support around 450+ servers on various domains.
- Monitoring the servers using Sentry one and SQL Diagnostic manager.
- Restoring and copying Production Databases.
- Maintain and troubleshoot Replication issues by continuous monitoring of replication.
- Troubleshooting performance issues, blocking, and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues.
- Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis.
- Installing SQL Server service packs based on the errors and flaws that are found in the application.
- Perform Full Backups and Transaction Log Backups.
- Restore them whenever necessary, creating back up strategies and scheduling them for execution.
- Installation of Oracle software on Oracle 11g and 12c
- Creating Oracle databases.
- Starting and shutting down the database instance.
- Creating and managing the table space for data files.
- Creating New database provisioning accounts for new user.
- Performing health checks on the Oracle Instances/databases.
- Identify and resolving the blockings locks on the databases.
- Password reset for the Oracle databases
- Worked Golden gate lag alerts.
- Worked on database slowness issues.
- Worked on Data guard lag alerts.
Sql Database Administrator
e-Zest Solutions Ltd.
04.2017 - 11.2020
- Experience in Installation and Configuration of MS SQL Server 2005, 2008, 2008 R2, 2012, 2014 and 2016 versions on Cluster and Stand-alone Environment
- Managing ticket queues basis of risk level and help them to team member for resolving the issues
- Configuring and Administrating Log shipping, Database Mirroring, Snapshot and Transactional Replication, Backup Jobs
- Troubleshooting performance issues
- Support around 250 servers on various domains
- Monitoring the servers using Spotlight
- Restoring and copying Production Databases
- Maintain and troubleshoot Replication issues by continuous monitoring of replication
- Troubleshooting performance issues, blocking, and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues
- Regular monitor of servers, which includes Backup Job Monitoring and troubleshoot all the issues on regular basis
- Installing SQL Server service packs based on the errors and flaws that are found in the application
- Perform Full Backups and Transaction Log Backups
- Restore them whenever necessary, creating back up strategies and scheduling them for execution
Education
M.C.A -
Annamalai University
Skills
- MS SQL SERVER 2005
- MS SQL SERVER 2008
- SQL SERVER 2008R2
- SQL SERVER 2012
- SQL SERVER 2014
- SQL SERVER 2016
- SQL SERVER 2017
- SQL SERVER 2019
- SQL SERVER 2022
- Linux
- Sentryone
- Failover cluster manager
- SQLDM
- OEM
- SQL Profiler
- SSMS
- SQL Configuration Manager
- PostgreSQL 13
- Oracle 12c
- Toad
Timeline
Senior SQL Database Administrator
GXO LOGISTICS INDIA PRIVATE LIMITED IBM India Pvt.Ltd.
12.2020 - 01.2025
Sql Database Administrator
e-Zest Solutions Ltd.
04.2017 - 11.2020
M.C.A -
Annamalai University
Similar Profiles
Virender ThakurVirender Thakur
Operations Manager at IBM India Private Limited/ Kyndryl Solutions Private LimitedOperations Manager at IBM India Private Limited/ Kyndryl Solutions Private Limited
P R JeevithaP R Jeevitha
IT SECURITY AND COMPLIANCEANALYST at Kyndryl Solutions Private Limited(IBM India Pvt. Limited)IT SECURITY AND COMPLIANCEANALYST at Kyndryl Solutions Private Limited(IBM India Pvt. Limited)
Sudip Kumar DuttaSudip Kumar Dutta
Cloud Infrastructure Engineer at IBM INDIA Pvt.Ltd On Contract Of Infinite Computer Solution India Pvt. LtdCloud Infrastructure Engineer at IBM INDIA Pvt.Ltd On Contract Of Infinite Computer Solution India Pvt. Ltd
Raghu Vamsi MRaghu Vamsi M
Associate Manager- Finance at Reverie Language Technologies LimitedAssociate Manager- Finance at Reverie Language Technologies Limited
Shwetha AgarwalShwetha Agarwal
Artist Manager at Nineone IncArtist Manager at Nineone Inc