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.