Data Aws

MATHIAS CHO AWUNDAGA

Silver Spring, Maryland ****5 Tel.: 240-***-**** (cell) Email: *********@*******.***

PROFILE:

A Senior Cloud Database (Oracle, MSSQL, Postgres, OCI, AWS, etc.) and Apps/EBS DBA & Instructor with over twenty-two years of experience and extensive knowledge and proficiency, working remotely and in-house, on premises and in the cloud (AWS & OCI), planning and implementing projects & solutions as an Oracle Database and Applications (EBS 11 & 12i) Lead DBA, Product Owner & Scrum Master, doing database design, Management, Capacity Planning, installations, patching, 24x7x365 Remote Monitoring & proactive tuning, Backup & Recovery (RMAN), Import/Export, Data pump, Cloning, Upgrade, Migrations, RCA, risk analysis, Database Security, logical & physical Database design, re-structuring, RAC, Standby-Databases & Data guard configuration & management, of Very Large Databases (VLDB) >10 TB+, with RDBMS of Oracle 7, 8, 8i, 9i, 10g, 11g, 12 & 19c on distributed platforms (UNIX/Linux & windows). Trained and mentored hundreds of DBAs and AWS Solution Architects for huge organizations. Extensive experience with Erwin, SQL Developer, (Data modeling), Toad, SQL, PL/SQL, Forms & Reports (packages, stored procedures, functions & triggers), shell scripts, OEM 12c & 13c, Quest Spotlight, Automatic Work Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM). Self-starter - requiring little to no supervision and possessing an entrepreneurial (can do) attitude with a fast-learning curve upon taking on new/challenging assignments and responsibilities. Passionate on learning new technologies; Great communication, analytical and problem-solving skills; expert working under pressure, resolving critical real time Production problems. Energetic and self-motivated team player with ability to work effectively, independently, and cooperatively, with project & infrastructure teams; High interpersonal skills; experienced work remotely – Teleworking for years.

SKILLS:

Cloud & Premises DBA: Oracle OCI & AWS

Managing Very Large Databases > 10TB

Heterogeneous Environments – Oracle, MSSQL, MySQL, Postgres, AWS Redshift & DynamoDB.

AWS Services: IAM, EC2, S3, EBS, RDS, VPC, ELB, CloudWatch, CloudFront, DMS, Route53

OCI Services: Compute, Block Volume, DBMS_CLOUD, File Storage, IAM, Streaming, Traffic Manager,

Documentation & implementation of policies and procedures of all projects and jobs.

Peer Review and documentation

Apply Agile/Scrum methodologies on projects from development to QA & to production.

Backup & Recovery- RMAN & Data pump

OEM 12c & 13c Cloud Control Installation & Implementation for Administration & Monitoring

Standby Database / Data Guard configuration for High Availability (HA) & Disaster Recovery (DR) Failover & Switchovers in testing DR Environment

RAC configuration & administration for High Availability and Performance Optimization

SQL, stored procedures & packages Tuning with SQL Trace, TKPROF, Explain Plan & SQL Tuning Advisors. ADDM implementation

DB & Apps Performance Monitoring & Tuning using Toad, SQL Developer, OEM, Splunk

Table & Index Partitioning (hash, range, & composite) for management & performance

Golden Gate & Oracle Streams for Data Replication & zero downtime Upgrade & Migration

Cloud Migration: premises to AWS & OCI with Data pump, GoldenGate, DBMS_CLOUD, SQL Developer, MAA, Data Pump, SQL*Loader, MV2ADB; AWS DMS & Schema Conversion Tool

EBS 11i/12i Installation, Upgrade, configuration, Patching, Cloning, Maintenance & Administration

Defining & documenting ETL processes & procedures

Flashback Technologies - view past states of database objects or return database objects to a previous state.

User Training and Support

Security Technical Implementation Guidelines (STIG) Compliance Standards Violations

Database security policies (data access, profiles) as per STIG Rules, Governance & Compliance

Software life cycle (SDLC) including requirement gathering, technical design, development, system integration & quality assurance phases.

Virtualization - Oracle Virtual Box & VMWare

Patching - Patch set, Critical Patch Updates (CPU), Patch Set Updates (PSU) Security patches (SPU) using “opatch”, adpatch & OUI.

Capacity Planning, documentation & Monitoring

Automation using crontab, AT scheduler.

MSSQL Server – 2002, 2005, 2008 & 2012

