Oracle Database Administrator
Resume:
Ransom Nche
******.****@*****.***
ORACLE DATABASE ADMINISTRATOR
SERVICE MEMBER OF THE UNITED STATES ARMY
OVERVIEW
Experienced Oracle DBA with 5 years of experience in Oracle Database Administration in large-scale production environments across multiple platforms. manages and maintains multifunctional Oracle databases, in particular the Oracle E-Business Suite. Administers production, development, and test databases and my primary responsibility is aimed at performing many related database functions. Facilitate resolution for all production issues in the Oracle databases.
Professional Skills
RAC (REAL APPLICATION CLUSTER)
Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard and replication using Streams.
High ability to analyze and understand the AWR reports and can fine tune the databases for maximum performance.
Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.
GOLDEN GATE CONFIGURATION
Performance Tuning of the database (Memory Tuning, I/O Tuning)
Performed RMAN backups (Full, Incremental and Cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
Have implemented two types of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC
Worked on large-scale databases with size around 10TB in large system environments.
Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
Created indexes to facilitate easy user interface implementation and tuning.
Involved in construction of DR sites for all the Production and IST environments.
Performed Database Refresh from Production to SIT, UAT and Development databases. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
Upgrade/Migration of oracle databases from 10g to 11g and 10gRAC to 11gRAC.
Worked on Set up, configuration and maintained Oracle Data Guard/Active Data Guard to control Primary and Secondary databases and also to ensure disaster recovery using various data protection modes.
PROFESSIONAL EXPERIENCE
ORACLE PRODUCTION SUPPORT DATABASE ADMINISTRATOR
MOTOROLA – Sunnyvale, CA
October 2017 – November2018
Cloned Database from Production to Test and Development.
Exporting and Importing of dumps using expdp and impdp.
Performed Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, AWR report, 12c OEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
Database security using Oracle Security Features (roles, privileges), auditing & Network ACL Config, Transparent data encryption, DBMS CRYPTO, etc
Expert in RMAN backups including full, incremental and cumulative.
Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
Extensively worked on Import/Export and Data Pump Import/Export tools.
Participate in configuring ASM (Automatic Storage Management)
UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
Performed Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
ORACLE DATABASE ADMINISTRATOR
JP Morgan Chase – Washington Crossing, PA
January 2015 – June 2017
Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and Upgraded from Oracle 10g to 11g.
Installation, Upgradation, Configuration and Troubleshooting GoldenGate 12c software.
RAC (REAL APPLICATION CLUSTER) CONFIGURATION
Configured Golden Gate Downstream Mining and Integrated components for Active-Passive and Active-Active replication.
Configured GoldenGate High Availability using Oracle DBFS and Active DataGuard.
DATA GUARD CONFIGURATION FOR HIGH AVAILABILITY AND RECOVERY
Table refreshes and schema refreshes using Datapump, expdp and impdp.
Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
Experienced in cloning the databases using HOT and COLD backups.
Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.2.0.1 to 11.2.0.3.
Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
Installation of oracle enterprise manager 12c, oracle management repository and deployed agents
Designed, developed, and implemented database security management, backup/recovery strategy, monitoring methods, and performance tuning. Provided technical support for all application administrators and users.
Applied critical patches to Oracle databases and application servers.
Installed Oracle Cluster Ware Software to set up 4-nodes in a production environment.
Manage agents using emctl utility and creating incident rules in enterprise manager 12c
Configuring administration groups and creating template collections in OEM 12c Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable Table spaces.
Installed RAC 12c on 3 node cluster for large production system and migrated the legacy system from Non-RAC environment to RAC 12c cluster database.
Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
Responsible for capacity planning, database security, recovery planning and installing patches
Configured and implemented different types of Advanced Replication Models of distributed databases.
Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).
Provided valuable inputs for various performance tuning issues. Explored 12c features by doing POC, including multi-tenant features
SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
Responsible for setup and implementation of 2 Node RAC on Linux in 11g and 12c R2.
Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
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.
JUNIOR ORACLE DATABASE ADMINISTRATOR
TD Bank - Greenville, SC
January 2014-December 2014
Installed Oracle Dataguard for Oracle Disaster recovery, High Availability and data protection.
Helped Implementing High availability using Golden Gate replication.
Knowledge on Golden Gates for Active-Active Replication between the Datacenter for High Availability
Written Stored Procedures and Triggers for database maintenance and management using PL/SQL and UNIX Shell Scripts for backups.
Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL, PL/SQL statements, reorganize database objects and design indexes to improve response of queries.
Involved in designing data warehousing boundaries and parameters, Data Transformation, PL/SQL, HORIZONTAL SCALING.
Created PL/SQL, SQL*Loader and UNIX scripts as a part of data load process to load external data into Oracle database tables.
Working Experience with Latest TOAD 9.6 having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Audit Objects, Diagnose Extents, Logminer, Segment Advisor, Database Monitor, Server Stat's, Session Browser, SGA Trace, Top Session Filter, HTML Schema Doc Generator, Query Builder.
Responsible for installing, upgrade and configuring the Oracle server, creating databases, storage structures and objects; database backup and recovery, monitoring and optimizing database performance Implemented Transparent Data Encryption (TDE) for database security.
Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
Automated the Data Replication process using Materialized Views for reporting databases.
Resolved RAC issues, OCR related issues, relocating the switched over services.
Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace.
Adjusted data models when necessary under direction of data architects.
Implemented Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN. Configured and maintained Standby Databases in OLTP environment to automatically synchronize with production database.
Supporting more than 30 Oracle 10g/11g development/testing environments on Solaris/SPARC and Linux/X64 boxes. Help the developers and QAs to do trouble shooting about database issues.
Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM, Statspack/tkprof tools
Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
General DBA daily jobs such as disk usage monitoring, table/index rebuild, and reorganization as needed. Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
Installed ASM environment and migrated databases from NON-ASM to ASM.
Used TOAD for database management.0
Made optimal use of Oracle Support in resolving the SRs.
24 X 7 Production & Development database support and administration
EDUCATION
BACHELORS IN COMPUTER SCIENCE
UNIVERSITY OF DOUALA- CAMEROON
UNITED STATES ARMY SCHOOL OF ORDNANCE
CERTIFICATIONS
ORACLE CERTIFIED ASSOCIATE (OCA)
CISCO CERTIFIED NETWORK ASSOCIATE (CCNA)
Contact this candidate