Oracle DBA Resume

SUMMARY

Over 7+ years of experience as Oracle 11g/10g/9i/ DBA in Production, Development and Test environment on multiple platforms.
Expert in Relational Database concepts and have been involved in Entity - Relationship modeling.
Expertise in Installation, maintenance, upgradation, administration, backup and recovery Of oracle RAC database.
Proficient in Installation and Configuration of 11gR2 cluster ready services and database in NFS and ASM file systems.
Experience in Administering High Availability Databases.
Basic & Advanced Replication environments
Using RAID, EMC Symmetrix Configuration using SRDF/BCV (Time Finder) integrated with Third party tools.
Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
Oracle Database Administration on 24x7 critical production and large databases of over 4 TB using Oracle 10g RAC, 9i.
Experience in Installation, Configuration & re-configuration of Oracle for Large Database on Unix/Enterprise Linux, SUN SOLARIS and Windows environment.
Setup Oracle Enterprise Manager (OEM) 9i/(Grid Control) 10g for database monitoring/performance/diagnostics.
Performance and Tuning: Tuned various large critical OLAP and OLTP databases of Tera bytes size using various tools like STATSPACK, AWR, Oradebug, Tkprof and Explain Plan Methods.
Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import) and proficient in RMAN.
Expertise in configuring, maintaining replication using Oracle Streams at table level (Unidirectional, Bi-directional).
Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage.
Oracle 9i RAC / 10g RAC implementation & administration using Oracle Clusterware (Oracle Cluster ware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery)
Experience in Standby, Data Guard.
Effective troubleshooting of database and performance problems.
Proficient in SQL, PL/SQL, Stored Procedures, Functions, Cursors and Triggers etc.
In-depth understanding of Logical and Physical Design of Databases.
Managing Database Structure, Storage Allocation, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges
Involved in different scenarios of OLTP as well as DSS databases.
Experience in Database Security and Auditing.
Enabling various alerts for Space Management.
Hands on Experience in using tools like Data Pump, SQL* Loader..
Performed Instance Cloning, Code migration processes, Oracle grid-control.
Proficient in INDEX REBUILDING and INDEX TUNING.
Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).
Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases (VLDB).
Have exposure to Automatic Storage Management (ASM) configuration.
Excellent personal time management, organizing, analytical and problem solving skills.
Implemented materialized views
Good communication skills to work independently and in a team environment.
Excellent team player and flair to learn and implement new technologies.
Knowledge on Golden gates
Ability to perform general DBA activities on Netezza
24 X 7 Production Database on Call Support.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship