Senior PostgreSQL & Oracle DBA with 10+ Years
Resume:
Venumadhav Vennu
Mobile: +1-415-***-****
Email-Id: ******.******@*****.***
Objective:
Seasoned Database Administrator with 10+ years of hands-on experience, demonstrating advanced expertise in PostgreSQL and Oracle Databases with RAC. Adept at leveraging strong technical skills, exceptional analytical abilities, and effective problem-solving strategies to drive efficient database management and performance. Committed to contributing to the success of an organization by applying my deep technical knowledge, leadership qualities, and dedication to optimizing database systems and processes. PostgreSQL Database Administration:
Having 10+ years of experience in Database Administration and 6+ years of years specializing in PostgreSQL with expertise in managing production databases across UNIX/Linux and Windows platforms.
Expertise in PostgreSQL Database Architecture, including installation and configuration via source code, RPM, and one-click methods.
Managing logical and physical backups, restoration techniques, and Point-in-Time Recovery (PITR) for PostgreSQL databases.
Performing major and minor upgrades and applying database patches using pg_dump/pg_restore & pg_upgrade.
Cloning databases using pg_basebackup and pg_dump, maintaining logical & physical replication setups for high availability.
Configuring and managing replication solutions, including Warm Standby, Hot Standby, and Streaming Replication for disaster recovery.
Implementing streaming replication for High Availability (HA) and Disaster Recovery (DR) using repmgr and Patroni for automated failover and monitoring.
Managing comprehensive backup and recovery strategies, including physical and logical backups, and performing PITR when required.
Installing and configuring pgbouncer for connection pooling and using pgbadger to generate performance reports from PostgreSQL logs.
Optimizing PostgreSQL performance through configuration tuning, user management, and tablespace optimization.
Performing routine maintenance tasks like re-indexing and vacuuming using tools such as pg_repack for minimal downtime.
Automating database activities like backups, recovery, performance tuning, and monitoring using shell scripts, Ansible, and Docker.
Optimizing SQL queries and database performance using tools like pg_stat_statements and pgbadger across PostgreSQL versions 9.6 to 15.6.
Upgrading PostgreSQL clusters and applying patches to ensure smooth transitions between versions with minimal downtime.
Managing PostgreSQL lifecycle environments, including development, test, and production systems.
Providing 24x7 on-call support for production and non-production PostgreSQL databases on Unix/Linux platforms, ensuring high availability.
Managing cloud-based PostgreSQL databases on AWS EC2, AWS RDS, and Google Cloud Platform (GCP) for scalable, secure solutions.
Venumadhav Vennu
Mobile: +1-415-***-****
Email-Id: ******.******@*****.***
Configuring, optimizing, and maintaining PostgreSQL environments on bare metal, AWS (RDS, Aurora, EC2), and Kubernetes.
Developing and maintaining automation scripts for monitoring, patching, installation, upgrades, and migrations.
Collaborating with cross-functional teams for seamless database operations, ensuring security, performance, and access control.
Conducting system performance analysis, capacity planning, and resource forecasting to support database scalability.
Maintaining PostgreSQL clusters and containerized environments using Kubernetes for optimized resource utilization and deployment.
Oracle Database Administration:
Over 5+ years of experience as an Oracle DBA, with a strong background in managing production databases utilizing RAC on UNIX/Linux (Sun Solaris, HP-UX, AIX, Red Hat Linux) and Windows platforms.
Provided 24x7 on-call support for production databases, including roles as an application and development DBA, ensuring continuous availability and performance.
Extensive knowledge in Oracle database administration across versions 10g, 11g, and 12c, with experience in large-scale OLTP and OLAP environments, handling mission-critical systems.
Managed installation and maintenance of Oracle 11g RAC and 12c RAC databases, including standby databases, to ensure high availability and disaster recovery.
Proficient in Dataguard configuration, including implementing and maintaining standby databases to support disaster recovery and high availability strategies.
Skilled in performance tuning using tools such as EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR, and ADDM, to optimize database efficiency and query performance.
Extensive experience in managing database backups using RMAN (Full/Incremental/Recovery backups), including manual and Commvault backups, as well as traditional hot/cold backups.
Expertise in logical backups and database migration tools, including DATA PUMP, Export/Import, and Transportable Tablespaces, to facilitate data movement and backup strategies.
Proficient in patching and upgrading Oracle databases, with expertise in transitioning from 10g to 11g and from 11g to 12c, ensuring smooth and effective upgrades.
Extensive experience in configuring and implementing ASM (Automatic Storage Management), with proficiency in ASMCMD and ASMLIB for efficient storage management.
Experienced in database refresh and cloning using Commvault, RMAN, and manual methods to support development and testing environments.
Proficient in raising service requests with Oracle Support and utilizing Metalink for resolving database issues and bottlenecks.
Hands-on experience with Oracle GoldenGate software, including installation, upgrade, configuration, and troubleshooting for data replication and integration.
Expertise in configuring GoldenGate downstream mining and integrated components for active-passive and active-active replication, with skills in monitoring and troubleshooting GG processes, including log dumps, record deletion, RBA skipping, and resolving network and mapping issues. Venumadhav Vennu
Mobile: +1-415-***-****
Email-Id: ******.******@*****.***
Educational Qualifications
Master of Computer Applications (M.C.A) from DRK Institute of Science & Technologies (JNTUH). Work Experience
Currently serving as an Associate Consultant at TCS (Americas) Inc since June 2025.
Previously worked as a Technology Lead at Tech Mahindra (Americas) Inc since July 2023.
Worked as a Senior Consultant at Infosys Ltd (Americas) Inc from July 2022 to June 2023.
Worked as a Senior Consultant at Infosys Ltd Hyderabad (SEZ) from July 2018 to June 2022.
Worked as a Senior Oracle DBA at Tech Mahindra Ltd Pune from September 2014 to June 2018. Technical Skills
Operating Systems : Sun Solaris, HP-UX, AIX, RHEL, Ubuntu, Windows Databases : Oracle 9i, 10g, 11g, 12c with RAC; PostgreSQL 9.5 to 15 DBA Tools : RMAN, EXP, IMP, EXPDP, IMPDP
Utilities : TKPROF, EXPLAIN PLAN, SQL*LOADER, TOAD Open-Source Tools : pgbadger, pgbouncer, pg_repack, pg_upgrade, pgbackrest, patroni, repmgr Replication Tools : GoldenGate V12.1.2.1.0, GoldenGate V19.1.0.0.13 Automation Tools : Ansible, Docker, Kubernetes
Cloud Platforms : AWS EC2, AWS RDS, and Google Cloud Platform (GCP) Experience
Project-1 (Current Project)
Project Name : Apple - USA
Role : Technology Lead
Duration : July 2023 to till date
Description:
Apple Inc. is a leading global technology company headquartered in Cupertino, California. Renowned for iconic products such as the iPhone, Mac, and iPad, Apple also offers a comprehensive ecosystem of services including the App Store, iCloud, and Apple Music. The company excels in integrating devices and cloud-based services, investing heavily in performance, reliability, and user experience to maintain its dominant position in the tech industry.
Responsibilities:
Providing 24x7 on-call support for PostgreSQL databases on Unix/Linux platforms, AWS EC2, and AWS RDS, ensuring high availability and performance optimization.
Installing, configuring, and administering PostgreSQL clusters across development, test, and production environments while managing database lifecycle activities.
Optimizing SQL queries and database performance using pg_stat_statements and pgbadger for PostgreSQL versions 13.6 and 15.6.
Implementing and maintaining streaming replication for high availability and disaster recovery using patroni and repmgr for automated failover and monitoring. Venumadhav Vennu
Mobile: +1-415-***-****
Email-Id: ******.******@*****.***
Managing comprehensive backup and recovery strategies with pg_basebackup for physical backups, pg_dump for logical backups, and performing Point-in-Time Recovery (PITR) as required.
Upgrading PostgreSQL clusters, applying patches, and configuring pgbouncer for connection pooling to enhance performance and ensure smooth version transitions.
Automating database operations including backups, recovery, and performance tuning using shell scripts, Ansible, Docker, and handling PostgreSQL and Oracle deployments, upgrades, and patches.
Managing cloud-based PostgreSQL databases on AWS (EC2, RDS, Aurora) and Google Cloud Platform
(GCP), optimizing configurations for scalability and performance.
Collaborating with cross-functional teams to coordinate planned and unplanned activities while maintaining database security and access control.
Developing and maintaining automation scripts for monitoring, patching, installation, upgrades, migrations, and daily tasks, and managing PostgreSQL clusters and containerized environments using Kubernetes.
Conducting system performance analysis, capacity planning, and resource forecasting, and evaluating new technologies and features for scalable, distributed databases. Project-2 (Previous)
Project Name : Broadcom - USA
Role : Sr. Consultant - Infrastructure Management
Duration : Mar 2020 to June 2023
Description:
Broadcom Inc. is an American designer, developer, manufacturer and global supplier of a wide range of semiconductor and infrastructure software products. Broadcom's product offerings serve the data center, networking, software, broadband, wireless, and storage and industrial markets. Responsibilities:
Provide on-call support 24x7 to production and non-production databases.
Coordinate and deploy changes to databases during releases.
Installation, configuration and administration of PostgreSQL database cluster as per requirement for development, test and production usage.
Creation of databases and configuration of rules in pg_hba.conf file.
Creation of users and assigning roles & permissions to the users.
Performance monitoring of database and tuning SQL queries using pg_stat_statements, pgbadger etc.
Installation and configuration of streaming replication between production and DR site.
Applying patches for PostgreSQL database cluster.
Upgradation of PostgreSQL cluster from old version to upper version.
Taking physical backups using the pg_basebackup tool and taking logical backups using the pg_dump, pg_dumpall tools.
Performing the PITR (Point in Time Recovery) using base backups and archive logs.
Installation and configuration of different extensions based on the requirement. Venumadhav Vennu
Mobile: +1-415-***-****
Email-Id: ******.******@*****.***
Installation and configuration of replication manager to automate the switchover and switchback activities and DR Activities.
Installation and configuration of pg-bouncer for connection pooling. Project-3 (Previous)
Project Name : John Deere - USA.
Role : Consultant - Infrastructure Management
Duration : Jul 2018 to till Feb 2020
Description:
John Deere is the brand name of Deere & Company, an American corporation that manufactures agricultural, construction, and forestry machinery, diesel engines, drivetrains (axles, transmissions, gearboxes) used in heavy equipment, and lawn care equipment. In 2019, it was listed as 87th in the Fortune 500 America's ranking and was ranked 329th in the global ranking. The company also provides financial services and other related activities.
Responsibilities:
Working as Tier-2 support on Major releases & Change Request Deployments.
Installing and creating Databases for test and development environments.
Applying Patches and Patchsets to the existing databases.
Upgrading the Databases from 11.2.0.4 to 12.1.0.2 to 12.2.0.1.
Migrating RAC/Standalone databases to new homes through Out-of-place patching.
Managing undo segments, control files and redo log files.
Maintaining oracle Users and granting Roles, Privileges to those users.
Performed Schema level and Table level data refreshes from Production to Development environments using Datapump EXPDP/IMPDP.
Database recovery, moving data files to different locations.
Monitoring Database status using OEM.
Scheduling Jobs in CRONTAB for daily/Weekly hot backups and generating Weekly and monthly reports for server and Databases statuses.
Performing Refresh & Rehost activities using Commvault & RMAN scripts.
Creating Standby Databases and configuring Dataguard broker.
Performing Switchover & Failover activities.
Installed and Configured the Golden Gate software.
Golden Gate setup to achieve Bi-Directional replication between Databases to achieve HA.
Configuring EXTRACT and REPLICAT processes and stopping and starting the processes.
Monitoring & Troubleshooting GG process using Log dump utility (ETROLLOVER, Deleting Bad Records, Skipping RBA, network issues, Lags, Clearing space for trail files).
Worked with development team for query tuning for optimization and Application performance.
Working closely with multiple teams on Troubleshooting the issues (Dev, Prod & QC)
Working with different Application teams for investigating & resolving data issues. Venumadhav Vennu
Mobile: +1-415-***-****
Email-Id: ******.******@*****.***
Project-4 (Previous)
Project Name : AT&T - USA.
Role : Sr. Oracle DBA
Duration : Sep 2014 to Jun 2018
Description:
AT&T Inc. is an American multinational telecommunications corporation, AT&T is the second largest provider of mobile, telephone and the largest provider of fixed telephone in the United States and provides broadband subscription and television services.
Responsibilities:
Installation and Creation of Oracle Databases as per the requirement.
Maintaining Control files, Redo log files and Data files.
Creating Tablespaces and resizing them as per client requests.
User Management and Database Security by granting appropriate Roles, Privileges and Profiles.
Backup and Recovery: Physical Backup (Hot, Cold and RMAN Backup).
Performing logical backup’s using Export/Import and Expdp/Impdp utilities.
Creation of RMAN catalog and performing the RMAN backups and recoveries.
Working on Tkprof, Explain Plan, AWR and ADDM reports generation.
Working on Database Cloning using RMAN/MANUAL.
Working on Database renaming using nid utility.
Working on Database Patching and Upgradation from 10.2.0.4.0 to 11.2.0.2.0.
Configure and administrating on Data Guard Environment.
Configure and administrating on ASM Environment.
Working on Migration from non-ASM Database to ASM Database
RAC installation and supporting RAC/ASM environment.
Cloning activities on RAC to RAC and RAC to non-RAC.
Adding and deleting of RAC Node.
Troubleshooting RAC instances & Listeners.
Implementing high availability solutions using RAC, Physical and Logical Standby databases (Data Guard) and Golden Gate.
Installation, Upgradation, Configuration and Troubleshooting GoldenGate software.
Configuring GoldenGate setup in Bi-Directional replication between Databases to achieve HA.
Configuring GoldenGate files for Extraction and Replication as per business requirements.
Contact this candidate