Manager Data

CHAM ETHEL BEI NKUO

**********@*****.*** / 240-***-****

Oracle Database Administrator

Experienced Oracle Database Administrator with over 6 years of Oracle experience in configuring, integrating, upgrading, migrating, and setting up databases in various environments. Highly skilled in database cloning and refreshing and tuning and assigning indexes. Excels as an IT professional and a database analyst, easily able to work in teams to achieve common goals. Skilled in installing, configuring, upgrading, and migrating databases as needed. Maintains strict database security and integrity standards for databases. I have knowledge of AWS, EXADATA, and SQL server databases.

Areas of expertise include:

Oracle 10g, 11g, 12c

Solaris

UNIX

AIX

Linux

Windows

TOAD

SQL DEVELOPER

Performance tuning

RMAN

RAC

Data guard

Goldengate

Upgrades and patches

Oracle Enterprise Manager (OEM)

Real Application Cluster (RAC)

ASM

Data pump

UNIX scripting

Database security

AWS

Data migration

EXADATA

PostgreSQL

Cold/Hot Backups

SQL/PL/SQL

TSQL

SQL*Loader

PROFESSIONAL EXPERIENCE

COPPER MOBILE DECEMBER 2016 – PRESENT

DALLAS, TX

Oracle Database Administrator

Participate in a 24/7 on-call rotation position for all prod, QA, and dev environments

Installed and created 11g, 12c databases for testing and development.

Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Utilized SAN level storage mirroring to perform data refreshes on large production data warehouse environments

Some experience working with Microsoft SQL Server to create databases, creating and managing users accounts

Experience working with AWS

Experience with EC2 and RDS instance

Hands on experience migrating to AWS

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.

Used Oracle 12c Enterprise manager to monitor and report the Database health

Used implemented range, list, hash, and sub partitions to develop partitioning strategies for large tables and create and schedule refreshes for materialized views

Provided high speed parallel bulk and meta data movement of database contents through skillful use of Data pump

Reorganized databases, tables, and schemas to improve performance and aid in capacity planning

Administered and troubleshot 2 node clusters on 10g/11gR2 and configured Grid Infrastructure SCAN listeners

Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.

Performed task like administering the RAC using SRVCTL adding nodes, administering storage components

Managed all ASM functions including storage, cloning, preparing/adding/and removing disks, tuning I/O, and troubleshooting crashes and memory problems

Expert in logical and physical data modeling and designed logical and physical database structure

Created user accounts, roles, privileges, administrative tasks and schema deployments

Ensured high availability, data protection, and disaster recovery through extensive use of Data guard and physical and logical standby databases

Utilized ADDM and SQL Tuning Advisor in 10g, 11g, and 12c to improve database performance by tuning SQL and instance parameters

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

Expert on Cluster management, event management, application management, connection management, storage management, load balancing and availability.

Quickly resolved client connectivity issues by using TCP/IP protocol configured SQL*Net files on server and client machines

Expert with setting up physical standby Data guard environment for prod and non-prod databases

Expert in using the data guard broker to manage the data guard environment

Efficiently monitored application and database security along with user accounts and passwords

Extensively used Hints, Indexes, and partitioning to improve performance

Recovered data files from logical and physical block corruptions

Applied all needed security patches including patch set, critical patch updates (CPU), patch set updates (PSU), and one-off patches

Configured Golden Gate for continuous, real-time capture, routing, transformation and delivery of transactional data across heterogenous platforms.

Hands on experience in collision handling during initial load

Migrated from Oracle to AWS

Migrated from Oracle to POSTGRES

Experience with EXADATA

SQL Server Experience

Experience in managing and monitoring SQL Server databases 2008,2012,2014,2016.

Downloaded, Installed, configure, patch, and upgrade Microsoft SQL Server Database.

Control and monitor user access to databases and maintain database security.

Perform basic analysis to help in identifying and resolving performance issues.

Document the company database standards and changes for future references.

Implemented Backup ranging from Full, Differential and Transnational backups. Recovered Database using the FULL SIMPLE and BULK LOGGED RECOVERYMODELS.

Troubleshoot performance of the database using tools like SQL PROFILE, TASK MANAGER, DYNAMIC VIEWS as well as Database Engine Tuning Advisor.

NRG ENERGY JANUARY 2013 – DECEMBER 2016

Houston, TX

Oracle Database Administrator

Provided prompt 24/7 support for all production and development databases

Utilized RMAN and traditional Data pump export/import to clone and migrate databases

Used RMAN to successfully recover database data during database crashes and media and disk failures as well as create and implement recovery strategies

Extensively used Crontab to schedule and monitor hot and cold physical backups

Created all users, groups, roles, profiles, and privileges for relevant groups

Optimized and tuned SQL queries using AWR, ASH, ADDM, Explain Plan, SQL TUNING ADVISOR.

Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.x for Clustered Environments.

Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.

Monitoring and optimizing the performance of the database/application using OEM

Applied all needed security patches including patch set, critical patch updates (CPU), patch set updates (PSU), and one-off patches

Skillfully used RMAN and Data pump conventional import/export to implement database, schema, and table level data refreshes

Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Performed full and incremental backups using RMAN for development and production databases.

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

Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.

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

Installed and configured 10.2.0.1 database and upgraded from 11g to non-CDB 12c

Successfully migrated from 11g to 11gR2 and from 12c non-CDB to pluggable databases

Implemented Security through Virtual Private Database and Fine-grained Auditing.

Implemented tablespace level TDE security successfully and created Oracle Wallets

Reviewed alert log and trace files to constantly monitor database performance (V$ dynamic performance views at peak load)

Checked database health status including table size growth, extent allocation, free and used space, and fragmentation by creating and running scripts

Managed space maintenance, capacity planning, disaster recovery, and database overall maintenance

Ensured zero downtime during physical standby database creation by using RMAN

Developed RMAN scripts for database backup and recovery

Performing failover and switchover manually and Data guard Broker

Knowledge in resolving gaps in the data guard environment

Resolved SRS efficiently through use of Oracle Support

Configured Golden Gate for real time replication of data

Knowledge in monitoring golden gate errors using ggserr.log file and the discard file

Experience in troubleshooting golden gate processes like abending replicate and extract

Daily Health Checkup of all the Databases using Oracle Enterprise Manager 12c.

Created standard process documentation for peers to follow and utilize

EDUCATION & CERTIFICATIONS

Msc in Biodiversity and Forestry University of Yaounde Cameroon

Certified Oracle Database Administration 12c

Certified in SQL Fundamentals

Contact this candidate