Oracle Data

Gregory Azonaquette

Email: **********@*****.**.**

Phone: 240-***-**** Oracle Database Administrator Professional Summary

Over 6 years of experience in Oracle Database Administration with heterogeneous systems including Solaris, Linux and Windows. Support a variety of mission critical applications with Oracle 9i, 10g, 11g and 12c. Proven technical knowledge on Database maintenance, combined with outstanding leadership ability and creative problem solving skills. Possess excellent communication /documentation skills, self-motivated and good team player. Ability to learn new technologies and be productive.

6 Years of Oracle Database Administration experience in Design, Development, Testing and Production support in all industry including Telecom, Financial, Pharmaceutical, and Insurance Industries.

Extensive hands-on experience in Installations, configuration, Cloning, Security, Patching and Upgrades of Oracle database on different platforms such as Windows, Linux, RHEL, Oracle Solaris, IBM-AIX.

Providing 24x7 production support and development support.

Experience in Installation of 12c Grid Control on OEL 6.3 and experienced in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.

Experience in planning and implementing different backup and recovery strategies using Recovery Manager

(RMAN). Performed point-in-time recovery for data files and databases using RMAN

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)

Installation and configuration of Oracle 10g &11g RAC using Cluster ware and ASM.

Installed Oracle Golden Gate 11g, Implemented Uni-directional and Bi-directional replication.

Strong experience in RMAN, fail-over/fail-back/switch-over of stand by databases.

Experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Databases and Switchover/Switchback of Database in 10GR2 /11GR2 RAC

Experience in multi-node and RAC environments including configuration of PCP.

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

Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.

Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multimode

Enabling Load Balancing in a Multi-Tier Architecture

Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology.

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

Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.

Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.

Gregory Azonaquette 2

Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM and command line.

Developing shell scripts and SQL scripts to carry out routine checks on databases.

Implemented proactive monitoring scripts for production databases.

Troubleshooting for slow performing SQL by enabling Database tracing including session specific tracing. Performed SQL Tuning using Explain Plan.

Utilized SQL* Loader to migrate or load data to Oracle.

Experience in using SQL, PL/ SQL procedures, functions, triggers and packages.

Experience in SQL tuning using Explain Plans and Hints, optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.

Installed patches using Opatch utility and expertise in applying Oracle PSU and CPU patches.

Multiple upgrades of Sun Solaris and Linux servers from 9i to 10g, 10g to 11g and 11g to 12c.

Experience with Oracle Support Process for Technical requests using Oracle Metalink and other support procedures.

Education

Oracle Certified Associate. (OCA)

LLM degree in International Law, European University of Viadrina Frankfurt (Oder), Germany.

B.Sc. Political Science.

Technical Skills

Database Oracle 10g, 11g, 12c

Operating Systems Windows NT /2000/XP, RHEL (RedHat Linux), UNIX, Solaris Database languages &

Tools

TOAD, OEM,Pl/SQL Developer, SQL*PLUS, SQL* LOADER, VBA, JAVA, SQL, SQL*Loader, Database Links Utilities, RMAN, OAM, EXP, IMP, expdp, impdp, SQL*Loader,

EMC, Veritas NetBackup

Gregory Azonaquette 3

Experience

Abercrombie & Fitch - Columbus, OH March 2014 – Present Oracle DBA

Responsibilities:

Involved in Installing, Configuring and Administration of Oracle 10g/11g RAC on ASM.

Upgraded databases from 11.1.0.7, 11.2.0.2 to 11.2.03.

Worked on 2 node and 4 node RAC databases from 200GB - 16TB

Installation of agent 11g and OEM Grid control 11g.

Proficient in writing UNIX Shell scripts to automate business process and daily backups.

Implemented scripts to monitor and get information on free space, alert log errors

Provided maintenance of user accounts, privileges, profiles and roles

Involved in capacity and resource planning.

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.

Sanitize behavior of SCAN.

Experience using 11g and 12c GoldenGate, including upgrading, setup and support in QA and production ODS.

Ensured that ODS was always in sync with sources by using custom scripts, EM12c monitoring, and GoldenGate director notifications.

Oracle Instance tuning and SQL tuning was done using OEM GC, AWR, ASH, ADDM, TKPROF, SQL Tuning Advisor, SQL Tuning Sets.

Perform failover failback testing.

Follow up on SRs for different issues (SCAN behavior, Node eviction, Failover etc. )

Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.

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

Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.

Migration of database from one server to another server.

Used Secure SCP & FTP extensively for the File transfers from machines to remote server.

Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.

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

Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.

Done migration of non ASM database to ASM database.

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

Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).

Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.

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).

Worked closely with the Oracle developers for better performance of Applications in writing the Packages, Triggers and Indexes on the tables.

.

Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Gregory Azonaquette 4

Admiral Insurance Company - Austin, TX Jun 2011 – March 2014 Oracle DBA

Responsibilities:

Work involved overall Maintenance of Oracle Database, Backup, Recovery and other database related activities.

Defined backup procedures using daily hot backups and weekly cold backup.

Ensuring proper online and offline backup. Periodical reading and validating of backups taken.

Used import/export utilities for cloning/migration of small sized databases and Datapump

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

Used import/export utilities for cloning/migration of small size databases and Datapump import/export to move data between 9i and 10g/11g environments.

Database performance monitoring and tuning using various tools like ADDM, AWR, ASH, Explain Plan and Statspack reports.

Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.

General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed.

Database Growth and Space management, capacity planning; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.

Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.

Used TOAD, OEM, for database management.

Keeping the databases up to date with respect to latest PSU's patches.

Installed, configured and maintained Oracle 11g Real Application Cluster (RAC) / ASM on Redhat Enterprise Linux 5.x boxes.

Implemented 11g Data Guard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.

Performed Data Guard switchover/failover as per the requirements.

Worked on Golden Gate 12c Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing Golden Gate configuration.

Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.

Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.

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

Made optimal use of Oracle Support in resolving the SRs.

Provided off-hour on call support for database related issues. Environment: Oracle 10.2.0.1, Oracle 9i (9.2.0.8), RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN, HP-UX 11, Sun Solaris 10.0

Contact this candidate