Bertrand Zih Kum

Oracle Database Administrator

adcjt7@r.postjobfree.com 301-***-****

Over 8 years of hands-on experience as an Oracle Database Administrator. I have complete life cycle knowledge including Installation. I have worked on Oracle 18c, 12c, 11g, and 10g versions involving database administration, development, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.

SKILLS SUMMARY

Skilled in Geospatial Database Administration and installation with SDE installation, versioning, feature class creation, event creation and GIS/LRS systems.

Proficient experience as an IT professional along with extensive experience as an Oracle Analyst

Proficient in Oracle 18c, 12c R1, 12c R2, 11g R1, 11g R2

Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing

Highly experienced in Oracle 18c, 12c, 11g, 10g Automatic 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.

Installed and Administered Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.

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

Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).

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

Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.

Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.

Performed backups and crash recoveries using conventional hot/cold backups and RMAN

Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM).

Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.

Implemented Dataguard in the production environment.

Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard.

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

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.

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 and Cloud control

TECHNICAL PROFICIENCIES

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/2012/2016

RDBMS

Oracle 10g, 11g, 12c, 18c

Languages

SQL, PL/SQL, UNIX Shell Scripting, PERL, Python.

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Arcmap, Arccatalog

Database Utilities

SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE

Department of Transportation (MNIT) – Saint Paul, MN June ’16 To Present

Oracle/Spatial Database Administrator

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

Using ESRI tools such as Arcmap and Arccatalog to implement geospatial database activities such as Versioning, feature class registration, relocating events, geodatabase upgrade, location appends, tunning enterprise geodatabase for performance issues and administration of SDE and MDSYS.

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

Implemented oracle 12c active standby database for test database environment.

Implemented oracle 12c flexi asm for pre-prod environment.

Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.

Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.

Implemented OEM 13c, OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.

Extensive Experience with Change Board Meetings and Change Control Management for all database changes.

Providing database administrative support and 24x7 on call support for production, development oracle 18c/12c/11g databases on Red Hat Linux 5.0 and later.

Experience with large databases (1.5 Tb) for OLTP and OLAP applications.

Performed installation, configuration and maintenance of oracle 11g/12c, 11g RAC databases.

Experience in configuring oracle 10g, 11g, 12c Real application cluster (RAC) (2 and 3 nodes) using cluster ware and automatic storage management (ASM).

Performed migration of oracle 10g/11g/12c non RAC single instance to RAC database instances.

Experienced in Cross platform Migration from Linux to windows and vice versa.

Experienced in Database and schema refreshes from PROD to TEST/DEV/TRAIN.

Experience with 11g/12c cluster maintenance using CRSCTL command.

Experience in using SRVCTL command for Oracle 11g/12c RAC database.

Implemented Disaster Recovery database 10g/11g/12c Data Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.

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

Experience in writing UNIX/SHELL scripts for providing the reports.

Experience in writing packages and procedures for routine loading and batch jobs using PL/SQL.

Installed and configured Oracle 11g/12c/18c database on a test server using Oracle standard procedures and OFA, for performance testing and future 11g/12c production implementation.

Applied PSU Patches (11.2.0.3, 11.2.0.4) and (12.2.0.3,12.2.04).as a part of maintenance activity.

Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption

Extensively worked with ASMCMD for managing ASM environment.

Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.

Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)

SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.

Proactive performance monitoring, and capacity planning for future database and server growth using OEM.

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Responsible for the smooth functioning of all ecommerce activities of the organization.

Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC

Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Resolved data integration issues.

Performed version upgrades 11g to 12c and 12c to 18c both in place and new configuration upgrades and patch installs.

Solid discipline in providing end-users timely updates on their problems. Installing server software.

ASM implementation & maintenance. Migrating and upgrading the Oracle 9i database to Oracle 10g, 10g to 11g, 11g to 12c and 12c to 18c and incorporating the changes in the database design.

Environment: Oracle 18c/12c/11g/11g and 12c RAC/10g, VMS, Sun Solaris, Windows Server 2003/2008/2012/2016, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Sears Holding Corporation - Chicago, IL June ’13 – June ‘16

Oracle Database Administrator

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.

Implemented oracle 12c active standby database for test database environment.

