Recovery Manager Dba

Name : Jean-Jules Fogang

Phone : 301-***-****

******@*****.***

Active US Secret Clearance

OBJECTIVE

Seeking a DBA position to utilize my proven DBA skills with a firm or agency that is dynamic and innovative where I can contribute to help achieve the organization’s projects, objectives and goals.

PROFESSIONAL EXPERIENCE

ALTA IT Services a System One Company October 2021 – Present Senior Oracle DBA DHA (SDD/JMLFDC)

• Use DBManager to:

- Create instances for applications connection

- Load exported data to databases

- Export databases

- Upgrade databases

- Upgrade releases

- Upgrade schemas

- Refresh development databases from production databases

• Check the newly released PSU patches in MOS (My Oracle Support) for databases on Windows and Linux servers and apply them

• Troubleshoot users access, RMAN, and other Oracle errors

• Write SOPs for ticket sorting

CACI International April 2021 – October 2021

Senior Oracle Cloud DBA

• Install/setup databases

• Patch/upgrade databases

• Manage AWS operations ranging from instances, buckets, network, firewalls, IAM access, and databases creation, and other Cloud-related features

• Managed database and OS accounts

• Refresh databases across environments

• Manage auditing in database and OS

• Research, develop and implement technologies that add value to the application

• Assist team in application deployment

• Assist team in database-related errors

• Scan OS and apply designated patches after downloading the latter Name: Jean Jules Fogang 2

SPN Solutions Inc. February 2020 – December 2020

Senior Oracle DBA DHA Contract (DOD)

• Managed twenty Oracle databases version 12c and 12c on three main DOD applications on AIX POWER 64-bit OS

• Managed eight Oracle databases version 19c on one main DOD application on AIX POWER 64-bit OS

• Upgraded databases from 12c to 19c

• Installed a full stack of EBS R12.6

• Restarted and shutdown services on Databases, cluster services, and EBS services

• Perform some EBS-related patches release 12.1.3 (Middle -Tier and database, using adop, adpatch, opatch, opatchauto…)

• Changed APPS, APPLSYS password using FNDCPASS

• Troubleshot the Concurrent Manager

• Troubleshot EBS components using the WebLogic console

• Monitored databases logs : alert logs, audit logs, listener logs, etc.

• Performed Databases and Grid CPU Quarterly patches

• Monitor ASM, tablespaces spaces throughout databases

• Monitor and troubleshoot databases backup using RMAN scripts

• Participated in scheduled maintenance for servers and applications.

• Wrote crontab scripts for various databases needs

• Monitored standby databases and recover them if need be

• Configure dand install RAC

• Supported various applications deployments

• Created scripts to clear archivelogs and audit logs

• Participated to unscheduled meetings for unscheduled maintenances

• Troubleshot network and cluster-related issues

• Performed backup using data pump (expdp and impdp) or RMAN

• Managed DOD STIGS review (POAMs) for the databases

• Participated in Tabletop exercises

• Managed data loads for applications

• Reclaim space from tablespaces

• Performed tuning of databases and queries

• Installed and troubleshot TDE (Transparent Data Encryption)

• Started/stopped and troubleshoot EOM

Name: Jean Jules Fogang 3

Deloitte Consulting March 2019 – February 2020

Application DBA DISA Contrat (DOD)

• Worked on a multi-year DOD project as Oracle EBS R12.2.6 DBA using STIGS

• Patched Database tier and application tier

• Started and stopped services (Databases and Applications Tiers)

• Worked on requests from functional teams and users including analyzers and logs purge

• Cloned production to lower environments

• Ran Analyzers for functional teams

• Cleaned logs as requested by stakeholders

NetImpact Strategies February 2019 – March 2019

Oracle DBA Department of Treasury

SEVATEC Inc. June 2016 – November 2018

Oracle DBA Department of Labor and Department of State Work on a multi-year high profile project at the DOL (Department of Labor) with the development team and DOS (Department of State) Federal Agencies where I support other teams (Applications, Development, Systems, Network, and Security) for applications rollout, monitoring and troubleshooting including:

• Completed configuration of databases backups using RMAN and wrote corresponding SOP

• Daily Check and troubleshoot databases backups

• Assisted Applications, development, systems team in a complete migration from Postgres to Oracle

• Configured data encryption using Oracle TDE with corresponding SOP writing

• Daily check of data guard and troubleshooting

• Re-create entire data guard using database duplication

• Configured Data Guard Broker with corresponding SOP

• Created schemas users with dependent objects

• Deployed quarterly databases patches deployments on Windows and Linux including

(RDBMS, OJVM, and Grid)

• Configured an entire OBIEE suite for business solution

• Integrated the use of JIRA, SHAREPOINT, REMEDY, SPLUNK, CSAM, DBPROTECT, CONFLUENCE, SERVICENOW, and TRELLO for interactive business solutions

• Managed SRs raised on MOS (My Oracle Support)

• Compliance Assurance, Remediation of security finding as results of POAMs Name: Jean Jules Fogang 4

• Create databases and schemas to accommodate applications’ needs

• Configured and added features and tools across databases testing cycle: Development, UAT, FT, Staging, and Production

• Used Eclipse, Gitlab, and Agile with developers as team’s collaboration framework (Two- week Sprint)

• Secure access to database objects using Oracle Database Vault

• Maintain wallets for highly secure databases for some of which I created triggers or rotated the password

• Assisted the developer to create and tune PL/SQL

• Managed a data warehouse with feeding OLTP databases including a SQL Server database that I monitored.

