Chibuzor Stanley Uba

832-***-****

ac1s1d@r.postjobfree.com

US Permanent Resident

ORACLE DATABASE ADMINISTRATOR

Over 7 years aggregate IT experience with strong troubleshooting skills and 5 plus years of extensive knowledge and proficiency in ORACLE,11g and 12c DATABASE design, administration and systems analysis. I have excellent communication skills and I am a great team player with a fast learning curve. I can work perfectly and effectively under stressful conditions where speed and accuracy are necessary for mission critical databases. My attention to detail and the ability to maximize system resources can be beneficial in the following areas.

Oracle Installation, configuration, patching and upgrades

Backup and recovery using RMAN

Monitoring and Performance tuning (AWR, ASH, AADM, ADVISORS)

Database Upgrade, patching and Migration

Job Automation in ORACLE

Data and database integrity and SECURITY

Implemented different HA/DR technologies such Oracle RAC, Data Guard, Golden Gate.

Experience with data migration and ETL activities

Oracle DBA Consultant

CIBER

Nashville, Tn

January 2017

Responsibilities

Database administrator (DBA) designing, coding, migration and testing.

Oracle Database upgrade from 11g to 12c and patching

Tune database to ensure acceptable level of performance and availability.

Backup and Recovery of database using RMAN, Database Migration, Creation of databases, table spaces & tables

Involve in data migration from legacy platform to Oracle

Data Guard Replication Configuration & Troubleshooting

Troubleshooting of issues in various Oracle Products

Managing Pluggable database in 12c and cloning

Analysis of objects with tablespace, checking invalid objects of the database, Checking the size of tables and check whether it need partition or not, managing users account, checking alert log

Checking database size and comparing it to previous size to find the exact growth of the database

Monitoring backup, troubleshooting and performance analysis

Collect, review and analyze system data for capacity and planning

Work with users to gather information about objectives, functions of service and database features to ensure that they meet end-user needs while maintaining compliance with security, Implement plans for data security, retention, recovery, monitoring and response

Write and maintain comprehensive documentation, including database dependencies, database inventory, and daily database operations documents

Managing table spaces, data files, redo logs, tables and its segments.

Designed and engineered the upgrade, re-architecture and migration of databases/applications

Modified and upgraded SQL Loader scripts for the system, and modified existing code, tables, views, and SQL Loader scripts to meet changed system requirements

Fine tuning of SQL queries using various performance tuning methodologies for maximum efficiency and performance.

Oracle RAC (Real Application Cluster) setup and tuning

Backups and recovery using shell scripting and RMAN

OEM Oracle Enterprise Manager Installation and configuration

Oracle database installation, partitioning, patching, and cloning

Install, configure GOLDENGATE replication and add table to replication

Involved in designing and implementing Oracle backup and recovery methods and disaster recovery methods using RMAN.

Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.

Performed Database Refresh in RAC Environment using transportable

tablespaces, EXPDP, IMPDP on Solaris, Red Hat Linux and UNIX Platforms.

Successfully Implemented key RMAN 11g features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals.

Experience on Performance tuning tools like AWR, ADDM, ASH, Stats packs, TKPROF, Explain Plan.

Generated DDL statements for creation of new database objects like tables, views, sequences, synonyms, indexes and created triggers, packages, procedures, functions and granted privileges.

Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance.

Storage and space management including table spaces and data files.

Used Oracle 11g Enterprise Manager db console tools such as ADDM, AWR for diagnosing & monitoring events, jobs & performance related problems.

Certified and applied CPU patches on Solaris, UNIX and Red Hat Linux platforms in RAC and Non-RAC Environment.

Sound knowledge on refreshes using expdp/impdp.

Ability to troubleshoot the oracle alerts.

Migrated database objects from development to production instances.

Performed Databases Refresh and Schema level refresh as per the User request from Production

UAT and DEV Environments for testing purposes.

24X7 production support and on call rotation.

Oracle DBA

AT&T

Atlanta, GA

August 2015 to Jan 2017

Installed, Configured, Upgraded & Applied patches and bug fixes for Prod, Test & Dev Servers.

Administered Oracle 11g/10g/9i production, test, development environment on RHEL, IBM-AIX, WINDOWS, and ORACLE LINUX.

Provided 24x7on call support for all the Production, Staging, and Integration and Development databases.

Involved in the installation and configuration of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL platform.

Upgraded databases, Oracle RDBMS 10g RAC and NON RAC to ORACLE 11G (11.2.0.3)

Responsible to administering and monitory oracle database running version 11g and 12c with over 30T of database on different OS system.

Participated in applying security patches (Patch set updates, Critical Patch Updates (CPU) to both PROD/DEV/QA database servers

Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.

Involve in automating some database jobs like indexes reorg, rman full and incremental backups, statistic gathering and also table space growth size detection through CRON jobs.

Data Guard Replication Configuration & Troubleshooting

Troubleshooting of issues in various Oracle Products

Managing Pluggable database in 12c and cloning

Analysis of objects with tablespace, checking invalid objects of the database, Checking the size of tables and check whether it need partition or not, managing users account, checking alert log

Checking database size and comparing it to previous size to find the exact growth of the database

Monitoring backup, troubleshooting and performance analysis

Collect, review and analyze system data for capacity and planning

Work with users to gather information about objectives, functions of service and database features to ensure that they meet end-user needs while maintaining compliance with security, Implement plans for data security, retention, recovery, monitoring and response

Write and maintain comprehensive documentation, including database dependencies, database inventory, and daily database operations documents

Managing table spaces, data files, redo logs, tables and its segments.

Designed and engineered the upgrade, re-architecture and migration of databases/applications

Modified and upgraded SQL Loader scripts for the system, and modified existing code, tables, views, and SQL Loader scripts to meet changed system requirements

Fine tuning of SQL queries using various performance tuning methodologies for maximum efficiency and performance.

Oracle RAC (Real Application Cluster) setup and tuning

Backups and recovery using shell scripting and RMAN

OEM Oracle Enterprise Manager Installation and configuration

Oracle database installation, partitioning, patching, and cloning

Install, configure GOLDENGATE replication and add table to replication

Involved in designing and implementing Oracle backup and recovery methods and disaster recovery methods using RMAN.

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

Periodic data refresh/ clones from production to testing environments, Re-organizing database structures using the expdp/impdp utility on a very regular basis and Troubleshooting errors

Identifying performance issues by making use of diagnostic pack by generating AWR, ASH and ADDM reports and resolved performance

Experience in creating and managing physical and logical Standby database using Data guard for HIGH AVAILABILITY

Oracle DBA

PROS Revenue & Profit OPTIMIZATION SOFTWARE

Houston, Tx

April 2013 to August 2015

Responsibilities:

Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.

Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.

Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 11g on multiple platforms.

Performed up-gradation of 10g to 11g.

Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.

Automated routine DBA tasks like backup's and stats by using Grid control job's.

Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.

Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.

Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.

Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration

Adding and removing nodes to existing Oracle database RAC configurations

Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment

Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.

Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.

Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.

Performed activities like monitoring the database and provide maximum uptime.

Created and granted users the privileges and roles and resizing the datafiles to manage database growth.

Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability

Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes

Created primary database objects (tables, views, indexes) once application developers have designed an application

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.

Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.

Oracle DBA

United Airlines

Houston, Tx

February 2012 to March 2013

Responsibilities:

Managed Oracle 10g, 11g databases for airport operations. These Oracle databases reside in HP/UX, Sun Solaris, Windows & Linux servers. Duties include 24x7 on-call production support, DB refresh, upgrade and patch.

Installed, configured, and maintained 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.

Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.

Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.

Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.

Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.

Involved in De fragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.

Responsible for all database activities such as User management, space management, database security management.

Implemented the resizing the online redo logs in production and in standby database.

Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.

• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.

Successfully performed data replication using Materialized views

Cloned/Migrated databases using RMAN and traditional DATAPUMP export/import utilities in Oracle 10gR2.

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

Applied patches.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7 support for all the production and development databases.

SKILLS

Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows [ ] 2000, Windows Advanced Servers,IBM AIX UNIX servers,

Databases: Oracle 12c, 11gR2, 10gR2 RAC, Oracle Database Tools: SQL*Loader, TKPROF, Toad, SQL Developer, DBartisan, OEM, Grid Control Tools & Utilities: Export/Import, RMAN, Data Pump, Winscp3, ERWIN, DBCA, DBUA, ADDM, DATA GUARD(REPLICATIONS), Remedy, OLTP, OLAP, DW, and ETL concepts. Excel, Tablue. Statistics.

Education

Master of Science in computer sciences University of Aberdeen

Udacity Nanodegree in Data Analysis

Bachelor of Science in Mathematics and Statistics Anambra state University

Contact this candidate