Oracle Data

Location:

Lanham, MD, 20706

Posted:

April 13, 2017

Contact this candidate

Resume:

DONALD JUNIOR KAZE

ORACLE DATABASE ADMINISTRATOR

240-***-**** / **********@*****.***

EXPERIENCE

Database Administrator Priority Health - Grand Rapids, MI

Jan 2014 – Till date

Environment: Oracle 11.2.0.3, 10.2.0.5, RHEL 5.5, Sun Solaris 10.0, DataGaurd, RAC, RMAN, OEM, Datapump, AWR, ADDM, ASH, TOAD 11.0.

Responsibilities:

Worked in an environment comprising 200 databases with the largest databases each of size 5 TB.

Upgrade/Migration of Databases from Oracle 11.2.0.2 to 11.2.0.3.

Implemented 12c Grid control (Multi OMS architecture) on 11.2.0.3 database, Standby OMS architecture is under progress.

Used TOAD for database management.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Performed Database Maintenance Tasks, Rebuilding Fragmented tables, gathering statistics, refreshing materialized views, created partition tables and maintaining index's

Enabled Flashback for database to create restore points and supporting DDL changes

Used Oracle database vault and proactively protecting application data, Created Oracle Wallet, Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns, created encrypted table spaces and backup wallet and master keys to tapes

Monitored Goldengate using 12c Goldengate Plugin and also Goldengate Director and shell scripts for alerting GG process down alerts.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Installed, configured Oracle database Vault and database Fire wall server and Implemented Advanced security 12c Oracle Advanced Security using TDE (Transparent Data Encryption) and Enabling Auto Login for the Keystore for cdb$root and Pluggable databases

Applied PSU quarterly on 11g/12c GRID & RDBMS homes using opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN

Performed periodic refreshing/cloning of production databases to development & testing databases using RMAN Duplicate database.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Experience in handling large databases upto 4TB in size and largest table of size 60GB with 145 million records.

Implemented and maintained 12c multitenant architecture using container and pluggable databases and performed conversion of non-container databases to pluggable databases

Installation, Configuration of ASM, RAC databases, Adding Services and maintaining GRID control.

Migrated databases from 9i and 10g to 11g R2 using utilities like export/import, datapump and transportable tablespace.

Implemented replication on databases using and Golden gate between homogeneous and heterogeneous databases.

Performed replication between databases using Materialized Views and DB links from a remote database.

Successfully performed installation, setup and creation of Primary & Standby database using dataguard to deliver no data loss with maximum availability mode.

Worked closely with application teams for rolling application.

Performance tuning of Oracle instances

Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.

Involved in performing upgradation from Oracle 9i, 10g to Oracle 11.2.0.3 RAC database.

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Fixed various database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and Active Session History (ASH).

Achieved optimal performance tuning by using explain plan, STATSPACK, SQL TRACE, TKPROF utilities.

Installation, configuration and maintenance of Physical Standby using Oracle Data Guard for Disaster recovery process on Oracle 11g, 10g.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization..

Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.

Designed Logical and physical database for business transaction functionality.

Provide production support for the deployed project till it is stabilized.

Collaborated with the UNIX system Administrator to configure any software and hardware requirements that will function with the Oracle Database

Refreshing development/test database from production using Export/Import & RMAN backups.

Creating database objects Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and creating database links.

Oracle Database Administrator Mayo Clinic - Waukon, IA

July 2012 – Jan 2014

Responsibilities:

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

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

Provided 24X7 support for all the production and development databases.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

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.

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

Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.

Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.

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

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.

Successfully performed migrations from Oracle 9i/10g to 10gR2 RAC (Real Application) Database.

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

Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.

Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7 support for all the production and development databases.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

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

Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

EDUCATION

Oracle Database Certified Associate 11g (OCA)

Oracle Structured Query 11g Certification

BSc in Computer Science

University Of Buea, Cameroon

PROFESSIONAL SUMMARY

Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.

Design and Architect End-to-End Oracle Database and Cloud Solutions based on commodity server, storage and network components.

Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicat.

Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicat rebuild and abend.

Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.

Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.

Laid hands on tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g. Testing and Validation of Oracle 12c/11g RAC databases on Dell Hardware Stack which include PowerEdge RAC and Blade Servers with networking Force 10 switches and storages like EMC, Compellent and Equallogic.

Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose.

Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Dataguard. Also proficient with new 11g features such as Active Dataguard and Snapshot standby database.

Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps

Expert in implementing development, testing, staging, production and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

Implementing standby database and database replication to provide high availability of database.

Expert in implementing oracle streams, and two types of standby databases supported by dataguard, logical standby and physical standby databases.

Performed tuning of Oracle Wait Events/Latches-Enqueues/Memory structures using Automatic shared memory management (ASMM), ASH and Buffer Cache Advisors.

Hands on experience in Performance Tuning and Memory (SGA) Tuning.

Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Performing Fault Injection Test Cases for verifying High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.

Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.

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

Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.

Implementation of Oracle Flash cache and different host based caching technologies like Dell Fluid Cache/Fusion IO to improve Oracle database performance.

Design and Implementation of Oracle Disaster Recovery Solutions using Oracle Data Guard and Storage based replication technologies.

Proficient in Performance tuning using AWR Reports, Reviewing Explain Plans for SQLs, Creating Baselines, Enable Tracing, Suggesting necessary indexes for boosting SQL performance.

Experience in Database Security by implementing Data Encryption(TDE) and SSL Setup over insecure networks.

Proficient in logical backups Export/Import and Datapump. 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.

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

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS

Databases: Oracle 12C/11G/10G

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer

Contact this candidate