We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

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

Hire Now