Home

Tirupathi reddy - Oracle DBA

[email protected]

Location: Alpharetta, Georgia, USA

Relocation: Yes

Visa: H1B

[email protected] +1 6783-950-799; Ext:110 Tirupathi Reddy EXPERIENCE SUMMARY An OCP Certified with around 10 years of experience as Oracle DBA in RAC and NON-RAC environments, in which last 2 years worked as Exadata dba, PostgreSQL database, Golden gate. Having knowledge on OCI, AWS and azure data factory. Worked in Cognizant technology solutions, Saksoft limited and IBM. Migrated the databases from Exadata x7 to X8 machine using data guard setup. Performed quarterly image (Domu) upgrade activities on Exadata X8 machine. Planned and implemented DR high availability solutions on OEL 10g Standby Database using Oracle Data Guard. Involved in bundle patch activity on Exadata x8 machines. Upgraded dbaastools on Exadata X8 machine using dbaascli. Configured 19C databases on Exadata X8 machine using json scripts. Having experience in generating TFA and exachk reports on Exadata server. Experience in configuring, backup and restorations from Cloud bucket. Strong knowledge on Three Main HW components on Exadata i.e. DB Servers, Cells and NW components like Infiniband/Roce, Admin Switch and PDUs. Performed DR DRILL s like switch over and switch back using data guard broker. applied COMBO OF OJVM+DB PSU patches on OEM 13.4 database, applied OMS patches on OEM 13.4, applied agent patches on prod and non-prod servers. Implementation and configuration of Data Guard and maintaining physical standby databases. Experience on resolving issues in Data guard like resolving Archive log gap on Standby DB s. Experience in configuring ASM disk groups with External, Normal and High redundancy. Performed backup validation and database restore testing using RMAN from cloud bucket. Experience in database refresh activities using RMAN, EXP/IMP, data pump and Transportable Table spaces. Ability to Diagnose the Database and Application Performance issues and Using Explain plan, Tkprof, AWR, ADDM and ASH to generate the report to check the Performance. And able to tune the database. Interacting with the Developers, to assist them in troubleshooting their problems related to Oracle Databases and Regular monitoring of Alert log file on day-to-day basis. RAC administration with SRVCTL and CRSCTL utilities. Installed Postgres Database (source or rpm in Linux environment). Re-indexing/Vacuuming (regular db maintenance related tasks). Configured PgBadger tool for log analysis. Managing Extract, data pumps, replicate processes for data replication in Golden gate. Having experience in applying Database patches. Performing Rebuilding Indexes on Objects when Required. TECHNICAL SKILLS Database Administration: Oracle 9i, 10g ,11g ,12c and 19c and Exadata X7 and X8, Golden Gate, PostgreSQL database, AWS and OCI Operating Systems: Aix, Unix, Linux and Windows. Oracle Tools & Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, TKPROF, AWR ADDM and OEM. Programming Languages: SQL and UNIX Shell scripting EDUCATION M.C.A(Master of Computer Applications) from Osmania University. PROFESSIONAL EXPERIENCE: Worked as Exadata DBA in Cognizant from APR 2021 to MAY 2023. Worked as Sr. Oracle DBA in SAKSOFT Limited from FEB 2019 to APR 2021. Worked as an Oracle DBA in IBM INDIA Pvt Ltd from JAN-2014 to FEB 2019 COGNIZANT April 2021 to May 2023 Client: TALCOTT RESOLUTION Role: Exadata DBA Roles and Responsibilities: Worked as Exadata DBA for supporting the insurance products with 24*7 and managing over all around 220 databases which include Production, Test and Development servers and RAC. Migrated the databases from Exadata x7 to X8 machine using data guard setup. Performed quarterly image upgrade activities on Exadata X8 machine. Involved in bundle patch activity on Exadata x8 machines. Upgraded dbaastools on Exadata X8 machine using dbaascli. Configured 19C databases on Exadata X8 machine using json scripts. Having experience in generating TFA and exachk reports on Exadata server. Experience in configuring, backup and restorations from Cloud bucket. Performed DR DRILL s like switch over and switch back using data guard broker. Implementation and configuration of Data Guard and maintaining physical standby databases. Worked on issues in Data guard like resolving Archive log gap on Standby DB s. Performed weekly and monthly release activities. applied COMBO OF OJVM+DB PSU patches on OEM 13.4 database, applied OMS patches on OEM 13.4, applied agent patches on prod and non-prod servers. Performed backup validation and database restore testing using RMAN from cloud bucket. Experience in configuring ASM disk groups with External, Normal and High redundancy. Plan, test & implement the database Backup strategies depending on the requirement. Checking the daily, weekly, monthly backup status. Generating Explain & Execution plans for long running queries and optimizing the queries for better performance. Generating performance reports to analyze the Database performance at peak hours. (AWR, ADDM, ASH Reports). Performed schema and table refresh from one database to another database using Data pump. OS level activities like space monitoring of Mount points and purging old log, trace, audit files. Database and schema refresh activities using Export and Import utilities for development and test environments. Responsible for purging and archiving the production databases. Managing Extract, data pumps, replicate processes for data replication in Golden gate. Installed Postgres Database (source or rpm in Linux environment). Re-indexing/Vacuuming (regular db maintenance related tasks). Configured PgBadger tool for log analysis. Performed Flash-Back database using guarantee restore point. SAKSOFT Feb 2019 to April 2021 Client: COLT Role: Sr. ORACLE DBA. Environment: Oracle 10g ,11g and 12c, RAC, Aix, Unix/Linux and Windows Platform. Roles and Responsibilities: Worked as Sr. Oracle DBA for supporting the telecom products with 24*7 and managing over all around 600 databases which include Production, Test and Development servers and RAC. Performed on DR DRILL s like switch over and switch back. Implemented active Data Guard to provide high availability of databases and for disaster recovery (DR) Implementation and configuration of Data Guard and maintaining physical standby databases Worked on issues in Data guard like resolving Archive log gap on Standby DB s. Implemented active Data Guard to provide high availability of databases and for disaster recovery (DR). Creating and administrating Disk Groups in ASM environment. Administration of RAC Instances using SRVCTL Utility Generating Explain & Execution plans for long running queries and optimizing the queries for better performance Generating performance reports to analyze the Database performance at peak hours. (Statspack, AWR and ADDM Reports). Performed database and schema refresh activities using Export and Import utilities for development and test environments. Performed routine checks of space utilization. Extended Table spaces by resizing/adding data files when needed. Data Purging of Production databases for increasing the query performance Performed number of development and test clones from Production databases Interacting with the Developers, to assist them in troubleshooting their problems related to Oracle Databases. Creating database users and by setting the default & temporary tablespaces, assigning quotas, roles, privileges and profiles to users. Creation and maintenance of other database objects like tables, views, synonyms, sequences, triggers and database links. Managing Extract, data pumps, replicate processes for data replication in Golden gate Regular monitoring of Alert log file on day-to-day basis. Working in 24/7 environment and on call support. IBM JAN 2014 to FEB 2021 Client: BHARTI DC (Airtel). Role: ORACLE DBA. Environment: Oracle 10g ,11g, 12c, RAC and Aix, Unix/Linux and Windows Platform. Roles and Responsibilities: Worked as Sr. Oracle DBA for supporting the telecom products with 24*7 and managing over all around 1800 databases which include Production, Test and Development and RAC. Configured rman catalog and added targets for maintaining backup repository. installation of 12c OEM agents and adding/removing targets into OEM. Having experience in configuring Data guard Broker. Having experience on DR DRILL s like switch over and switch back. Implementation and configuration of Data Guard and maintaining physical standby databases. Worked on issues in Data guard like resolving Archive log gap on Standby DBs. Database and schema refresh activities using Export and Import utilities for development and test environments. Documented the necessary procedures as per the industry requirements for data guard RAC installation and Datapump setup processes. Managing Extract, data pumps, replicate processes for data replication in Golden gate. Performed deployment activities like Creating Tables, indexes, & triggers to assist developers. Creating database Users and setting default tablespace and Temporary tablespace, assigning Roles, Privileges and Profiles. Creating and Managing tablespaces and other database objects and resolving related space management issues. Interacting with the Developers, to assist them in troubleshooting their problems related to Oracle Databases. Regular monitoring of Alert log file and trace files on day-to-day basis for errors. Keywords: database