Emerson Mosi
Arlington,TX
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. A history of meeting company needs with consistent and organized practices. Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.
Overview
9
9
years of professional experience
Work History
Senior Oracle Database Administrator
Lonestar Trucking Academy
Mansfield, TX
08.2017 - Current
- Providing administrative support and maintenance on Oracle 10g, 11g ,12c and 19c installations, database creation, database security, database optimization and tuning.
- 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.
- Upgraded databases from 10g to 11g and 11g to 12c. Applying PSU and bug fix patch.
- 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
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
- Collaborated with cross-functional team to define features and build powerful and easy-to-use products and customer-facing workflow tools.
- Wrote scripts and processes for data integration and bug fixes.
Oracle Database Administrator
Nima Transport Group.
Grand Prairie, TX
08.2014 - 05.2017
- 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 disk groups, 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 (Cluster ware 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 our organization.
- Provided 24 X 7 Production & Development database support and administration
Education
Electrical And Power Transmission Installation
Los Angeles Trade Technical College
Los Angeles, CA08.2012
CCNA, A+ - Computer Networking
El Camino College
Compton01.2006
OCP Certification.
Brontech Academy
Greenbelt, MDSkills
- 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
- Troubleshooting
- Microsoft Office
- Multitasking
- Critical thinking
- Data management
Timeline
Senior Oracle Database Administrator
Lonestar Trucking Academy
08.2017 - Current
Oracle Database Administrator
Nima Transport Group.
08.2014 - 05.2017
Electrical And Power Transmission Installation
Los Angeles Trade Technical College
CCNA, A+ - Computer Networking
El Camino College
OCP Certification.
Brontech Academy
Languages
English
Full Professional
French
Native/ Bilingual
Similar Profiles
Emerson MosiEmerson Mosi
Senior Oracle Database Administrator at Lonestar Trucking AcademySenior Oracle Database Administrator at Lonestar Trucking Academy
Rebecca NarvaezRebecca Narvaez
4th/5th grade teacher at Somerset Charter Schools at Lonestar Academy4th/5th grade teacher at Somerset Charter Schools at Lonestar Academy
Christopher GravelleChristopher Gravelle
Teacher at Lonestar Online AcademyTeacher at Lonestar Online Academy
Michael MandujanoMichael Mandujano
Janitor at WhiteDove Janitorial SVCJanitor at WhiteDove Janitorial SVC
Madison VazquezMadison Vazquez
IT Technical Support Specialist at PrestoIT Technical Support Specialist at Presto