Implemented oracle 12c flexi asm for pre-prod environment.

Utilized rman recover table functionality and created proof of concepts for our pre-prod environment.

Installed, Configured Oracle 12c Goldengate on Oracle 12c Database.

Implemented OEM 12c Repository database, OEM 12c Agent and golden gate plugin Installations.

Extensive Experience with Change Board Meetings and Change Control Management for all database changes.

Providing database administrative support and 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0 and oracle enterprise Linux 5.5

Experience with large databases (1.5 Tb) for OLTP and OLAP applications.

Performed installation, configuration and maintenance of oracle 11g/12c, 11g RAC databases.

Experience in configuring oracle 10g, 11g Real application cluster (RAC) (2 and 3 nodes) using cluster ware and automatic storage management(ASM).

Performed migration of oracle 10g/11g non RAC single instance to RAC database instances.

Experience with 11g cluster maintenance using CRSCTL command.

Experience in using SRVCTL command for Oracle 11g RAC database.

Implemented Disaster Recovery database 10g/11gData Guard on physical standby database in maximum performance mode using LGWR ASYNC mode.

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

Experience in writing UNIX/SHELL scripts for providing the reports.

Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Applied PSU Patches (11.2.0.3, 11.2.0.4) as a part of maintenance activity.

Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption

Extensively worked with ASMCMD for managing ASM environment.

Used Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.

Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)

SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and Statspack.

Proactive performance monitoring, and capacity planning for future database and server growth using OEM.

Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases

Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.

Responsible for the smooth functioning of all ecommerce activities of the organization.

Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC

Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.

Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.

Resolved data integration issues.

Performed version upgrades and patch installs.

Solid discipline in providing end-users timely updates on their problems. Installing server software.

ASM implementation & maintenance. Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.

Environment: Oracle 12c/11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Pinellas County - Clearwater, FL Jun’11 – Jun’13

Oracle Production Support Databse Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

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

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

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

Have set up the cronjobs for runalert, spacewatch monitoring, RMAN backup (level_0 and level_1) and recovery, archive log purge, deletion of archive logs and AWR reports on AIX-5.3.

Used normal import and export and also datapump import and export for exporting and importing schemas, tables etc from one database to another.

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.

Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.

Production Support for Critical Application Databases, work closely with

Application Team in identifying issues and provide solutions for various issues (created via IBM-CMR, IMR in-terms of incidents and work orders of different severity levels like Sev1, Sev2, Sev3, Sev4).Used IBM Mange Now.

Implemented Oracle Patches (CPU, PSU) on the Compliance databases Device a plan to patch them quarterly so that we can cover all the databases in a year.

Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.

Extensively worked with dba_jobs, dba_scheduler_jobs, functions, procedures and packages.

Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned the tables and indexes for better performance.

Have used different tools like TOAD (10.1), EXPLAIN PLAN, AWR, ADDM Oracle enterprise manager (GRID CONTROL)

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.

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.

Kenexa - Wayne, NJ Mar ’10 – Jun’11

Oracle Production Support Databse Administrator

Installed and configured ORACLE 10g on HP-UX and Windows NT.

Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.

Cleaning the ORACLE_HOME file system by cleaning the log files, alert log file and listener.log files

Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.

Backup and recovery utilizing RMAN.

Working with the application support people to resolve database related issues and running the scripts for the application support people.

Creating users and database links, snap shots on production and development servers.

Maintaining system security, defining of roles, profiles etc.

Checking CRON jobs. Monitoring Application specific background processes.

Creating materialized views and materialized view logs to implement the table level replication for the MIS databases.

Use Oracle Metalink Support to resolve different issues related to database servers, security patches.

Created, maintained and troubleshoot PL/SQL objects, shell scripts and utilities.

Implemented proactive monitoring using STATSPACK, SQL TRACE & TKPROF, EXPLAIN PLAN.

Separated the indexes, data, rollback segments and redo log files on separate disks to minimize contention, Monitored the buffer cache hit ratio and the dictionary cache miss ratio. The DB_BLOCK_BUFFERS and SHARED_POOL_SIZE were increased, resulting in tremendous improvement in performance.

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 of Science in Information Technology

University of Siantou (Cameroon).

Contact this candidate