We provide IT Staff Augmentation Services!

Senior Oracle Dba/architect Resume

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.

Hire Now