Emerson Mosi

Arlington, TX ***** 562-***-**** adz0e2@r.postjobfree.com

Summary

I am a self motivated, deeply-driven, professional Certified Oracle Database Administrator with over 8 years of experience, with a profound knowledge in database security and user management, backup and recovery, database design, performance monitoring and tuning, migration, upgrades, Patches, cloning, replication, advanced configuration of RAC and Data Guard, OEM. Proficient in an assortment of technologies including Oracle 10g, 11g, 12c, 19c, MySQL, PL/SQL. Exceeds ongoing and overlapping deadlines in fast-paced environments. Skills

Backup and Recovery (RMAN)

Data Pump and Export/Import

Transparent Database Encryption

Database Security

Database Upgrade and Migration

Oracle Performance Tuning

Patch Set Management

Oracle RAC

Oracle Data Guard

Oracle Golden Gate

TOAD

SQL Developer

SQL Loader

Oracle Enterprise Manager (OEM)

Oracle VM Virtual Box

Linux operating system

Database Analysis

Experience

SENIOR ORACLE DATABASE ADMINISTRATOR 08/2017 - Current Lonestar Trucking Academy - Mansfield, TX

Providing administrative support and maintenance on Oracle 10g, 11g and 12c installations, database creation, database security, database optimization and tuning. Experience with providing and maintaining high availability and disaster recovery using ORACLE DATA GUARD. Monitoring and troubleshooting database performance using OEM, AWR, ADDM, ASH, Explain Plan, and TOAD. Performing other Security related tasks including Transparent Data Encryption (TDE). Implementing Security policy enhancement through roles, profiles, privileges and password policies as per business requirements.

Cloning schemas, objects and databases on new server using exports from 10g database and imported in 11g using data pump.

Performing backup and recovery procedures using RMAN and Data Pump utility for Oracle databases. Upgrading databases from 10g to 11g and 11g to 12c. Appling PSU and bug fix patch. Implementing, tuning and maintaining Oracle database using OEM. Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report. Participating in 24/7 on-call DBA rotation schedule. Managing Database Structure, Storage Allocation, Table partitioning, Table/Index segments, and Rollback segments, Constraints, Database Access, Roles and Privileges Oracle Database performance-tuning services with EXPLAIN PLAN, AWR reports, ADDM Extensive use of Oracle Enterprise Manager (OEM) Grid control for Performance, Administration and Maintenance of Databases

Day to day maintenance included patching, cloning, and administration of concurrent manage process, Users, Forms, Reports and performance issues.

24x7 remote support and on call rotation

ORACLE DATABASE ADMINISTRATOR 08/2014 - 05/2017

Nima Transport Group. - Grand Prairie, TX

Creating DBs and assigning appropriate roles and privileges to users depending on user activity. Installation of oracle 11g databases in production, development and test environments depending on project requirements.

Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications. Configured and Managing Oracle 11g R2 Data Guard (Active Physical Standby on 2 nodes RAC ) Design and Maintaining Physical standby maintenance (Switch over using Data Guard Broker). Applying upgrade patch, maintenance and interim (Opatch) patches on all databases. Refreshing Dev and Test instances with data from Production on regular basis. Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab. Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment. Tuning test and production database by altering parameters. Export and Import of database objects to copy from one database to another database. Investigating suspicious database activity using Fine-Grain Auditing. Write database documentation, including data standards, procedures, and definitions. Reconciled functional and technical problems through research and training workshops, achieving 65% increase in satisfaction rate of database end users and supervised coaching of junior DBAs. Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report. Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances

Used ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues. Setup unidirectional replication on oracle 11g databases using Golden gate. Monitoring and troubleshooting gaps between source and target databases configured with Golden gate. Successfully upgraded databases from 11g to non CDB 12c. Successfully migrated 12c Non CDB databases to pluggable databases. Created Oracle Wallets and implemented Tablespace level TDE security. Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments.

Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running oracle. Plan for contingency, disaster management that includes standby databases, data guard and cloning/refresh of databases

Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed backup methodology for the organization. Provided 24 X 7 Production & Development database support and administration Education and Training

Los Angeles Trade Technical College - Los Angeles, CA Electrical And Power Transmission Installation, 08/2012 El Camino College - Compton CCNA, A+

Computer Networking, 01/2006

Brontech Academy - Greenbelt, MD

OCP Certification.

Languages

English:

Full Professional

French:

Native/ Bilingual