• Installed a SQL Server Database (Server Tool and SQL Server Management Studio) ORACLE USA Inc. January 2014 – May 2016

Database Engineer

• Installed and configure of databases including embedded applications

• Performed databases migrations and upgrades across platforms and versions 10g, 11g, 12c to maximize databases performance and reduce downtime

• Installed and managed RAC (Real Application Cluster)

• Duplicated and clone of databases

• Restored databases

• Installed wallets on databases using orapki

• Performed Oracle Cloud computing to facilitate and accelerate data growth

• Created and maintain Standby databases

• Managed databases across versions: 10g, 11g, 12c. Over 400 databases with thousands of embedded applications. Monitoring using applications like Solarwinds, Nagios, OEM Grid Control 12c.

• Performed fine grained security

• Performed TDE (Transparent Data Encryption), Data Redaction using Oracle 12c OEM

• Tuned and Troubleshoot diverse issues in databases

• Supported other teams (Application, Development, Systems, Network, SAN) during maintenances and normal course of activity. An average of 25 maintenances every week

• Rolled back database and database objects as needed

• Performed storage management in LINUX and Windows platforms

• Exported and import database objects as needed

• Created SOPs and upload them to the resource internal page

• Performed health check on databases

• Performed 24/7 on-call duty on a rolling basis. One full week every month

• Managed outages according to SLAs and general investigation procedures Gsmark LLC Government Contracts January 2013 – December 2013 Oracle DBA in charge of data security

Name: Jean Jules Fogang 5

• Created users accounts, appropriate privileges and profiles, granted users system and objects privileges

• Ensured that data and data access were secure

• Organized and ensured that data was securely backed up

• Created triggers and conducted fine-grained access control

• Upgraded, when need be, Oracle database using DBUA or Data Pump Export/Import

• Implemented migration strategies based on cost, time, and platforms requirements

• Performed advanced troubleshooting using trace files, alert log, and external links including Oracle Support

• Generated Reports and prepared memo to communicate progress and provide early alerts for major updates

• Used performance tuning to maintain and troubleshoot database problems

• Established a backup and recovery strategy using daily hot backups, RMAN and weekly full backup.

• Ensured that daily RMAN backups were completed and valid for restore and recovery

• Was part of overall capacity planning and redesign of databases

• Implemented and maintained Oracle dataguard: physical and logical databases for disaster recovery. Ensured that each standby database was always in Sync with production database by checking archivelogs and copying missing ones over to the standby database when required.

• Installed and configured Oracle Enterprise Manager (OEM) and Grid Control for Oracle 11g

Pinkerton Government Services September 2011-December 2012

Oracle DBA

• Established a backup and recovery strategy using daily hot backups, RMAN and weekly full backup.

• Allocated system storage and planning for future storage requirements for the database and related functions.

• Performed database migrations from Oracle versions 10g and 11g

• Created and configured Oracle databases using DBCA or manually by using scripts.

• Utilized Automatic Workload Repository (AWR) to generate snapshots of key performance data

• Utilized Automatic Database Diagnostic Monitor (ADDM) to reduce DB processing time by diagnosing key problems

• Created primary database storage structures (tablespaces) and primary objects (tables, views, indexes) after the application developers had designed applications

• Modified the database structure, as necessary, as directed by the application developers

• Controlled and monitored user access to databases

• Planned and executed backup and recovery activities (Control Files, Redo Logs, System Data Files, etc.) to ensure timely and complete recoverability. Maintained archived data on tape or other media as defined. Backed up and restored the database (On line and Complete) to assure restoral capability.

Name: Jean Jules Fogang 6

• Implemented and maintained Oracle physical and logical dataguard databases for disaster recovery

• Managed database security by creating and assigning appropriate roles and privileges to users depending on each user’s activity, using tools such as Oracle Advanced Security Option

• Designed, tested, deployed and documented Oracle RAC databases procedures SUMMARY OF QUALIFICATIONS

• Detailed and goal-oriented Oracle Database Administrator with experience in designing, implementing, and maintaining Oracle 10g, 11g, and 12C. Worked across a multitude of platforms WINDOWS Severs 2003/2008/2012, Red Hat Linux,

• Experienced in Oracle database creation, data migration using Import and Export utilities, Data Pump, RMAN and other server OS applications

• Great communication, presentation, and problem-solving skills. Work well at all levels of business.

TECHNICAL SKILLS AND CERTIFICATIONS

Databases: Oracle10g/11g and 12c.

Operating Systems: Windows Server /2000/2003/2008/2012, Linux (Centos, Red Hat). Oracle Tools: Oracle Enterprise Manager (OEM), OUI, Oracle Data Guard, DBCA, DBUA (Database Upgrade Assistant), ASMCA (Automatic Storage Management Configuration Assistant), Oracle Net Manager, SQL*Plus and Recovery Manager (RMAN), Data Pump. Experience with: Toad, SQL Developer

Certifications: OCA, Security + SY0-601

RELEVANT TRAINING

Oracle University

DBA University (Oracle Silver Partner)

RAC, ASM, and DATAGUARD in Oracle 12C

OTHERS

AWS Cloud, Oracle Cloud Infrastructure, Oracle EBS R12.2 EDUCATION

Oracle Database 11g: Administration I

Oracle Database 11g: Administration II

Oracle 11g: Data Guard Administration

Oracle 11g: Managing Oracle on Linux for DBAs

Name: Jean Jules Fogang 7

2008: Master’s Degree in NPO Management from Eastern University St Davids, PA

Contact this candidate