Database Administrator Oracle Cloud
Resume:
Certified: Microsoft Azure Oracle Cloud
Praveen Kumar Desai Karanam
Email: ****************@*****.***
Phone#: +1-470-***-****
linkedin.com/in/praveenkumardesaikaranam-137083203 Valid H1B: October 1st, 2024 - September 30th, 2027 EXPERIENCE SUMMARY
Lead Database Administrator - I have around 9 years of experience in the field of IT Industry as Oracle DBA in RAC and NON-RAC environments, experience on PostgreSQL database, MYSQL. Having knowledge on OCI, AWS.
• Having experience in generating TFA and exachk reports.
• Performed DR DRILL-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.
• Implement and configure Data Guard and maintain 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.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Experience in Partition purging activity and backup and restore Partition from prod to non-prod using data pump.
• Tuning the SQL Queries using explain plan, TKPROF and Index Tuning.
• Perform database tuning and performance monitoring.
• Experience in Database Performance Tuning- Working with Indexes, Table Partitioning and Performance Reports Generation and analyzing.
• Worked on Table Partitioning (Range) and related indexes.
• 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. Certified: Microsoft Azure Oracle Cloud
TECHNICAL SKILLS
• Database Administration: Oracle 9i, 10g,11g,12c and 19c and Golden Gate, PostgreSQL database, MYSQL, AWS and OCI
• Operating Systems: Aix, Unix, Linux, HP-UX and Windows.
• Oracle Tools & Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * Loader, TKPROF, AWR ADDM and OEM.
• Programming Languages: SQL
EDUCATION
• Bachelor of Engineering, SCSVMV University, Kanchipuram in 2015. CERTIFICATIONS:
• Microsoft Certified: Azure Fundamentals(Certification number: B4BD64-E4E5V2)
• Oracle Cloud Data Management 2022 Foundation Certified Associate(Credential ID OC2353386)
• Oracle cloud Infrastructure Foundations 2021 Certified Associate(Credential ID OC2353386) PROFESSIONAL EXPERIENCE:
• Lead DBA in Infosys from March 2023 to April 2025.
• Senior Oracle DBA in Cognizant from Feb 2021 to March 2023.
• Cloud Administrator in Parametric Technology from Aug 2020 to Jan 2021.
• Oracle DBA in Cyient Ltd from May 2016 to FEB 2020 INFOSYS March 2023 to April 2025
Project: Syntegon
Role: Senior Oracle DBA
Worked as Oracle DBA for supporting the products with 24*7 and managing over all around 1500 databases which including Production, Test and Development servers, RAC, PostgreSQL and AWS RDS databases.
• Performed DR DRILL’s like switch over and switch back using data guard broker.
• Implement and configure Data Guard and maintain physical standby databases.
• Worked on issues in Data guard like resolving Archive log gap on Standby DB’s.
• Performing Switchover and switch back activities between regions on AWS RDS oracle and PostgreSQL databases.
• Performed database and schema refresh activities using Export and Import utilities for development and test environments.
Performing OS level activities like space monitoring of Mount points and purging old log, trace, audit files.
• Managing Extract, data pumps, replicate processes for data replication in Golden gate
• Adding tables in existing Extract and Replicant processes and performing IDL. Certified: Microsoft Azure Oracle Cloud
• Managing Extract, data pumps, replicate processes for data replication in Golden gate.
• 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.
COGNIZANT Feb 2021 to March 2023
Project: TALCOTT RESOLUTION, Griffin Road North, Windsor Role: Senior Oracle DBA
Roles and Responsibilities:
Worked as Oracle DBA to support insurance products 24*7 and managing over all around 220 databases, which included Production, Test, and Development servers and RAC.
• 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 and 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.
• Tuning the SQL Queries using explain plan, TKPROF and Index Tuning.
• Perform database tuning and performance monitoring. Certified: Microsoft Azure Oracle Cloud
• Experience in Database Performance Tuning- Working with Indexes, Table Partitioning and Performance Reports Generation and analyzing.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer-related data.
• Worked on Table Partitioning (Range) and related indexes.
• Experience in Partition purging activity and backup and restore Partition from prod to non-prod using data pump.
• 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).
• Performed Flashback database using guaranteed restore point. PARAMETRIC TECHNOLOGY Aug 2020 to Jan 2021
Role: Cloud Administrator.
Environment: Oracle 10g,11g and 12c, RAC, Aix, Unix/Linux and Windows Platform. Roles and Responsibilities:
Worked as cloud administrator managing around 600 databases which include Production, Test and Development servers and RAC.
• Performed on DR DRILL’s like switch over and switch back.
• Implement and configure Data Guard and maintain physical standby databases
• Worked on issues in Data guard like resolving Archive log gap on Standby DB’s.
• 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 to increase query performance
• Performed several development and test clones from Production databases
• Interact 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.
Certified: Microsoft Azure Oracle Cloud
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Worked on Table Partitioning (Range) and related indexes. Experience in Partition purging activity and backup and restore Partition from prod to non-prod using data pump.
• Managing Extract, data pumps, and replicate processes for data replication in Golden gate
• Regular monitoring of Alert log file on a day-to-day basis.
• Working in a 24/7 environment and on-call support. CYIENT May 2016 to Feb 2020 Role:
ORACLE DBA.
Environment: Oracle 10g,11g, 12c, RAC and Aix, Unix/Linux, HP-UX and Windows Platform. Roles and Responsibilities:
Worked as Oracle DBA with 24*7 and managed 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.
• Implement and configure Data Guard and maintain physical standby databases.
• Worked on issues in Data Guard, like resolving the Archive log gap on Standby DBs.
• Database and schema refresh activities using Export and Import utilities for development and test environments.
• 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.
• Interact with the Developers to assist them in troubleshooting their problems related to Oracle Databases.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer-related data.
• Worked on Table Partitioning (Range) and related indexes.
• Experience in Partition purging activity and backup and restore Partition from prod to non-prod using data pump.
• Regular monitoring of the Alert log file and trace files on a day-to-day basis for errors.
Contact this candidate