ELVIS NGAYI

*** *********** ***** *** **** CA ***10 240-***-****

ac7wjo@r.postjobfree.com

PROFILE

I am an Oracle DBA with over 8 years of experience in the Information Technology discipline. My strengths are in Requirements Gathering, Change Management, Oracle Security and various aspects of Database Administration including Backup & Recovery using RMAN, Disaster Recovery using Data Guard, Upgrades, Patching, Troubleshooting, ETL, Data Migration and Performance Tuning with Oracle version 11g & 12c.

WORK EXPERIENCE

Oracle Database Administrator - AVANT-GUARD GROUP LLC – 03/2017 – present

Write, execute and monitor shell scripts for backups using RMAN both for L0 & L1 backups and Data Pump for 24/7 database using crontab.

Apply Oracle Database Security quarterly patches

Enroll users and maintain system security by management of application users through control of their account status and privileges & roles.

Configure database security from vulnerabilities from incoming requests through IP based restrictions to specific application servers.

Modify the database structure, as necessary, from information given by application developers especially in tablespace management.

Control and monitor access to the database and do regular database audits if schemas, grants etc.

Review AWR Reports and ADDM to diagnose Performance Tuning related issues.

Perform data migration from one environment to another using Data Pump and Transportable Tablespaces for application developers.

Perform Hot & Cold Database Cloning using Data Pump.

Enable Password Management for all database logins from the default login settings by designing password policies

Review user grants to restrict access to certain Data Dictionary of the database.

Work with team to configure standby databases for data guard to ensure high availability, data protection & disaster recovery.

Configure servers and install Oracle 12c to use ASM storage. Database Administrator - BEST ALTER SOLUTIONS INC - 05/2015 – 02/2017

Did additional system configurations after database creation to suit client need such as appropriate FRA space, configure recoverability, automate startups and shutdowns etc

Assisted in ensuring that RMAN Backups completed.

Performed flashback of database objects for application developers. Elvis Ngayi 240-***-**** ac7wjo@r.postjobfree.com

Created and manage primary database storage structures (tablespaces) for application developers.

Installed and created Oracle 11g & 12c databases in

Assisted in the creation and management of database objects (tables, views, indexes) for application developers designing applications.

Participated in the upgrade from Oracle 11.2.0.3 to 12cR1.

Used SQL Loader for ETL loading of data into the Data Warehousing database

Supported the Development and Test efforts for the REMEDY Help Desk System

Assisted in the Configuration of Oracle Enterprise Manager 13c, both the Oracle Management Server and the Agents. Also Patching of the OMS & Agents.

Assisted in performing database upgrades using DBUA and Data Pump

Participated in RAC configuration for 4 node database for high availability. IT Systems Security Assessor - PROSCROW LLC - 05/2013 – 04/2015

Performed walkthrough and detailed testing on key controls such as access, change management and computer operations using the audit program.

Reviewed Security Impact Analysis (SIA) reports to make sure that appropriate testing was conducted.

Reviewed Plan of Action and Milestones (POA&M) or Corrective Action Plans

(CAP) to ensure that deficient security controls are remediated as planned

Prepared the Security Assessment Plan (SAP) and obtained an approval prior to testing.

Ensured that remediation actions are conducted on findings issued in the Security Assessment Report (SAR).

IT Risk Analyst - KIA MOTORS -10/2011 – 01/2013

Participated in the review of Service Management tools provided by Service Providers.

Reviewed Service Level Agreements between vendors and customers and also Underpinning Contracts associated.

Analyzed Continual Service Improvement initiatives

Performed review of Service Design Packages in accordance to ITIL best practices to evaluate Service Life Cycle Plans.

Systems Analyst - SILICON TECHNOLOGY SYSTEM - 09/2009 – 08/2011

Developed successful execution of SDLC for clients.

Examined and evaluated current systems

Liaised with users to track additional requirements and features

Collaborated with IT team and developers to produce new systems Help Desk Support - CAMEROON TELECOMMUNICATIONS - 01/2006 – 08/2009

Provided technical assistance and support for tickets and issues related for CAMTEL’s ADSL, Wireless Broadband, Fiber optics and VoIP services

Walked customers through problem-solving process.

Ran diagnostic programs to resolve problems.

Installed computer peripherals for users.

Elvis Ngayi 240-***-**** ac7wjo@r.postjobfree.com EDUCATION

Master in Business Administration, MBA

Arden University: in progress

Bachelor’s Degree (LL.B Law)

University of Buea : 2003

TRAININGS / CERTIFICATIONS:

Oracle OCA/OCP + DATA Security

Chaveran Institute of Technology

Security Control Assessment

AssuranceHill Consulting

Oracle Database 11g: SQL Fundamentals I

Oracle University

Scrum Master

International Scrum Institute

OTHER SKILLS:

NIST-Risk Management Framework – System Development Life Cycle

COBIT good-practice framework

SCRUM Framework.

Basic knowledge of HIPAA, FFIEC, SOC2, ISO & PCI standards

Fluent in French Language

Contact this candidate