George Fon

Over * years of strong experience in Oracle Database Administration in heterogeneous system environments including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g and 11g.

Extensive knowledge in database backup and recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN)

Available to work onsite in Richardson; can start 2 weeks from an offer

SUMMARY

Experience in using GoldenGate during Disaster Recovery scenario and logical backups and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces. Optimized SQL using explains plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements. Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner. Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability. Experience in installation, upgrades, patches and TAR support. Duties included database creation, Performance tuning/reorganization, cloning, backup/recovery, user and security management, auditing, general troubleshooting, coding, and configuring servers. Experience as On-Call 24x7 production DBA support, application/development DBA and willing to work beyond regular hours.

SKILLS

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) / Network Attached Storage (NAS). Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.

Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.

Good experience in patching and upgrading from 10.2.0.x to 11.2.0.x

Experienced in maintaining databases on large Production, Testing and DEV environments.

Developed database monitoring/health check alert scripts for database up time/downtime status, and sizing issues using grid control (OEM)

Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases on RAC environment.

Installed and administered Oracle 11g ASM & 10g RAC software with ASM.

Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.

Responsible for RMAN backups, and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.

Created Users, Roles and Profiles, Privilege management with role-based security.

Performed database tuning using Explain Plan, TKPROF, Statspack, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.

Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps.

Implemented GoldenGate 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.

Upgraded Oracle 10g, 11g and 12c database version.

Good experience of installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).

Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.

Familiar with Data Warehousing (ETL), Data modeling and OLTP concepts and ASM, SAN.

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 Data Guard. Also proficient with new 11g features such as Active Data Guard 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

Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database.

Experience in Logical backup using and full/ partial export/import and Data Pump.

Extensive work experience in a database migration project team, serving in both an advisory and technical capacity

PROFESSIONAL EXPERIENCE

Oracle America Inc. (contract), Colorado Springs, CO 01/2019 – Present

Oracle Database Administrator

Applying quarterly patches to Customers Oracle Exadata Database Machines.

Upgrade the entire Exadata full rack system from db compute nodes, cell nodes and the infinite band switches and Creating new Grid and Oracle Homes.

Install and configure OEM 13c to monitor the entire environment, from the apps servers to the database servers.

Maintaining up to 500 multitenant container databases in 64 Exadata X5 full rack cluster which includes production and non-production databases.

Prepare Analyzing and interpretation Patch Assessment, Patch Plan and Performing Prechecks Work before the patching Window.

Perform GI upgrade from 11.2.0.4 to 12.1.0.2, 12.1.0.2 to 12.2.0.1 and from 12.2.0.1 to 18.0.0.0 on Exadata Machines.

Performing Non-Rolling, Rolling and Hybrid Method of Patching.

Worked on physical Exadata BareMetal, ZDLRA and also VM's Environments.

Configured TDE wallets in multitenant container databases and worked on various TDE troubleshooting scenarios.

Performed tasks related to Transparent Data encryption in Primary and Standby Production Databases and making sure they are in sync.

Prepared a TDE document for the team which has contents like Configuring TDE wallets from Scratch, TDE Troubleshooting scenarios, BCP with TDE, Cloning PDB with TDE, Unplug and Plug with TDE.

Hosting WebEx calls and Videos with Customer.

Creating New SR with Support for Customers in respect to Patching Issues.

Troubleshooting and fixing patching issues and also working with Oracle Support.

Experience working and fixing issues on OCC (Oracle Cloud and Customer) and ExaCC (Exadata machine on Cloud), OSS (Object Storage Services)

Performed patching activities on the Cloud, upgrades and Post upgrades.

Experienced working on the CWD (Cloud Watchdog)

Work with Oracle Support and Developers.

Experienced in using Tools like JIRA, Confluence, Apex and Fleet Manager Automation.

Experience working on EXADATA servers. Patching the OS systems, Cells, IB switches.

Resolved conflicting patches and checks.

Good in communication, documentation, proactive, team player, multitasking, fast learner, Conscientious, problem solving, courteous and helpful.

Genesys Corporation - Burlington, MA 02/2014 – 09/2018

Oracle Database Administrator

Configured Oracle Data guard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required.

Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for issues and validating disk space.

Migration of large number of databases from 10g to 11g and implemented ASM on RAC and stand-alone databases and Applying PSU Patch and Migration of non ASM database to ASM database.

Scheduled Cumulative Incremental backups using RMAN Cloned databases using RMAN Utility.

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

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

Installation and configuration of Golden Gate and Replication of data using Oracle Golden Gate.

Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, Trace Analyzer, EXPLAINPLAN, and also used Oracle Enterprise Manager (OEM) 11g and 12c to monitor single instance and RAC databases.

Administering and setting up of 11G RAC and 10G RAC clusterware and instances.

Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.

Provide support for Oracle RAC, including applying patches, performance tuning, Backup and recovery issues with RMAN, trace analysis, service creation for the apps to fail over, cluster and system management.

Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2 and also implemented SSL wallet to secure the connections.

Installed and Managing Oracle, 11gR2 3 nodes of cluster (RAC) on Solaris 11.

Configured and Managing Oracle 11gR2 Data Guard (Active Physical Standby on 2 nodes RAC )

Installed and currently Managing Oracle 12c Grid Control (OEM) for monitoring Production, Active Data guard (DG Broker), Stage and Dev systems.

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

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.

Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Statspack, ADDM, ASH reports, OEM Grid Control, Fine tuning of SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and table spaces at performance standpoint.

Tools Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

CenturyLink Inc - Monroe, LA 03/2011 – 01/2014

Oracle Database Administrator

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

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

Installed Oracle 11g on Linux platform using ASM. RMAN point in time recovery and Instance recovery done on 11g.

Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.

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

Performed Data refresh activities using the export data pump utility.

Installation of 2 node and 3 node RAC, Migrating of database to RAC database. Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).

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

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 9i (9.2.0.7) 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.

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

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

EDUCATION

Bachelor degree in Law, University of Buea, Cameroon

OCA 11g certified

Oracle Cloud Infrastructure 2019 Professional

Oracle Cloud Infrastructure Professional 2020

Oracle Cloud Infrastructure Developer 2020

Oracle Cloud Infrastructure Cloud Operations 2019

Oracle Cloud Infrastructure Foundations Associate 2020

AWS Solution Architect Associate

SQL fundamentals certified

Scrum Master certified

Contact this candidate