Venkata Palety

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

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