We provide IT Staff Augmentation Services!

Sr. Oracle Dba Resume

CA

8+ years of IT experience as an Oracle Database Administrator having hands on experience in Installation, Management, Administration, Backup and Recovery, Performance monitoring and Tuning of Oracle RDBMS.

Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.

Performed Capacity Planning and Bench Marking.

Partitioned tables for better performance and manageability.

Logical and Physical Database design.

Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.

Used SQL*Loader (sqlldr) utility which is used for high data loads from any text file, to inserted into database.

Scheduled Jobs through Job Scheduler

Performed data modeling using Erwin data modeler.

Responsible for allocating system storage and develop plans for future storage, implementing policies and procedures to ensure the integrity, security, availability, and accessibility databases like capacity planning.

Installed and created Oracle10g databases in development, Production and QA environment including configuration, backup & performance tuning.

Implemented Oracle RAC (Real Application Cluster) with four nodes for Scalability and high availability.

Loading data into a normalizedOracledatabase using SQL*Loader and External tables.

Coding and preparation of Test plans.

Upgraded databases from 8i, 9i to 10g, 10g to 11g and applied patches.

Extensively worked on deployment/migration process, data flow control between production,development and reporting.

Created and monitored the Standby database Configuration for the Disaster recovery scenarios.

Worked withOracleData Pump(expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.

Implemented Replication using Oracle streams

Design and implemented backup strategies, like, incremental, complete and cumulative Backup of the database using Recovery manager (RMAN). Used utilities like Export/Import and Data Pump. Performed Hot/Cold Backups.

Design and developed scripts to monitor instance locks, long running queries, free space, and extent growth.

REFRESH/CLONING of Database using RMANDuplicate for development, testing.

JavaScript Requires
Sorry this site will not function properly without the use of scripts.
The scripts are safe and will not harm your computer in anyway.
Adjust your settings to allow scripts for this site and reload the site.