Oracle Database Administrator Resume

SUMMARY

Over 5 years of experience in Oracle Database Administration with focus on the following areas: Oracle Real Application Clusters (RAC), Backup and Recovery, Capacity Planning and Optimization, Data Modeling and SDLC, Performance Tuning, Contingency Plan for Disaster and Recovery.
Change Control/ Change Management, High Availability, Replication, Data Guard, Oracle Streams, Security & Auditing, Application Design, Development and Implementation, Collaboration with fellow DBAs and other internal teams in Establishing, Documenting and Implementing Database Standards, Sharing responsibility with fellow DBAs for 24/7 on - call support, and Flexibility to adapt to and willingness to learn new technologies.

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

Implemented and maintained operational and disaster recovery procedures
Installed and Configured Grid monitoring tool for Oracle 11g Database.
Perform data migration using Data Pump Export /Import and SQL Loader utilities.
Work with users to resolve database/query performance issues using database advisors and AWR/ASH reports.
Conducted regular database performance testing and tuning
Performance tuning using AWR, ADDM, SQL Trace, and TKPROF.
Control database resource access through user profiles and data access control through Virtual Private Database and principle of least privileges implementation.
Maintain database configurations in compliance with release management and change management.
Installed and Configured Grid monitoring tool for Oracle 11g Database.
Apply Oracle patches for various bugs and quarterly security patches to both primary and standby databases.
Backup/Restore of databases/tables/schema using Datapump export/import and transportable tablespces.
Implemented different Partition methodologies to improve performance and manageability.
Provide 24x7 remote support and on call database support for database Developers and end-users.

Conducted database server performance

Confidential

Responsibilities:

Designed, tested, implemented and documented database migration procedures involving the use of the export/import and migration utilities.
Performed data migration using Data pump Export /Import and SQL Loader utilities.
Developed and implemented backup and recovery procedures of databases.
Configured the necessary parameters for Flashback database settings and Flash Recovery Area, then used RMAN to issue Flash Recovery Commands.
Worked in conjunction with application development team to develop, test and approve database architecture and production schema changes.
Developed and implemented an online reporting platform.
Recommended systems changes to programming management
Established a backup and recovery strategy using daily hot backups, RMAN and weekly full backup.
Created, reviewed and monitor stored procedures and triggers used for user applications and back end reporting.
Maintained database configurations in compliance with release management and change management.
Performed daily database administration on production environments.
Performance tuning using AWR, ADDM, SQL Trace, and TKPROF.
Monitored trace files and log files for errors and database corruption.
24x7 remote support and on call database support for database developers and end users.

TECHNICAL SKILLS

Databases: Oracle 10g, Oracle 11g, SQL Server 2008/2005, MySQL

Operating systems: Linux, Windows

Tools: SQL Developer, DBCA, DBUA, Oracle Enterprise Manager (OEM)

Backup: RMAN, Hot and Cold backup

Migration Tools: SQL Loader, Data Pump (expdp/impdp)

Tuning Utilities: Autotrace, TKPROF, Explain Plan, AWR, ADDM, ASH, SQL Trace

High Availability: RAC, ASM, Grid Control, Data Guard