Subramanyam Muddamsetty Email & Phone Number

 Around 8 years of experience as ORACLE DBA, RAC, Golden Gate, Oracle Pl/Sql, Cloud DBA, Data Guard, DBA support both in Production and Non-Production domain. Currently associated with “Accenture’’ as Oracle Database Administrator. Oracle database administration and application support on 24X7 critical production and large databases in multiple database versions ranging from 11g, 12c. Working as L3 DBA in both environments of Oracle Database (Oracle Enterprise Edition and Oracle Standard Edition). Good understanding of Database Architecture. Doing core DBA activities like database creation, database Decommission user management, memory management. Handled databases ranging from 500 GB to 5 TB in different environments. Good knowledge in Migration to Azure and handling Azure databases  Creating primary Database storage structures (tablespaces, datafiles, resizing them) Handle logical backup by datapump utility (export, import), routine maintenance tasks such as backups and recoveries, applying patches, upgrades and performance monitoring. Effective management in Materialized views, views, logon triggers with database links.  Database Backup & recovery, hands on experience using RMAN and incrementally updated IMAGE copy backups with FRA. Implement and maintain backup and archiving procedures in line with business and regulatory requirements. Done tablespace re-organization from non-standard blocks to standard blocks. Added disk to disk group with rebalanced operation in ASM. Perform Database monitoring and tuning to ensure databases run at peak performance, troubleshooting performance issues. Creating indexes and rebuilding them. Involved in performing disaster recovery from primary to standby, fixing the gap resolution of archive logs and rebuild the Standby Databases (data guard). Involved in Migration of RAC and standalone server databases to AWS EC2 with snapshot backups and RDS by DMS method. Handling Oracle database in AWS cloud on RDS and EC2. Migration of OCR and VD to another disk group with different redundancy in RAC setup. Having Good knowledge in POSTGRESQL. Good knowledge on Configuring Physical standby using Data guard and Perform failover and switch over  Configured hot standby and switch over on PostgreSQL.  Involved in maintenance activities like purging obsolete trace files using ADRCI, compiling invalid objects with script utlrp.sql in database is also part of activity. Involved in patching, upgradation and downgrade of GRID and database from 11.2.0.4 to 12.2.0.1.

• 

  Vagdevi Intitute Of Technology, Proddatur

  Information Technology