Mefor Mbekie Mbafor

443-***-****

adyuud@r.postjobfree.com

https://www.linkedin.com/in/mefor-mbafor-102958135/

BIOINFORMATICIAN

Currently Database Administrator with Secret Clearance and Master’s degree in Bioinformatics with specialization in Biotechnology, graduate of UMGC.

Expertise:

~ Server Administration for Database support, Operations, Security and Troubleshooting

~ System installation of updates, patches and required upgrades for operational optimization

~ Security of Database Systems, Backup & Recovery Solutions

~ Management of Relational Databases

Education & Training

University Maryland Global Campus, College Park, MD

n Masters in Bioinformatics specialization in Biotechnology

Courses: Relational Database Systems Data Structures and Algorithms Structure of Computer Prog Essentials of Computer Prog

Hood College, Frederick, MD

n Bachelors in Sociology

Technical Summary

Certifications:

Oracle Certified Associate, Comptia Security +

Platforms:

Windows 2008, 2010, 2012, 2016, Unix, Red Hat Linux, Ubuntu Linux

Languages:

Python, PL/SQL, SQL, R, Java

Software/Tools:

BLAST, EMBOSS, FASTA, Dotlets, SQL Developer, ORF Finder, Clustal Omega, DBCA, DBUA, R-Studio, GDC Data Transfer Tool, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), Exadata, Data Pump (expdp, impdp), MySQL, SQL Server, ER Assistant

Applications:

IDLE Python (3.9), Apache Netbeans, R(4.2.1), RStudio, Spyder, JupyterLab, ClustalW Data Manager, Eclipse, Anaconda, Weblogic, Solarwinds, Splunk, Oracle VM VirtualBox Manager

Professional Experience

SIMVENTIONS, Dahlgren, VA n Database Administrator/ Developer, 05/2023 to Present

Secret Clearance

Overall work includes the establishment, monitoring and troubleshooting of inbound/outbound interfaces to EDW (Warehouse) to and from multiple Navy and DOD systems.

Interface directly with the government customers daily and as needed.

Work with the customer on creating and refining requirements.

Designing and building underlying DB objects to meet customer requirements based on the functional specs provided. This includes various database objects such as views, triggers or stored procedures…

Safeguard PII and work in a secure environment.

Rapidly troubleshoot and address issues with incoming data or problems that occur within the load process.

Scheduling jobs for execution, monitoring, verifying them for successful completion, by reading and understanding attributes of various oracle logs.

Script writing to manipulate incoming files and prep them for loading.

Write technical documentation related to processing incoming files and producing outgoing file extracts.

Writing scripts to manipulate outgoing files and send them to customers.

Daily modifying and writing of Oracle load scripting using SQL, PLSQL and SQL*Loader.

NEXCOM, Virginia Beach, VA n Database /Webservices Administrator, 12/2015 to Present

Secret Clearance

8 + Years of Oracle Database Administration. Full time employee.

Close 95% of assigned tickets using CA ticketing system.

Providing 24x7 support for all databases, database platforms and web servers on a rotation alongside team of 8.

Commended for quick Implement application of information Security/Information Assurance policies, principles and practices in applications and services.

Daily checks and analysis of systems based on automated reports.

Have actively worked on 2 to 3 projects concurrently while meeting deadlines.

Observing seasonal growth trends for databases and coordinating physical environmental requirements with Unix, Linux and SAN Administrators.

Regular management and problem resolution of database systems varying from versions 9i, 10g, 11g, 12c to 19c.

Perform routine maintenance to ensure databases and web services are accessible and data is accurate. Provide technical support for crashes or failures by recovering database or web services and/or restoring data as necessary with knowledge of Oracle Data Guard and RMAN recovery technologies.

Regular and routine application of quarterly Patches and Security Updates to required systems.

Implementation of database changes through test, war, preproduction and production environments.

Administering to Oracle Systems, SQL server systems, Exadata container databases and Netezza as required.

Applying security technical implementation guide requirements Oracle and SQL server database and web servers..

Creating and maintaining database administration scripts using Unix shell and SQL.

Monitoring the performance of Oracle database engines across Unix, Linux and Windows operating systems.

Flexibility to work on multiple projects concurrently to meet deadlines.

Ability to work independently or within the team.

Implementation and execution of database backup and recovery methodologies.

Implementing and testing high availability and disaster recovery strategies.

Assisting in capacity planning for new and existing database and web services.

Perform routine maintenance to ensure databases and web services are accessible and data is accurate. Provide technical support for crashes or failures by recovering database or web services and/or restoring data as necessary with knowledge of Oracle Data Guard and RMAN recovery technologies.

Data migration between databases using both Oracle11g and 11g export/import utility and Oracle 11g exp/imp data pump.

Certificate installations after generating certificate requests for submission to DoD.

Generation of certificates and jks files for linux registers.

Database creation and a modification to database objects such as tables, database files, indexes etc.

Configuring databases and web servers to support application software while keeping web servers compliant with defined standards. Writing and maintaining system documentation according to established standards to facilitate ongoing support and maintenance.

Meeting yearly company expectations for emergency response and other mandatory training.

Regular maintenance of user applications such as Peoplesoft, Data Manager, Retek Management Systems

Work on multiple projects concurrently and meet deadlines.

Implement application of information Security/Information Assurance policies, principles and practices in applications and services.

Update and modify configuration files.

Project & Programming Experience

MatchTx LLC, BIOT 670I Biotechnology Capstone Project, (08/2022 to 11/2022) - for predictive cancer genome analytics; the treatment of cancer with personalized genomic data comparison based on patient outcomes:

Research and identification of predominant biomarkers most relevant to breast cancer and bone marrow cancer.

Data collection (clinical and mutation) and preparation (data downloading, assembling, and processing).

Application of several supervised machine learning techniques and models to process and analyze acquired data (logistic regression, ridge regression, support vector machine, random forest, decision tree etc).

Presentation of findings, final recommendations, business options in presentation and submission of 55-page report.

The use of tools like Dotlet to align and make comparisons of protein sequences in at least two substitution matrixes Blosum and PAM.

Installation of Debian GNU/Linux across a Ubuntu operation system.

Installation of guest operating system, Ubuntu inside VirtualBox.

Installation of samtools and minimap2 packages.

File parsing of FASTA files after conversion from FASTQ.

Creation of relational SQL databases with freeware database tools MariaDB.

Written statement of work for the creation and design of my proposed database.

Produce multiple sequence alignment with Clustal Omega

Well versed in writing SQL statements for advanced queries using aggregate functions and table joins and query analysis with execution plans.

Well versed in the use of Zero Order and Hidden Markov Model framework for emission probability calculations of DNA fragments.

Practiced in the application of Viterbi algorithm to zero order Markov model to determine most likely path of a sequence.

Use of Data visualization libraries

Use of Bioconductor packages, Biostrings package and preexisting libraries in R after downloading and installation of R & R-Studio

Performance of data reduction analysis using PCA.

Creation of multiple sequence alignment in and phylogenetic tree in R with ape and clustalw.

Use of factoextra package.

Use of CSV and TSV (SAM, VCF, GFF & BED) file formats.

Creation of a neural network for breast cancer diagnosis including its validation and training in R studio.

Use of BioJava packages after installation and integration into NetBeans.

Development of Java program to translate DNA sequences into their corresponding protein sequence.

Modify program to translate three forwarding open reading frames with the use of GeneticCodes and DNATools class transcribe and translate methods.

Installation of Python IDLE (3.9)

Written programs include:

Calculation of both GC and AT content from a read in DNA sequence.

Transcription of DNA sequence to RNA sequences.

Stores amino acids into an array, before prompting end user to choose and then print amino acid in sequence based on position.

Stores DNA sequence into an array while also reformatted DNA sequence.

Written program that identifies motifs from FASTA formatted file.

Creation of programs that read and parse information from EMBL records.

Use of SQL developer Data Modeler

Formulate an entity relationship diagram.

For creation of a logical and relational model for database implementation.

Reverse engineering of database into a logical and relational model.

Use of python data visualization libraries ggplot and seaborn

Contact this candidate