Oracle DBA

Experienced as Oracle DBA with a demonstrated history of working in the IT and service-based industries.
Major sectors working with:
1)Banking
2)Insurance and data-center
3)Telecom
*Experience of more than 9+ years in Database administration and working at client locations.
*Skilled in Oracle Database Admin, RAC, ASM, RMAN, and strong information technology professional with a Bachelor of Engineering.
*Currently working with 40+ USA, UK, and Canadian clients with wide variation database infrastructure system.

Activities :

• Implemented Active & Passive Oracle Database in 2 Node Rac(12.1.0.2)
• Migrating Cluster and Databases from 11.2.0.3 to 12.1.0.2.
• Configured Oracle Grid Control Monitoring(13c)
• Configured ASM, migrated databases from NON-ASM to ASM
• Migrating single instance to RAC.
• Configured RAC in oracle 10g.
• Migrating production database from 10g to 11g on Linux.
• Upgraded core production database from 9.2.0.6 to 11.1.0.6 using export utility.
• Upgrading core database from oracle 9.2.0.1 to 10.1.2.0.
• Implementing Dataguard as a part of disaster recovery solution.
• Performed quarterly switchover and switchback in manual and managed recovery mode.
• Cloning development and test database with backup of production database.
• Performing de-fragmentation and purging activity.
• Implemented analyze activity for rural banking in core production environment.
• Migrating database from standard to enterprise edition.
• Installing agent software.
• Patching databases using OPatch utility.
• Installing oracle software on Linux, HP-Unix, and windows platform.
• Creating of Oracle Database on Linux and Windows platform.
• Bouncing database and listener.
• Scheduling backups in crontab(Linux) and scheduled task(windows)
• Verifying scheduled user managed & rman backups.
• Managing logical and physical structures i.e. Tablespaces and datafiles growth
• Creating Schema’s and Working with Privileges, Profiles and Roles
• Proper investigation regarding ORA-07445 and ORA-600 with the help of metalink
• Proactively Monitoring file system growth, Alert Log and Archive Destination
• Performing export and import
• Execution of Scripts on Quality and production database.