SRINIVAS PASUPULA
Bangalore
Summary
Experienced database professional with 11 years in SQL Server Database Administration and 5 years in AWS Aurora PostgreSQL. Specializes in optimizing database environments through performance tuning, automation, and backup and recovery strategies. Skilled in RDS cluster upgrades and Blue/Green deployments, ensuring high availability and minimal downtime. Committed to building stable and scalable database systems that drive business growth.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Lead Database Administrator
C&R Software
Bangalore
05.2021 - Current
- Managed daily DBA operations, including deployments, incident investigations, backup and restore operations, and performance tuning.
- Supported database migrations from SQL Server and Oracle to AWS Aurora PostgreSQL.
- Configured AWS DMS by creating source/target endpoints and managing DMS tasks to ensure smooth database migrations.
- Analyzed query plans, optimizing inefficient queries by identifying missing indexes, QPM (Query Plan Management).
- Executed pg_dump and pg_restore operations for testing across production and CQA environments to validate database integrity.
- Created Aurora clone clusters from snapshots with continuous backup configurations.
- Designed Datadog dashboards for database monitoring and alerting using AWS CloudWatch metrics.
- Developed automation scripts to clear idle sessions and streamline routine maintenance tasks.
- Client : C&R Software, USA
Database Operations Engineer
FICO
Bangalore
03.2018 - 05.2021
- Configured SQL Server Always On Availability Groups (AG/DAG) as per client requests.
- Performed database migrations from on-premises environments to the Azure cloud.
- Analyzed and resolved deadlocks and performance issues on SQL Server instances, enhancing overall database performance and reliability.
- Executed database refresh from production to test servers, ensuring data accuracy and availability for testing.
- Installed, uninstalled, and configured SQL Server based on client requirements.
- Monitored disk space utilization, performed sizing, and supported capacity planning activities.
- Managed SQL Server Availability Group upgrades and OS patching through planned failovers, minimizing downtime during critical maintenance.
- Resolved issues related to Transactional replication.
- Performed database consistency checks using scheduled maintenance jobs.
- Client :FICO, USA
Database Administrator
Sheorey Digital Systems Pvt. Ltd
Bangalore
05.2016 - 03.2018
- Installed, configured, and upgraded SQL Server instances to support aviation software applications.
- Monitored system workloads and analyzed SQL queries to optimize database performance and prevent bottlenecks.
- Implemented automated backup and disaster recovery strategies, ensuring zero data loss during operational disruptions.
- Managed user access controls, applied security patches, and enforced data security and compliance standards to safeguard sensitive information.
- Designed efficient database schemas and resolved application-level data issues in collaboration with development teams.
- Provided 24/7 on-call production support, and resolved database-related technical issues.
- Clients: Air India, Indigo, SpiceJet, GoAir, Gulf Helicopters, and Reliance Aviation.
Junior Database Administrator
Flexis IT Pvt. Ltd.
New Delhi
07.2014 - 05.2016
- Created and configured database mirroring environments, enhancing data availability and disaster recovery.
- Analyzed and resolved SQL Server performance issues, improving system efficiency and reliability.
- Monitored disk space utilization, managing storage capacity to ensure optimal database performance.
- Managed SQL server-level and database-level security, including roles and permissions.
- Migrated SQL Server databases from version 2000 to 2008.
- Client: Vancouver Railway, Canada.
Education
Master of Science - Communication Systems Engineering
University of Portsmouth
Portsmouth, UK11-2013
Skills
- SQL Server Administration
- Database management
- SQL Server optimization
- Performance Tuning
- High Availability
- Database migration
- Data modeling
- Cloud architecture
- Aurora PostgreSQL
- Automation
Certification
AWS Certified Solution Architect (Associate)
Languages
English
Proficient (C2)
C2
Hindi
Proficient (C2)
C2
Telugu
Native
Native
kannada
Intermediate (B1)
B1
Timeline
Lead Database Administrator
C&R Software
05.2021 - Current
Database Operations Engineer
FICO
03.2018 - 05.2021
Database Administrator
Sheorey Digital Systems Pvt. Ltd
05.2016 - 03.2018
Junior Database Administrator
Flexis IT Pvt. Ltd.
07.2014 - 05.2016
Master of Science - Communication Systems Engineering
University of Portsmouth