Mbah Blesse

Oracle Database Administrator

202-***-**** /ac0pk0@r.postjobfree.com

EXPERIENCE

Kaiser Permanente - Indianapolis Jan ’13 – Now

Oracle Database Administrator

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

Responsibilities:

Upgrade/Migration of Databases from Oracle 11.2.0.2 to 11.2.0.3.

Worked in an environment comprising 180 databases with the largest databases each of size 10 TB.

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 and Point in time recovery (PITR)

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

Created Oracle Wallet, Enabling Transparent Data Encryption, Automatic Login Enabled for Transparent Data Encryption, and Salting

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 with ASM on AIX platform.

Oracle Software installation and creation of database with respect to OFA standards

Install and troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).

Scheduled UNIX scripts in Cronjobs to automate daily tasks like backups, monitoring the alert logs, cleaning old archive logs, old log files, and monitor table space.

Applying quarterly patches and system Upgrades from 11.2.0.4 to 12C

Designed and implemented disaster recovery strategies such as Active dataguard, Rman

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

Installed ASM environment and migrated databases from file system to ASM.

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.

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

Migrated databases from 10g to 11gR2 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.

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 Refresh, logical backups and migration of databases.

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

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.

Used Erwin to Designed Logical and physical database for business transaction functionality.

Provide production support for the deployed project till it is stabilized

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

Mayo Clinic - Texas Jan ’11 – Dec’12

Oracle Database Administrator

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) using 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.

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

Used 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.

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

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

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

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

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

Provided 24X7 support for production and development databases capacity planning.

Worked extensively on creating development, testing, staging, production RAC and standby databases for OLTP and Data Warehousing using customized scripts.

Excellent knowledge of Full and Incremental Backup & Recovery, Cloning of databases using RMAN, OEM Grid Control 12c, Net Backup, PL/SQL, UNIX Shell Scripting

Design, development, and testing of backup and recovery to ensure complete recoverability.

Perform proactive checks using OEM Grid Control 12c & TOAD to manage, table space usage, memory structures, rollback segments, logs, alerts etc.

UNIX Systems Administration - Database and application integration efforts. UNIX shell scripting, scheduling Autosys & CRON jobs.

Team player with excellent interpersonal, analytical, problem-solving and communication skills

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 Information Technology

PROFESSIONAL SUMMARY

Design database in compliance with OFA standards, business needs and best practice.

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

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

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

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

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.

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

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).

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

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.

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

Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle

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.

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

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

TECHNICAL SKILLS

Databases: Oracle 12C/11G/10G

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

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

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

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

Contact this candidate