Laurance Pufong

Oracle Database Administrator

Email: ac6qg4@r.postjobfree.com

Phone: 240-***-****

SUMMARY:

IT professional with over 5 years working experience as an Oracle Database Administrator. I have complete SDLC knowledge. I have worked on Oracle 10g, 11g and 12c versions. Duties include Installation, Production support, project work, Instance configuration, upgrades, patches, migration, cloning, space management, security admin, backup and recovery, performance tuning, data guard, golden gate, and RAC.

Professional Experience

Newedge - Chicago, IL Feb 2015 – Present

Oracle Database Administrator

•Monitoring and Troubleshooting of Database Replication issues using Golden Gate, dealt with conflict resolution and performance issues.

•Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS.

•Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.

•Implemented Initial Data Load, Batch/Online replication, Security in Golden Gate.

•Implementing Best Practices for migration regular databases to Oracle Exadata

•Resolved/Diagnose Node Eviction issues.

•Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.

•Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc

•Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.

•Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

•Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.

•Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11gRAC & 12C environment for the Production databases.

•Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to 5TB.

•Experiencing in Installing OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.

•Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.

•Migration of databases to 12C from Oracle 10g&11g.

•Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes. Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

•Database Services creation for distributing the applications across multiple nodes, Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,

•Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace

•Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

•Implemented 11g Interval Partitioning for monthly partitioning of large tables..

•Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.

•Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.

•Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.

•Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.

•Handled Chained Rows and Row migration, and solved the database performance issues.

•Experienced with ASM, adding, deleting disks to the disk group.

•Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.

•Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.

•Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

•Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC

•

Fannie Mae - Mae, WA July 2013 – January 2015

Oracle Database Administrator

•Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

•Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

•Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.

•Monitor and fully analyze performance issues in production Oracle databases by using OEM, ASH/AWR/ADDM, EXPLAINPLAN and TKPROF tools.

•Partitioning Tables, Rebuilding of Indexes, Secure files, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.

•Knowledge on Standardization of 12c/11g Clusterware build and DB build by preparation response files.

•Implemented Oracle Physical Standby DataGuard on multiple oracle 11g / 12c databases.

•Configured DG Broker for easy Failover/Switchover during outages and Convert to Snapshot standby during DR test every 6 months.

•Troubleshooting and fixing DG Broker configuration.

•Troubleshooting and Fixing out of sync Oracle Physical Standby DataGuard using RMAN incremental backup.

•Upgrading Oracle databases from 11.2.0.x to 11.2.0.4 and from 11.2.0.4 to 11.2.0.4.5 and from 11.2.0.X to 12.1.0.1.

•Quarterly PSU patching on AIX/RHEL for 11g/12C databases on Standalone and RAC DB's using rolling patching.

•Applying/Rolling back one-off patches to/from Standalone or RAC DB's.

•Loading data from flat files to database using SQL*Loader, External Tables.

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

•Implementing Datapump, conventional export/import utility of Oracle 11g, 12c for re-organizing Databases/Schemas/Tables to improve the performance.

•Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 11g and 11g/12c environments.

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

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

•Trouble shooting and performance tuning golden gate replications, monitoring scripts for Golden gate in Unix scripting

•Install and configure Cloud Control 12c, deploy 12c agents, plug-in installations on the target servers and monitor databases.

•Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

•Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

•Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

•Refreshed/cloned databases using RMAN utility.

•Performed Database upgrade from Oracle 10g (10.2.0.2) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

•Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

•Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

•Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

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

•Used TOAD for database management.

•Made optimal use of Oracle Support in resolving the SRs.

•24 X 7 Production & Development database support and administration.

Summary

•Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.

•Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.

•Proficient in database concepts with rich experience in database design, development and management.

•Excellent knowledge of Oracle architecture, Golden Gate architecture, SQL Performance tuning, SQLT and eager to explore any unknowns.

•Good working knowledge of troubleshooting Infrastructure issues related to Oracle database server such as memory, CPU, I/O, Disk etc.

•Working knowledge of technologies such as Oracle, Oracle Real Application Cluster, Oracle Golden Gate, and Oracle Http Servers.

•Hands-on experience working as Production DBA, working knowledge on SLA metrics and Remedy system and worked with Oracle Support.

•Knowledge Installed and configured 2, 4, 6 node server side load balancing RAC (Real Application Clusters) databases on HP UNIX and Linux with ASM (Automatic Storage Management) and Data Guard.

•Experience in Upgrade from oracle 10g to 11g and Migration of oracle database from red hat Linux, Window platform to Linux on development, integration and production environment using Oracle Data Migration Assistant.

•Exposure on High Availability Concepts (RAC, Standby), Database Cloning, and Oracle Streams and Oracle Golden gate.

•Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

•Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM) required to fulfill the storage needs.

•High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.

•Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature.

•Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.

•Extensively managed users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).

•Configured Oracle Enterprise Manager (OEM) Grid Control (in Oracle 11g, 10g) for the purpose of monitoring multiple databases and application servers.

•Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.

•Implementing 10g Data guard with one physical database.

•Experience in configuration and administration of Data Guard (Physical/Logical standby Databases).

•Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.

•Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purpose.

•Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard)

•Experience with supporting the Production Database with complete lifecycle including Installations, Upgrade, Patching, Cloning, Backup/Recovery, High Availability including Oracle Real Application Cluster (RAC) and Data Guard. Expert in RMAN backups including full, incremental and cumulative.

•Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.

•Extensively worked on Import/Export and DataPump Import/Export tools.

•Knowledge in configuring ASM (Automatic Storage Management)

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

•Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility.

•Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.

•Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

•Expertise in maintaining Database Security using auditing.

Education

•Bachelor degree in computer science: University of BUEA-Cameroon, 2011

•Comptia A+ certified

•OCA certified

Contact this candidate