Security Data

Narcisse Abangepoge

Location: Killeen, Texas Phone: +1 (254) – 720 – 2505

Sr. Oracle Database Administrator AWS Solution Architect

Email: ********.*.*****@*****.*** LinkedIn: https://www.linkedin.com/in/narcisse-abangepoge/

I have 6+ years of experience in Information Technology with a proven track record in performance and delivering over dozens of high-profile projects. Committed to fast product development and implementation while retaining emphasis on stability, security, fault tolerant, resilient and a scalable architecture.

I possess the skills to quickly adapt to any environment during any point of the project cycle and provide efficient response to company deadlines and system complications.

EXPERIENCE

06/2018 – PRESENT

SR ORACLE DBA, wELLS FARGO aUSTIN tEXAS

Designed, implemented and maintained all AWS infrastructure and services within a managed service environment.

Designed, deployed and monitored infrastructure in public clouds (AWS) using Infrastructure as Code (Terraform, Ansible).

Implemented AWS security best practices using services CloudTrail, Security Hub, GuardDuty, Inspector, IAM, KMS, WAF.

Network Management - VPC Peering/Transit gateway between VPCs (between AWS accounts).

Created or reviewed Terraform templates that automated the entire infrastructure for the application while following standards.

IAM role management (Creation of IAM Roles, IAM policies. Enabling the right roles to users, Assume role).

Implemented security best practices in AWS including multi factor authentication, access key rotation, encryption using KMS, firewalls- security groups, NACLs and S3 bucket policies.

Optimized cost through instances, selection and changing of EC2 instance types based on resource need, S3 storage classes and leveraging Auto scaling etc.

Worked extensively with AWS services such as EC2, S3, VPC, ELB, Auto scaling, Route 53, IAM, CloudTrail, Cloud Watch, SNS, API etc.

Creating/Managing DNS records on Amazon Route 53.

Setup/Managing VPC, Subnets; make connection between different zones; Blocking suspicious ip/subnet via ACL.

Support the business development lifecycle (Business Development, Capture, Solution Architect, Pricing and Proposal Development).

Hands on experience in AWS provisioning and good knowledge of AWS services like EC2, S3, ELB, VPC, Cloud Watch, IAM, SNS etc.

Planned, installed and upgraded multiple Oracle databases from 11.2.0.4 to 12.2.0. Implemented backup/recovery strategies and monitoring for all databases.

Added targets to OEM 13c, deployed agents on hosts and used OEM 13c to monitored/tuned Oracle databases, applied CPU quarterly patches using OEM 13c.

Planned and deployed PSU, CPU patches for standalone databases, Oracle RAC including rolling patch, in-place and out-place patch implementation.

Used OEM 13c to create patch plan, deployed CPU and PSU patches to test, dev and prod systems. Worked with Oracle support to resolved patch conflicts.

Implemented, tested backup strategy with RMAN. Cloned and recovered critical/non-critical datafiles with RMAN and performed point-in time recovery using RMAN.

Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments.

Worked on Multitenant Databases (Oracle 12c Container and pluggable databases). Cloned PDBs from PDB$SEED, unplug and plug PDBs from one CDB to other CBDs.

Performed Point-in time recovery on table using RMAN in Oracle 12c.

Tablespace resizing using OEM 13c and SQL queries to add more space to tablespace.

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.

Used Oracle 13c Enterprise manager to monitor and report the Database health for over 300+ databases

Some experience working with Microsoft SQL Server to create databases, creating and managing user’s accounts and Migration.

Handled High volume production databases around 80 TB size along with Physical standby databases

Performed Data file recovery for critical and non-critical data file corruption both logically and physically using Data pump and RMAN respectively.

Performed database backups/recovery using mongo-dump and mongo-restore utilities.

Migrated multiple MongoDB databases from old hardware to new hardware. Setup solid monitoring, backup strategy for all MongoDB databases.

Implemented MongoDB upgrade from MongoDB 3.2 to 3.4 and to 3.6 on RHEL 6.4 servers.

