Oracle Database Administrator Resume
3.00/5 (Submit Your Rating)
Falls Church, VA
PROFESSIONAL SUMMARY:
- Six years’ experience providing data management and DBA functions.
- Highly skillful and talented in installation, configuration and maintenance of Oracle 12c and 11g, databases.
- Development experience on UNIX/Linux and Windows systems and experience with SQL.
- Expertise in Performance Tuning and OEM.
- In - depth knowledge of and experience in designing and maintaining conceptual, logical, and physical data base models.
- Managed multiple 24x7 Production, Test and Development Databases on single instance DBs.
- Administrated databases using OEM Grid Control.
- Experienced in planning, installation, maintenance, configuring and administering of standalone, backup and Recovery, RMAN, server consolidation, DB migration, upgrades and patching.
- Expertise in database administration, installations, configuration, upgrades, migration, performance tuning, backup and recovery, cloning, space management, patching, security, Fine grained auditing, capacity planning and designing databases.
- Monitored different databases and application servers using OEM Grid Control.
- Proficient in database design for OLTP and OLAP.
PROFESSIONAL EXPERIENCE:
Oracle Database Administrator
Confidential, Falls Church, VA
Responsibilities:
- Planned, installed, configured, managed and troubleshot Oracle 12c and 11g databases on Linux and Windows OS.
- Managed and maintained Oracle 12c and 11g database servers across multiple environments.
- Expertise in the creation of databases, table spaces, tables, indexes and other database objects.
- Installed and manage Oracle Enterprise Manager.
- Performed bulk load into the database using SQL Loader.
- Performed standard and fine grain database auditing.
- Documented database structure, changes, problems, issues for future reference.
- Administered database user accounts: created, modified and deactivated user accounts; assigned and monitored user access rights.
- Configured and implemented the use of RMAN for cold and hot backup to the databases.
- Used DATAPUMP and Export /Import utilities extensively for logical backups.
- Performed database cloning using RMAN.
- Monitored the user sessions and take appropriate action to kill the inactive sessions.
- Created and rebuilt indexes as necessary.
- Performed various performance goal oriented database tuning.
- Used Explain Plan, AWR, ADDM and various Oracle Advisors to tune the database.
- Created and tuned various materialized views as well as tuned various slow running queries.
- Performed instance tuning, memory tuning query tuning and complete database tuning.
- Created and implemented various table partitions for large tables.
- Applied quarterly CPU patches to different version of databases.
- Upgraded Oracle 10g DB to 11g and Oracle DB 11g from 11.2.0.1 to 11.2.0.3 using patch set.
Oracle Database Administrator
Confidential, Bowie, MD
Responsibilities:
- Configured various RMAN parameters as per the requirement.
- Performed physical backups using RMAN utility.
- Identified and recovered the corrupted database blocks using Block recover option in RMAN.
- Configured and implemented the use of RMAN for cold and hot backup to the databases.
- Installed and configured relevant network components to ensure database access as well as database consistency and integrity.
- Troubleshoot and resolved various Oracle connectivity problems.
- Provided troubleshooting assistance to all issues and concerns related to Oracle Forms.
- Performed balancing on the scalability of data conversion and configuration.
- Provided network troubleshooting and administrative support for the development staff.
- Installed and managed of Oracle database using database control.
Oracle Database Administrator
Confidential, Silver Spring, MD
Responsibilities:
- Configured various RMAN parameters and performed physical backups using RMAN utility.
- Performed Complete Media Recovery of Database depends on the nature of failure.
- Configured and implemented the use of RMAN for cold and hot backup to the databases.
- Resolved various Oracle connectivity problems.
- Installed and managed Oracle database using database control.
- Administered database user accounts: created, modified and deactivated user accounts; assigned and monitored user access rights.
- Monitored tablespaces and datafiles utilization as well as managed undo tablespaces, redo logs, control files, and archive logs.
- Implemented multiplexing control files and redo log files