MBUH KUM

ORACLE DATABASE ADMINISTRATOR

PHONE: 443-***-****

EMAIL: aczgh5@r.postjobfree.com

SUMMARY OF EXPERIENCE

As a certified and experienced Oracle DBA with over 5 years of hands on experience, I have a great exposure to numerous database versions, sizes as well as various operating system platforms. Some of my experiences include, but not limited to database administration, production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, space management, and database security with Oracle (10g, 11g, 12c) on Sun Solaris, Red Hat, HP-UX, AIX, and some Windows Platforms.

SUMMARY OF SKILLS

-Involved in CAPACITY PLANNING for High Availability solutions, like RAC, and DATAGUARD projects.

-Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.

-Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.

-Oracle Database Upgrades 10g to 11g, 11g and 11gr2 to 12c.

-Migrating and consolidation of 11g databases into 12c in both QA and Production environments.

-Installation and consolidation of 12c multitenant database's in QA and Test environments. Container and Pluggable database administration and cloning.

-Experience on Data Replication using Snapshot, Materialized views, import/export and DATAPUMP.

-Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.

-Experience in Installation of Oracle Databases 10g, 11g and 12c versions.

-Experience in the Upgrade of Oracle Databases in patch set Level and also in version Level (10g to 11g) and (11g to 12c).

-Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, Patch sets as per the Oracle recommendations.

-Excellent knowledge on oracle 10g and 11G architecture and administration, good understanding of new features.

-Experience in configuration of Oracle 10g, 11g and 12c physical & logical standby database using Data Guard.

-Expertise in Disaster Recovery Planning and high availability solutions by performing switchover and failover operations in Data Guard.

-Experience in creating and managing Single Instance databases and RAC primary and standby databases under various business critical environments.

-Good hands-on experience in High Availability solutions with Oracle 10g, 11g RAC, Physical and Logical Standby Databases (Data Guard)

-Good hands-on experience in configuration of Oracle 10g R2, 12c OEM Grid Control to monitor database.

-Good hands-on experience applying recommended Upgrade Patches as well as CPU/SPU and PSU patches to the standalone and RAC databases. Design, development, system integration phase, quality assurance phase, development and production support activities.

-Experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB

-Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g. GOLDEN GATE CONFIGURATION

-Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.

-Installation and Configuration of Oracle 12c Multitenant container and pluggable databases.

-Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle 12c Pluggable Databases running on the latest platforms.

-Extensive skills in performing database crash recoveries techniques like Point In Time/SCN/cancel using full backup, level 0 and level 1 incremental differential and cumulative backups.

-Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.

-Excellent skills in generating execution plan using EXPLAIN PLAN and gathering reports using TKPROF for Application Tuning and gathering optimizer statistics for SQL Tuning.

-Experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.

-Experience in creating and managing control files, redolog files, data files and archive redolog files.

-Experience in Database and table reorganization using methods like Online table reorganization, coalesce, deallocate and shrink space.

-Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).

-Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).

-Proactively monitoring the database's health and taking preventive or corrective actions

-Proficient in Database Design (Physical and Logical Database Design) and Normalization.

-Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas NetBackup and IBM Tivoli Storage Manager (TSM).

-Used EXPDP&IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.

-Proficient in using various database Utilities like EXPORT/IMPORT, DataPump, TOAD

-Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.

-Automated many common tasks using crontab including Backups, exports and imports.

EDUCATION AND CERTIFICATION

-B.A IN BUSINESS ADMINISTRATION AND MANAGEMENT

-CERTIFICATION:

ORACLE 11g CERTIFIED ASSOCIATE

-LANGUAGES:

FLUENT IN ENGLISH AND FRENCH

WORK EXPERIENCE

SNAP ON BUSINESS SOLUTIONS

Richfield, OH

Feb 2014 – present

Title: Oracle Database Administrator

-DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.3 & 6.1. Database sizes range from 20GB to 3TB (in ODS & EDW environments).

-Upgraded databases from 10.2.0.5 to 11.2.0.3 and from 11.2.0.3 to 12.1.0.1.0 using DBUA and manual methods.

-Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

-Applied CPU/PSU patches to various database versions including 10g and 11g. Applied 11.2.0.4 patch set on multiple databases.

-Disaster Recovery (DR) Plan Implemented using DATAGUARD (Physical Standby) for high availability/disaster recovery purpose on Oracle 11g.

-Performing Monthly Re-org of complete databases using expdp and impdp

-Implemented & Managed Physical Standby and Configured Automatic Storage Management (ASM).

-Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR

-Provided valuable inputs for various performance tuning issues.

-Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, AWR, SQL*Trace, TKPROF.

-Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1

-Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

-Had fixed several performance tuning issues which relates to RAC & standalone databases by recommending better solutions that could save cost, virtualization, and resources

-Extensive use of SQL Plus and Unix shell scripting to automate tasks such as refreshing Oracle production, development and QA databases

TRUVEN HEALTH ANALYTICS

Ann Arbor, Michigan

June 2012 – Feb 2014

Title: oracle Database Administrator

-Installed Oracle and grid software on standalone servers on ASM and file system.

-Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM

-Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

-Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

-Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

-Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually.

-Worked on disaster recovery of dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.

-Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.

-Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2, 11gR2.

GENERAL SERVICE ADMINISTRATION

Washington, DC

April 2011 – May 2012

Title: Junior (Intern) oracle DBA

-Migration from Linux to Solaris and 32 bit to 64 bit.

-Restore and Recovery of database in case of database crash, disk/media failure.

-Applying patches and works closely with Oracle to make Application environment up to date.

-Backups & Recovery Maintenance, Databases Performance Tuning.

-Typically involved in database Designing, creation and maintenance.

-Good working knowledge of SQL, PL/SQL, and shell scripting.

-Created, modified and deactivated database user accounts with best practice naming convention

-Assigned and granted system privileges, profiles and roles to users and application users

-Installation and application of several Oracle critical patches to various database versions

-Space management monitoring and allocation across 50 database servers.

-Performed database upgrade from 11.2.0.3 to 11.2.0.5

-Installed and configured relevant network components to ensure database access as well as database consistency and integrity

-Create and manage documentation on the configuration and support of the Oracle databases

-Database instance and schema creation utilizing DBCA / manual script, migration, archive and restoration

-Performed daily incremental backup and full weekly backup using Oracle backup utility RMAN

-Performed disaster recovery using the RMAN backups created

-Provided remote database support for users using SSH and terminal services

-Generated AWR & ADDM reports for performance tuning

-Provided fix for client database security SOX audit across entire 50 databases in Prod, Dev and QA environments

-Tuning test and production database by altering the parameters.

-Export and Import of database objects to copy from one database to another database.

-Investigating suspicious database activity using Auditing.

-Write database documentation, including data standards, procedures and definitions.

TECHNICAL SKILLS AND ENVIRONMENTS

OPERATING SYSTEMS:

-Red Hat Linux RHEL 5.x, Solaris, UNIX, Windows

RDBMS:

-Oracle 11g/10g, SQL Server

LANGUAGES:

-SQL, PL/SQL, UNIX Shell Scripting.

SOFTWARE/ APPLICATIONS/ TOOLS:

-DBCA, DBUA, Recovery Manager (RMAN), Recovery Catalogue ( RCAT) Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, OS Watcher, TOAD, DataPump (expdp,impdp) SRVCTL,SQL*Plus

TUNING TOOLS:

-SQL TRACE, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SQL TUNING ADVISOR

WEB TOOLS:

-HTML, XML

Contact this candidate