Planned, installed and configured SQL Server 2017 on RHEL 7.3. Migrated multiple databases from SQL Server 2012 to SQL Server 2017.

Created users per project request, implemented solid backup strategy and monitored databases using SSMS.

Setup MySQL 5.7 and migrated data from MySQL 5.6 to MySQL 5.7 server on both PROD and Test environments. Automated MySQL backup with custom Bash scripting using MySQL-dump utility.

02/2016 – 05/2018

DATABASE ADMINISTRATOR, usaa AUSTIN tEXAS

Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.

Refreshing Dev and Test instances with data from Production on a regular basis.

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

Installed Oracle 11g on Linux platform using ASM.

Creating Materialized views and Materialized View Logs for Data Replication.

Working with optimizer Hints and Explain Plan to enhance performance and to generate optimal solutions.

Worked on building and rolling out new 12c databases for TEST/DEV/QA environments.

Implemented oracle 12c active standby database for test database environment

Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK reports and AWR Reports. Provided recommendations using ADDM reports. Analyzed the trace files Using TKPROF utility.

Performed various tasks like Administering RAC using SRVCTL, adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.

Developed compliance reports and performed auditing at higher levels.

Extensively used Data pump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.

Monitoring and optimizing the performance of the database/application using OEM along with homespun scripts.

Capacity planning: Allocate system storage and plan future storage requirements.

Worked on SQL tuning using SQL Tuning Advisor, SQL Access Advisor, SQL Profiler and SQL Optimizer.

Installation and configuration of Oracle databases environments (10/11g), upgrades, patching for security vulnerabilities (CPU and PSU).

Prepared technical architecture proposals for enhancements and migrated an existing standalone database to RAC database.

Provided senior technical support to Developers, troubleshot performance issues and maintained high availability and security of databases.

Analyzed and tuned the Database to identify potential database bottlenecks such as response delay locking contention, wait event using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.

Collaborated, worked together with development and operations staff and resolved problems quickly and efficiently.

11/2014 – 02/2016

ORACLE DBA, usaa AUSTIN tEXAS

Maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, and 10g RAC servers for the purpose of disaster recovery procedures.

Installed, configured, deployed and monitored different databases and application servers using Oracle OEM 12c Grid Control.

Increased data security; implemented TDE and database auditing, created threshold on database metrics and set alert for a stronger security.

Maintained Active Data guard, creating both Logical and Physical Standby databases for DR solutions.

Worked on 24/7 environments, supported, monitored, managed and troubleshot database related issues over 300 oracle 10g, 11g and 12c databases with sizes from 300G to 29TB.

Implemented backup strategies used RMAN for incremental/full backup and Datapump to backup logical components.

Installed and used Oracle Golden Gate unidirectional to replicate data in real time for critical databases eliminating downtime to zero.

Implemented TDE, Data Redaction and database auditing to improved data integrity and security.

Troubleshot and resolved web application issues escalated from customer support and other departments with a 100% success rate.

Performed Data file recovery for critical and non-critical data file corruption both logically and physically using Data pump and RMAN respectively.

Worked with Oracle Data Pump (expdp and impdp) which provides high-speed, parallel, bulk data and metadata movement of Oracle database contents.

EDUCATION & CERTIFICATIONS

Master of Business Administration University of the Incarnate Word, San Antonio, TX August 2019

AWS Solution Architect (SAA-C01)

Oracle Certified Associate 12c (OCA 12c)

ORACLE AUTONOMOUS DATABASE CLOUD CERTIFICATION

AGILE LEADERSHIP PRINCIPLES

SKILLS

Written/verbal Communication

Oracle database 11g, 12c, 18c

Linux Operating Systems

AWS cloud

EC2, EFS, S3, RDS, IAM, CloudWatch

PL/SQL, SQL

Bash shell scripting

MySQL

PostgreSQL

Database Migration

Oracle RAC

Oracle data guard

ASM, NFS

Database Security

RMAN, Data Pump

Performance Tuning

AWS SCT & DMS

Load Balancer

Contact this candidate