SUMMARY

• Accomplished, analytical Senior Oracle DBA. Specializing in the implementation of high availability systems with DataGuard, RMAN, RAC and GoldenGate.
• Hands on Lead for Confidential ’s Disaster Recovery Test.

TECHNICAL SKILLS:

Oracle Products: Oracle 12c, Oracle 11g, Oracle RAC, Oracle 10g, Oracle 9i, Oracl8i, PeopleSoft, SAP/R3, Oracle 9i Application Server, 9i IFS, Data Warehouse Design, Oracle DataGuard, Recovery Manager, SQL* Loader, Export and Import Utilities, Oracle Enterprise Manager, Resource Manager, Oracle Spatial, Case Tools Oracle Design, Power Designer, Oracle Applications 11i, 11.5.7, 11.5.8, 12.0.4

Operating Systems: Sun Solaris, HP - UX, Sequent DYINX PTX, AIX, Veritas Cluster Server, Linux Red Hat, Red Hat Advanced Server V2.1, Windows 98, Windows NT .

Languages: PL/SQL, UNIX Shell Scripting, RMAN Scripting .

Databases: Oracle DBA, Oracle 10G, Oracle 9i, Oracle 8i

Hardware: Sun 5500/E6500/E220/E450, Sequent NUMA-Q 2000, SunFire V880, HP 9000 rp-8400 .

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA/Architect

Responsibilities:

• Migrate databases from OEM12c to 13c
• Troubleshoot Dataguard Environment issues
• Upgrade 11.2.0.database to 12.1.0.2 and apply PSU Patch.
• Build and Patch RAC Clusters on Solaris and Linux
• Install and configure GoldenGate
• Active Dataguard Build and support.
• RMAN Duplication for test data refresh
• Apply PSU Patches to DataGuard Environment.
• Production Support.

Environment: Oracle, Linux, HP, Solaris and Windows

Confidential

Senior Oracle DBA

Responsibilities:

• Upgrading RAC HP-AIX and Linux Clusters from 11.2.0.4 to 12.1.0.2
• Designing Disaster Recovery Test.
• GoldenGate Support Oracle.
• Active Dataguard Build and support
• RMAN Duplication of databases to remote servers.
• Data Guard build and support.
• Production Support.

Environment: Oracle, AIX, Linux, and Windows

Confidential, Troy, MI

Senior Database Administrator

Responsibilities:

• 12c upgrade: Migration of 11.2.0.3 RAC to 12c 12.1.0.1 RAC
• Migration of MySQL to Oracle data warehouse via GlodenGate.
• Installation, configuration and administration of RAC Clusters on Oracle 11.2.0.4 and RHEL 6. 32 CPU Linux servers.
• Design and Creation of Data Guard Environment using Active Duplication for Disaster Recovery.
• Team lead for failover recovery testing.
• Configuration, design and implementation of RMAN Backups and restores using NetBackup.
• Performed database tuning and monitoring using ORACLE AWR, ADDM.
• Database refresh from production to development, test and QA using Oracle Datapump & RMAN
• Infrastructure Monitoring, system maintenance, proactive monitoring using Nagios
• Data warehouse: Research, Loading data from multiple environments: DB2, MySQL and NoSQL, using Integrated DRDA and Oracle (ORACLE GATEWAY) or Oracle GoldenGate
• FGAC (Data Masking)
• Configure OEM Plugin for MySQL.
• Backup and restore of MySQL Databases.

Environment: Oracle (11.1.0.2- 11.2.0.4 ), RAC, Red Hat Linux, DB2, MySQL, Goldengate

Confidential, Southfield, MI

Oracle DBA

Responsibilities:

• Oracle Golden Gate support version 12.1, design and document process to populate Oracle Data warehouse from MySQL to Oracle.
• Migration of MySQL to Oracle data warehouse via GlodenGate
• FGAC (Data Masking)
• Patching OEM Grid Infrastructure and upgrading clusterware.
• Security Setup Fine Grain Auditing
• Data Guard Support.
• Installation and configuration of OBIEE 11.1.1.6 on RHEL 6.
• Interface with Oracle Corporation for technical support.
• As part of a team provide 7x24 technical support.
• Configuration of RMAN Backups and restoring to different servers.
• Performed database tuning and monitoring.
• Preformed system maintenance, proactive monitoring, security, and research.
• Configure OEM Plugin for MySQL.
• Backup and restore of MySQL Databases

Environment: Oracle (10-11.2), RAC, and Red Hat Linux

Confidential, Okemos, Ml

Senior Oracle DBA

Responsibilities:

