We provide IT Staff Augmentation Services!

Oracle Goldengate/dba Consultant/etl Consultant Resume

SUMMARY:

  • Migrated over 40+ RAC/Non - Rac Oracle DBs (of sizes varying over 10 TBs) from version 11gR2 to 12c using RMAN backups/Export Dumps and Goldengate trail files.
  • During the entire migration time period, the proposed architecture solution had the capability to ROLLBACK to the source 11gR2 DB version.
  • Streamlined Oracle backup/recovery procedures and also provided oracle performance problems that surfaced after migration using Real Application Testing i.e. RAT and analysis of AWR reports.
  • Migration effort resulted in reduced green zone times for the client,since the client was close to 24*7 shop with DBs distributed across all the major regions of the world.
  • Working in developing high scalable distributed Systems, Asynchronous and event driven system using Apache Kafka.
  • Integrated Oracle Goldengate 12.3.1 with Kafka connect handler.
  • Also implemented CDR fixes during GG replication between Oracle source and/or target DBs.
  • Migrated over 30+ RAC/Non-Rac Oracle DBs from oracle version 11gR2 running on Linux Platforms to 12c DBs running on Exadata.
  • The inputs to the migration architecture were RMAN backups/Export Dumps/Goldengate Trail files.
  • Migration was needed to move the DBs to better HW at the storage level. During the entire period training was also done to resident Oracle DBAs and Goldengate Architects.
  • Analyze AWR performance data reports to troubleshoot slow DB performance issues.
  • Heavily uses DB partitioning to solve performance problems.
  • Migrated large oracle DBs using zero downtime Goldengate approach from Oracle 10gR2 to 12c RAC DBs.
  • The migration effort was done to better HW equipment using Red Hat OS. During my consulting period, performed day to day normal DBA activities that included installations of new Oracle DB versions, perform RMAN backups/recovery operations and maintain multiple Oracle active dataguard setups.
  • Maintained and managed multiple Oracle Streams enabled databases. Performed day to day typical Oracle DBA tasks that included Oracle Upgrades to 12c, develop scripts to perform backups and manage multiple oracle Dataguard setups.
  • Migrated their oracle 11gR2 RAC DBs to 12c RAC DBs. Added goldengate replication setups to their newly migrated DBs.

SKILLS:

Software: Oracle (7.X, 8i, 9i, 9iAS,10g and 11g), EMC's TimeFinder and SRDF, SQL Loader, Oracles RAC on UNIX/W2K servers, OEM tools, Oracle Names Server, RMAN, Oracle DWB, Legato SW, AWS cloud infrastructure, UNIX Shell/Perl/Awk, SQL Navigator, TOAD, Quest Central for Oracle, EMC’s Autoadvise, VERITAS VCS 4.0, IBM’S GPFS/HACMP, GoldenGate replication SW.

Operating Systems: HP-UX (OS version 11.0), NCR UNIX OS, SUN UNIX OS, AIX UNIX OS, Linux OS, Windows NT/2000 and Compaq Tru UNIX/DIGITAL UNIX.

Languages: UNIX C, SQL, Oracles PL/SQL, PRO*C, 4GL's, UNIX and VAX DCL Scripts, IBM Assembly, C, UNIX shell scripts, awk and Perl scripting.

Hardware: Sun Microsystems(workstations, midrange servers and E10K servers), HP 9000 Series, NCR UNIX systems(SMP/MPP architecture), Compaq's Tru UNIX, DGs and IBMs RISC machines, EMC/Hitachi storage subsystems, IBM 4341, Windows NT servers/clients, Oracle Exadata DB Machine X3-X.

EXPERIENCE:

Confidential

Oracle GoldenGate/DBA Consultant/ETL Consultant

Responsibilities:

  • Configure, design and implement Bi-Directional replication between 12c Pluggable Oracle DBs.
  • Perform core DBA tasks and train in house GoldenGate DBAs

Confidential

Oracle GoldenGate/DBA Consultant/ETL Consultant

Responsibilities:

  • Configure, design and implement Bi-Directional replication between multiple 11gR2 Oracle DBs.
  • Perform multiple DBA tasks and train in house GoldenGate DBAs
  • Implemented GG automatic Conflict Resolution and Detection i.e.CDR to trap and fix DML conflicts. Also implemented automatic CDR of GG version 12.3
  • Migrate multiple Oracle RAC/NON RAC DB setups into the AWS cloud infrastructure
  • Design and migrate Oracle Goldengate environments into AWS cloud infrastructure
  • Working towards via training to become to become AWS architect
  • Profiling data for quality, remediation of gaps and anomalies using DataStage and Information Analyzer
  • Leveraged on Information Analyzer work and translated all rules into DataStage code and implemented the entire DQ solution from development through to QA, Release and Production environments.
  • Experience in handling configuration and administration of databases like MySQL and NoSQL DBs like MongoDB.
  • Integrated goldengate trail files with Kafka Handler to implement a Kafka producer that writes serialized change capture data from multiple oracle tables to one topic.

Confidential

Oracle DBA/GoldenGate Consultant/ETL consultant

Responsibilities:

  • Configure, design and implement real time replication from between multiple 11gR2 RAC/NON RAC DBs
  • Continuously monitor and solve production DB performance problems using OEM 12c
  • Maintain physical standby DBs using active dataguard for RAC DBs using ASM
  • Provide guidance and train in house Oracle DBAs in the areas of REPLICATION and tuning
  • Installation, maintenance of Oracle DB machines and migration of DBs to Exadata using features such as smart scans and use of flash cache in exadata cell nodes. Also installed plug ins to OEM to monitor exadata environments
  • Migrated current DB to the Oracle DB Appliance’s pre-created optimized DB using GoldenGate and Transportable Tablespace features of Oracle
  • Installed and configured RAT and SPA to measure the DB performance prior to migrating production DB’s to Oracle DBs on Oracles DB Appliance’s
  • Experience in MongoDB installation, patching troubleshooting and backup and recovery core DBA operations
  • Limited experience on working with MongoDB Ops Manager
  • Performed Oracle upgrades from 11.* to 12c. Very familiar with in memory features of Oracles 12c
  • Part of team that successfully installed, validated and deployed Exadata X2-2, X3-2 and X4-2 quarter, half and full rack for various environments
  • Successfully utilized iLOMs for managing and troubleshooting storage cells and compute nodes
  • Familiar with Sharplex replication and converted the same to start using GG replication

Confidential

Oracle GoldenGate/DBA Consultant

Responsibilities:

  • Configure, design and implement 9i RAC to 10gR2 RAC Database migrations using near zero down time upgrade functionality of GoldenGate
  • Install and configure Oracle Veridata to resolve out-of-sync between data elements and generate reports for review
  • Continuously monitor and solve 9iRAC production DB performance problems using OEM and other tools of Oracle. Design and maintain physical standby DBs using active Dataguard for RAC DBs using ASM
  • Upgrade 10g OEM to 11g OEM, and monitor all production and UAT DBs via a single interface tool

Confidential

Oracle GoldenGate Consultant

Responsibilities:

  • Configuring, designing and implementing replication via GoldenGate between 11gR2 RAC DB to implement near zero downtime during application upgrades and during DB upgrade cycles.
  • Via Oracles GoldenGate web user interface initiated comparisons, review and resolve out-of-sync data.
  • Monitor DBs using grid control

Confidential

Oracle Streams Consultant

Responsibilities:

  • Manage, monitor and enhance bi-directional multiple streams environment on multiple AWS cloud computing Linux platforms.
  • Perform DBA related tasks such as backup and recovery, performance tuning and train in house DBAs on AWS cloud servers.

Confidential

Oracle GoldenGate Consultant

Responsibilities:

  • Configured, designed and implemented replication via GoldenGate between 10gR2 (RAC and/or NON RAC, Train in-house DBA in the usage of GoldenGate.
  • Upgrade and migrate Confidential 11.5.10.2 to R12.

Confidential

Oracle GoldenGate Consultant

Responsibilities:

  • Configuring, designing and implemented bi-directional replication between 4 Oracle 10gR2 DBs by replacing trigger based multi master replication of oracle.
  • Designed and implemented conflict detection and limited resolution in multiple GoldenGate DB implementations.
  • Build 11gR2 DBs using oracle best practices of having separate oracle homes for GI and for DB SW.
  • Design, develop, and review data models in conjunction with the application development teams, work with the development team on a continuous basis to implement best coding practices.
  • Maintain multiple 24*7 production DB’s and work with end users and developed user requirements, which was then converted into a logical model prior to physical implementation.
  • Training in house DBAs on DB performance and management of GoldenGate replication environments that were RAC enabled.
  • Heavy usage of OEM to monitor RAC and NON RAC DBs using ASM to park DB files

Confidential

Oracle Senior DBA/RAC Architect

Responsibilities:

  • Designed and architecture a DB migration from 10gR2 on Solaris OS to a 2 node RAC on Linux using Oracles GoldenGate with zero downtime
  • Also installed and configured a 7 node RAC of 10gR2 DBs on two different sites one in VA and the other in Texas. Enabled and managed replication of key via streams.
  • Designed and implemented HA features into the DB based on the HA business requirements. Heavy usage of dataguard to implement HA solutions for critical production DBs.
  • Provide APPS DBA support to maintain one of the ERP DB applications
  • Train in house DBAs to do DB performance and management of 10gR2 and 11g Oracle DBs.

Confidential

Oracle Senior DBA/RAC Architect

Responsibilities:

  • Installed and migrated multiple 2/3/6 node RAC implementations using ASM/OCFS2/Veritas VCS to a 10gR2/11gR1. Configured all production DB instances to have a DR setup using data guard on Linux.
  • Coordinated with the owners of business to develop new business views of data by normalizing the ER relationships between tables
  • For multiple DB applications enabled resource management, implement downstream replication and MVs, implemented RMAN backups, configured Oracle grid control to monitor all production DBs.
  • Extensive use of oracle wait (analysis)from AWR reports and use of DBA Hist tables to meet DB application performance SLAs
  • Develop Perl and shell scripts to implement DB proactive monitoring tasks
  • Optimized DB performance at the DB level, at the OS level, at the application level and also at the Hitachi/EMC disk subsystems.
  • Install, manage and configure Times Ten DB instances on multiple platforms.
  • Lead DBA, trained in-house DBAs & offshore DBAs to troubleshoot oracle installation, performance and migration issues. Ensure DBs are managed and implemented using JPMC standards
  • Designed Oracle DBMS solutions to many end users so that their applications can use advanced 11g and 10g features. Heavy usage of OEM to monitor oracle and NON oracle DBs.
  • Design and maintain standby DBs using active dataguard.
  • Build 11gR2 DBs using oracle best practices of having separate oracle homes for GI and for DB SW.
  • Designed and developed ADHOC PL/SQL procedures and triggers.
  • Installed and maintained multiple TimesTen instances within the Investment Bank division of JPMC
  • Worked with UNIX SAs and Network Admins to build HA solutions for IB division of JPMC using JPMC standards
  • Designed and developed standards within JPMC to build and configure DB systems across the globe

Confidential

Oracle Senior DBA/Architect

Responsibilities:

  • Installed and migrated a 6TB production DB (10gR1) from a 2 node RAC using ASM to a 10gR2, 6 node RAC using ASM and Linux OS.
  • Perform DBA functions that included performance tuning, backup and recovery, DB migrations, patching for test, development and production RAC and NON-RAC DB environments.

Confidential

Oracle Senior DBA/Architect

Responsibilities:

  • Installed, configured and supporting a 2 node RAC production/development environments using 10g on Sun Solaris and VERITAS VCS. Enabled TAF, Load Balancing and develop application code using PL/SQL. Performed user management, backups and configure test/production Sybase version 12 DB applications.
  • Provided user level support for both Oracle and Sybase DB applications on Sun UNIX platforms.
  • Installed Oracle and Sybase SW on multiple systems and extensively used DB Artisan to manage both Sybase and Oracle DB environments.
  • Design and develop shell scripts to perform every day DBA tasks proactively. Also analyze wait events via AWR and ASH reports to resolve DB application issues.
  • Implemented and supported HA solution using 9i/10g Oracle Data Guard Provided training to in-house DBA’s and perform daily DBA tasks that includes migrating 9i DBs to 10G.

Hire Now