SQL server Management studios (2008,2012)

Integration and Aggregation of data from different databases within or outside the organization

Always Updated on emerging technologies and new design approaches.

SharePoint / Web Designer for documentations

EXPERIENCE:

SENIOR TECHNICAL DATABASE ADMINISTRATOR / ARCHITECT & CLOUD DBA CONSULTANT June 2018 – Present

Bereans Information Technology, LLC. Washington DC.

Lead Database Administrator and Architect, leading in research, test, upgrades and migrations implementations of apps and databases to new infrastructures on-premises and into the clouds – AWS and Oracle Infrastructure Cloud, OCI. Overseeing implementations of new technologies, capacity planning, and reviewing and testing all documentation in Test before migration to Production. Responsibilities include, but are not limited to

Documentation & implementation of policies and procedures pertaining to projects & the management, security, maintenance, Backups, and use of the database & apps systems.

Enforce Change Management processes in each environment – Test, Stage/Dev & Prod

Design, test and support solutions for Disaster Recovery on premises and in the Cloud as per Agile/Scrum methodologies

Installation & configuration of PostgreSQL & Oracle 12c, 18c & 19c on Linux, following OFA, on premises, AWS & OCI

Database security policy development, documentation, and implementation: passwords, privileges, profiles, data encryption, Data Redaction (Masking), TDE, Auditing, network security

Splunk installation & configuration to analyze security and system operations in real time and for monitoring and correlation of database events with events from other applications in the technology stack often ignored by other commercial monitoring tools, and hence resolving the multi-layer data flow issue with a single view.

Proactive Monitoring & Tuning with OEM, Spotlight, and Splunk to ingest logs such as backup logs, Sensitive data access, Audit trail logs, DB object changes, alertlog, trace files, listener logs, Storage, application logs, OS logs, Network Logs for detecting intrusions, sql injection, poor performance, space, cpu & memory usage.

Manage heterogeneous ecosystems on premises and clouds - AWS, Azure & OCI

Extensive knowledge and experience on Amazon Web Services (AWS) Technologies like: EC2, S3, RDS, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), IAM, VPC, Subnets

Launching EC2 instances w/ Linux AMI & bootstrapping with Apache using Bash scripting, auto-scaling, Elastic block Store (EBS), Security Groups and load balancers (ELB) for databases and applications.

Define best practices around migrating applications and required Databases to AWS, OCI and other Cloud providers.

Develop and document standards and procedures for all aspects of Database/Warehouses in the Cloud.

Identify system enhancement and automation opportunities for installing/maintaining database technologies, building, deploying, and monitoring applications as well as alerting and remediating system outages.

Create network architecture on AWS VPC, subnets, Internet Gateway, Route Table and NAT Setup.

Setup HA (High Availability) and FT (Fault Tolerant) for AWS EC2 Instances using the AWS Technologies like: EC2, Route53, ELB, CloudWatch, AMI (Amazon Machine Images), VPC, Subnets

Homogeneous database migrations with AWS Database Migration Service (DMS) - Oracle to Amazon RDS for Oracle, MySQL to Amazon Aurora, MySQL to Amazon RDS for MySQL, or Microsoft SQL Server to Amazon RDS for SQL Server

Heterogeneous database migrations – using AWS Schema Conversion Tool to convert the source schema and code to match that of the target database, and then use the AWS DMS to migrate data.

GoldenGate implementations for data replication, DR, ETL, Zero downtime upgrades & migrations and query offloading.

Work with SharePoint administrators to migrate sites of documents and content from on-premises environments.

Provide product support and training to users and stakeholders including content managers, site owners, SharePoint administrators and applications support teams.

Ongoing migrations - Oracle on premises to OCI – Autonomous Database - ATP, ADW, #Schema Advisor

Ongoing database technical support for RDS, EC2 environment in Amazon Web Services (AWS).

Ongoing technical support and research for migrating databases and applications from AWS to OCI.

Database & AWS Training Instructor, Mentor & Program Director: June 2015 – Present

BiTech Training, College Park, MD

Have been working as a DBA and teaching Database Administration since 1997; trained over 300 DBAs. Expert in training and mentoring motivated people with zero IT knowledge to becoming DBAs within six months, with a focus on Oracle, MsSQL on Linux/Unix on Local Clouds (VMs), and public clouds - AWS, OCI & Azure.

