Resume

Sign in

Oracle Manager

Location:
Silver Spring, Maryland, United States
Posted:
April 02, 2019

Contact this candidate

Resume:

Oracle Database Administrator

Professional

ac8zgh@r.postjobfree.com

213-***-****

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

__ _

PPPRR

ROOOF

FFIIIL

LLEEE

Professional Oracle DBA with over 6 years of diligent experience. I have supported the complete life cycle of the SDLC. I have worked on Oracle 10g, 11g and 12c versions. I have done database administration duties including production support, installation and configuration, database security, upgrades, patch management, database migration, backup and recovery, performance tuning, database cloning, golden gate, data guard, RAC, and security management. I am always ready to face new challenges, open to learn and contribute when I have the opportunity.

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

__ _

SSSKK

KIIIL

LLLLLS

SS

Proficient with Database Cloning, Migration, and Patching of Oracle Databases. Installation, Configuration & Troubleshooting Golden Gate Downstream Mining and Integrated components for Active-Passive and Active-Active replication setups in both windows/Linux environments.

Install, configure, and upgrade MS SQL and Oracle. Install, configure and upgrade to Oracle 12c; consolidate multiple databases into multi-tenant database containers; evaluate and implement latest database technology and new Oracle 12c features.

Experience as 24x7 productions DBA as well as the application (development) database administrator.

Managing database security & Creating and assigning appropriate roles and privileges to users depending on the user activity.

Configured Golden Gate High Availability using Oracle DBFS and Active DataGuard. Expertise in maintaining Database Security using auditing. Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.

Experience in doing upgrades including maintenance & monitoring implementation. MARLYSE K. FOTSO

2

Planned and implemented high availability solutions such as Real Application Cluster

(RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems. Highly Experienced in Hot/Cold Backup, Recovery & Cloning of databases using RMAN. Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters. Experience in database patching, cloning, upgrade, migration & maintaining standby db server (DR).

Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram, DFD)

Expertise in all the phases of Software Development Life Cycle (SDLC). Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch).

Experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

.

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

__ _

EEED

DDUUU

CCCA

AATTT

IIIO

OONNN

Bachelor in Information Technology

CompTIA A+, CompTIA N+

Fluent in English and French

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

_

__ _

WWWO

OORRR

KKK

EEE

XXXP

PPEEE

RRRI

IIEEE

NNNC

CCEEE

Marriott Vacations Worldwide - Lakeland, FL

Mar 2017 – Present

Database Administrator

Responsibilities:

Providing database administrative support 24x7 on call support for production, development oracle 12c/11g databases on Red Hat Linux 5.0. Experience with large databases (1.5 Tb) for OLTP and OLAP applications. Administration and supporting of Oracle RAC 11g/12c Databases ranging from 100GB to

Oracle Certified Professional (OCP)

Oracle certified Administrator (OCA)

Oracle SQL Developer

Tester Quality Assurance

MARLYSE K. FOTSO

3

60TB.

Installed, Configured & Monitored Golden Gate components for unidirectional and bidirectional replications and maintain data synchronization. Refreshing development/test database from production using Export/Import & RMAN backups.

Managing database security & Creating and assigning appropriate roles and privileges to users depending on the user activity.

Installed and configured Oracle (11g R2 and 12c) databases on Linux 5, HP-Unix 11.X. Migrated the database from existing Oracle 10g to Oracle 11g and Upgrades of database

(from 10.2.0.3 to 11.2.0.2 ans 12.1.0.2)

Installation, Configuration and Maintenance of Oracle 11g/10g RAC with ASM and single instance database and Administrated Real Application Cluster (RAC) databases. Applied Critical Patch Updates and Patch Set Update (CPU/PSU) on various platforms using Universal Installer and OPatch Utility.

Monitoring and troubleshooting the gaps between source and target databases configured with goldengate.

Successfully upgraded the databases from 11g to non CDB 12c. Successfully migrated 12c Non CDB databases to pluggable databases. Created Oracle Wallets and implemented Tablespace level TDE security. Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces Implemented Disaster Recovery database 10g/11gData Guard on physical standby database in maximum performance mode using LGWR ASYNC mode. Performed database backups with RMAN incremental and cumulative backups by registering 10g/11g/12c databases in recovery catalog. Performed complete and incomplete database recovery, data file and table space point in time (TSPITR) recoveries using RMAN and user managed backups. Performed database tuning using Explain plan, Stats Pack, TKPROF, SQL tuning advisor, SQL access advisor, SQL planned management tools and AWR (automatic workload repository), ADDM (automatic database diagnostic monitor) and ASH reports and performed database tuning based on the recommendations by ADDM reports. Expertise in storage management by managing space, table spaces, segments and extents, Rollback segments and data dictionary.

Designed Logical and physical database for business transaction functionality. Created procedures and functions using PL/SQL.

Walgreen Company - Deerfield, IL

Mar 2014 – Feb 2017

Oracle Production Support Database Administrator

Responsibilities:

Successfully installed and configured Oracle 11.1.0.7, Oracle 12.1.0.1 databases on AIX platforms.

MARLYSE K. FOTSO

4

Monitored different databases and application servers using Oracle Enterprise Manager

(OEM) 10g Grid Control.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 12c, 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform. Involved in converting a single instance database to Oracle 11g, 10g RAC databases. Installed ASM environment and migrated databases from NON-ASM to ASM. Used TOAD for database management.

Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Configuring Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.

Developed RMAN Cold Backup Script to take backups automatically every week for about 200 databases vary in size from 200GB to 2TB and automated the process through crontab.

Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables. Database refreshes using expdp, impdp, RMAN Duplicate and cloning. Made optimal use of Oracle Support in resolving the SRs. 24 X 7 Production & Development database support and administration. Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Documented the Standard Processes for peers to follow. Applying upgrade patch, maintenance and interim (opatch) patches on all the databases. Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Hughes Network Systems, MD Jan 2013 – Feb 2014

Oracle Database PL/SQL Developer

Performed SQL and PL/SQL tuning,

Analyzing and resolving database system production problems. Analyzing user requirements and statistics and participating in database design and performance evaluation reviews.

Advising systems engineers on database coding issues. Created procedures and functions using PL/SQL.



Contact this candidate