Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Venkata Palety

Austin,TX

Summary

Over all 17 years of IT experience as a Sr.PostgreSQL DBA , Sr.MySQL DBA , Mongo DBA , Sql server & Sr. Oracle Database Administrator, RAC Administration and Application DBA on various platforms. 10+ Years of expertise in PostgreSQL with knowledge of installations and Configurations on various platforms along with the implementation of DR setup etc. 7+ Years of expertise in MySQL with knowledge of installations and Configurations on various platforms. Hands on experience in Master-to-Master replication. When I joined this project, it was not good the DB Performance wise. But now I completely got the insight and improved my DB Performance up to 35%. I am supporting to the administer applications and also helping application teams to run the solutions faster.. I focus to monitor the bloats and to remove them using PG_REPACK utility without a downtime. Scheduled the daily gather stats frequently using tables in non-peak hours and also scheduled the same job on all table in every Sunday. We always maintain High availability at cluster level. We regularly test the failover mechanism. Major task to monitor and set the notification on replication. If we see a lag at replication level we will get an email notification and also teams alert. I reduced the IOPS cost based on the writes at table level. Expert in Performance Monitoring and Tuning of PostgreSQL Databases on Unix/Linux platform. Experience in Database Performance Tuning, Optimization, Query rewriting and Troubleshooting. Oracle Exadata, RAC Expert in Oracle database technologies aspect. Having expertise skill in Install, Configure, Upgrade, Migrate, Maintain and Support Oracle Databases, related tools and products on various Infrastructure platforms. Expertise in support Oracle Real Application Clusters and Oracle Exadata Machine environment includes cell nodes administration which is hosting critical applications of database environments for Investment Banks & Financial Institutions. Hands on experience in GoldenGate configuration and support. Strong experience in configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization. Knowledge in implementing, configuring, and troubleshooting database instances, replication, backup, partitions, storage, and access. Proficient knowledge in migrating data from different RDBMS to PostgreSQL using Golden gate. Hands on experience of database backups and Recovery strategies using RMAN, Hot Backup, Export, and Transportable Tablespace. Experienced in Capacity Planning, Configuration, Installation, Upgrades and High Availability (HA) solutions and Backup & Recovery, performance tuning & Cloning. Expertise at database administration activities such as monitoring database instances activity for blockers, waiting sessions, locks, dead locks, services start-up problems, Cluster management, connectivity problems, and max session reached errors etc… Expert in Performance Monitoring and Tuning of Oracle Databases on Unix/Linux platform Performance Tuning using SQL Tuning Advisor, Statspack, ADDM and AWR report Plan, test & implement the database Backup & Recovery strategy depending on the database size. Checking the daily, weekly, monthly backup status

Overview

17
17
years of professional experience
1
1
Certification

Work History

Sr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator

Cisco Systems Inc
06.2016 - Current
  • Company Overview: Cisco Systems Inc
  • Is the world’s largest provider of network and networking solutions
  • Cisco has pioneered the development of networking technologies like VOIP (Voice over IP) and has been a key innovator and provider of Internet hardware
  • Cisco is headquartered at San Jose, CA, USA and has offices and manufacturing facilities around the globe
  • Proactively monitored system performance using tools like pg_stat_statements, pgBadger, Prometheus, and Grafana, tuning the database to handle increasing workloads and ensuring high availability
  • Experience in Database Performance Tuning, Optimization, Query rewriting and Troubleshooting
  • Extensive experience with AWS services and designing cloud-native, fault-tolerant architectures
  • Extensive experience in designing and managing backup and recovery strategies, including Point-In-Time Recovery (PITR) and disaster recovery (DR) solutions
  • Extensive experience in deploying, managing and developing PostgreSQL clusters
  • Patch, Upgrade and keep the PostgreSQL DBs current
  • Implemented Streaming replication, logical replication, Cascade replication
  • Maintaining custom vacuum strategies at table and db level
  • Design and implement disaster recovery for the PostgreSQL Database
  • Proficient in Linux systems such as Ubuntu, CentOS, and RHEL
  • Migrated MongoDB clusters from on premises to Cloud AWS Document DB
  • Managed MongoDB deployment in cloud environments (AWS) to ensure scalable, cost-effective, and resilient database architecture
  • Set up and maintained sharded clusters to distribute large datasets across multiple nodes, providing scalable and high-performing environments
  • Experience in DMS in cloud
  • Working with data masking transformation to change sensitive production data to realistic test data for Non-production environments
  • I need to understand the challenges before them to make this transition and to ensure that the needs and expectations of the client are represented correctly in the final solution
  • Packaging of the developed component to be deployed in production environment
  • Upgraded critical database engine from 9.4 to 9.6 and then upgrade to 12, 15.10
  • Hands on experience designing and developing High Availability solutions using Oracle RAC, Data Guard and ASM on Linux platform
  • Successfully migrated SQL Server 2008 R2 databases to SQL Server 2016 with minimal downtime, resulting in improved system performance and security
  • Implemented Always On Availability Groups for mission-critical applications, achieving a 99.99% uptime across production systems
  • Work with Oracle support for debugging, troubleshooting of database related issues
  • Identifying and resolving incidents and address to user problems/concerns
  • Implemented Master to Master replication in Mysql
  • Provides high technical expertise for the planning, analysis, design, development, implementation, maintenance and control of the organization’s server-class databases
  • Identifying performance bottlenecks using AWR and ADDM reports and resolving them
  • Worked on SQL and PL/SQL tuning
  • Worked on Oracle 11g/12c/19c /21c Grid Control including monitoring/setup and performance tuning purposes
  • Cisco Systems Inc
  • Is the world’s largest provider of network and networking solutions
  • Cisco has pioneered the development of networking technologies like VOIP (Voice over IP) and has been a key innovator and provider of Internet hardware
  • Cisco is headquartered at San Jose, CA, USA and has offices and manufacturing facilities around the globe

Sr. Oracle Database Administrator

GE - General Electric Company
01.2015 - 05.2016
  • Extensive experience in deploying, managing and developing PostgreSQL clusters
  • Setup and maintenance of postgres master-slave clusters utilizing streaming replication
  • Responsible for monitoring environments using monitoring tools [Ex: Nagios, Xymon etc.]
  • Develop and enhance scripts to automate and execute various DBA tasks
  • Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends
  • Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)
  • Provides high technical expertise for the planning, analysis, design, development, implementation, maintenance and control of the organization’s server-class databases
  • Identifying performance bottlenecks using AWR and ADDM reports and resolving them
  • Worked on SQL and PL/SQL tuning
  • Worked on Oracle 11g/12c Grid Control including monitoring/setup and performance tuning purposes
  • Identifying deadlocks and other lock contention issues during stress tests
  • Extensively involved in fine tuning home mortgage application SQL’s
  • Proactive tuning, suggesting recommendations to avoid performance problems
  • Extensively used EXPLAIN PLAN, Auto Trace and TKPROF for query refining
  • Analysis of Execution plans for each and every query for above application and recommending required Indexes, hints and partitioning to improve SQL query performance
  • Performed POC for implementation of Oracle 11g & 12c new features
  • Lead architect in data retention and data purging strategy
  • RMAN for backup and recovery

Oracle Database Administrator & PostgreSQL DBA

Celgene
01.2013 - 12.2014
  • Maintaining High availability Oracle Instances on Real Application Clusters with high-end 24
  • 7 support process
  • Monitoring Cluster Services, resources status using cluster server manager and the logs of scheduled rman backup, export jobs and data load jobs
  • Configuration management and monitoring for database, application resources in HP Openview monitoring tool
  • Monitoring of cluster resources on RAC environment with VERITAS cluster server manager
  • Participation in Change review board meetings and coordinating with application support team and execution of change requests as per schedules
  • Documentation and maintain database, application standards, Fix the issues and provide root cause analysis
  • Query optimization and troubleshooting
  • Patch, Upgrade and keep the PostgreSQL DBs current
  • Experience in working on 24 X 7 Production Database on Call Support

Oracle Database Administrator

NEXTEL
09.2011 - 12.2012
  • Responsible for issue resolutions participates in client meetings and presentation
  • Managed performance of team members, career, training and development planning
  • Facilitated goal and objective setting, promotions and performance reviews
  • Installation and Configuration of Oracle 11g R2 Real Application Clusters (RAC) databases on OEL 5.5
  • Cloning the Oracle Applications from Production to Development servers
  • Performing Logical backups using Export and Expdp Utilities
  • Performing daily incremental backups, weekly backups using RMAN
  • Monitoring the Table spaces and adding/resizing datafiles
  • Configured physical standby database (DATAGUARD) and tested for failover and switchover
  • Upgrading the database from 9.2.0.6 version to 10.2.0.3 version
  • Doing cross platform migration using Export/Import from Sun Solaris to Linux server

Oracle Database Administrator

AT & T
01.2008 - 08.2011
  • Managing and supporting Production, Development, Test databases (9.2.07, 9.2.05, 8.1.7.4) and Oracle Applications (12.1.3,11.5.10, 11.5.9, 11.5.8, 11.5.5, 11.5.2)
  • Study existing Production environment and prepare an approach document for Migration
  • Participate in planning with server management team to setup the SAN storage devices multipath configurations that includes pre-requisites, kernel configuration, and installation of Oracle software, configuring public/private and virtual IP addresses required for multi-instances
  • Prepared backup strategy for high availability systems and Implemented shell scripts to perform RMAN level0 and incremental backups as per policy

Education

Master of Science - Computer And Information Sciences

BharatiDasan University
06.2021

Skills

  • RH Linux
  • Ubuntu Linux
  • Sun Solaris
  • Windows Family
  • PostgreSQL
  • MySQL
  • MongoDB
  • Oracle 8i
  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Oracle 19c
  • Oracle 21c
  • MariaDB
  • Amazon Aurora
  • DocumentDB
  • Oracle E-Business Suite 11i
  • Oracle E-Business Suite R121
  • Oracle E-Business Suite 122
  • Fusion WebLogic 10g
  • Fusion WebLogic 11g
  • PgBouncer
  • Pgbadger
  • PgPool
  • Oracle RMAN
  • Export-Import
  • SQL Loader
  • TOAD
  • DBCA
  • Netca
  • ASM
  • RAC
  • PLSQL Developer
  • GoldenGate
  • Sql Loader Utility
  • OEM Grid Control
  • NETCA
  • Jenkins
  • Xymon
  • Thousand eyes
  • Graphana
  • PL/SQL
  • SQL
  • Plus
  • UNIX shell scripting
  • Unix CRON jobs
  • Python
  • AWS
  • Azure
  • Strong work ethic

Certification

  • Oracle Certified Professional (OCP) 10G DBA
  • Trained 10G and 11G workshop, RAC, Goldengate and EXADATA
  • GRC Controls

Timeline

Sr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator

Cisco Systems Inc
06.2016 - Current

Sr. Oracle Database Administrator

GE - General Electric Company
01.2015 - 05.2016

Oracle Database Administrator & PostgreSQL DBA

Celgene
01.2013 - 12.2014

Oracle Database Administrator

NEXTEL
09.2011 - 12.2012

Oracle Database Administrator

AT & T
01.2008 - 08.2011

Master of Science - Computer And Information Sciences

BharatiDasan University
Venkata Palety