ORACLE DBA resume

SUMMARY:

Over ten years of professional experience in Oracle DBA/Developer with RDBMS systems. Extensive experience in database design, datamart with Teradata wareshouse. Experience managing/maintaining Oracle 11g/10g databases. Logical and physical database experience, Experience on Backup/Restore using RMAN. PL/SQL, TOAD, SQL*Plus, UNIX and Shell Script experience. Grid Control/OEM experience. RAC, ASM, Data Guard experience.

WORK EXPERIENCE:

ORACLE DBA
Confidential, 11/2011-Present

Responsible for management of complex Oracle 10g and 11g Data Warehouse environments for a large Energy database system.
Led tasks in area of Oracle database server staging, database creation, maintenance, Backup,
Restore, Recovery, Patching, and Upgrade.
Migrated development and test databases into the data center using RMAN backup and duplication; converted single instance databases to the RAC databases.
Successfully implemented Oracle 11g ASM database storage technology
Proven experience in supporting 24x7 business databases environments on UNIX, and Windows. Responded immediately during DBA on-call rotation to critical conditions such as backup failure, database crash, low disk space, database locking, and slow performance
Database monitoring job using OEM
Expertise in Oracle Data Guard with real-work experience in a production setting.
Oracle Grid Control (setup, usage, installation)
Good knowledge of role based securities, manage user accounts, privileges and access

ORACLE DBA
Confidential, 3/2009-10/2011

Responsible for management of complex Oracle 10g and 11g Data Warehouse environments. For a large financial database system.
Working in Production support role, Responsible for the installation, upgrade, administration and performance tuning of various releases of Oracle databases and applications on UNIX.
Applying patches and upgrades to all releases of Oracle Database versions.
Installation and configuration for stand-alone /RAC database. Shell Scripting skills to support Oracle environment running on UNIX.
Implementing comprehensive Backup/Restore mechanisms using RMAN. Supporting Oracle RAC environments. Manage and support multiple Development, Test and Production Oracle environments.
Work with Oracle Utilities like DataPump and SQL * Loader.
Participate in an on-call rotation.

ORACLE DBA
Confidential, 11/2003 - 4/2009

Designed and implemented a database for sales and customer service using Oracle 11g and UNIX. Proactively monitor the Production Database and optimize SQL for better performance for USPS database management system.
Perform database Backup and recovery in support of business continuity using RMAN.
Manage database installation and upgrade scripts corresponding with release cycles. Automate database monitoring using varying scripting technologies (PL/SQL, shell scripts, Perl ). Monitoring using OEM and analysis tools to diagnose relative health of production databases. Test and coordinate Oracle patches and upgrades.
An expert in all topics related to table spaces, indexing and especially partitioning. Knowledge in Oracle Data Guard with real-work experience in a production setting. Knowledge of RAC.Experience with 10g and 9i

Teradata ORACLE DBA/DEVELOPER
Confidential, 1/2000-10/2003

Designing a very large relational Teradata Warehouse for USPS EDW service. Solid in the transition of the logical data models to physical data models using Er-Win, ETL, and data-mining. Designed logical data models ER-WIN, Wrote back end stored procedures using with BTEQ and QueryMan toolsto implement complex business rules. It is under Window XP and UNIX with 9i and 8i.
Work with Oracle Utilities like Standby database and SQL * Loader.

ORACLE DEVELOPER/DBA
Confidential, 7/1998- 1/2000

Responsibilities: Work on the Identification Tasking and Networking project for Federal Bureau of Investigation (ITN/FBI). Involved in design and develop of a fingerprint processing system. Designed ERD with ORACLE Designer/2000 and Developer/2000. Wrote Pro*C&C++ code, Store Procedures and Triggers with ORACLE 8 RDBMS, PL/SQL, SQL*plus and ClearCase. This system is built under HP9000 in a UNIX environment.
Worked to maintain the table space, table, view, database triggers, store procedure, schema, and roles under Server Manager. Monitored the sessions and performed backup functions with archiving redo log files by using Oracle Import and Export utilities.
Developed application to load large amount of data (in both binary and ASCII format) into the tables with SQL*Load tool. Worked on database performance tuning. The system is developed under UNIX, Windows 95 and Windows NT environment.

EDUCATION:
B.S. in Computer Science.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship