Venkateswara Reddy Tumu Email & Phone Number

Alpharetta, Ga, Us

Atlanta, Ga, Us

 Developed shell script to automate TTS Backup, Password Rotation, User addition/removal, Gather Stats, Custom metrics in all databases from centralized server Installed and configured of 6 production database clusters on Exadata cloud at customer machine.  Applied both PSU/RU to GI and DB homes on ExaCC machine Managing Production environment with extra later of security through Oracle Wallet/TDE encryption  Migrated DR databases to new datacentre Performed DR Drill activities to recover databases Upgraded databases from 11g to 12c and 18c Upgraded GI from 11g to 12c and 12c to 18c versions  Involved in many performances tuning activities and suggested codes changes RMAN Point in time refreshes & worked on Automation projects.  Installed couchdb 2.1 docker version and setup 2 and 3 node clusters Configured shell scripts to monitor database availability  Upgraded to couchdb 3.1 version from 2.1 version and configured 3 node clusters Installed OEM13c and configured 600+ agents  Created many custom metrics as per requirement

Houston, Texas, Us

 Created Shell scripts to automate Oracle RMAN backups and user password changes for All oracle databases Installed and configured OEM12c(12.1.0.4) OMS Applied CPU/PSUS Patches to all databases USING OEM and manually. Implemented oracle 11g Rel2 Grid setup on 3 node cluster using ASMLib interface Patched and upgraded 11.2.0.2 ,11.2.0.3,11.2.0.4 RAC environment to 12.1.0.1/12.1.0.2 environment Implemented physical standby for 11.2.0.4 Grid database and tested for switchover Created OEM templates to apply PSU/CPUS to all databases at a time to reduce the customer downtime. Cloned and configured Grid, cluster, ASM, Database binaries and database for high availability. Applied latest CPU,PSU patches to all Prod/Uat/Dev databases. Managing backup and recovery of RAC databases.  Cloned Production databases to test databases as per user requirements. Created high availability services and tested for failover Managing backup and recovery RAC databases OCR and VOTING files. Design and implemented RMAN backup strategy for RAC database Converting standalone database to RAC database Administered the cluster databases using CRSCTL and SRVCTL utilities. Implemented RMAN backup strategy for the RAC database. analysing SQL Queries for excessive CPU usage, high disk reads / writes and execution plans by using TKPROF and EXPLAIN PLAN Generating the database health check reports using AWR, ADDM Migrating the data between production and the development database using Oracle utility Import & Export. Administration of ASM Instances and ASM Disk groups in RAC environment. Involved in query level tuning's as part of performance issues Created backup reports and metric reports as part of pro-active maintenance.

Mumbai, Maharashtra, In

 Applied latest CPU, PSU patches to all Prod/Uat/Dev databases. Managing backup and recovery of RAC databases.  Cloned Production databases to test databases as per user requirements. Created high availability services and tested for failover Administered ASM instance by using SQLPLUS and ASMCMD command line. Implemented normal redundancy at ASM level. Provide 24*7 supports for production environment. Cloning databases through RMAN Performed Upgrade/Migration of the oracle databases from Oracle 9i to Oracle 10g. Configured the Clone databases from production to reporting databases.

 Implemented oracle 11g Rel2 Grid setup on 3 node cluster using ASMLib interface Patched and upgraded 10.2.0.2 ,10.2.0.3,10.2.0.4 RAC environment to 11.2.0.1/11.2.0.3 environment Implemented physical standby for 11.2.0.1 Grid database and tested for switchover Cloned and configured Grid, cluster, ASM, Database binaries and database for high availability. Applied latest CPU, PSU patches to all Prod/Uat/Dev databases. Managing backup and recovery of RAC databases.  Cloned Production databases to test databases as per user requirements. Created high availability services and tested for failover Managing backup and recovery RAC databases OCR and VOTING files. Design and implemented RMAN backup strategy for RAC database Converting standalone database to RAC database Administered the cluster databases using CRSCTL and SRVCTL utilities. Implemented RMAN backup strategy for the RAC database. Analysing SQL Queries for excessive CPU usage, high disk reads / writes and execution plans by using TKPROF and EXPLAIN PLAN Generating the database health check reports using AWR, ADDM Migrating the data between production and the development database using Oracle utility Import & Export. Administration of ASM Instances and ASM Disk groups in RAC environment. Involved in query level tuning's as part of performance issues Created users and assigned roles as per user requirements Implemented physical standby database and tested for switchover Tablespace management, User management Roles and privileges Design and implementation of Backup and Recovery activities using RMAN & Export/Import utilities. Taking HOT Backups daily base and weekly cold backup. Data loading from flat files to oracle tables using SQL* loader. Migrating the data between production and the development database using Oracle utility Import & Export.