marceline yatah

Oracle Database Administrator

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

ac7u50@r.postjobfree.com

Summary

Over 6 years IT experience in Oracle products both production and development environments. Hands on experience in Oracle 12c/11g/10g databases and have been involved in Installation, Configuration, Upgrades, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Reporting, database security, Performance Tuning, Unix Shell Scripting, RMAN, RAC, Golden Gate, Data Guard, OEM Grid Control. I possess full SDLC life cycle experience.

Professional Skills

Providing 24x7 production support of both development and production 12c/11g/10g databases on different Platforms

Installed and created databases for Testing, Development and Production using DBCA or database scripts.

Experienced in Setting up and administering both Oracle 10g and 11g RAC cluster ware and instances.

Involved in migrating non-RAC databases to RAC environment and also migrated databases from Non- ASM file system to ASM file system using RMAN.

Experience on high volume databases with sizes varying from 100GB to 5 TBs of data.

Experience in migration/consolidation of databases using oracle 12C Multitenant (oracle 12C container and Pluggable databases).

Experienced in setting up 11g Data Guard Physical/Logical standby, and hands on experience with Data Guard new features like Active Data Guard and Snap shot standby.

Configured Data Guard-broker (for failovers and switchovers) and involved in registering of databases in Data Guard broker using utility DGMGRL.

Experience in installation and configuration of Oracle Golden gate (GG) (both unidirectional and bidirectional).

Migration of database across and within the same platform using tools like transportable tablespaces and data pump.

Involved in migrating databases on AIX from 10g, and 11gR1 to 11gR2 on Linux.

Installed 12C database software and upgraded database from Oracle 11g to 12C

Proficient in regular Database Administration activities such as Upgrades, Migration, Patches, Cloning, Backups and Recovery, Performance Tuning, capacity planning, script development, and documentation.

Experience with SQL coding including DDL, DML and fine tuning those SQLs for better performance.

Creating and Managing Users, Roles and Privileges with required security implementations.

Tuned the database at various levels such as Memory Tuning, SQL Tuning and Database Contention, I/O Tuning, Capacity planning by using TKPROF, Explain Plan, SQL Trace, UTLSTAT, STATSPACK, AWR, ASH and ADDM.

Performed database refresh from production to test environment in both RAC and NON RAC environment using RMAN.

Exposed to writing, debugging and modifying shell scripts to automate jobs

Expert in encryption for databases using Wallet Manager.

Some exposure with AWS performing backups and recovery using S3 and checking my mount points like EC2.

Proficient in using 10g features Flash-Back Recovery, Data Pump, AWR, ASM, ASH, Recycle Bin.

Experience in schema management, Table space, data file and extent management, as well as user and privilege management

Created and modified Database objects like Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures and Packages.

Planned and implemented DR & high availability solutions using Oracle RAC and Standby Databases.

Developed and deployed scripts to provide updates from development to production

Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, VERITAS Net Backup.

Installation, configuration, Designing & Administration of ORACLE Database Vault

Responsible for RMAN backup and recovery scripting.

Expertise in loading data from flat files using external tables, SQL* Loader.

Knowledge of Data transfer between SQL Server and Oracle.

Supported Oracle 9i/10g/11g databases in different environments like HP-UNIX, Red Hat Linux, Sun Solaris and Windows.

Logical & Physical database design, Capacity Planning and benchmarking

Knowledge on Oracle Support processes for technical requests with Oracle support.

Good Programming Skills in SQL, PL/SQL, UNIX Shell Scripting.

Result oriented, self-motivated, Team player, ability to work independently.

Creating the Private and Public database link across the servers.

Flexible and excellent team player, ready to work in any shift.

Strong Problem analysis and resolution skills.

Excellent at documentation for future references.

Excellent troubleshooting skills and quick learner.

Authorized to work in United States for any employer.

Technical skills

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10, Windows 95/98/NT/2000

RDBMS: Oracle 10g, 11g and 12c

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

Work Experience

Pfizer - Groton, CT

Jan 2015 - Present

Oracle Database Administrator

Responsible for installing, configuring, and maintaining Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g as well as GoldenGate 12c software.

Configure GoldenGate Downstream Mining and Integrated components for Active-Passive and Active-Active replication and ensure GoldenGate High Availability using Oracle DBFS and Active Data Guard.

Table refreshes and schema refreshes using Datapump, expdp and impdp.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.2.0.1 to 11.2.0.3

Created a standby database using RMAN Duplicate to reduce the down time for the PROD database during the migration process.

Plan and schedule Backups and restoration strategy, taking Logical Backups (with Export/Import Data pump utilities).

Applied critical patch updates CPU released by oracle quarterly.

Developed scripts to proactively monitor the databases and alert the DBA on events such as running out of extents, disk space and actively involved in Shell Scripting for various CRON jobs to run.

Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.

Manage agents using emctl utility and creating incident rules in enterprise manager 12c

Implemented Dataguard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database

Configure administration groups and create template collections in OEM 12c 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).

Collaborate with Oracle developers to improve performance in Applications in writing the Packages, Triggers and Indexes on the tables.

Created database objects and managed the permission access on the objects with necessary security.

Perform SQL tuning and Database performance tuning based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance daily.

Creating Volume and Configured ACFS on ASM diskgroup, extensively worked on creating oracle Databases with ASM filesystem and good knowledge on SAN-based storage systems for oracle databases.

Trained team members and acted as DBA adviser for some major projects has resulted in 90% successful implementations. Some of the project has reduced downtime for databases by allowing switchover, fail over and recovering databases due to hardware or network failures.

Presented training on Data Guard for DBA team, saving team members many hours and improving efficiency in debugging related issues.

Work collaboratively with other teams including Project Managers, Developers, Sysadmins, network admins to ensure project success.

Documented lessons learned, database procedures for future references.

Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Acxiom - Little Rock, AR

Mar 2012 - Dec 2014

Oracle Production Support Database Administrator

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

Performed full & incremental backups (cumulative and differential) using RMAN and implemented recovery strategies.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Loading data from flat files to database using SQL*Loader, External Tables.

Implemented Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.

Created and scheduled jobs through OEM.

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

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Involved in the installation, configuration and extended support to Oracle 11g, 10g 2- Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Upgraded Database from Oracle 9i (9.2.0.7) to 10g (10.2.0.5) and to 11g (11.1.0.7) RAC database.

Installed ASM environment and migrated databases from NON-ASM to ASM.

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

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Education

-Bachelor Degree in Computer Science from the University of Buea, Cameroon.

Certification

-Oracle certified Associate(11g)

-Certified Scrum Master

Others

Visa Status: Green Card

Contact this candidate