Njeck Anyam Check [US. Citizen]

Telephone: 240-***-****

Secondary: 202-***-****

Email: ac27dz@r.postjobfree.com

Willing to relocate!

Professional Profile

* ***** + of experience in the field of Oracle Database Technology with experience in designing, developing and implementing various database solutions.

•Extensive experience in Installations, configuration, Cloning, Security, Patching, Upgrades.

•Implementation of Enterprise wide Database Monitoring enabling Oracle 11g Enterprise Manager Grid Control. One stop solution for monitoring every single Oracle Database within the global enterprise

•Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.

•Installed Oracle Golden Gate 11g, Implemented uni-directional and bi-directional replication.

•Strong experience in RMAN, fail-over/fail-back/switch-over of stand by databases

•Experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Database and Switchover/Switchback of Database in 10GR2 /11GR2 RAC

•Experience in multi-node and RAC environments including configuration of PCP.

•Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multimode

•Enabling Load Balancing in a Multi-Tier Architecture

•Import/Export and Expdp/ Impdp utilities.

•Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.

•Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.

•In-depth understanding on oracle utilities SQL Trace, Explain Plan, TKPROF, Statspack, AWR, Analyzer and DBMS_STATS in Performance Tuning.

•Creating roles, profiles, privileges and assigning roles to users.

•Extensively worked on monitoring and optimizing the database by performance tuning.

•Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM).

•Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows.

•Performance Tuning of Oracle database using OEM, SQL analyzer, Stats pack, AWR, ADDM, ASH, RDA, Explain plan, TKPROF, SQL TRACE and Ordebug.

•Data transferring using Export/Import utilities and SQL*Loader.

•Expertise in creating and maintaining databases to Oracle Optimal Flexible Architecture (OFA) standards in very large scale database environment (VLDB) and mission critical OLTP and DSS systems.

•Resolved database network problems using Oracle Net Configuration Assistant, Oracle Net Manager, Netstat and ping utility.

•Involved in writing stored Procedures, Functions and Triggers in PL/SQL to interface application with database system.

changing

Technical Skills

Databases

Oracle 10g, 11g, 12c

Database Tools

Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Remedy

Operating Systems

UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware

Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

Middleware

BEA Weblogic 10.2.3

Remote Tools

Cisco VPN, Checkpoint VPN, Remote Admin, VNC, Remote Desktop, VMware Virtualization.

Career Summary

NuVasiveInc - San Diego, CA April 2014 – Present

Role: Oracle Database Administrator

•AWS EC2 instance creation and management. Including configuration and provisioning of instance for deployment of oracle db's

•Deployed RDS on EC2 instance including oracle and mysql.

•Coordinated maintenance activities including shutdown and startup of db's and ec2 instances

•Completed RDS backups before and after maintenance activities including upgrades and patching

•DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on IBM AIX 5.2 & 5.3. Database sizes range from 4GB to 2TB (in ODS & EDW environments).

•Backup/Recovery monitoring and reporting using both BMC SQL Backtrack &Oracle RMAN

•Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future utilization.

•Oracle Database up-gradation done in multiple environments from 9i, 10g and 11g to 12c

•Performed capacity planning required for migrating databases/schemas from Oracle 8i, 9i, 10g to Oracle 12c environment

•Extensive experience with Oracle patching, performed multi-platform database version UPGRADE, cross-platform migrations and bug fix/interim patch implementations in UNIX platform

•Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard.

•Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.

Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.

Written Shell scripts to Monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc.

Partitioning of large tables for better performance and manageability..

Involved in migrating databases from Windows to Linux, HP-UX to IBM AIX.

Logical & Physical Database Design

Capacity Planning and Benchmarking

•Oracle 9i/10g/11g/12c RAC, Standby Database, Clustering and Data Guard Setup, Automatic Storage Management (ASM) and Configuration and Tuning.

•Implemented physical standby database for maximum availability using Oracle Data Guard 11g withOracle Enterprise Manager (OEM) 12C cloud Control. Experience in implementing 10g Data guard with one physical database.

•Responsible for analyzing and designing the process to implement the available oracle patch sets

•Installed and configured High Availability Oracle GoldenGate (OGG) systems on Oracle 11gR2

•Configure and build heartbeat monitoring in Golden Gate

•Working extensively on Backup & Recovery online/offline using RMAN, User-Managed physical/logical backups using Import/Export/Datapump, DB refreshes and cloning using RMAN

•Working closely with DEV teams to create database objects (tablespaces, schemas, tables, views, indexes, triggers, stored procedures etc) as per the business needs

•Interacting with Storage team for adding mount points to complete database/schema migration activities

•Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.

•Create database Objects, Tablespaces, Schemas as needed.

•Schema migrations from Development to Production via Tech Test environments.

•Database refresh from Production to Tech Test as needed.

•Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10g Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.

•Create oracle databases on configured servers using both the DBCA & Database creation scripts.

•Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

•Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM) required to fulfill the storage needs.

•Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10gRAC servers for the purpose of disaster recovery procedures.

•Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

•Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.

•Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.

•Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, and backup logs to send notification emails.

•Migrated data to a new ASM Diskgroup to improve the IO performance of the database.

•Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.

•Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.

•Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) from previous RMAN backups.

•Performed capacity planning, space monitoring like tablespace growth, ASM disk space.

•Resolve critical issues by raising SR with Oracle Support and Root Cause Analysis (RCA).

•Application of Oracle software patches when/where necessary.

Tools Used: Oracle RMAN, Oracle 10g (9.2.0.8), DBMS STATS, Data pump, SQL TRACE, TKPROF, EXPLAIN PLAN

LabCorp - Newton, MA June 2011 – March 2014

Role: Oracle Database Administrator

•Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.

•Worked with different middleware & IDM teams to resolve their issues from the database side.

•Refreshed non-production environment with production using Datapump & RMAN

•Applied patches and database re-organization using oracle enterprise manager (OEM).

•Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.

•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.

•Logical backups were scheduled for Development, QA and UAT databases using export/import and Data Pump.

•Performed documentation for Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation, Oracle 11g Standby Documentation.

•Interacted with system and storage administrators, data modelers, developers, application owners for gathering the required information and resolving various issues.

•Expertise in Job Scheduling environments like AutoSys & Cronjobs

•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 24X7supports for all the production and development databases.

•Successfully performed migrations from Oracle 10g/11g to 11gR2 RAC (Real Application) Database.

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

•Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.

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

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

•Implemented disaster recovery system, using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configuration

•Experienced working on non-prod databases which are resided on Virtual Machines and understanding the working process.

Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLAN

Education

Prince Georges Community College

Contact this candidate