Oracle DBA Resume

EXPERIENCE SUMMARY:

Oracle Database professional with over 4 years of experience. Worked in large - scale database environments (developmental, test and production) in various platforms such as LINUX/UNIX and Windows.
Highly motivated individual with strong leadership and interpersonal skills, who can be trusted with highly sensitive/confidential documentation and projects.
Self-starter and adaptive learner exceeding business standards and expectations.
Possesses excellent written and verbal communication with the ability to articulate a variety of concepts to technical and non-technical audiences.

SKILL:

EXPERIENCE DETAILS

Confidential

Oracle DBA

Responsibilities:

Oracle 11g and 12c RAC Database monitoring, backup and recovery and maintenance.
Created Physical Standby databases, configured log shipping. Worked on switching over these physical standbys to primary and original primary as physical standbys.
Performed batch jobs using Crontab utility.
Monitored and Troubleshot database performance using OEM, AWR, ADDM, Explain Plan, SQL Trace, TKPROF, ASH, ADRCI and Cluster Interconnect Tuning (RAC).
Performed backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.
Cloned schemas, objects and databases on new server using exports from 10g database and imported in 11g using data pump.
Installed and configured Weblogic 11g and 12c on RedHat Linux environment. Configured Weblogic domain and performed code deployment on Oracle Weblogic domain.
Implemented Flashback technology of Oracle 11g and 10g along with Recycle bin for faster recovery of databases and database objects.
Configured Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
Member of Production DBA Team and participated in ON-CALL rotation.
Maintained and administered data warehouses

Confidential

Junior Oracle DBA

Responsibilities:

Installed Oracle 10g and 11g on Linux environment
Created Users and Assigned Roles/Privileges, Expiring User Password, Creating User Profiles.
Refreshed test and development databases from production database.
Utilized TOAD for database management.
Installed Oracle Grid Control Management Server.
Created Testing and Development databases following OFA compliance rules.
Identified and removed fragmentation, row migration/chaining of database objects.
Performed space management, capacity planning, disaster recovery and overall maintenance of databases.
Performed incremental backups using RMAN.
Identified and recovered corrupted db blocks using Block recover option in RMAN utility
Troubleshoot and resolved various Oracle connectivity problems.
Perform bulk load into the database using SQL Loader.
Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10g.
Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.