Courses: Advanced Functional Linux fundamentals, AWS for DBAs 1 & 2, Senior Cloud DBA 1 & 2

Other Responsibilities include:

Develop, Update and implement Course Curriculums to keep up with changing technologies.

Expert in training folks with zero IT knowledge to becoming Oracle DBAs within six months, with a focus on the Linux o/s, Oracle and MsSQL for beginners. Remote Classes to Distant students.

Teaching and mentoring junior DBAs from Introduction to Advanced Database Design, Development and Administration.

Use techniques to get immediate and lasting audience participation including asking direct questions to various individuals and encouraging group responses.

Use multimedia Power Points props and anything that helps break up the boredom of material.

Use of Social Media (WhatsApp, Messenger, etc.) in engaging students 24x7 from start to end of course.

Incorporated humor and comedy into the subject matter whenever possible.

CONSULTANT – EXPERT DBA & SYSTEMS ENGINEER July 11 – Now

Roboz Surgical Instrument Co., Gaithersburg, MD 20898

Database Design - design and Architect database solutions as per Oracle Flexible Architecture (OFA) that are secure, highly available, scalable and efficient, requiring minimal maintenance over time.

Backup & Recovery Strategizing - Develop backup, restore and recovery strategies with UNIX teams, including development of backup scripts, RMAN configuration, and batch job configurations.

Capacity planning: identify server hardware, software and configuration requirements for new databases, working in conjunction with Infrastructure team members.

Migration, Upgrades and Patching – Oracle 10g – 11g – 12c

Train / Mentor Junior DBAs and database users onsite and sometimes online

SENIOR/LEAD DATABASE ENGINEER / ARCHITECT & APPS DBA Nov. 2001 – Jun-2019

Healthy Directions, LLC. Bethesda, MD / Helen of Troy. El Paso TX.

Lead Database and Oracle Financials / Apps DBA and Architect at Helen of Troy (HOT) / Healthy Directions (HD), reviewing, restructuring, fine-tuning, designing, capacity planning and migrating Internet Market Oracle 9i, 10g, 11g, 12c & MS SQL Server databases (Development, Testing & Production) running against oracle apps, COTS and custom applications on Unix, Linux and Windows NT/2000+. His responsibilities include 24x7x365 databases and Oracle EBS monitoring & Tuning; systems design and recommendations, Database Security, upgrades - patching, migrations (servers or software), operations and performance in development, testing and production. Works overtime, nights and weekends to meet up with project schedules, or as scheduled or just to resolve issues. Sometimes, works even while on vacation abroad via remote terminals, RD. Principal Duties, Responsibilities & implementations include but not limited to configurations, installations, administration, proactive monitoring and tuning, troubleshooting single instances, RAC and Standby databases on Exadata & Linux (Red Hat, OEL, Centos 5.6); systems & database backups; Active Monitoring of database, user activities, alert logs, application trends, operating system logs, space usage, hardware capacity, and network. Secured and Optimized performance of corporate systems:

Database & Apps Migration & Upgrade - Oracle 10g to 11g to 12c, 11i to 12i EBS including Oracle Middle Tier technologies such as Oracle SOA Suite, Oracle WebLogic, Oracle BI Publisher - OBIEE, EDQ, ODI and Oracle Identity Management (OID, SSO, and Oracle Access Manager), on distributed platforms (UNIX/Linux, windows) using rman, Export/Import, datapump, Transportable Tablespaces or Database Upgrade Assistant (dbua). Migration of databases from Windows to Linux

Implementation of Oracle's advanced EBS and database technologies such as TDE, Shared APPL_TOP, ASM, GRID, etc.

Integration of heterogeneous databases to solve problems imposed by different platforms, different query languages, different data models, different dependencies exist among databases and applications.

Integration and aggregation of data from different databases within or outside the organization using Database Gateway for MSSQL (Dg4MSQL), DG4IFMX, DG4SYBS, DG4ODBC, Golden gate, database Links, tnsnames.ora & Listeners configurations.

Automate routine Database Administrative functions to ensure accuracy, minimize downtimes and costs.

Agile Scrum: As a member of scrum team, participated in ceremonies including Sprint planning, Sprint review, Sprint retrospective, and daily scrum meetings. Contributed to Artifacts - Product backlog, Sprint backlog, and Burn Down charts.

Evaluate new technological developments relevant to the infrastructure. Recommend appropriate technological alternatives to Infrastructure Solutions and Technology Management.

