Oracle Database Administrator

MARCELLE MBA

ORACLE DATABASE ADMINISTRATOR

240-***-**** /// *.**********@*****.***

Executive Summary

Database Administrator with over six (6) years’ experience in: Installation, Implementing, Design, Development, Testing and Production support in all industry verticals. Extensive hands-on experience on working with 12C Grid Control and experienced in monitoring and managing of Oracle instances (10g /11g/12c, configuration) using Enterprise Manager Grid Control (OEM grid). Cloning, Security, Patching, Upgrades of Oracle version installed and configured on different platforms like Windows, Linux, Oracle Solaris, HP-UX. Provide 24x7 production support and development support.

Skill Summary

Six (6) years of experience administrating Oracle 11g Release 2, Over three (3) years working on 12C.

Two (2) years of experience with Enterprise Manager Cloud

Control 12c

Two (2) years of experience with Transparent Data Encryption (TDE),

One (1) years of experience supporting Oracle 11g database environment running on IBM AIX 7.1 (64-bit)

One (1) years of experience supporting Oracle 11g database environment running on IBM AIX 7.1 (64-bit)

Three (3) years of experience administering Oracle Goldengate 11g Release 2

One (1) year of experience on Oracle Goldengate 12c, where I did Install and configured a unidirectional Oracle Goldengate 11g. Setup the Oracle source and target replication setup and administration as well as documenting all the steps

Five (5) years of experience with deployment of Oracle database and application patches;

Less than one (1) year of experience with Storage Area Network (SAN) and file systems.

Experience in implementing and planning Backup and Recovery strategies using Recovery Manager (RMAN). Performed block recovery, datafiles and database recovery using RMAN and Point-in-Time Recovery option.

Developed Database Monitoring/Health Check Alert Scripts for Database Uptime/Downtime status, and sizing issues using Grid Control (OEM)

Two (2) years of Installation and configuration of Oracle 11g RAC using Clusterware and ASM.

Four (4) years Experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Database and Switchover/Switchback of Database in 11GR2

Experience in very large-scale database environment and mission critical large OLTP and OLAP systems.

Highly experienced in Cloning of Oracle databases from Multi-Node to Single-Node and Single Node to Multimode.

Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.

Five (5) years of Performance Tuning where I have used tools such as ADDM, SQL TUNING ADVISOR, AWR, ASH, SQL ACCESS ADVISOR

Developing Shell Scripts, Crontab and SQL Scripts to carry out routine checks on databases. Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.

A year of experience in creating, administering and maintaining MySQL, MongoDB, PostgreSQL.

April 2016 - Present

Oracle Dba, Teradyne inc – north reading, MA

Involved in Installing, Configuring and Administration of Oracle 10g/11g RAC on ASM. Worked on 2 node RAC databases from 200GB – 10 TB. Managing ASM Disks and Disk groups with ASM. Follow up on SRs for different issues (SCAN behavior, Node eviction, Failover etc.)

Assisted in the configuration and Worked on a Unidirectional Goldengate for real time data replication.

Responsible for configuring Dataguard physical and standby database setup for high availability and handling synchronization issues between primary and standby

I also applied both PSU and CPU patches using the Opatch utility patches on all the databases Upgraded databases from 11.1.0.7, 11.2.0.2 to 11.2.03 and to the new 12c.

Exposure to new 12c Features, Container and Pluggable Database, FAR-SYNC Instance, Cascade Redo Transport Destination, allowed usage of SYNC and NOAFFIRM to extend Data Guard Range, Moving online Data file, etc.

Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges. Implemented scripts to monitor and get information on free space, alert log errors. Provided maintenance of user accounts and Also used the OEM (12C) to monitor my Databases.

Oracle Instance tuning, and SQL tuning was done using, AWR, ASH, ADDM, SQLT, TKPROF, SQL Tuning Advisor, SQL Tuning Sets, SQL Baseline. Also resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.

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

Migration of database from one server to another server. As well as migrating from test and dev to prod. Created a stand by database by using RMAN Duplicate to reduce the downtime for the PROD database during the migration process. Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.

Refreshing Dev and Test instances with data from Production on a regular basis.

Maintained the data integrity and security using integrity constraints and database triggers. Also applied TDE (wallet)

February 2013 – March 2015

Oracle Database Administrator, Met Life Insurance-aurora,il

Good in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc. Performed space management, capacity planning, disaster recovery and overall maintenance of the databases. Managing databases from planning and testing stages through implementation and support.

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle database.

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs. Implemented Recovery Strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application Tuning.

Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances. Performed disk and disk group management in ASM while installing 11gR2 RAC. Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2).

Ensured that oracle database systems operate securely and efficiently. Enabled value-based auditing and Created Oracle Wallets and implemented Tablespace level TDE security.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “run Installer” and Perl based utility “Opatch”.

Provided 24X7 support for all the production and development databases.

Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2.

Technical Proficiencies:

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Tools and Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer.

RDBMS: Oracle 10g, 11g and 12c

Operating Systems: HP-UX 10.x, 11.x, 12c, Solaris RHEL 3.x, 4.x, 5.x. Enterprise Linux

ORACLE 12C CERTIFIED (OCA)

BACHELOR IN ANIMAL SCIENCE

SKILLS

I am a highly organized, proactive, creative and a motivated professional with extensive experience. I am a fast learner, good at disseminating information and documentations. I am a team player and culturally versed hence interacting professionally with others is easy. I am Bilingual in French and English.

Contact this candidate