Information Systems Disaster Recovery

***** ******** **** ***** ***** Asumadu-Sakyi Tel-443-***-****)

Houston TX 77044 ********@*****.***

EDUCATION

Johns Hopkins University Present

Masters in Information Systems, Whiting School of Engineering 3.7

University of Maryland, College Park December 2011

Bachelor of Arts in Economics, College of Behavioral and Social Sciences GPA: 3.166

University of Bristol, UK January-June 2011

Information Systems (Exchange Program) GPA: 3.8

Certificate OCA/11g, Security+,Couchbase,

Openshift.

Conference Oracle DB Security Test Drive

Mongodb World 2019

RedHat Openshift-Better Together

TECHNICAL SKILLS AND TRAINING

Operating System: Linux RedHat, Windows, Unix, Window 2012/2008/2003 Server, DOS

RDBMS/Application: Oracle 12c/11g/10g, SQL Server 2012, Oracle SQL Developer, Oracle Enterprise Manager, Toad, SSH,Winscp, Mongodb, Liquibase. Couchbase, Sync Gateway, AWS, Openshift Ansible, Jenkins, appDynamic, Datadog

Languages: SQL, PL/SQL, Batch and Shell Scripting, Java, C#

Tools/Utilities: RAC, DBCA, Listener, TNSPING, RMAN, OEM, Export, SQL*Loader, Opatch, Oracle Warehouse Builder, Data Pump, NETCA, DBUA, Oracle Universal installer, Oracle VM Virtual Box, ADRCI, Stata, Database Application, Net Manager, Toad, DBmanager, PVCS Version Manager, Gitbash, Eclipse, Visual Studio 2015, .Net Framework 4.0, SQL Developer, Cdata sql, Opsmanager, RazorSQL, Robo 3T, Mongodb Compass, cbbackup,cbbackupmgr,Curl, Mongo shell,

MS Office: Word, Excel, Power point, Access, cmd, postman, sync_gateway

AREAS OF EXPERTISE

Data analysis, Disaster recovery procedures, High availability of Data, Couchbase and MongoDB upgrade implementation, Oracle upgrade implementation, Cross platform migration implementation, Performance & Memory tuning, Database monitoring, Configuring and Troubleshooting, CPU patching, Database exports and imports, Oracle software installation, Mongodb installation and patching, Couchbase installation and cluster setup, password propagation, database creation, software updates, sync_gateway configuration, postman, opsmanager monitoring and installation

DATABASE ADMINSTRATION EXPERIENCE

United Airline Houston, TX

Senior Nosql DBA February 2018 – Present

Lead my team to complete annual projects to support United commercial Mobile and Web applications.

Installing, configuring and setting up Couchbase clusters with the highest of 24 nodes.

Troubleshooting and configuring sync gateway for data synchronization.

Tuning databases performance, creating and building necessary indexes for high optimization.

Lead disaster recovery exercise for all united application on Mongodb and Couchbase databases.

Repairing corrupted data to a recoverable state and syncing data across other data bearing nodes

Refreshing databases across multiple environments as part of application migration or troubleshooting.

Building Disaster Recovery clusters and creating XDCR for data replication across two data centers.

Keeping development, QA and Production Mongodb and Couchbase servers up to date with necessary upgrades.

Auditing and configuring both Mongodb and Couchbase clusters to stay in compliance with updated GDPR including

Data encryption.

Maintaining database backup and troubleshooting failures for database recovery and restore.

Upgrading Mongodb to its current version, creates Mongodb accounts and manages Mongodb clusters for sustainability and performance

Optimization.

Setting up EC2 instances and building cloud formation for Couchbase clusters.

Configuring and building AWS Documentdb to support various applications

Configure and renew SSL/TLS certificates on both Mongodb and Couchbase clusters for data security.

Installing, configuring, and upgrading Opsmanager to monitor and backup deployed Mongodb Replicasets.

Upgraded and reconfigured a mobile application 2.6 Sync_gateway to control the cache size and reduce RAM usage on the node.

Hewlette Packard (HP) Frederick, MD

Senior Oracle/Mongodb DBA October 2015 – January 2018

•Installed Mongodb 4.0, 3.6 and 3.4 on linux 7 servers including development, test, stage and production.

•Refreshed mongo databases for developers to troubleshoot productions issues

•Created mongo-connector for elastic search for data collection

•Configured Opsmanager for data backup, recovery and monitoring.

•Applied periodic patch to Mongodb boxes.

•Upgraded Mongodb version 3.2, 3.4 and 3.6

•Created oracle wallet for application service accounts for secured access to database.

•Cloned Real Application Cluster production database to a test environment

•Maintained, troubleshot, configured and recovered both standalone and RAC databases.

•Applied Oracle security patches quarterly to both software and databases to limit vulnerability on both standalone and cluster servers.

•Upgraded oracle 11g database to oracle 12c on 150 production servers over time using DBUA.

•Set up Rman backup for standalone and Real Application Cluster databases.

•Supported and troubleshot production database upgrades for Sever Support Team on Call basis.

•Successfully installed 11g and 12c Oracle software and created a database.

•Restored and recovered database for development and production servers on both standalone and RAC servers.

•Compiled 32bit, net codes to be compatible with Microsoft 64bit systems.

•Reviewed STIG violation with STIG viewer and applied fixes to reduce vulnerabilities.

•Maintained existing application code by updating and changing code to suit current application request from functional team.

•Created setup installer project for 64bit platform systems to be deployed to thirty-five client systems using InstallShield Limited Edition.

DOD/CACI Inc. Frederick, MD

Oracle DBA January 2014 - October 2015

•Administered database objects including indexes, views, tables, clusters, sequences and procedures.

•Monitored the daily status of OTR servers using SCOM and personal scripts. This prevented storage and data errors.

•Monitored scheduled database nightly upgrade on all development servers. Data issues that may cause a failure are researched and fixed before running the job to upgrade the database.

•Successfully Installed Oracle 12c RAC by installing Grid infrastructure and Oracle database software. Applied the latest CPU patch and created documentation for future use.

•Exported and Imported production databases onto Development and Test Servers for research, testing and migration.

•Troubleshot network problems that prevented users from getting access to test, development and production databases.

•Tested and resolved issue that may cause a database upgrade to fail after in-house build. Successful testing is pushed to production database.

•Worked on various trackers to apply schema and null data changes to both RAC and Standalone databases.

•Restored and recovered RAC database from production using RMAN utility and created documentation as part of our COOP project 11GR2 & 12C.

•Successfully performed a RAC database cloning using RMAN backup files 11GR2 & 12C

•Engaged in occurring DBA tasks like managing users including granting and revoking roles and privileges to ensure database security.

•Provided remote support to system administrators and server support team during files transfer, database migration processes and syncing users’ password.

•Involved in database STIG security vulnerability projects to detect and fix “finding”. Reported to Information Assurance Manager

•Worked to test Oracle Transparent Data Encryption on the database. (Column and Tablespace Encryption)

Moore Information Washington, DC

Oracle DBA July 2011- December 2013

Took part in a large number of tuning projects, perform application, SQL, and database instance tuning using a wide range of technologies including AWR, extended SQL trace (event 10046 trace files), OEM Performance Manager, and Custom Scripts

Developed, designed and implemented the company’s internal DBA Portal using Oracle 11g Application Server.

Designed and implemented various high availability solutions for a diverse group of clients running oracle 11g using RMAN, Oracle Flashback, and Log Miner.

Created and automated, enterprise wide monitoring infrastructure using several key technologies including UNIX shell scripts and SQL. This allows our operational DBA team to efficiently gather metadata, exceptions, and performance statistics for remote clients running Oracle using a consolidated Intranet approach.

Chaveran Inc. Bowie, MD

DBA Intern January 2010 - Dec 2011

I successfully installed oracle data warehouse and new database upgrades, patches on windows and Linux using ASM.

Created database objects like table spaces, tables, views, synonyms, snapshots, partitioning, indexes and sizing tables

Supported a five-gigabyte database by trouble shooting Oracle connectivity problems for performance tuning and system efficiency

Designed database schemas, set up database users, managed database permissions and set up database roles, and enabled database auditing for security

Set up range, hash, list and internal partitions for performance, used traditional and data pump utilities to facilitate cross platforms restore operations.

HONORS AND INTEREST

Alpha Lambda Delta, Grant Brett Promethean Kappa Tau, Certificate of Excellence (Morgan State University)

Interests: Database Administration, Entrepreneurship, Financial Markets, Capital Investments, Reading, Basketball

Community Services Baltimore, MD

Campus Pals Coordinator: Setting up tours for Elementary and High School students to receive talks on the insight and benefits of getting higher education.

Capital Partners for Education (Since Aug.2010): mentor an inner-city kid through weekly phone calls or meetings

Inspire DT Mentorship Program (Aug 2020)

Professional Affiliation College Park, MD

Economic Association of Maryland (EAM) September 2008-2011

Maryland Information Systems Society (MISS) September 2009-2011

Contact this candidate