Oracle DBA Resume

SUMMARY:

IT professional having around 3.6years of experience as Oracle Database Administrator.
Having Knowledge on configuring ASM Disks &ASM database creation.
Experience in User management, Space management.
Managing Undo Segments, Redo Logs, Checking Alert Log and Trace Files for errors.
Analyze SQL statements using Explain Plan.
Database administration, Managing Table spaces, Objects, Disk Space.
Creation of Schema with Quota Maintenance.
Configuring and managing backup &recoveries through RMAN utility.
Experience in Backup and Recovery concepts.
Creating users with restricted access with required privileges.
Experience in Patching and Decommission Oracle Databases.
Creating and managing database objects like tables, views, and indexes.
Working on Oracle 10g and 11g Databases.
Creating profiles and attaching them with users and monitoring the users.
Performing Schema level/Full DB Refresh using Export &Import andData pump.
Familiar in working with various environments.
Working in 24/7 Production Environment.
Troubleshooting Database related problems.

TECHNICAL SKILLS:

RDBMS: 10g and 11g

Oracle Tools& Utilities: RMAN, Export - Import, Data pump and O Patch.

Enterprise wide Tools: HPSM (Hp service manager)

Languages: SQL

PROFESSIONAL EXPERIENCE:

Confidential

Databases: 350+

Platforms: Linux, AIX, Windows.

RDBMS: Oracle 10g (RAC), Oracle 11g

Oracle DBA

Responsibilities:

Troubleshooting Database related problems.
Managing Undo Segments, Redo Logs, Checking Alert Log and Trace Files for errors.
Creating users, granting privileges /roles, user account unlock and password reset for users.
Adding additional data files to the existing table spaces for resolving space issues
Trouble shooting DB down/Listener Issues.
Taking hot and cold backups.
Performing Schema level/Full DB Refresh using Exp& Imp, Data pump.
Troubleshoot the issues as and when required.
Configuring Recovery Catalog using RMAN.
Handling day-to-day activities and Maintenance of database tasks.
Switching over to Standby from Primary when required.
Monitoring physical and logical backup.
Defragmentation of tables and indexes for improved performance and effective space management.

Confidential, Chicago

Platforms: Sun Solaris, Linux

RDBMS: Oracle 10g, Oracle 11g

Oracle DBA

Responsibilities:

Generating AWR & ADDM Reports and analyzing the same.
Performed Installation of Oracle on Linux, Solaris flat forms.
Adding additional data files to the existing table spaces for resolving space issues
Trouble shooting DB down/Listener Issues.
Handling day-to-day activities and Maintenance of database tasks.
Switching over to Standby from Primary when required.
Taking hot and cold backups.
Performing Schema level/Full DB Refresh using Export &Import, Data pump.
Performed Schema Refresh.
Working on issues on Data guard like resolving Archive log gap on Standby DBs.
Performing CPU Patching for Oracle databases with variety of environments
Creating databases for business Requirements.
Monitoring the database growth, Re-Organization of Tables by using export and import utility and backup and recovery.
Monitoring space at Table space and Mount point Level, Adding space to Table space whenever necessary, adding space to Data files, adding new Data files in various Environments.
Changing Parameter values as required at Database Level.
Monitoring of backups whether successful or not by going to relevant log files and destinations.
Performing Schema level/Full DB Refresh using Exp &Imp and Data pump.
Cloning using RMAN
Analyze SQL statements using Explain Plan.
Database administration, Managing Table spaces, Objects, Disk Space.
Creation of Schema with Quota Maintenance.