Oracle DBA Support Resume

PROFESSIONAL SUMMARY:

6+ years of professional experience in Oracle Database Administration & Support having an immense experience in Production and Development, Installation, Administration, Monitoring, Trouble Shooting, Data Guard, Migration, Performance Tuning, Patches, Backup and Recovery, Cloning.
Experienced in working with a team to provide 24×7 on - call support for production and development environments.
Experience in Installation and configuration of Oracle 12c, 11g on RHEL, Oracle Linux.
Hands on experience in configuration, administration, maintenance & recovery of single-instance Databases.
Hands on Experience using Oracle utilities Datapump, SQL Loader, RMAN, Original export/import.
Extensive experience in planning and execution of Database Backup and Recovery using RMAN.
Performance tuning of the database - SQL Statement Tuning. Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
Cloning databases for development/testing environments using traditional backup methods as well as using RMAN.
Extensive experience of Performance tuning of various aspects of the database using utilities like TKPROF, Explain Plan.
Extensive knowledge in creating and tuning SQL query procedures and functions for optimum performance.

TECHNICAL SKILLS:

Operating Systems: Red Hat, Oracle Linux, AIX IBM, Windows Solaris

RDBMS: Oracle 12c/11g/10g

Tools: RMAN, OEM, Datapump, Golden Gate, SQL Developer, TOAD, SQL Loader, RAC, Dataguard

Languages: Java, SQL

WORK EXPERIENCE:

Confidential

Oracle DBA Support

Responsibilities:

Resolving internal database errors due to configuration issues or corruption
Utilizing ASMM & AMM to configure and adjust database memory
Using SQL loader to upload data into the database
Worked on import/export, export data pump/import data pump and SQL- loader.
Installed and maintain 11g and 12c databases
Cloned databases using RMAN duplicate and used Data Pump for object level refreshes. Contributing to Knowledge Management content creation and maintenance
Working with development on product improvement programs (testing, SRP, BETA programs etc.) as required
Running RMAN backups and recovery procedures
Installing and deploying quarterly and annual patches
Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL

Environment: Oracle 11g, 12c, RMAN, Datapump, SQL*Loader, Linux, Windows, RAC

Confidential

Oracle DBA

Responsibilities:

Built & Administered 4 node RAC cluster with ASM
Installed, configured, and upgraded Oracle server software and related products, maintain multiple Oracle 10g/11g/12c standalone and RAC databases on Linux, and AIX servers
Actively monitored tablespaces, listeners, users/schemas in multiple databases
Supported and Advised development teams on DB related issues
Implemented database auditing
Coordinated and worked with development & system admin teams extensively
Installed Oracle 11gR2 client software for multiple servers with different operating systems such as Windows, AIX, Oracle Linux, and Red Hat
Built the RMAN catalog & automated backup strategies using a shell script
Database/Schema refreshes using RMAN, Exp/Imp, & DataPump
Used Data Guard switch over as a way of migration to an Exadata Machine with very little downtime in production environment
Implemented Flashback technology in production and non - production environments
Implemented replication through Materialized Views
Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner
Used OEM to monitor databases and their performance
Created relevant staging tables to load data identified the business validation rules. Created SQL Loader scripts using UNIX shell scripting
Designed and Implemented Disaster Recovery Strategies
Created and Managed application users/schemas and their associated tablespaces
Troubleshooted and fixed a number of RMAN backup jobs and DataPump Export issues
Upgraded from Oracle version 10.2.0.4 to 11.2.0.2 & 12.1.0.1 to 12.1.0.2 in production and non-production environments
Applied quarterly CPU & PSU security patches
Worked closely with Oracle Support with various Oracle related issues
Successfully recovered corrupted databases
Carried out the setting up of RMAN back up schedules of databases
Participated in Disaster recovery (DR) exercises

Environment: Oracle 11g/12c, SQL Developer, Toad, Windows XP, RHEL 4.x and Solaris 5.x, Shell Scripts

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship