Ejike Bismarck Nnamani

acti04@r.postjobfree.com

310-***-****

Experience Summary:

* ***** ** ********** ** a Database administrator, has hands on experience in database administration in multi RAC environment, RMAN for Backup and recovery, Data guard for Disaster recovery production support, installation, configuration, upgrades, performance tuning, backup and recovery, cloning, patching, space management, and database security.

•Excellent experience in Installation and configuration of Oracle11g(11.2.0.3,11.2.0.4), 10g(10.2.0.3,10.2.0.4,10.2.0.5), 9i(9.2.0.8)inHP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux environment.

•Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities likeOracle grid control 12C and RMAN.

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

•Good experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments

•Experience in Auditing and Capacity Planning, Configuring & ManagingStandby Databases(Data Guard).

•Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

•Experience in using 10g/11g DATAPUMP, AWR, ASM, ADDM, Grid Control Monitoring & Oracle Enterprise Manager (OEM).

•Performed In-place and Out-of-place patch set Upgrades

•Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.

•Experience of Oracle Golden Gate (GG) installation, configuration and troubleshooting Golden Gate EXTRACT and REPLICAT issues.

•SQL Trace using Events 10046, 10053, SQL_TRACE,Dbms_session,Dbms_support.

•Experience in Real Application Cluster(RAC)11g environment with Auto Storage Management(ASM).

•Installed and Monitored Oracle11g/10g RAC software and experienced on Performance Tuning on RAC.

•Migrated NON-ASM databases to ASM using RMAN

•Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.

•Creating Users, Roles and Profiles, Privilege management with role-based security.

•Hands on Experience in Space Management, Capacity Planning.

•Experience in various tools like OEM, TOAD, SQL Developer 2008 and performing data migrations using Export/Import utility.

•Expertise inGoldenGate (10.x and 11.x) replication solutions to facilitate data flow between Heterogeneous (SQL Server and Oracle) environments.

•Install and configure Oracle GoldenGate and Veridata12c.

•Have experience in Oracle Support (raising SR) processes for technical requests through METALINK.

•Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required

•Experience in SQL Tuning, Optimization, cost based optimization and Hints.

•Proficient in Index REBUILDING and Index TUNING.

•Experience in creating Documentation of Oracle database operations and capacity planning.

•Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities)

•Worked as a team member to provide 24x7 on-call production database support.

•Have strong analytical, administration and problem-solving skills dedicated to maintain the high quality standards. Good communication skill, ability to work independently.

Technical Skills:

Operating systems

HP –UX 11.11,11.31, Sun Solaris10,OEL5,6,

Redhat Linux(5,6,6.4),AIX

Languages

L, SQL, PLSQL, Unix shell Programming

Databases

Oracle 12c/11g/10g/9i, Oracle 11g/10g Real Application Cluster (RAC), ASM

Hardware/Machines

HP HP-UX, Intel Xeon, Sun Ultra Sparc, IBM–AIX

Tools & Utilities

EXEXP/IMP, OEM, RMAN,TKPROF, STATSPACK, AWR,ADDM, SQL LOADER, SQL NET, TOAD, SRVCTL, DBMS APIS, ORADEBUG, RACDIAG, RDA

Professional Experience:

Marsh and McLennan Com, NJ July 14 to Jan 2016

Role: Oracle DBA

Responsibilities:

•24x7 production support for several mission critical systems which utilize multiple Oracle 10g, 11g databases.

•Administration of a 2 node RAC, configuring and monitoring daily BACKUPs, troubleshooting errors, to improve performance.

•Upgrade and Migration of Databases from 11.2.0.1 to 11.2.0.4 and applying patches as per requirement.

•Good experience in managing the databases using the OEM grid control like Scheduling Backups, Performance Monitoring, alerts setting, generating reports in seconds, email notifications, Black out instances during maintenance/down times etc.

•Physical standby Data Guardconfiguration, Maintenance and support for DR activities

•Database level - Handling Performance Tuning Activity using OEM (AWR/ADDM), Database space management, security Patches.

•In-place upgrade of a Oracle RAC Database from 11.2.0.2 to 11.2.0.4

•Installed Oracle 11g using OUI on 2 nodes RAC environment with ASM and OCR services.

•Managing, Troubleshooting and resolving oracle database, RAC and applications issues.

•Troubleshooting EXPDP/IMPDP errors in a RAC environment, configuring storage accordingly.

•Cloning the databases for development and testing purposes.

•Worked on import/export, export data pump/import data pump and SQL- loader.

•Performed the Upgrading of databases from 11.2.0.1 to 11.2.0.4.

•Experience in taking daily/weekly hot backups and cold backups using RMAN.

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

•Oracle-to-Oracle replicated environments utilizing Golden Gate.

•DDL replication using Golden Gate

•Test initial Data Load option of GoldenGate during environment build

•Migrated database from ASM to Non-ASM using RMAN

•Knowledge of the Oracle Golden Gate installation, configuration, troubleshooting GG issues

•Trouble shooting and performance tuning Golden Gate replications

•Configure error handling for restart, logging, production support and status reporting in GG

•Upgraded the data’s from Existing Oracle 9i to Oracle 10g to 11g

•Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

•Implemented DATA GUARD (Standby) for high availability/disaster recovery purpose.

•Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.

•Oracle Database Performance Tuning and SQL Tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF etc.

•Refresh the test and development databases from the source production databases on a regular basis using export/import utility

•Configured database entries and Monitoring of all the databases using Oracle EnterpriseManager (OEM) 10g/11g grid control and TOAD.

•Focused on separate Partitionslike data loads, index creation and rebuilding, backup/recovery.

•Configured ASM and suggested feasible workarounds for ASMMetadata corruption and Configured user log on load balancing and failover on RAC database.

•Preparing cluster, configuring and Installation of Clusterware and Oracle RAC.

•Implemented database auditing, data security and Remediate high-risk violation in production environment and Gathering schema stats and monitoring the index usage.

•Creating and dropping of users, granting and revoking rights as and when required.

•Management of table space growth, monitoring data files additions, extent growth.

•Good experience in SQL, PL/SQL, Shell Scripting.

•Experience in parameters tuning and setting them to best optimal value for better performance.

•Researchingerrors/issues/bugs which were impacting the performance of the database and recommended permanent solution without losing the performance.

•Installation, configuration and creating new test databases for production and development databases.

•Applied High priority, security patches downloaded from Metalink.

Environment: Oracle 11gR2/10gR2 HP-Unix 11i 11.31, Oracle Enterprise Linux 5.2/6.4,RAC, ASM, RMAN, OEM, Windows 2008R2 Servers, Dataguard, DataPump, OEM, SQL*Loader,Toad and SQL developer 2008.

T-Mobile, Atlanta GA Jul ’10 to Mar’14

Role: Oracle DBA

Responsibilities:

•24x7 Oracle Production Database Administrations.

•Managing, troubleshooting and resolving oracle database and applications issues.

•Refresh/Cloning of Database and applications for development and testing purpose.

•Working alongside programmers and contributing to the development process.

•Planning and recommendations for optimum performance.

•Extraction of data from flat files into Oracle Database using SQL*Loader.

•Defining and Setting backup and recovery procedures.

•Responsible for SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF

•Developing Hot, cold and logical backup scripts to automate the backup procedures.

•Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.

•Written SQL, PL/SQL functions, procedures, packages and triggers.

•Monitoring and managing the Storage Usage by Resizing Older Tablespaces, Creation of New Tablespaces and relocation of data files for better Disk I/O.

•Writing Shell Scripts for managing day-to-day activities and automation of backup.

•Optimal Space utilization in table space by avoiding fragmentation.

•Usage of Partitions to improve the query performance and manageability.

•Installation of Oracle RDBMS server software and version upgrades.

•Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).

•Monitoring of database objects like rollback segments, temp segments and table spaces.

•Automated the process of analyzing tables.

Environment:Oracle 10g/9i/8i, OEM (Grid Control), PL/SQL, RMAN, Datapump, SQL*Loader, Sun Solaris, RedHat Linux, Windows.

Contact this candidate