Oracle Database Administrator Resume Irving, TX - Hire IT People

PROFESSIONAL SUMMARY:

4 years of experience as an Oracle DBA in Production, Development and Test environments, and transforming business strategies into efficient and integrated global business solutions.
Experience in Upgrading databases and applied patch sets to multiple databases.
Expertise in database space management and expertise in troubleshooting and performance tuning.
Backup of databases (Making backup schedules depending upon business strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
Recovery of databases (Recovering from media failure, recovering tables dropped accidentally, recovering data files, recovering from block corruption etc.)
Experience in using OEM grid control, TOAD, and data migrations using export/import.
Experience in using 10g features data pump, flash - back recovery, AWR, ASM, ADDM, and Grid Monitoring.
Database performance tuning using Explain Plan, AWR, ADDM, ASH.
Experience on working with data guard physical standby databases.
Performance tuning experience, 10g and 11g RAC tuning and Load balancing.
Expertise in configuration and Installation of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables and SQL*LOADER.
Skilled in dealing with RAIDs on local server (Via RAID card BIOS) in ASM environment such as installation, taking backup, migration of database from Non - ASM to ASM environment.
Excellent knowledge in hot/cold backup, recovery, cloning of databases using RMAN.
Excellent Written and verbal Communication skills with a customer service-oriented attitude.
Knowledge on Oracle Support processes for technical requests with Metalink.

TECHNICAL SKILLS:

Operating systems: Linux, Solaris

Databases: Oracle 11g, 10g (RAC, RAC one node and single instance)

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control

Tools: Export/Import, RMAN, Data Pump, Winscp

Languages: Unix shell scripts, PL/SQL, Perl

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Oracle Database Administrator

Responsibilities:

Involved in 24x7 supports for production databases.
Worked with DBA Team of 20 members and 24*7 Support.
Maintained instances of around 10 TB.
Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
Performing periodic backups (daily, weekly, and monthly) and created, performed recovery strategies using RMAN utility.
Taking schema backups using data pump and import.
Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).
Write SQL scripts to monitor table space and extent growth.
Forecasting and future planning for tables space growth.
Performance tuning of databases for optimized results using AWR and ADDM reports, stats gathering, creating indexes, optimizer hints and analysis of explain plan.
Data refresh from Production to development and test environments using data pump utility.
Development databases, which includes hot backup, cold backup, and export backup.
Tuning the database performance through ASH/AWR/ADDM report.
Troubleshooting of Oracle Golden Gate, administration of data replication between different environments
Experience of working in Database as a service (DBaaS).
Guiding the application team to understand how the database works with their application.
Monitoring the day-to-day activities of Production database, monitoring its growth and performance using OEM.
Extensively used Autosys to schedule Unix shell and Perl script jobs.
Manage the change control by taking responsibility of tickets and assigning the queue to team members thereby keeping it balanced.
Play the role of secondary on call DBA to support the escalations from the base level of contact

Environment: 11g, RAC, Sun Solaris, AIX, ASM, GRID, AWR, ADDM, OEM, Data Guard, Golden Gate, RMAN

We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Irving, TX

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship