TANYI G. OKIE
ORACLE DATABASE ADMINISTRATOR/POSTGRES DBA
An Oracle Database Administrator/Postgres DBA with over 5+ years of experience in production databases management, administration, installation, configuration and upgrades of Oracle 11g, 12c, 18c, 19c databases (standalone and RAC). Working on a variety of platforms ranging from Linux, Sun Solaris,Aix and Oracle Linux. Experience Also includes Oracle Utilities such as DataGuard, Data Pump, GoldenGate, Flashback, RMAN, OEM etc . Also Experienced in the management, administration, installation, configuration and upgrades of PostgreSql 9.2,9.4,9.6,10,11 and 12.
Oracle 11g, 12c, 18c, 19c / PostgreSql 9.2, 9.4, 9.6, 10, 11, 12
Oracle (Oracle Enterprise Manager, SQL*Plus, DB Configuration Assistant) Toad, OEM Grid, OEMCloud control 13c, RMAN, Exp/Imp/Data Pump, Statspack/AWR, DBCA, DBUA, ADDM.
PostgreSql(pg_dump, pg_repack, Pgbackrest, pg_restore utility, pg_basebackup, PG_Admin4, Pg_admin3)
MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX
Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2
Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop
5+ years of experience as Oracle DBA, providing 24*7 support of development and production 19c/18c/12c/11g/10g multi-terabyte databases on Various Platforms.
Expert in high availability technologies such as Oracle 10g/11g/12c/18c,19c RAC, ASM, and Data Guard/Standby Database.
Excellent experience in Installation and configuration of Oracle 19c/18c, 12c, 10g, 11g in UNIX/LINUX and Windows environment.
Implemented strategy for partitioning and management of historical data tables.
Proficient in performing day to day DBA activities like creating schemas, users and table spaces management, performing export and Import, Creating DB links, Materialized view creation, index creation and fine-tune queries.
Planned and implemented DR & high availability solutions using Oracle Data Guard, Golden Gate and RAC.
Using Grid XAG 9.1 to Monitor and manage Goldengate Rac Integration
Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g and 12cRAC.
Experience in Installation, configuration of Oracle RAC, implemented 2 and 3 nodes RAC environments for a 1TB database.
Planned and implemented high availability solutions using Oracle 10g and 11g RAC 12c Rac, Standby Database using Oracle Data Guard (Physical as well as Logical).
Proficient in using Oracle Enterprise Manager (OEM), Quest TOAD and Oracle SQL Developer.
Backup of Databases (Creating Backup Schedules based upon Business Strategy: Daily Backup, weekly Backup, merged backups etc.)
Created and tested some features of Oracle 12c multitenant database and Oracle 18C
Create and manage Physical Backup/Restore using RMAN with tools like veritas and netbackup
Performed Flashback technologies like Flashback Database, Flashback Query and Flashback Table
Captured long running SQL/runaway queries using AWR, ADDM and advise for restricting of SQL.
Performed Switchover/Failover Testing for New Built Oracle RAC and Oracle Data guard Clusters
Upgraded the database from Oracle 10g to 11g and from 11g to 12c to 18c using DBUA, Manual and Silent Upgrade methods
Managing Storage using Oracle ASM by creating/dropping Diskgroups using asmca, asmcmd and sql syntax for ASM
Sharing knowledge and extending help and suggestions for various issues faced by team members.
Gathered database/Objects statistics using DBMS_UTILITY, DBMS_STATS packages and ANALYZE command.
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 Data Pump Import/Export tools.
Knowledge on Oracle Support processes for technical requests through Meta link.
Monitoring & Reorganizing Tablespaces/Tables/Indexes.
Skilled in using tools such as SQL Developer and TOAD.
Replication (snapshots/materialized views)
Expert in RMAN backups including full, incremental and cumulative.
Data replication using Goldengate, streams and AQ
Installed, Configured and Troubleshoot PostgreSql 9.2, 9.4, 9.6, 10, 11 and 12 on windows and Linux
Used OS Watcher Utility (output) to give capacity planning advice to Customers and Clients
Oracle Corporation, Lehi, UT April 2016-Present
Role: Oracle dba /PostgreSql Dba/ Oracle Support Engineer (Goldengate)
Using Grid XAG 9.1 to Monitor and manage Goldengate Rac Integration
Support Engineer for Oracle Goldengate Product ranging from 10g to 18c
Support Advanced Replication Technologies like Streams, A.Q and Advanced replication
Support for Integrated Distributed Transaction and Database Links.
GoldenGate Troubleshooting and Goldengate Advance Configuration.
Goldengate Configuration on rdbms 11G,12C,18C and 19C on linux.
Configuration of Goldengate 12.3 on linux and mastery of Goldengate 12.3 new features
Configuration and support of OGG Microservice architecture and Parallel Replicat (OGG’s 12.3, 18C and 19C
Support for Oracle Streams, AQ and MGW
OEM 13 Installation, Configuration, Troubleshooting and target/database deployments
Oracle 18c installation and configuration
Oracle Goldengate 18c Installation and Configuration on Database 19c, 18c, 12c and 11G
Imported Schema’s from Oracle 11g to RDS oracle 12c on Cloud (AWS) using SQL DEVELOPER
Migrated from on prem to PosgreSql using DMS
Configured and worked on PosgreSql Aurora
Upgrade database from 11g to 18c using DBUA and Manual upgrade
Upgrade database from 11g to 19c using manual method and dbua
Configured, installed and troubleshoot Goldengate 19c on database 19c,18c,12c and 11g
Used pg_basebackup to take physical backup and restore to a new cluster in postgreSql
Used pg_dump, psql, pg_dumpall and pg_restore to backup and restore tables (logical backups)
Monitor postgreSql performance issues using VACUUM, REINDEX, ANALYZE, VACUUM FULL
Configured postgres streaming replication across linux servers for data integrity
DB Best Technologies, LLC, WA April 2015– March 2016
Role: Oracle Database Administrator
Used RMAN Duplicate and HOT/COLD backups to migrate the data from 18.104.22.168 to 22.214.171.124.
Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
Configured a 2 node Rac and Dataguard configuration for Dev and Test environments
Used Secure SCP extensively for the File transfers from machines to remote server.
Application of Oracle software patches when/where necessary.
Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.
Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
Experienced in cloning the databases using HOT and COLD backups.
Backup/Recovery monitoring and reporting using Oracle RMAN
Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.
Create oracle databases on configured servers using both the DBCA & Database creation scripts.
Manage, tune and troubleshoot database issues both on UNIX command line, SQL*Plus, OEM client, Oracle 11g database control, oracle 11g Grid Control as well as other third-party tools (TOAD, SQLDeveloper, DBArtisan and dbXpert for Oracle).
Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
Tested and qualified 11g new features for setting up 11g standards for database creation and configuration. Qualified installed procedures for 11g.
Designed and implemented database backups and Recovery strategies using RMAN, Datapump Export/Import, Cold, Hot backups
Create database Objects, Tablespaces, Schemas as needed.
Schema migrations from Development to Production via Tech Test environments.
Database refresh from Production to Tech Test as needed.
Migration from Oracle on Prem – AWS using DMS(Data Migration Service) and SCT
Configure 2-node Rac for scalability and HA
Data Guard Configuration
Tools Used: Oracle RMAN, Oracle 10.2.0.1, Oracle 11g, DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN
• University of Buea, South West Region, Cameroon.
Bachelor of Science (B.Sc.): Political Science and Public Administration