• Oracle out of place upgrades from 11.2.0.1 to 11.2.0.3 with PSU Application.
• Dataguard: Snapshot database for disaster recovery, oracle lead for disaster recovery test.
• Flashback Database and Flashback Table Procedures for data loads and database upgrades using guaranteed restore points.
• Patching OEM Grid Infrastructure and upgrading clusterware.
• Data Guard Support.
• Data migration using transportable tablespaces
• Utilized performance tuning for Oracle Real Application Clusters (RAC).
• Configuration of RMAN Backups and restoring to different servers.
• FGAC (Data Masking)
• Performed database tuning and monitoring; involving I/O, memory tuning, and application tuning.
• Managed table partitions, large data sets, and provided AWR Reports
• DIACAP and production support
• Preformed system maintenance, proactive monitoring, security, and research.
• MySQL user maintenance.
• MySQL Backup and restore of databases.
• Configure OEM Plugin for MySQL.

Environment: Oracle (10-11.2), RAC, HP-UX 11.3.6, Windows, Linux

Confidential

Senior Oracle DBA

Responsibilities:

• Upgrading RAC HP-AIX Four Node Cluster from 10.2.0.2 to 11.2.0.1.
• Patching Grid Environment.
• Streams Support.
• RMAN Duplication of databases to remote servers.
• Production Support.

Environment: Oracle, AIX, Linux, and Windows

Confidential

Oracle DBA

Responsibilities:

• Planning implementation and upgrade of Oracle 11.1.5.7 to r12.1.2
• Cloning Apps 11.1.5.7
• Cloning production databases to test servers using RMAN.
• Planned implementation of Data Guard.

Environment: Oracle, Linux, Windows

Confidential

Oracle /Peoplesoft DBA

Responsibilities:

• Planning implementation and upgrade of Oracle 9.2.0.4 and 9.2.0.8 to 11.1.0.7.6 on SUN M5000.
• Configured Grid Control, 10.2.0.5 using 11.1.0.7.6 Database LTOM and OS Watcher
• Configured RMAN Backups
• FGAC (Data Masking)
• Backup and restore of MySQL Databases
• User creation and maintenance of MySQL databases
• Relational Design for datawarehoue and reports using Informatica.
• Oracle Streams configuration for data warehouse.
• Optimized ETL Jobs for Data Warehouse.
• Planned implementation of Data Guard

Environment: Oracle, Solaris Sparc, Peoplsoft, Windows

Confidential, Dearborn, MI

Senior IT Consultant

Responsibilities:

• Planning implementation and upgrade of Peoplesoft 8.5.0 on Oracle 10.2.0.3 RAC to Peoplesoft 9.1 on Oracle 11.2.0.2 RAC
• Moving SAP from filesystem to ASM.
• RMAN restore and recover 10g database against 11g instance.
• Datapump imports using a network link.
• Building Peoplesoft: PROD, DEMO and TEST Environments.
• Supporting SAP and Peoplesoft Databases.
• Utilized performance tuning for Oracle Real Application Clusters (RAC).

Environment: Oracle, Peoplesoft, SAP, ETL, PL / SQL, SQL, RAC, I / O

Confidential, Warren, Ml

Senior Oracle DBA

Responsibilities:

• Planned and implemented Disaster Recovery Solution for U.S. Navy Recruiting Applications. Navy.com, Navy-Reserve.com and Navy for Moms utilizing Oracle Data Guard.
• Upgraded servers from Oracle 9.2.0.4 to 10.2.0.4 and 11.1.0.7.
• Implemented Oracle advanced features such as Partition Table, Partition Index, and Function Based Indexes.
• Relational Design for datawarehoue and reports using Informatica.
• Architected and developed ETL Procedures using PL/SQL to load and update data from multiple sources.
• Optimized SQL queries and developer code.
• Utilized performance tuning for Oracle Real Application Clusters (RAC).
• Used constraints for validating and imposing rules on tables and partitions to split logical tables into number of physical separate locations.
• Performed database tuning and monitoring; involving I/O, memory tuning, and application tuning.
• Managed table partitions, large data sets, and provided manual reports
• Troubleshot backed up and recovered proactive database.
• FGAC (Data Masking)
• Preformed system maintenance, proactive monitoring, security, and research.

Environment: Oracle, ETL, PL / SQL, SQL, RAC, I / O

Confidential

Senior Oracle DBA

Responsibilities:

• Managed reorganization of Oracle Database Farm, Patching and upgrading Farm from Oracle 9.2.0.2 to 10.2.0.2.
• Implemented Oracle advanced features such as Partition Table, Partition Index, and Function Based Indexes.
• Developed and designed ETL Procedures using PL/SQL to load and update data from multiple sources.
• Optimized SQL queries and developer code
• Utilized performance tuning for Oracle Real Application Clusters (RAC).
• Managed table partitions, large data sets, and provided manual reports
• Implemented a four node 10g RAC Cluster on an HP Itanium64 Platform.
• Performed troubleshooting, backup and recovery, proactive database and system maintenance, proactive monitoring, security, research and development.
• Performed database tuning and monitoring; involving I/O, memory tuning, and application tuning.

Environment: Oracle, ETL, PL / SQL, SQL, RAC

Confidential

Senior Oracle DBA

Responsibilities:

• Created UNIX and PL/SQL Scripts.
• Performed Evidence Control Reporting on multiple servers originating from a central server and mail reports to the requestor, this was for Sarbanes Oxley (SOX-404).
• Upgraded Solaris and Linux Servers from Oracle 9.2.0.6 to 10.1.0.4 and 10.2.0.1.
• Managed table partitions, large data sets, and provided manual reports
• Performed extensive debugging and performance tuning of scripts, sessions and workflows including partitioning, memory tuning and cache management.

Environment: Oracle, UNIX, PL / SQL, SOX, Solaris, Linux, Tivoli

Confidential, Detroit, Ml

Sr. Oracle DBA

Responsibilities:

• Administered and designed General Motors Litigation Support Application: Size 3TB, on SUN E4800.
• Designed and developed ETL Procedures using PL/SQL to load and update data fror1 multiple sources.
• Created logical and physical database design model to support displaying multimedia information.
• Improved and Monitored database performance via tuning Sun Kernel Parameters, Oracle Partitioning, creating necessary indexes and caching small tables.
• Utilized performance tuning for Oracle Real Application Clusters (RAC).
• Installed and Configured 9IAS.
• Modified ERD and Functional Design for Litigation Application.
• Implemented and designed of Flashback Error Correction.
• Utilized Oracle Redefinition Utility for segment reorganization.
• Created schema objects (tables, views, indexes, triggers) source to target mapping, storag6 capacity planning and support of Veritas Cluster.

Environment: PL / SQL, ETL, Sun Kernel, RAC, Oracle, ERD, Flashback

Confidential

Lead DBA

Responsibilities:

• Directed the implementation of High-Availability Solutions, Veritas Clustering, EMC Timefinder, Standby Databases and Oracle 9i migration (monitoring, backup & recovery, and SQL Tuning).
• Performed installation, configuration, cloning and monitoring for Oracle 11i, Release 11.5.7.
• Designed and built Data Warehouse.
• Used Oracle 9i to analyze and set up H.R. application with multiple block sizes.
• Configured and set up the 9i Application Server and 9i IFS.
• Established Undo Management process using FlashBack Query and Logminer applications used Presumable Triggers for Batch Processing.
• Utilized Recovery Manager and Oracle Data Guard to stabilize Backup and Disaster Recovery.
• Used Three Node RAC Cluster on Red Hat Linux Advanced Server 2.1, Oracle 9.2.0.1
• Developed Statspack monitoring for 100 instances using a single Statspack Repository.
• Generated a checklist for Performance Tuning and monitoring RAC Cluster.
• Data Warehouse: ETL Strategy, Performance Tuning and Job Development.
• Loaded Data using Custom PL/SQL Programs (Table Functions, Merge and External Tables) EXP/IMP and SQL * LOADER.
• Posted processing of loaded data in Index Builds and Rebuilds.
• Reconciled During the Extract and Techniques for Archiving Data.

Environment: Oracle9i /11 i, Linux Server 2.1, Oracle 9.2.0.1, Statspack, EXP / IMP, SQL, Sun Solaris 8.2, EMC, HP 900 Confidential, Peoplesoft, IFS

Confidential, Okemos, Ml

Senior Principal Consultant

Responsibilities:

• Executed Database Tuning/Performance Monitoring and System-Level Tuning on the Sun and HP Clusters involving kernel parameter changes and monitoring.
• Implemented Backup, Recovery and Disaster Plan on Sun 4500 Cluster with Parallel Server running Oracle version 8.0.5.2.1 using Recovery Manager.
• Established upgrade plan to 8.1.5, release 2; reviewed with UNIX Administration staff.
• Utilized Explain Plan and Query Optimization employing Hints for Application Tuning/Performance Monitoring. Performed Capacity Planning using UNIX Shell (Korn) Scripting and PL/SQL coding.
• Performed mentoring for the Unemployment Agency's DBA staff.

Environment: Oracle 8.0.5.2.1, Recovery Manager, Oracle 8.1.5, UNIX, UNIX Shell, PL/ SQL Windows 95 / 2000, MS Office Suite, Sun 4500

Confidential, Detroit, Ml

Senior DBA

Responsibilities:

• Analyzed/documented major processes including associated steps and flows.
• Provided Logical and Physical Data Modeling.
• Designed ERD diagrams.
• Performed Database Tuning and Performance Monitoring, and System Tuning that modified Sun and Sequent Numa-Q parameters.
• Utilized Tkproff, Explain Plan and Enterprise Manager for Application Tuning.
• Developed Backup and Recovery Strategy implementation and testing scenarios utilizing triple mirroring, standby databases, Recovery Manager and Advanced Replication.

Environment: Oracle, Windows 95/2000, MS Office Suite, Sun Solaris.