Provide training and guidance to End-Users, Peers and Junior Database Administrators.

Database Design - design and build Production database services to ensure the highest standards of availability, resilience, integrity, security and performance. Using Reverse Engineering & Forward Engineering with ERDs for documentation

Architect multitenant container databases (CDB) on Exadata for provisioning dozens of pluggable databases (PDB)

Establish security policies and general vulnerabilities management: Oracle Label Security, Transparent Data Encryption (TDE) (password, Dual mode), Data Masking, Data Redaction, Database Vault, Audit Vault. Encrypt backup.

Deployed web application firewalls: In addition to protecting a site & Database against cross-site scripting vulnerabilities and website vandalism, create DB objects to mitigate SQL injection (SQLi) attacks.

Establishing/documenting/implementing policies and procedures pertaining to the management, security, maintenance, and use of the database management system.

Patching: Apply & Test security patches (CPU, PSU, SPU, Interim patches.) as released quarterly or recommended.

Practice the principle of least privilege: Grant necessary privileges only; Revoke unnecessary privileges and roles from the database server user group PUBLIC; Restrict permissions on run-time facilities; Restrict operating system & network access; Apply all security patches and workarounds.

Backup & Recovery Strategies & Policies - Develop backup, restore and recovery strategies with UNIX teams, including development of backup scripts, RMAN configuration, and batch jobs scheduling with crontab.

Recovered/restored multiple databases from disk failures that involved loss of some physical files.

Proactive Monitoring and Tuning - Develop database monitoring plans - Monitoring vital signs (or metrics) related to database health, performance, security. Analyzing workloads running against databases for identifying any issues needing attention and ensuring optimal performance.

Monitors all production database activity for operational improvements including but not limited to CPU, Disk and Memory utilization, space utilization, replication, and consistency of sites, long running queries/data loads, query access plans, security infractions and overall performance of databases Develops and Tune as necessary.

Implementing corrective measures for database issues/problems found during monitoring.

Monitoring tools: Oracle Grid / OEM 13c - AWR, ADDM, TKPROF, Quest Spotlight, Toad, shell Scripts, SiteScope, etc.

Database Duplicating / Cloning for Refreshing or creating pre-prod/Dev/Test/DR environments with Prod/pre-prod databases.

Capacity Planning - Provide system resource plan, sizing, growth analysis and capacity planning for Oracle database deployments.

Data Guard / Standby Databases – Physical & Logical configurations, deployment, and administration for Disaster Recovery. Active Data Guard

Replication using Golden gate, oracle snapshots / materialized views, streams, …

Golden gate – configuration and administration

RAC Architect – Oracle 11g, 12c & 19c Real Application Cluster – RAC implementations - installation and configuration of Oracle Clusterware (CRS), Oracle ASM for RAC across Windows & Linux clustered environments. RAC backup with RMAN

Auditing - tracking who did what and when in databases.

Standardization – Set standards and guidelines for all database related implementations (Optimal Flexible Architecture – OFA) and enforce them to maintain consistency across environments. Create Change Management Guidelines (CMG) to meet SLAs of 99% uptime.

Provide support to development teams and development/testing environments for fine-tuning of SQL statements, PL/SQL programs and ETL processes & procedures of structured & unstructured data sources into database, account management, creating users, profiles, roles, db-links, linked servers, tables, views, materialized views, indexes, sequences, triggers, stored procedures and functions.

Support production systems - 24x7x365 database and oracle EBS support.

Project Management: Demonstrate strong teamwork, interpersonal and communication skills. Demonstrate strong analytical and problem-solving skills. Demonstrate Adaptability and Professionalism. Focus on Quality and Customers. Adopt and Manage Change

Setup and maintain Technical Documentation standards - on all critical processes (Example: Standby log shipping, Security best practices, Performance tuning methodology etc.). Analyzing, designing, programming, testing and documenting Data flow processes, Database backup & Recovery Procedures.

Platforms – Windows (2000 - 2019), Solaris & Linux (Red hat, ULN, CentOS) on HP, Dell Servers & Exadata

Virtualization: Virtualization of existing hardware onto VMWare & Oracle Virtual Manager.

Apps DBA

Upgraded EBS 11i to 12i on 10TB+ Databases.

