Oracle DBA Resume

OBJECTIVE

To pursue an innovative and challenging career in IT field, be in track with the latest know - how of technology.
Work in a competitive team environment where efforts are recognized and achievement is equally promoted.

SUMMARY

Having 4 years of experience in DBA activities like Database Creation, Tablespace management, User management, Table/Index management.
Very good in designing and creating Table partitions and Materialized Views.
Good in Table Partitioning features like add, drop, exchange, split and merge options.
Good experience Network configuration like listener, tnsnames.
Good in performing Online Redefinition (Non-partition to Partition).
Scheduling jobs using crontab.
Creating and maintaining database links for different databases.
Experience in implementation of backup and recovery strategies like Hot, Cold backups using Physical and RMAN methods.
Having good experience in using original exp/imp and data pump utilities.
Performed imports using database links.
Very good knowledge about Flashback Technology and its features.
Having experience in creating RDBMS homes, database using Cloning (RAC).
Good Experience in Managing, Restoring and Recovering Clusterware Components (OCR, VOTING DISK).
Performed migration from Non-ASM to ASM.
Migrated Single Node Instance to RAC Databases (Non-RAC to RAC).
Managing Databases and clusters using SRVCTL and CRSCTL.
Involved in configuration of TAF (Transparent Application Failover).
Implemented Dataguard in single instance databases as well RAC databases.
Performed Node addition and Deletion in RAC databases.
Having good experience in installation of Grid infrastructure 11gR2 with ASM.
Good experience in upgradation of Cluster and RAC databases from 11gR1 to 11gR2.
Experience in installation, upgrading various versions of database (10g/11g) on different platforms.
Upgrades Involved 11.1.0.6 -->11.1.0.7--> 11.1.0.7.7-- >11.2.0.3.
Experience in installation and configuration of Oracle 11g Data guard, switchover and failover.
Experience in monitoring the performance of database using performance tools such as AWR.
Configuring and maintaining OEM.
Experience in preparing the Technical Documents on relevant topics.

TECHNICAL SKILLS

RDBMS: Oracle 10gR1/11gR1&11gR2 & Oracle 10gR1/11gR1&11gR2 RAC, ASM

Operating System: Redhat/Oracle Enterprise Linux 4/5.5.

Languages: SQL, Shell Scripting.

Database Tools: exp/imp, Data pump, AWR, RMAN, ASMCMD

RAC Utilities: Crsctl, Srvctl, Cluvfy, oifcfg, Opatch, SCAN.

Dataguard: Physical Standby, Active Dataguard, Snapshot Dataguard.

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

Installation and Configuration of Oracle 11g.
Managing data file objects including tablespace and datafiles, object sizing as well as monitoring database usage and growth.
Creating Users, Profiles and Roles.
Performing exports/imports and RMAN backup and recovery.
Managing tablespaces, user profiles, indexes, storage parameters.
Performance tuning using AWR.
Developed standards for directory structures on new UNIX boxes.
Responsible for creating user logons and managing user accounts.
Involved in Creation and Maintenance of table partitions and indexes.
Adding space to the data files according to tablespace growth.
Backup and Recovery strategies for Oracle database using expdp/impdp, cold and hot backups.
Backup and maintenance of OCR and Voting Disk files.
Created database links for multiple databases.
Configuring the RAC database in archive log mode.
Creation of RAC Database Using ASM.
Adding, Deleting RAC nodes to and from Cluster.
Converting the single instance database to RAC database for test instance.
Monitoring of RAC and Database instances using srvctl and crsctl.
Refreshing dev database from production environment

Confidential

Oracle DBA

Responsibilities:

Managing tablespaces, user profiles, indexes, storage parameters.
Performing database upgrades from Oracle 9i to 10g as part of new releases.
Created a number of database instances for development, testing and production.
Good in performing exports/Imports and RMAN backup and recovery.
Performed number of dev, test and stage cloning from PROD databases.
Migrated databases between machines.
Adding space to the data files according to tablespace growth.
Installed patch sets and upgraded Oracle (RDBMS).
Cloning the databases regularly for the reporting databases and stage environments.
Implemented Materialized Views for efficient and high availability of Processed Sales data.
Regular database activities, backups monitoring and troubleshooting.
Involved in Users and Space management.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship