Seeking a challenging job where I can utilize my skills and abilities to attain self-growth and continuous learning.

• 11g Dataguard
• Knowledge On 11g RAC
• Having good knowledge of Oracle Architecture (SGA, PGA and Background Process)
• Schema Management
• Managing logical and physical structure i.e. Tablespaces and datafiles
• User Managed Backup - Hot and cold backup
• Configuring database listeners
• Cloned production database to the test environment using Recovery Manager (RMAN) without connecting to target database
• Served as Oracle DBA in a 24x7 Production environment managing several Database instances
• Having the experience of Production Database administration, and day-to-day Operations of different Database

Roles and Responsibilities

• Monitoring Alerts for disk space, archive destination, Listener, Instance availability, and ORA errors.
• Creating and monitoring the tablespaces, allocating tablespaces to users.
• Maintaining Archive data on Tape
• Deleting expired, obsolete backupset using RMAN
• Oracle Database patching using Opatch
• Creating and managing database objects like tables, views, and indexes.
• Creation of users, roles, managing user privileges.
• Create Database link to access the object on remote database and check the connectivity.
• Installed & configured Oracle 10g/11g on various UNIX platforms (RHEL4, RHEL 5, OEL5)
• Involved in the creation of client Database instances as per requirements for test environments
• Performed regular Backups as per Organization Strategy to support the database and also maintain 24 hours uptime for the database while carrying out the activities
• Extensively used new features of 11g like Import, Export and Data Pump logical backup and AMM
• Take export backup of important tables of Production database on a daily basis
• Implemented ACTIVE STANDBY feature of Oracle 11gR2 on test environment.
• Cloned oracle 11g database to the test environment using hot backup, and using ACTIVE STATE CLONE using RMAN.
• Involved in database Upgrade from 10.2.0.1 to 11.2.0.2.
• Oracle 11g software cloning.
• Migration of database from one platform to another platform

Backup and Recovery

• Good Exposure to RMAN (Hot & Cold) Backups
• Good Exposure to MANUAL (Hot & Cold