Oracle Rac Dba Resume
4.00/5 (Submit Your Rating)
MA
SUMMARY
- 6+ years of experience in Oracle RAC DBA, Oracle DBA, Red hat Linux Admin encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Performance Monitoring and Tuning, RAC, Data Guard, e - business suite and web logic installation & Configuration.
- RAC DBA, Oracle DBA, providing 24x7 support of both Production & Development on Various Platforms.
PROFESSIONAL EXPERIENCE
Confidential, MA
Oracle RAC DBA
Responsibilities:
- Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
- Installing & configuring Oracle cluster ware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issue, deinstallation & cleanup of cluster ware)
- Testing and benchmarked the application prior to going into production to determine its effects on with special focus on load testing for interconnect traffic.
- Worked with customer for different RAC related issue
- Troubleshoot performance issues for the RAC instances
- Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster ware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
- Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
- Resolved/Diagnose Node Eviction.
- Upgrade of 10g R2 RAC to 11g R1 RAC
- Upgrade of 10g R2 RAC to 11g R1 RAC
- Add or Remove Node from RAC.
- TAF Configuration
Confidential, Atlanta GA
Database Administrator/Data Modeler
Responsibilities:
- Tuned SQL created by the developers and changed various db parameter to enhance performance
- Utilized Oracle Enterprise Manager (OEM) for monitoring, administration and performance tuning and SQL developer.
- Performed Oracle Database 10g and RAC 11g Tuning and Performance.
- Designed and Implemented Software change control for database and other application components
- Utilized Oracle internals Knowledge including SGA, tables and index partitioning.
- Able to identify issues and recommend and implement solutions.
- Rotational On-call production DBA support
Confidential, Dedham, MA
Oracle DBA
Responsibilities:
- Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle
- Installation and administration of Oracle 11g/10g/9ion OEL, RHEL,Windows, UNIX and Sun Solaris in OLTP environment.
- Performed Migration and Upgrade of databases to 11g and 10g
- Up gradation of databases applying patches, patch sets and critical patch updates.
- Installation and configuration of Oracle Server RAC with ASM on multi node systems, 11g, 10g and 9i in different operating systems for OLTP environment on Very Large Databases(VLDB).
- Experience on Oracle ASM/RAC and up gradation of standalone databases to 11g RAC environment.
- Configuration of Automatic Storage Management (ASM).
- Configuration and Management of Data Guard on RHEL, OEL and Windows.
- Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
- Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control
- Experience on import/export.
- Regular database synchronization for test database environments through automation.
- Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g/9i.
- Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
- Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, data pump export/import.
- Migrating the databases from one platform to another platform.
- Implementation of Flashback Technology
- Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
- Experience working with Database Resource Management.
- 24*7 on-call production database support and maintenance including remote database support
- Assisting in implementation of change control process in production.
- Ability to work in a team as well as to take individual responsibility.
- Expertise in installation and configuration of Oracle and large databases on Unix Operating System.
- Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.