Venkateswar Reddy Bogi Reddy
Anantapur
Summary
Experienced Oracle DBA with more than 6 years in database administration. Key responsibilities include leading large database upgrades, contributing to cross-platform migrations, and implementing TDE for data security. Experienced in disaster recovery testing and ensuring high availability for critical systems.
Overview
6
6
years of professional experience
Work History
Senior Oracle Database Administrator
Tata Consultancy Services
Bangalore
02.2022 - Current
- Oversaw user access control and space management protocols across all databases, enforcing security policies while guaranteeing data integrity and availability.
- Enabled agile development and accurate user acceptance testing (UAT) by regularly refreshing non-production environments with sanitized data from production, utilizing RMAN, and Data Pump.
- Maintained enterprise-wide database stability and security by methodically applying critical quarterly patches (PSU/CPU), and performing timely version upgrades.
- Managed the full lifecycle of over 700 Oracle database instances (11g, 12c, 19c), providing 24/7 on-call support, and leveraging Oracle Enterprise Manager (OEM) Cloud Control for proactive monitoring.
- Collaborated effectively with development, testing, and operations teams to define technical requirements, and ensure optimal database performance for new application integrations.
- Optimized complex queries and database processes by utilizing advanced diagnostic tools, including AWR, ADDM, ASH, and EXPLAIN PLAN, reducing resource consumption and improving throughput.
- Resolved critical performance bottlenecks by collaborating with development teams on SQL tuning, leading to significant improvements in application response times and user experience.
- Authored and maintained the central repository of runbooks and standard operating procedures (SOPs) for all disaster recovery scenarios and database upgrades, reducing recovery time and human error.
- Ensured maximum uptime during planned maintenance by performing seamless Oracle Data Guard switchover/switchback activities for critical OS patching, and infrastructure upgrades.
- Enhanced data security by implementing Transparent Data Encryption (TDE) for sensitive production databases, ensuring compliance with key data privacy regulations.
- I took full ownership of high-priority database incidents, was responsible for raising Oracle Service Requests, and supplying all required diagnostic data to drive root cause analysis for a swift resolution.
- Validated the high-availability architecture by executing controlled switchover and failover exercises using Oracle Data Guard, consistently meeting a near-zero Recovery Point Objective.
- Managed and supported multi-node Oracle RAC environments to provide active-active high availability for mission-critical, 24/7 applications.
- Orchestrated multi-terabyte database migrations with near-zero downtime, ensuring complete data integrity and seamless business continuity during the platform transition.
- Worked alongside with my team to execute the successful recovery of a 60 TB database from tape backups during a real-world storage outage, ensuring the integrity of the restored data.
- Mentored junior DBA team members on best practices for performance tuning, database upgrades, and backup strategies, improving the overall skill level and efficiency of the team.
- Architected and implemented scalable, high-performance database solutions to support evolving business needs, designing for optimal security, resilience, and future growth.
- Led a team of DBAs in the successful planning and execution of multiple production database upgrades from 11g, 12c, to 19c, ensuring zero data loss and minimal business disruption.
Junior Oracle Apps Database Administrator
Cognizant
Bangalore
03.2019 - 11.2021
- Conducted daily health checks and proactive monitoring of database systems by reviewing alert logs, managing space allocation, and resolving locking issues.
- Managed database security by creating users, roles, and profiles, and granting appropriate access privileges.
- Collaborated closely with development teams to support application releases, and provide necessary database assistance.
- Refreshed development and test instances with production data using RMAN for recovery, and Oracle Data Pump for data object migration.
- Performed database backup and recovery operations, with experience in both cold (offline) and hot (online) backup procedures.
- Automated, repetitive administrative tasks, such as schema exports and tablespace usage reports, can be accomplished by scheduling shell scripts via crontab.
- Applied patches to both the database using Opatch, and the E-Business Suite application using adpatch and adop utilities.
- Executed Oracle E-Business Suite (EBS) cloning using Rapid Clone to create consistent application environments for testing and development.
- Managed and supported a high-availability Oracle E-Business Suite (EBS) environment, featuring a multi-node application tier to ensure performance and resilience.
- Delivered 24/7 on-call support for the underlying database infrastructure, including multi-node Oracle RAC clusters, and standalone instances running on Linux.
Education
Bachelor of Technology - Computer Science and Engineering
Gates Institute of Technology
Anantapur, India12-2017
Skills
- Oracle Database (19c, 12c, 11g)
- Oracle E-Business Suite (EBS) R121, R122
- Oracle Enterprise Manager (OEM) Cloud Control
- Oracle RAC (Real Application Clusters)
- Oracle Data Guard (switchover, failover, DR drills)
- Disaster recovery (DR) planning and real-world execution
- Backup and recovery (RMAN, hot/cold backups)
- Oracle Data Pump (expdp, impdp)
- Transparent Data Encryption (TDE)
- Cross-platform migration (XTTS)
- Shell scripting
- Opatch and AD Utilities (adadmin, adctrl)
Languages
Telugu
First Language
English
Upper Intermediate (B2)
B2
Accomplishments
- Played a key role in a real-world disaster recovery effort, successfully restoring a 60 TB database that prevented catastrophic data loss and allowed for the resumption of critical business operations within the target RTO
- Successfully led multiple complex database upgrade projects from Oracle 11g/12c to 19c, ensuring 100% data integrity, and achieving minimal downtime for business-critical applications
- Improved critical application performance by an estimated 25% by identifying and resolving persistent database bottlenecks through advanced SQL tuning and diagnostics, using AWR, ASH, and SQL Tuning Advisor
- Strengthened the corporate security posture and ensured compliance with data privacy regulations by successfully implementing Transparent Data Encryption (TDE) across all sensitive production databases
- Maintained 99.9%+ uptime across a complex environment of over 700 production database instances through proactive monitoring, robust support protocols, and management of Oracle RAC clusters
Timeline
Senior Oracle Database Administrator
Tata Consultancy Services
02.2022 - Current
Junior Oracle Apps Database Administrator
Cognizant
03.2019 - 11.2021
Bachelor of Technology - Computer Science and Engineering
Gates Institute of Technology
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
CHAVVA NITHISHCHAVVA NITHISH
CAE Engineer at General Motors Technical center IndiaCAE Engineer at General Motors Technical center India