Resume

Sign in

Data Manager

Location:
Marietta, Georgia, United States
Posted:
October 10, 2016

Contact this candidate

Resume:

Ojimadu Njoku

acwzof@r.postjobfree.com

**** ******** ****** **,

Atlanta, GA 30324

Phone: 404-***-****

OBJECTIVE: To offer my skills and experiences in the field of Information Technology in a creative and collaborative environment where my analytical and technical skills will contribute to the overall goal of the organization

SUMMARY OF QUALIFICATIONS

Oracle 11g/ Oracle Database Administration

Performance Tuning & Capacity Monitoring

Data Security, Backup & Recovery

Standby/Failover Administration

Database migration and cloning

Migration of 11i to 12i Application database using GoldenGate.

Database-Backed Web Solutions

Experience in Performance tuning of Oracle Goldengate Processes to achieve zero time.

Configured Goldengate components for unidirectional and bidirectional replications and maintain data synchronization.

SQL Tuning in an Oracle Environment

Data Profiling, querying and reporting on multiple RDBMS

Oracle RAC (Real Application Cluster) setup and tuning.

Backups and recovery using shell scripting and RMAN

Import/Export

Performed data migration from MySQL to Oracle using Goldengate.

Installation and configuration in AWS Cloud

Advanced performance tuning & monitoring

Oracle database partitioning, patching, and cloning

WORK HISTORY

Oracle/Oracle DBA

Hathrup capital funding, Atlanta, GA 04/14 – Present

Environment: Oracle 9i/10g/11g/12C, TOAD, Oracle Enterprise Manager (OEM), RMAN, RAC, Data Guard, Grid Control, Golden Gate, VERITAS, Linux Advanced Server, IBM AIX, RHEL, Windows, ASM.

Responsibilities:

Installation, Configuration and Administration of Oracle Databases.

Installation, upgradation, configuration and troubleshooting Goldengate 11G/12C software.

Monitoring and Performance tuning of Goldengate sessions at Database level and GGSCI level and investigate replication failures using ggserr.log, report files and LogDump utility.

Performed Zero Downtime migrations from Non Exadata machines to Exadata machines usingOracle Golden Gate and Dataguard.

Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle10g Automatic Storage Management (ASM).

Setup and maintenance of DATA GUARD on 9i, 10g, 11g for Disaster Recovery and reporting purpose with various modes. Developing methodology to create logical-standby configuration with help of RMAN clone.

Setting up schedule RMAN Backup using DBMS_SCHEDULER and CRONTAB in Oracle environment.

Database performance monitoring, Application performance monitoring, tuning database and application with efficient database parameters.

Database Cloning for Logical and Physical Standby server. Provided suggestions to system administer regarding disk configuration, RAID level according to database sizing and capacity planning.

Perl scripting, shell scripting and PL/SQL programming to resolve business problems of various nature.

Managed Oracle Net Configuration, monitoring Alert Log Files, Listener Log, Redo Log status, and Trace files for the database.

Configure Dataguard for DR disaster recovery.

Creating automate scripts to take backup of database by RMAN, imp/exp at data file and user level. Restore of database by script. Recovery of full database by applying archive and redo logs.

Frequently monitored the database level parameters for performance issues and tuned SGA, Optimizing SQL Queries.

Perform capacity planning required to create and maintain database environments.

Migrated Oracle databases to Sybase

Created database links to retrieve data from multiple servers.

Wrote procedures, triggers in PL/SQL and shell scripts.

Writing SQL and SHELL scripts for monitoring database.

Monitored Schema level performance issues and performed the tasks like analyzing tables, rebuilding indexes and gathering Stats on a timely basis

Data refreshes using export/import as well as data pump jobs, monthly partition maintenance like truncating partitions and adding new partitions.

Maintained cluster servers to provide high availability.

Responsible for data integrity and concurrent data, locks and deadlocks.

Successful in providing 24/7 support for production, development, and test database.

ORACLE DBA

Tech-Edge Group LLC, Atlanta, GA 03/10 – 04/14

Environment: Oracle 9i/10g/11g, Oracle Enterprise Manager (OEM), OEM 10g/11g Grid Control, RMAN, SQL BACKTRACK, RAC, ASM, DataGuard, AIX 5.x/6.1, Linux RHE, TOAD, Shell Scripting, PL/SQL,

Responsibilities:

Installed, configured and maintained Oracle 9i/10g/11g Databases on Linux, UNIX and Windows Platforms.

Involved in the complete SDLC, Database design, System analysis, design and development.

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

Installation and Configuration of 11g Grid Control.

Installed OEM Grid Agents on UNIX, LINUX and Windows for monitoring of production databases.

Implemented Oracle Database 11g, 2 node Real Application Cluster (RAC) using Oracle Cluster ware for achieving high Availability on ASM.

Setup and maintain RMAN backup and recovery strategy for RAC and Single instance Databases.

Worked on Oracle 9i to 10g/11g migration projects with low maintenance window and applied patches to various databases.

Worked on OEM Grid Control 11g, scheduling and troubleshooting OEM jobs and deploying OEM agents. Scheduling Backup Jobs and troubleshooting failed jobs through OEM GC.

Disaster recovery implementation using physical standby databases for high availability.

Worked for Incident & Problem Management and Change Release Management to meet business SLAs (Service Level Agreement).

Monitored the Performance of the migrated databases using grid Control and features AWR, ADDM, ASH and generated the reports for metric collection and health check of the databases.

Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.

Created, Upgraded, and Cloned Oracle databases for Development and testing databases.

Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.

Configured RMAN tape backups (TSM) for the newly created databases and scheduled Daily, Weekly and Monthly Jobs using the OEM Grid Control.

Installed and patched SQL server 2005 and SQL server 2008 R2 servers.

Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.

Performed Databases Refresh and Schema level refresh as per the User request from Production to UAT and DEV Environments for testing Purpose's.

24X7 production support and on call rotation

DATA ANALYST

PSI Shipping, Houston, TX 08/06 - 06/09

Environment: Oracle 9i/10g, TOAD, SQL Plus, Oracle Enterprise Manager (OEM), RMAN, Oracle and Linux.

Responsibilities:

Creating and maintaining databases, creating table spaces, tables, indexes, data files etc.

Backup plan designing and implementation using cold/hot backups, Flash copy, Volume copy and RMAN backup technology.

Perform capacity planning required to create and maintain database environments.

Helping the development team and data warehousing team.

Writing complex queries and procedures using SQL*Plus and toad.

Used ERWIN for DDL forward engineering on 10g.

Developed shell scripts and automated nightly jobs using cron to schedule the backups, exports, refresh test DB from production site and build development, testing staging DB's.

Report Generation using crystal reports 8.0.

Monitored table space size, resizing table space, relocating data files for better disk I/O.

Extensive use of Export and Import for full database backup, schema level backup, Table level backup and metadata as well as full database defragmentation.

Creating users, allocation to appropriate table space quotas with necessary privileges and roles for all databases.

Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Monitoring table space size, resizing table space, relocating data files for better disk I/O.

Designed Backup Strategies and Disaster recovery plans depending upon the criticality of the Databases.

Performed large data loads through SQL*Loader

Developed Database Triggers and PL/SQL Procedures, Functions using PL/SQL.

Managing archive logs, DB-links, partitions.

Create Indexes by analyzing and rebuilding of Indexes for better performance.

Managed database users and security for the SQL Server database.

Fine-tuned and maintained large production SQL Server databases, as well as monitored overall database activities using Profiler

Monitoring of SQL Server databases, working to maximize availability and tune data performance as needed.

.

EDUCATION

Georgia Perimeter College Clarkston, GA

AS (Associate in Science). Fall 2013.

Federal University of Technology, Owerri Nigeria

BS (Information Management Technology). Spring 2005.

Reference:

Available upon Request



Contact this candidate