Database Administrator Resume Profile

Senior Oracle DBA with more than 7 years of experience in Building and maintaining mission critical Production databases. Hands on experience in installing and maintain Real Application Cluster RAC , Golden Gate and Exadata. Very good troubleshooting skills in RAC, Dataguard and Golden Gate.

Summary

7 years of experience as Oracle, Sybase and SQL Server DBA.
Worked on project for consolidating warehouse within Asset management Business unit for Fidelity.
Experience of managing Datawarehouses on Exadata boxes.
Hands on experience installing, creating and maintaining RAC databases. Worked on 10g and 11gr2 RAC.Good knowledge of ASM.
Extensive experience in Oracle Golden Gate. Worked on installing and maintaining Oracle Golden Gate from Oracle to non-Oracle RDBMS.
Currently managing 4 half Rack X2 Exadata boxes.
Excellent ability to quickly learn new software and apply full range of capabilities.
To work in a challenging environment and be known for depth of knowledge, innovative ideas, hard work, quality, timeliness of service, and honoring the commitments.
Self starter with drive, initiative and a positive attitude.
Excellent ability to troubleshoot RAC node evictions, Issues with Dataguard.

TECHNICAL PROFILE

SKILLS	TOOLS
Operating Systems Worked On	Linux,AIX,Solaris,Windows
Databases	Oracle 11G,Oracle 10G,Oracle 9i,Sybase, ASE 12.5,MS SQL Server 2000,MS SQL Server 2005,SQL Server 2008,TimesTen
Programming Language	SQL

WORK EXPERIENCE

Confidential

Designation : Senior Database Administrator

Confidential

Designation : Senior Database Administrator.

Responsibilities

Developing Backup strategies for weekend backups of Critical environments

Duplicating a database through RMAN.

Implementing Golden Gate from Oracle to different RDBMS like Sybase,AS400.

Perform compression on warehouse databases using Exadata Hybrid Columnar Compression.

Setting up dataguard.

Setting up dataguard from Non RAC to RAC database.

Administer all database servers.

Manage Datawarehouses on Exadata environment.

Installing and maintaining Oracle Database servers on request of the customers.

Setting up Pro-active Monitoring jobs on the database.

Refreshing schemas from production to development.

Applying patches to the instances to fix the bugs.

Upgrading the database.

Sizing of the database. Sizing of redo,undo,temp tablespaces etc.,

Backing up the databases.

Applying CPU patches

Applying PSU Patches

Applying PSU Patches to RAC databases in Rolling forward mechanism..

Develop basic perl scripts for user creation, password reset.

Performing Disaster Recovery using Data Guard.

DETAILS OF THE PROJECT WORKED

The environment is multi RDBMS environment with major percentage being Oracle .Sybase and MS SQL Servers being the other RDBMS.The environment is quite complex one with Dataguard,Real Application Clusters, Oracle Streams, Sybase Replication,MS SQL Server Logshipping,MS SQL Data mirroring .
One of key task of the project is management of the databases and also troubleshooting the issues which come up in the databases in minimum period of time ensuring no down or minimum down time.
The project also expects us to cater to the needs of the customers by continuously keeping track of their requirements and in case of emergencies quickly help them out. Below are some of the major accomplishments:
Datawarehouse consolidation: The purpose of the project was to consolidate different Datawarehouses on to one Warehouse. We also achieved to move off the databases from AIX to Linux as a part of this exercise. We used Golden Gate for this project to achieve zero downtime migration.
Migration of database from Non RAC to RAC: The purpose of the project was to migrate Non RAC database to RAC database. This was achieved by setting up dataguard from Non RAC to RAC database. Then performing cutover from Non RAC to RAC database.
Golden Gate implementation: Implemented Golden Gate from Oracle to Oracle,Oracle to Sybase,Oracle to AS400 and Oracle to JMS queue.
Duplicating database through RMAN: The purpose of duplicating database in this particular project was to recover tablespace to point in time. This was achieved by creating auxiliary instance as of the required point in time and then doing export-import of that particular tablespace.
Duplicating RAC Database: Duplicated RAC Database to standalone database and performed Database point in time Recovery.
CPU Patching: The Purpose of the project was to patch all 9.2.0.8 and 10.1.0.5 instances in the environment.
PSU Patching: Purpose of this project was to apply PSU Patch for all 10.2.0.4 RAC and Non RAC databases.
Upgrade database to 11G: The purpose of this project was to upgrade database to 11G.The same was achieved by using DBUA.
Install 11GR2 RAC Grid Infrastructure: Installed 11GR2 Grid Infrstructure .Installed ACFS.
Sizing of database: The purpose of the project was to size various files of database like redo,undo,temp .
This project also involved evolving an effective strategy for efficient usage of space for SYSAUX tablespace.Space recommendations to user tablespace were made by using Segment advisor.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship