Oracle Database Administrator Resume

SUMMARY

Having 2.6 years of professional experience in providing Oracle Database Administration support.
Experience with supporting the Production Database with complete lifecycle including Installations, Upgradation, Patching, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC).
Having noledge in oracle Architecture. Installation, setup and configuration of Oracle 11g and 12c on Linux platform.
Having noledge on database creation using DBCA method and Manual method.
Experience in Configuring & managing backups using RMAN utility by scheduling backups in crontab and also from OEM 13C cloud console.
Applying PSU patches and Bug patches to fix the bugs using OPatch&OPatchAuto both rolling & non - rolling manner.
Experience in performing schema & Table level refresh using Logical backups method and Datapump.
Creating and monitoring the tablespaces, allocating tablespaces for users& managing the space issues.
Administered database user accounts. Created, modified and deactivated user accounts, assigned and monitored user access rights.
Generating AWR, ADDM & ASH Reports to monitor the performance of the database.
Configured OEM, creating agent homes and adding hosts & targets.
Having working Knowledge on AWS RDS instances.
Having good experience on Automatic Storage Management (ASM).
Performed various tasks on ASM -- Creating a disk group, adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM.
Closely worked with Storage and Unix Teams for additional storage to ASM and file system and any Storage related issues.
Experience in configuring high-availability using DATA GUARD with Physical Standby for both Standalone & RAC databases.
Experience in creating a Snapshot Standby as per the application team request for Application Testing & reporting purpose.
Administering & Monitoring the Standby databases using Data dictionary views, alert logfile .
Troubleshooting the Standby database issues like archive log gap between primary & standby (Gap Resolution), missing of data files at standby side, applied logs with delay.
Having good understanding of Oracle RAC Architecture.
Knowledge of Installation and Configuration of Oracle 11g/12c Real Application Clusters (RAC) databases on Linux/Unix operating system.
Experience in Rolling Patch and Non-Rolling Patch for RAC Databases using Opatch and Opatch Auto.

TECHNICAL SKILLS

Operating System: Linux, OEL6/7, Windows,Sun Solaris

Databases: Oracle Versions 11gR1&R2/12c/18c

DB Technologies: RAC, Data Guard, ASM & Flashback

DBA Tools: OEM, VNC Viewer, WinSCP, Putty, Service Now etc.

Backup & Recovery: EXP/IMP, EXPDP/IMPDP, RMAN, Hot & Cold

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

Creation of database users by setting the default tablespaces, assigning quotas, roles, privileges and profiles.
Applied PSU patches every quarter recommended by Oracle on Standalone and RAC databases.
Refresh the database, Schema using EXPDP/IMPDP from production to development database for further testing purposes.
Troubleshooting database issues like Table space Utilization, Temp & Undo Table spaces.
Resolving archive log gap between Primary and Standby databases using RMAN incremental backup and Managing Media Recovery process, Network failures and Configuration issues.
Involved in OS Patching for performing the activities related to the Databases.
Implementation of Backup and Recovery Strategies using RMAN.
Troubleshoot and resolved log gap in Data Guard Configuration.
Monitoring the ASM disk groups by adding, removing the disks to the Disk groups.
Scheduling and creating scripts for archive log, RMAN backups using CRONTAB and OEM.
Raising SR to Oracle Support for various Internal ORA errors, bugs and issues.
Handling experience on checking the locks, inactive sessions and took appropriate actions to kill inactive sessions, long running jobs and high CPU utilization situations.
Scheduling housekeeping scripts for trace and archive log files.
Operational excellence check on daily basis.
Checking of Alert log and Trace files to monitor the database on a daily basis.
Configuring and maintaining tnsnames.ora, listener.ora and sqlnet.ora files.
Worked withOracleSupport during ORA-600 and ORA-7445 issues

Environment: RAC on Linux 6/7 & Oracle 11.2.0.4,12.1.0.2 Sun OS 10, EXPDP, IMPDP, RMAN, Dataguard, Flashback, ASM.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship