Kene Osonwa

321-***-**** admvb3@r.postjobfree.com

ORACLE DATABASE ADMINISTRATOR

Career Objective

Around 8+ years of extensive database and over 10 years of General IT experience. Would like to be part of a challenging environment where my technical skills and analytical abilities can be used towards achieving the objectives and goals of your organization.

Key Competence

Excellent experience and maintaining database including database security, Capacity monitoring and performance tuning (I/O, Memory & SQL Tuning etc.) using Statspack, Explain plan, Analyze, ADDM, AWR Report and so on. Gathering and analyzing AWR report for troubleshooting purposes.

Great working experience in writing SQL for creating views, functions, stored procedures, creation of database etc.

Extensive experience implementing backup and recovery strategy for disaster recovery using Hot/Cold Backups and using the Oracle backup utility such as RMAN.

Experience in a variety of hardware platforms including; MS-Windows 2000, 2003, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX

Excellent knowledge of SQL*Plus, SQL*Net, SQL*Loader, Enterprise Manager & Performance Tuning Pack

Great working knowledge installing, patching, maintaining and upgrading all Oracle software (10g t0 11g) .

Extensive knowledge on database backup/recovery strategy (RMAN, Export/Import & Datapump), Capacity Planning, Oracle configuration management, Database Cloning, Refresh, and patch management

Documentation of the work assigned in the environment and stored for the future use.

Strong emphasis on organization and documentations. Excellent interpersonal and strong communication skills (including Presentations). Customer-service oriented attitude and self motivated, dedicated in any work environment.

Work Experience

Geodis Logistics Sept 2018 – Present

Role: Database Administrator

Architect, plan, design, develop, deploy and support Oracle, Sql Server, and Postgres Databases

Recommends and oversees implementation of database level configuration changes to optimize performance. Ensures maintenance of physical integrity of all production databases

Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases

Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples

Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery

Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.

Review new database schema changes

Monitor and manage database indexes for optimal performance

Automate the configuration management of database and Big Data systems

Performing schema management, database sizing, maintaining privileges

Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc

Install and configure SQLServer2008 R2/ 2012 and 2016 with backup jobs, database mail and configuration options.

Upgraded SQL Servers with latest service packs.

Work on change requests, permission requests and refreshes requests.

Created checklists for proper/unattended install of SQL Server, applied service packs and security x.

Configure and maintain transactional, Snapshot replication and merge replication.

Worked with SQL Disaster Recovery processes like Log shipping methodologies, clustering and mirroring.

Worked with capacity planning, database sizing and monitoring

Monitor data activities like database status, logs, space utilization, locks and long transactions.

Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions.

Create database maintenance plans for SQL backups, optimization, and integrity check and t-log backups

Migrate Oracle database to Azure /Oracle cloud

Administer and Monitor Exadata X8-2 Full Rack

Install Oracle 19c,18c,12c, 11g ASM RAC software with ASM, Migrated Non ASM database to ASM databases and ASM database to Non ASM databases based on need and architectural designs

Installation of high availability RAC environment and upgrading databases to 18c, and 19c environments.

Co-ordinate with Oracle Platinum support on Exadata patches and validate patches after completion

Successfully maximized database performance on Exadata using smart scan technologies such as storage index, Hybrid columnar compression and predicate filtering.

Registered all Exadata components with Enterprise Manager Cloud Control 12c to monitor and manage Exadata machine and regular databases

Designed and implemented database backup and recovery strategy using compression features on Exadata.

Use scripts, Oracle Grid Control and TOAD to monitor database health and perform common database administration tasks

Monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements, reorganize database objects and design indexes to improve response of queries.

Automation of Startup Shutdown on all Production and Development Database.

Create and manage Scripts for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.

Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators.

Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, capacity planning, space management, database Security, troubleshooting and documentation. (RAC and NON-RAC environments)

Capacity planning and sizing for setting up project and support environments on cloud

Migrated and manage mission critical Databases to Exadata Oracle cloud

Integrating on premise ancillary systems with Cloud using Fast Connect.

Westgate Resorts Oct 2014 – Sept 2018

Role: Oracle Exadata Database Administrator

Responsibilities:

Support over 100 Oracle databases on 19C,18C,12c, 11gr2, 11gr1, 10g

Back up Oracle databases using RMAN utility

Refresh Test and Dev environment using RMAN duplicate and DATAPUMP

Architect, plan, design, develop, deploy and support RAC/ASM environment

Setup Disaster Recovery solutions for Oracle (Data guard)

Document migration process, database creation, monitors, and load scripts

Administer and Monitor Exadata X3-2 Full Rack and Exadata X2-2 Quarter Rack

Develop backup and recovery, as well as disaster recovery strategies for production Databases

Work with Storage team to setup backups using Veridata Netbackup and EMC DDBEA

Migrate mission critical Databases to Exadata Full Rack 11G from Oracle 11G on Solaris and Linux

Install Oracle 19c,18c,12c, 11g ASM RAC software with ASM, Migrated Non ASM database to ASM databases and ASM database to Non ASM databases based on need and architectural designs

Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgrading databases to 12c, 18c, and 19c environments.

Experience in using ASM file system and managing using server control utility (SRVCTL) and CRSCTL to achieve high availability.

Configure high availability services Load balancing and SCAN features for clustered databases.

Troubleshooting Cluster Startup Issues, Node Evictions, Network Issues and Storage Related Issues.

Configured and Manage Oracle pluggable container database

Install and manage Oracle OEM 12c/ OEM 13c server and client

Successfully setup and managed oracle active dataguard on Exadata between multiple Data Centers.

Performs Database Switchovers and Application Deployments using Oracle Active Data Guard on Primary and Standby Sites

Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects

Migrated mission critical Databases from Exadata machine X3 to X7

Setup IORM on Exadata for improving performance and to allocate IO resources to multiple Cells.

Use Exadata Hybrid Columnar Compression for a very Large Tables greater than 1.5 TB.

Monitoring the Exadata InfiniBand Switches/ports, DB/CELL nodes and IB topology through ILOM and OEM 12c.

Run Exadata diagnostic tools (sundiag and exachk) as required for troubleshooting and patching

Administer Exadata Storage Cells using Command Line Interface (cellcli) and the Distributed Command Line Interface (dcli)

Upgrade 11gr2 databases to 12c pluggable databases

Configured and setup Uni-directional, Bi-directional topology based replication using GoldenGate Replication.

Diagnosed and resolved extract, replicate and network issues during GoldenGate replication

Improved performance of GoldenGate Replicat using Range & BatchSQL Parameters

Configured and build heartbeat monitoring in GoldenGate

Developed monitoring scripts to monitor GoldenGate and report issues proactively.

Use Logdump utility to troubleshoot and fix GoldenGate replication issues by analyzing GoldenGate trail files.

ITQ Consulting Jan 2009– Sep 2014

Role: Database Administrator

Responsibilities:

Administering and maintaining the company’s databases including daily monitoring and performance analysis using, ADDM, AWR Report etc. Gathering and analyzing AWR report for troubleshooting purposes.

Working with other IT professionals for database designs and reviews; troubleshooting database issues, and deploying timely fixes; maintaining regular and proactive database patches, updates and performance enhancement.

Enhancing SQL statements performance using Explain Plan and Oracle optimizer hints

Ability to manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.

Creating database that meet the constantly changing requirement and need of the company and clients.

Configuring the Oracle Network environment including Oracle Net Services and Listeners, configuring and managing oracle network.

Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. This include checking if the Listener is running, optimal running of all databases, Unix error messages, disk space availability etc.

Installing, patching, maintaining and upgrading all Oracle software (10g to 11g) using DBCA;

Performing constant database backup and recovery using RMAN, Data pump Import and Export utility, multiplexing the Control file etc. Using RMAN to clone database.

Managing and securing the database by using appropriate proper authorization schemes, roles and privileges

Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving. Monitor, optimize and allocate physical data storage for database systems

Sending daily operational report to the top management regarding the whole operation of the day, including any hitches and unusual situations.

Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc. Provided a 24hr on call production support.

Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments.

ITQ Consulting Atlanta, GA Aug 2006- Dec 2008

Role: System Analyst

Responsibilities:

Identified, resolved, and provided recommendations to various instances of performance problems which include Database performance problems, I/O hardware performance problems etc. Provided a 24hr on call production support.

Administered and maintained constant back up and archived data on tape

Assisted in database server tuning, application tuning, maintaining detailed documentation according to company’s policy, capacity planning and database security.

Set up and manage database security by creating new users, roles, profiles, and provide required user privileges.

Assisted in writing scripts for creation of users, analyzing space requirements and maintaining tablespaces, partitioning schema objects etc.

Assisted in maintaining, analyzing, evaluating and updating database integrity and security for users and security access to databases.

Responsible for the report of any issues to the Manager through daily ProSummary report, nightly production log, etc.

ITQ Consulting Atlanta, GA Aug 2004- Aug 2006

Role: Helpdesk Analyst

Responsibilities:

Support and troubleshoot network and connectivity issues

Configure and support PC, laptop and peripheral hardware including installing and configuring software programs

Diagnose and solve hardware problems

Provide subject matter expertise for projects; Manage projects as appropriate.

Keep abreast of current software and hardware technology trends and new technology.

Diagnose, troubleshoot and resolve a wide range of software, hardware and network issues

Prioritize and escalate issues where required

Plan and lead training sessions for new and existing users

Monitor, log and track all phases of help desk support

Skill Set

RDBMS

Oracle 12c/11g/10g/9i/

OPERATING SYSTEMS

HP-UX 10.x, 11.x, Sun Solaris 5.8, 5.9, 5.10, Linux (Redhat Linux) and Windows NT/2000/2003/XP.

LANGUAGES

SQL, PL/SQL, T-SQL, C, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS

DBCA, DBUA, WinScp, Oracle Data Guard, OEM (GC), RMAN, ASM, VCS, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, Erwin, TOAD, Data Modeler, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM, OEM / Grid Control.

Education and Training

Bachelors of Business Administration, Valdosta State University 2001-2004

Oracle 10g 11gR1, 11gR2, 12c

Contact this candidate