Yaw Asamoah

**** **** ******* **, ***, OK, ***** adckym@r.postjobfree.com 240-***-****

www.linkedin.com/in/yaw-asamoah-731a07

https://university.mongodb.com/certified_professional_finder/#name=asamoah

Employment Authorization: US Citizen Security Clearance: Yes

Professional Skills Summary

Over 15 years of IT experience, with 12 as Oracle DBA, 5 years as MongoDB DBA. Manage a cluster of servers, databases, and schemas to support various applications in achieving organizational business objectives.

I manage databases on Linux platform using these tools: Mongo shell, MongoDB Compass, Ops Manager, OEM, GRID Control, TOAD for Oracle, Bash Shell scripting, vi Editor, RMAN, SQL Plus, PL\SQL, JSON

EDUCATION and Certifications

MS – Management Information Systems (MIS), Bowie State University, Maryland.2001

BA – Sociology, University of Ghana, Ghana 1994

Certifications: MongoDB Certified DBA Associate (2020) C100DBA

Oracle Certified Professional (2008) Administration II (10g)

Oracle Certified Associate (2007) Administration I (10g)

VMware Certified Professional (2011)

Oracle University Trained 11g RAC Administration (Oct 2008)

11g Performance Tuning (Nov 2009)

11g SQL Tuning Workshop (Dec 2009)

Member: Oklahoma City Oracle User Group, since August 2007

Professional/Work Experience

DOT/Federal Aviation Administration, Oklahoma City, OK - Nov 2015 - Present

Snr MongoDB DBA DOT-FAA (Certified – C100DBA)

Proven experience with installing MongoDB to scale across data centres

Upgrade MongoDB to newer versions

Solid experience with Indexing to improve queries, sharding and overall performance

In-depth understanding of MongoDB high availability with replica sets

Proficient with large scale deployment design to improve reads and writes

Configuring replica sets with SSL/TLS certificates for authentication

Manage backup strategies using Ops Manager, LVM snapshots, Sever level files copy, and mongodump

Experience with CPU, Memory, Disk space monitoring and management

Experienced with schema design using denormalized data models, embedded docs, and arrays

Good at reviewing performance stats using MongoDB tools such as Profiler, mongotop, mongostat

Creating users, assigning roles, managing user authentication and privileges using RBAC

Experienced at troubleshooting system issues with MongoDB, such as client connectivity

Setting up MongoDB auditing, to capture suspicious database activity

Team building, mentoring, writing and sharing best practices documentation

Leader Communications Inc,Oklahoma City, OK - Apr 2011 - Nov 2015

Snr Oracle Database Administrator (Certified – OCP)

Provide DBA support to application developers, and business users on critical applications in production and non-production environments

Solid experience with versions 11g, 12C, 18C and 19C

Administer Oracle Databases on different operating systems including: Sun Solaris, Red Hat Linux and Windows 2000/NT Server, VMWare

Monitor and optimise database availability and performance through systems, SQL, and database tuning

Install and administer Oracle 12c& 11g RAC primary and standby databases, with Data Guard

Proficient with RAC administration, including adding and removing node from Cluster

Troubleshoot and solve performance issues with OLTP and Data Warehouse databases

Migrate database files from non ASM to ASM disks

Review data models, SQL, PL/SQL and pair with development and reporting teams in an agile environment

Upgrade databases from 10g to 11g

RMAN database backup, restore and recovery

Apply critical patch updates to databases, in both rolling and non-rolling fashion

Product installation, testing, deployment, user support

Drive logical and physical design of databases.

Collaborate with the Engineering team in data modelling, conceptual design and data architecture design

Objectstream Inc,Oklahoma City, OK - Jun 2007 – Apr 2011

Database Administrator (Certified – OCA)

Install client/server Oracle Software

Create physical databases, create tablespaces to store data, create roles and users

Manage user security through roles

Create tables, indexes, views, aliases and synonyms to meet developer requests

Creating Object data and User-defined data types

Create database links and materialized views for reporting.

Partitioning large tables using partitioning keys

Performing cold, hot RMAN backups and supplement it with daily export utility

Providing remote technical support

CHAVERAN Inc, Bowie, MD - Jan 2005 –Jun 2007

Jr Database Administrator

Running CRUD scripts

Taking exp / imp, expdp / impdb backups

Creating users and managing RBAC

Reviewing alert logs for database issues.

Fixing missing permissions and synonyms issues.

Compiling invalid objects issues, and research oracle errors messages

Writing documentation and DBA team’s best practices

Contact this candidate