Summary
Overview
Work History
Education
Skills
Timeline
Generic

Pavan Asopa

Mumbai,Maharashtra

Summary

Talented Database Administrator with 3.7 years of expertise and extensive knowledge of Oracle RAC. Excellent communicator with advanced presentation creation and delivery skills.

Overview

8
8
years of professional experience

Work History

Oracle Database Administrator

Clover Infotech
Mumbai , Maharashtra
2016.06 - Current

Real Application Clusters (Oracle RAC):

• Oracle RAC 10gR2 / 11gR2 / 12cR1 / 12cR2 installation and configuration.
• Patching Oracle GRID and RDBMS.
• Adding/Deleting ASM Disk group
• Multiplex OCR/Voting in RAC
• Oracle RAC upgrade from 10g RAC to 11g RAC
• Oracle RAC upgrade from 11g RAC to 12c RAC (CDB / Non CDB)
• Node addition / deletion in Oracle 10g/11g RAC
• RAC IP change activities.

Database Upgradation / Migration:

• Single instance database upgrades from 9i to 11gR2 , 10g to 11gR2 / 12c and 11gR2 to 12c.
• RAC database upgrades from 10gR2 to 11gR2.
• RAC database upgrades from 11.2.0.2 to 11.2.0.4.
• RAC database upgrades from 11.2.0.4 to 12.1.0.2.
• RAC database upgrades from 11.2.0.4 to 12.2.0.1.
• Standalone GRID upgrade with RDBMS from 11.2.0.2 to 11.2.0.4 along with OS cluster.
• Cross platform database migration from RHEL to Windows and Solaris to Linux.
• Handling upgrades with standby in place.

Oracle Disaster Recovery:

• Single instance DR and Oracle RAC DR
• Cascaded standby databases and Logical standby database.
• Configuration of oracle Active dataguard.
• Manual DR for oracle standard edition database.
• Switchover and Switchback of single instance and RAC standby databases.
• Flashback standby databases.
• DataGuard Broker

Oracle Advanced Security:

• Oracle Database Vault.
• Transparent Data Encryption.
• Data Masking.
• Data Redaction.
• Oracle Audit Vault and Database Firewall

Oracle Enterprise Manager:

• Configuring and Installing Oracle Enterprise Manager Cloud Control 12c/13c.
• Data Masking / Data Redaction Through OEM.
• Monitoring Multiple Databases Through OEM.
• Configuring Database Aalerts, ASM alerts etc.
• Configuing reports like Database Checklist Report, Capacity Planning Report, DR sync report etc.

Education

Bachelor of Science - Electrical, Electronics And Communications Engineering

Basaveshwar Engineering College
Karnataka
06.2015

Skills

  • Running backups
  • Systems administration
  • Linux operating system
  • Compiling data
  • Implementing security measures
  • Problem resolution

Timeline

Oracle Database Administrator

Clover Infotech
2016.06 - Current

Bachelor of Science - Electrical, Electronics And Communications Engineering

Basaveshwar Engineering College
Pavan Asopa