Oracle Data
Resume:
Honoré Foimoukom
Oracle Database Administration
Bachelor’s in law and Political and Criminal Science
University of Douala; Douala, Cameroon
Computer Science Courses
University of Douala; Douala, Cameroon
2003-2007
Associate Degree in Public Relations and Journalism
Prince George’s Community College; Maryland, USA
2014-2017
STATUS: US CITIZEN
*********@*****.***
SKILLS SUMMARY
Over 5 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, LINUX, and Windows, supporting a variety of mission critical applications with Oracle 10g, 11g, and 12c.
Experience as On-Call 24x7 production DBA support, application/development DBA, system administrator.
Monitored physical I/O and Proper sizing of rollback segments.
Optimized SQL using explain plan, Auto trace feature and TKPROF to analyze the execution plan and tune the statements.
Tuning of database using Utlstat scripts Statspack and dynamic performance views to monitor system statistics and wait events, AWR, ADDM and Tuning of SGA.
Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem-solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
Migrate to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs.
Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams with RCA and proposed solutions.
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. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.
Upgraded Oracle 10g database version to 11g
Upgraded Oracle 11g database version to 12c version
Provided database related services to their development & QA environments.
Good experience of Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).
Upgraded various databases from 10g to 11g, 11g to 12c and minor version upgrades
Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC
Supported Server migrations, Application upgrades/Migrations and Data center movements
Configured Offline and Online Disaster recovery sites to maximized the database availability
Applied Oracle Patches (CPU/PSUs and One-off patches)
Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager.
Experience in installation, upgrades, patches and TAR support Duties.Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures and Triggers.
Worked on Data transferring with export/import utilities and Data pump.
Highly experienced in performance monitoring/tuning/troubleshooting.
Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
Participated in planning and implementation of off-site Disaster-Recovery planning and testing
Worked with development and operations staff in resolving problems quickly and efficiently
Resolve the bottlenecks in all the database environments.
Extensive knowledge to maintain Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.
Worked extensively in Performance Tuning Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.
On call technical support for 24x7
HIGH PROFICIENT TECHNICAL SKILLS
Performance Turning, Disaster recovery, Database security, High Availability, Real time replication
CERTIFICATION
-ORACLE DATABASE 12C ADMINISTRATION CERTIFIED
-SQL FUNDAMENTAL CERTIFIED
-SCRUM MASTER ACCREDITED CERTIFICATION
WORK EXPERIENCE
Feb 2016 – present
US FOODS - ROSEMONT, IL
Oracle Database Administrator
Installation and configuration of 10g,11g,12c in UNIX/LINUX (RHEL)and Windows server 2010,2012.
Installation and configuration of 12c Container Databases on standalone servers and cluster on windows and unix platforms.
Upgraded multiple Standalone and RAC databases and grid infrastructure from 11gR2 to 12cR1.
Worked New Features on 12c databases such as recovering tables, masking the fields, using advanced optimization parameters for good performance of 12c Databases.
Experience in troubleshooting RAC databases and engaging with application team for gaining performance enhancements for application in clustered environment.
Applied PSU on standalone TEST environment using OPatch and same PSU(Grid and RDBMS Patching) on production cluster using OPatch Auto.
Supported in Performing GoldenGate configuration, administration, installation, also configuring pumps and managing trail files by purging old extract files and log files.
Troubleshooting GoldenGate using GGSERR.LOG and logdump utility.
Replication Using GoldenGate for multiple extracts and replication and mapping, Great understanding and usage of advanced parameters in Golden Gate
Responsible for Installation and upgrading of GoldenGate 11.2.1.0.1 to GoldenGate (v12) 12.1.2.0.0.
Implemented Physical Standby Databases on 2-node 11gR2 Real Application Cluster and automized scripts to delete archive logs that already applied to standby.
Duplicating Tablespaces And Databases from Production server to Test server as per customer requirement.
Involved in datacentre migrating large size database in multiple platform.
Expertise in Active DataGuard, Snapshot using Dataguard Broker (DGMGRL) and RMAN.
Generated AWR (Statspack), ADDM, Explain Plan, TKPROF, SQLTRACE, ORADEBUG reports for Performance tuning and also used new tools of 12c for security purpose.
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.
Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC
Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup and Comm vault.
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 500GB to 5TB.
Successfully upgraded the databases from 11g to non CDB 12c.
Successfully migrated 12c Non CDB databases to pluggable databases.
Created Oracle Wallets and implemented Tablespace level TDE security.
Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
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
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.
Implement and enforce security for all of the Oracle Databases; the three basic security tasks are authentication (Setting up user accounts to control logins to the database), authorization (setting permissions on various parts of the database), and auditing (tracking who did what, with the database).
Perform database re-organizations as required to assist performance and ensure maximum uptime of the database, implement SQL access and tuning advisors recommendations.
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
Tools Used: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN
November 2012 – Feb 2016
CARESOURCE - DAYTON, OH
Oracle Database Administrator
Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
Worked on disaster recovery of exadata 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.
Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
Performed troubleshooting of database using AWR and ADDM reports.
Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
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.
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
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
Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN
Contact this candidate