Oracle Database Administrator

ALAIN-DELON FOUEFACK

Oracle Certified Associate (OCA 12c)

Killeen, Texas Tel: 240-***-****

Email: ********@*****.*** LinkedIn: https://www.linkedin.com/in/alain-delon-fouefack-4113721aa

PROFILE

Seven years of Oracle database administration and related experience with extensive knowledge and proficiency in Oracle 10g, 11g, 12c, 18c and 19c database design, administration in DEV, TEST and PROD environments. Experience in managing databases on Oracle platform OCI with exposure in others such as MySQL, DB2, SQLServer, etc... Excellent communication skills and a great team player with learning abilities. Work effectively under stressful conditions where speed and accuracy are necessary for mission critical databases. Possess great attention to detail and the ability to maximize system resources; skills which are beneficial in the following areas:

Backup and recovery using data pump and RMAN.

DB growth monitoring and capacity Planning.

Monitoring and Performance tuning using OEM 13c Cloud Control.

Oracle High Availability involving Oracle RAC and Data Guard.

Oracle Virtual Machine (OVM) for testing.

DB Creation, Configuration, Upgrade, Patching and Migration.

DB duplication and refreshes.

DB Creation, Configuration, Upgrade, Patching and Migration.

RDBMS data loads into Oracle tables using ETL tools.

Database integrity and advanced security implementations (TDE).

Automation and shell scripting.

Oracle Cloud Infrastructure (VM )

DB user’s management.

TECHNICAL SKILLS

Databases

Oracle 10G/11G/12C/18C/19C

Operating Systems:

Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

Solaris, OCI, AWS, AZURE

Tuning Tools:

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages:

SQL, PL/SQL, UNIX Shell Scripting, PERL.

Utilities:

RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE

The Home Depot, Dallas TX: October 2017 – Present

Oracle Database Administrator

Providing senior level database support skills in administration of production and non-production database environments.

Working in an environment comprising about 250 databases ranging from 500 GB to 40 TB in size.

Executing and troubleshooting SQL Queries as required.

Supporting activities including installations, configurations, upgrades, performance, tuning, backups, and disaster recovery (DR), regular maintenance jobs, encryption, and troubleshooting.

Extensive experience ensuring scalability and high availability using Real Application Clusters (RAC) under controlled failover scenarios.

Upgrading and Migrating oracle databases from on-premise infrastructure to Oracle cloud infrastructure (OCI)

Managing Oracle Cloud Database as a service DBaaS Infrastructure

Designed, Architected, and implemented projects to migrate services from on-premises servers to Oracle Cloud

Configuring and managing bare metal and virtual machine oracle database services on Oracle’s Cloud Infrastructure – OCI-Classic and OCI

Upgrading and Migrating oracle databases from on-premises infrastructure to Oracle cloud infrastructure (OCI)

Provisioning databases using Oracle Cloud API’s

Ensuring Maximum Availability Architecture by implementing redundancy across Oracle Cloud Availability Domains (AD’s)

Configuring database backups to Oracle’s Cloud Object Storage

Configured Databases on cloud platforms like OCI, AWS and AZURE

Administering databases running on Oracle 12c with current upgrades to 19c.

Experience in database performance tuning and Reporting

In collaboration with team, strategize, collaborate, participate, and troubleshoot in various technical meetings with strong verbal and written soft skills.

Configuring, monitoring, using current and historical metrics using Oracle OEM.

Extensive working knowledge of UNIX/LINUX and Shell Scripts, along with an automation mindset and practice.

Walmart, Austin TX: July 2015 – August 2017

Oracle Database Administrator

Experience providing high availability with Real Application Cluster (RAC).

Upgrading and Migrating oracle databases from on-premise infrastructure to Oracle cloud infrastructure (OCI).

Hands-on experience in implementing and managing heterogeneous database systems including 12c, 18c multitenant databases, RAC, ASM, Data Guard, and Oracle Cloud environments.

Managing Oracle Cloud Database as a service DBaaS Infrastructure

Designed, Architected, and implemented projects to migrate services from on-premises servers to Oracle Cloud.

Configuring and managing bare metal and virtual machine oracle database services on Oracle’s Cloud Infrastructure – OCI-Classic and OCI.

Upgrading and Migrating oracle databases from on-premises infrastructure to Oracle cloud infrastructure (OCI).

Provisioning databases using Oracle Cloud API’s.

Ensuring Maximum Availability Architecture by implementing redundancy across Oracle Cloud Availability Domains (AD’s).

Configuring database backups to Oracle’s Cloud Object Storage

Configured Databases on cloud platforms like OCI, AWS and AZURE

Administering databases running on Oracle 12c.

Hands-on experience in implementing database security strategies such as user management, identity access management (IAM), implementing advance security features like transparent data Encryption (TDE) and audit banner related features.

Database Refresh/cloning from production to development using RMAN and data pump as requested by development team.

Managing Oracle Cloud Database as a service OCI / DBaas Infrastructure

Oracle Databases 12c Administration on Premise and Oracle Cloud Service, such as database creation, managing storage structures, users, objects, privilege, security, backing up and recovery by RMAN

Performed day to day database administration tasks like database creation using DBCA as well as working on upgrade projects using DBUA (11g to 12c, 12c to 13c).

Database migration across platforms and on engineered systems like Oracle Database Appliance (ODA) using RMAN Duplicate, Data pump and Transportable Tablespaces.

Proficient with upgrading and patching of Oracle databases and Oracle applications.

Configuring, patching, administering, registering, and monitoring of agents using EM 12c / OEM 13c Cloud Control and Oracle Management Cloud (OMC) in a high availability environment.

Handling OEM alerts for database agents within the environment.

Managing/administrating Exalogic using OEM and managing Exalogic using emcli/GUI interfaces.

Proficient with upgrading and patching of Oracle databases.

System tuning, performance monitoring, and database maintenance.

Database performance improvement through design reviews, review explain plans, SQL code reviews, AWR analysis and SQL tuning using recommendations from SQL tuning advisor.

Develop procedures, packages, scripts, and tuning SQL & PL/SQL statements.

Migrating oracle databases from on-premise infrastructure to Oracle cloud infrastructure (OCI)

Provisioning databases using Oracle Cloud API’s.

Ensuring Maximum Availability Architecture by implementing redundancy across Oracle Cloud Availability Domains (AD’s).

Configuring database backups to Oracle’s Cloud Object Storage.

Capital One, Austin TX: March 2013 – May 2015

Oracle Database Administrator

End to end implementation of database upgrades from Oracle 11.2.0.3 to 11.2.0.4

Applied PSU Patches (10.2.0.3, 10.2.0.4) as a part of maintenance activity.

Performed frequent refreshing/cloning of production databases to development & testing databases using RMAN and DATAPUMP.

Managing and Implementing database change request.

External code review of database changes and processing database change build request

Database Query Performance Tuning

Frequently working with offshore application development team.

Work frequently with application developers to address and clarify data requirements to resolve technical and functional issues.

Diagnosing/Troubleshooting database issues on-day-to-day basis.

Participating in performance management & Team Development activities

24/7 on call support for production and lower environments to ensure maximum uptime and high availability

Drive Knowledge Transition (KT) with team members and other stake holders including mentoring junior team members.

EDUCATION

Oracle Certified Associate (OCA 12c)

University of Dschang, CAMEROON Bachelor’s in Operational Marketing

References available upon request

Contact this candidate