Manager Oracle

Emmanuel Ekome

Oracle Database Administrator

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

Professional Summary

6+ years Experience in Oracle/PostgreSQL Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modeling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams Enterprise Manager and Golden Gate on Sun Solaris, Exadata,Red Hat Linux, ETL tools, HP-UX, AIX, and Windows Platforms Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) and Data Guard.

Ability to work both as an individual contributor and as a member of a team.

Experience in Performance tuning of Oracle Golden Gate Processes to achieve zero lag times.

Experience in PostgreSQL RDBMS with knowledge of installations and Configurations, Backups, Warm/Hot Standby/Streaming Replication/pgHA, pgbouncer, Stado and ora2pg.

Lead the design, testing, implementation, maintenance, and control of the organization's physical, relational, and object-oriented databases across multiple platforms and computing environments.

Good Experience in migrating Databases from Solaris, AIX Oracle 10g/11g to Linux Oracle 12c

Implementation of high availability solutions with Oracle 11g RAC and 12c RAC, Physical and Logical Standby database (Data Guard) and golden gate

Designs, implements, maintains Disaster Recovery (DR) methodologies and creates documentation.

Configuring and fixing the Issues with Pgadmin-III client application. Responsible for monitoring environments using monitoring tool viz. Nagios, Check_Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.

Installing and configuring new servers as per customer's request. Cloning the Development, test and UAT environments with production data as per customer's request.

Design and implement disaster recovery for the PostgreSQL Database. Configuring third client software pgadmin-III, phppgadmin to access the database server. Configuring the backup jobs on customer system. Experienced in performing PITR.

Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and data Ware-housing.

Good Experience in implementing Exadata Smart Scan for query processing and data mining scoring to scalable intelligent storage servers.

Hands on experience on using of macros, conflict resolution, filtering and transformation, exception handlers and Security.

Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.

Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.

Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.

Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.

Experience in Database capacity planning, monitoring object growth and Storage Management.

Performed data migration from flat files into an Oracle database using SQL*Loader.

Experience in performing Cloning and Refresh using RMAN and Datapump.

Experience in Oracle Advanced Compression techniques.

Experience in Online/Offline Re-Organization of database objects.

Experience in Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.

Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.

Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.

Experience working with database security tools TDE, DB Vault / VPD.

Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.

Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c.

Experience in handling very large databases (VLDB) ranging up to 100TB.

Proficient in writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts.

Experience in Shell Scripting for configuring monitoring alerts and automation.

Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.

Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone

Experience in Upgrading databases, applying patches.

Managing Security Management, Schema Management, Instance Management, Storage/Space Management.

Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Installed Oracle 11g with ASM and OCFS2 File systems.

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

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.

Experience Summary

Trustaff - Cincinnati, OH March 2018 – Present

Oracle Database Administrator

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.

Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.

Able to resolve the performance issue in database 12c using full database caching and In-Memory Aggregation features

Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.

Migration of data from SQL server to Oracle12C.

Migration of data from Oracle 11g & 12c and to 18c for testing

Installed, patched, and managed Oracle Database versions 12c on Oracle Enterprise Linux (OEL)

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.

Supports Dataguard databases running on Physical standbys.

Installation of 12c OEM and customize it to our needs.

Installing Oracle Golden gate on RHEL and setup table level replication .

Experience with RAC /EXADATA

Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.

Configured Streams to capture propagate, apply changes in multiple databases.

Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

Setup/ Configuration/ Monitor / Support of PostgreSQL Powa and pact tools. PostgreSQL database (version 9.2.18 till 12.0) creation/configuration/ maintenance into local and AWS cloud storage following agency level policies, rules and security.

Standby setup/configuration of PostgreSQL from In-house Redhat Linux server to AWS cloud and GCP VM.

Database migration from Oracle to PostgreSQL into AWS EC2 and GCP VM using AWS SCT, AWS DMS, Ora2Pg, orafce, ora_migrator, oracle_fdw, bash shell, Python scripts and Coding/ Converting Oracle shared procedures in PL/SQL to PostgreSQL PL/PgSQL

Upgrading to PostgreSQL Version 10.2, setting related configuration parameters, migrating existing partitions with Inheritance to Native Range/List partition tables and changing automation scripts as per new / changed features / Syntax of PostgreSQL version 10.2

Created Table Level Logical replication in PostgreSQL version 10.2 using Publication and subscription at Primary/Secondary PG databases.

Physical replication, WAL archive setup/monitoring of multiple PostgreSQL databases.

Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.

Installation, maintenance and tuning of 11g RAC databases including ASM and CRS.

Set up, configured and maintained data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.

Data Migration as part of enterprise data warehouse project.

Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data.

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 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 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades

Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC

Configured Offline and Online Disaster recovery sites to maximize 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. Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements

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.

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

Installed Oracle 11g on Linux platform using ASM.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

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

Bergdorf Goodman - New York, NY March 2014 – February 2018

Oracle / Postgresql Database Administrator

Successfully installed and configured Oracle 12.1.0.2, Oracle 11.2.0.5 databases on Windows and AIX platforms.

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

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

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2

Managed and monitored database using command line as well as 11g, 12c and 13c OEM

Applied CPU and PSU Patching

Performed Database Tuning & Performance, Storage Management

Installed and configured Golden Gate, trouble shoot Golden Gate and monitor replicate lag and check point

Implemented Golden Gate 10g/11g replication. Monitored Golden Gate lag and extract

Performed schema migration

Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL and Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, EXPLAIN PLAN, TK PROF, DBV.

Continuous monitoring of performance during peak and non-peak loads using AWR reports, ASH, ADDM and Optimization SQL code using SQL Trace, tkpof, Explain plan.

Involved in the installation, configuration and extended support to Oracle 11g, 12ctwo Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 12c RAC databases.

Installed ASM environment and migrated databases from NON-ASM to ASM.

Used TOAD for database management.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Experienced in cloning the databases using HOT and COLD backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 12c.

Made optimal use of Oracle Support in resolving the SRs.

Use of Datapump, conventional export/import utility of Oracle 12c, 11g for re-organizing Databases/Schemas/Tables to improve the performance.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 11g/12c environments.

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

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

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Documented the Standard Processes for peers to follow.

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

Install and Managed Physical Standby databases Data Guard for disaster recovery.

Experience in Backup and Recovery techniques using RMAN.

Integrated the Backup Status Reporting for all the databases in the enterprise to enable the web reporting using Oracle SQL, PLSQL

With help of EXPORT/IMPORT utility of database to do table level and full database Defragmentation.

Technical Summary

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 2012

RDBMS

Oracle 10g, 11g, 12c, PostgreSql 9.x – 10.x, microsoft sql server,2012,2016 version

Tools

TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM

Database Utilities

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

Education

BACHELOR DEGREE IN COMPUTER SCIENCE BSC (UNIVERSITY OF BUEA) CAMEROON

ADVANCED LEVEL CERTIFICATE

SCRUM MASTER CERTIFICATION

SQL FUNDAMENTAL CERIFICATION

ORACLE CERTIFIED ASSOCIATE (OCA)

ORACLE CLOUD INFRASTRUCTURE 2019 ARCHITECT PROFESSIONAL

AWS CERTIFIED SOLUTION ARCHITECT-ASSOCIATE

ORACLE AUTONOMOUS DATABASE CLOUD 2019 CERTIFIED SPECIALIST

Contact this candidate