Served on major oracle 11.5.10.2/12i EBS complete upgrade and integration project, discovery and assessments of customer existing Oracle E-business Suite and multi-vendor products, for H. Directions, as Oracle EBS applications architect.

Created and implemented project plan for upgrading EBS 11.5.10.2 to 12i multi-node RAC/ASM/SSL, integration with OAS 10g/Portals and compatibility/upgrade of several third-party products into a single integrated solution for global operations.

Technical Lead and implementation of EBS 11i Upgrade to 12i which included Install, upgrade, Migrations, Export/Import, RMAN, Patches, & Clones, Patch Management, Regression Testing & Version Control.

Responsible for Test Plan for Regression Testing by respective functional users. Executed post-upgrade product-specific task and included business users for regression testing. Completed capacity planning and working on upgrade issues.

Provided day to day maintenance duties such as patching and tuning concurrent managers as per Oracle best practices.

Patching Oracle Applications using adpatch and responsible for evaluating patching requests, communicating constraints, issues and timelines for deployment.

Assist functional team with forms and reports as well as functional setup of FA, AP, GL HR and AP.

Install and configure Oracle Discoverer and Single Sign-On.

Planned and performed online/offline refresh/cloning techniques for Oracle database and EBS Application Test and Development environments from Production environment.

Setup system & user profiles for Oracle Applications, administer concurrent managers & reports.

Developed suite of utilities for maintenance of multiple Oracle Applications environments: automated database tasks, Webserver, Form servers & managing concurrent managers/concurrent programs, startup/shutdown process.

Shell scripting for automated open & close backup. Installed and configured Veritas NetBackup for RMAN backups.

Developed, planned, and coordinated Disaster Recovery (DR) testing for multiple databases and applications.

Coordinate & execute code migrations.

Interface with Oracle Corp. for technical support, MOS. Opening/Responding to Service Requests - SR.

MSSQL SERVER DATABASE ADMINISTRATION

Troubleshooting and resolving SQL Server & Oracle database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.

Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.

Detect & troubleshoot SQL Server related CPU, memory, I/O, disk space & other resource contention.

Backups, restores, recovery models, database shrink operations, DBCC, Clustering, Database mirroring, Replication.

Knowledge of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)

Create linked servers between SQL Server & Oracle; Create packages for data transfer between environments

Review SQL Server performance and train staff on areas for improvement in code, storage, indexes, and configuration

SENIOR & LEAD DATABASE ADMINISTRATOR/ENGINEER Sept. 04 – April 05

USI Networking (AT&T), Annapolis, MD

Worked nights/weekends as a lead DBA at the USi Data Center with teams of DBAs working remotely from India, in concert with in-house Platform and Network engineers. Handled databases (Oracle8, Oracle8i, Oracle9i, & 10g, MSSQL, MySQL) of all sizes and platforms (Win NT, 2K, 3K; Sun Solaris Unix, HP-UX, Linux. Responsibilities included but not limited to Patching, Backups, Restoration & Recovery, Monitoring, Troubleshooting, Restructuring and Tuning for optimal performance.

EDUCATION: Bachelor of Architecture Degree

New Jersey Institute of Technology (N.J.I.T.), School of Architecture, Newark, NJ

TRAINING: Oracle Autonomous Database Cloud 2019 Certified Specialist May-2020

Oracle Cloud Infrastructure Foundations 2020 Certified Associate July-2020

Oracle Cloud Infrastructure 2019 Cloud Operations Certified Associate July-2020

Oracle Cloud Infrastructure 2019 Certified Architect Associate July-2020

SCRUM MASTER Accredited Certification March-2019

Oracle Corporation, Reston, VA March 2006

- Oracle E-Business Suite 11i Installation & Patching

- Oracle E-Business Suite 11i Administration

Oracle Corporation, Rockville, MD March 2001

- Advanced Performance Tuning, Oracle 8i

- PL/SQL and programming

HP training and education, Rockville, MD February 2001

- Technical Introduction to Broad Vision (BV)

- Broad Vision (BV) Administration & Performance tuning

Certified Oracle Professional (OCP) June 2001

MCE Computer Consulting, Inc. Herndon, VA April 1996

- Database Administration (DBA), Oracle 7.3.2.3

- Database creation & Configuration - Performance tuning

- Visual Basic 3.0 - MS Access - Oracle 7 - SQL & PL/SQL

- Data Modeling - Cobol II / DBII - Oracle 8 - Developer 2000

Contact this candidate