We provide IT Staff Augmentation Services!

Oracle Goldengate Dba Consultant Resume

Redwood City, CA

SUMMARY

  • 10+ years of experience in Oracle database (8i/9i/10g/11g) administration, backup and recovery, performance tuning, monitoring, schema maintenance on a various environment like Sun Solaris, HP - UX,TRU 64, AIX, LINUX, Windows 2003, Windows Bit.
  • Extensive knowledge of Oracle GoldenGate OGG Replication tool and supported Production environment.
  • Installation and Configuration of Oracle 9i and 10g Real Application Clusters (RAC)
  • Experience working with SAN as storage for ASM file system using RAID 0+1 to 5 technologies.
  • Experience Working with Physical and Logical Standby Databases.
  • Experience in taking logical backups of data using oracle data pump utilities like exp, imp, expdp and impdp, to move Oracle data from one server to another server.
  • Experience setting up Backup strategy for Oracle DB using RMAN.
  • Experience in RMAN tape backups using net backup.
  • Migration of databases from Lower Version (8i) to Higher Version (9i, 10g and 11g).
  • Migration of Oracle databases from Sun Sparc to Solaris x86.
  • Experienced in Automatic workload repository (AWR) to collect memory statistics and automatic database diagnostic monitor (ADDM) to monitors and analyzes statistics and provides advisory services.
  • Involved in Performance tuning, database monitoring activities using STATSPACK with Perfstat User.
  • Monitoring of the queries with high response time and high disk reads per execution and tuning the same using Explain Plan, TKPROF, Auto trace of Multi Terabyte Database.
  • Applied CPU/PST Patches and Security Patches for production and development databases.
  • Experience in Tablespace management both locally (LMT) and dictionary managed tablespaces (DMT).
  • Experience in writing scripts Proactive Monitoring like monitoring the disk usage and the memory usage of the server and monitoring Tablespaces.
  • Used various packages extensively like DBMS JOB, UTL FILE, DBMS STATS, and DBMS SQL, DBMS REORG, DBMS SCHEDULER.
  • Extensively used tools like SQL*Loader, Toad, SQL developer, Oracle Enterprise Manager (OEM) using DBConsole.
  • Experience in creating Materialized Views specifically for Replication.
  • Root Cause analysis to find the problems at the database level.
  • Experience in working with Data Mart using SQL LOADER with direct or parallel option.
  • Attended Oracle Training provided by companies to learn more about Oracle New features.
  • Worked both as a development and Production Support DBA and having experience in full life cycle of database administration.

TECHNICAL SKILLS

Database Skills: Oracle 8i/9i/10g, 11g, Sql Server SQL, PL/SQL

Operating Systems: UNIX(Sun Solaris 8/9/10,Sparc - AIX4.3), Red Hat/Fedora Linux, HPUX-11.23,Tur64 Windows NT/2000/2003

Applications Tool: PL/SQL Developer, SQL *PLUS Oracle Enterprise Manager (OEM) Oracle Utilities (Import / Export, SQL*Loader, 10g Data Pump) Quest Toad 8.5, BMC

Protocols: FTP, SSH, Telnet, TCP/IP,VNC Viewer

Languages: UNIX Shell Scripting, SQL, PL/SQL, Perl

PROFESSIONAL EXPERIENCE

Confidential, Redwood City, CA

Oracle GoldenGate DBA Consultant

Responsibilities:

  • Architect and setup a database replication from the primary DB in SE to the new DB in SE to cater to the ETL and Elastic Search.
  • Validate the replicated data for its completeness and accuracy.
  • Implement Oracle Adapter for JMS to deliver RDBMS transactions to IBM MQ Series 7 messaging queue.
  • Setup the monitoring of the replication/replication lag and alerting.
  • When the PRIMARY DB switches/fails-over, the GG should resume taking the changes from the new primary. Document the changes needed for this to happen.
  • Training the in-house DBAs and documentation of the procedures/run-book.
  • Architect and setup a full schema/partial schema replication for other use-cases.

Confidential, San Mateo, CA

Sr. Oracle DBA

Responsibilities:

  • Managed 400+ production and 600+ non production oracle database instances for mission critical SAAS application in cloud based ERP, CRM and entire suite.
  • Designed and Developed 4-Way replication strategy using GoldenGate in order to implement high availability and DR. This allowed us to bring down DT in case of disaster from 20+ min to less than 5 min.
  • Worked on Oracle GG Binaries upgrade from 11.1 to 11.2 and downgrading back from 11.2.1.0.23 back to 11.2.1.0.5
  • Used GG in order to upgrade mission critical database from 10g to 11g with less than 2 min Downtime from database infrastructure team.
  • Acting as SME for Oracle GoldenGate changes in environment and supported OGG Bi-directional Replication for login database for all customers of Confidential Inc.
  • Created Wiki Page (KM) for Oracle GoldenGate support and various projects such as OGG binaries upgrade, setting up DB for failover.
  • Invited as keynote speaker at customer reference program for GoldenGate Implementation by Oracle at Headquarters.
  • Worked on Space Management projects using EXPDP/IMPDP, Index Rebuild on regular basis in order to avoid moving database to higher capacity box resulting in cost savings.
  • Identification of performance issue and coordinating with performance team to have them resolved.
  • Identified DB performance issues and supported Performance team to track and reach solution using EXPLAINPLAN, AWR & ASH. Worked on SQL Profiling to solve query performance issues.
  • Contributed to Oracle Database upgrade project from 10g to 11g for more than 400+ Production databases. Applying various patches such as CPU/PSU and Security patches.
  • Recovered from Data Loss situation for Confidential Customer using Internal end to end performance tracking database and using Oracle Redo Log mining.
  • Provided on-call support on a rotational basis.
  • Performed regular maintenances with very less downtime SLA.
  • Mentored New Hire/junior members of the team

Confidential, San Mateo, CA

Programmer Analyst

Responsibilities:

  • Managing 50+ oracle database instances for mission critical application in the home lending industry.
  • Implemented and Supported Oracle GoldenGate (11.1) One way Replication form multiple databases to MIS reporting tool.
  • Administration of Active-Active two nodes RAC 10.2.0.4 on Linux 64bit systems for over 60+ TB database. Growing 5TB+ YOY.
  • Involving in the database design based on reinforcement of MISMO standards for the existing system and developing design document and coordination activity.
  • Logical and physical database design, query optimization and tuning
  • Creation and maintenance of database objects such as tables, indexes, packages, and functions.
  • Creating PL/SQL scripts in order to perform various activities such as monitoring processes, gathering data, partitioning large table of size 250GB and above and other Core DBA task for an easy administration.
  • Documentation of systems and procedures; creation of process and policy as needed
  • Identification, evaluation and implementation of new and relevant database technologies in support of business needs
  • Provide on-call support on a rotational basis
  • Mentoring junior members of the team
  • Database Monitoring using EM Grid Control and other scripts to manage the SAN space.
  • Implemented 3 Node Oracle RAC 11g using ASM on Linux 64 Bit Operating System in development environment for Application testing.

Confidential, Mountain View, CA

Operations Lead - 1

Responsibilities:

  • Designing the Oracle backup strategy, scheduling and implementing database backup and restoration using Import/Export, hot backups, cold backups and data pump utilities.
  • Used Oracle utility RMAN to implement Oracle backup.
  • Involved in the plan for implementing Physical Data Guard as DR solution.
  • Upgrading Oracle Databases from 9i to 10g and 11g.
  • Extensively used export-import and Data Pump -- Expdp/ Impdp to take logical backup and Migrate databases at hardware level.
  • Performance Tuning and optimizing current and new applications utilizing SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuild of indexes and creation of views.
  • Trouble shooting performance issues using Explain Plan, TKPROF, STATSPACK, AWR and ADDM.
  • Decreasing Contention by appropriate Table space management and Sizing of objects.
  • Participated in data modeling review for designing object relational database.
  • Involved in applying oracle DST patches in 9i and 10g.
  • Generated working documentation for the DBA team use.
  • Optimizing database performance by analyzing database objects, generating statistics, creating indexes and partitions.
  • Set up of Oracle Enterprise Manager on Single Instance and Oracle 11g RAC for monitoring the Databases.

Confidential

Software Engineer

Responsibilities:

  • Supporting multiple Oracle customers across geography part of Oracle Database Networking Team - OCS.
  • Supporting issues related to Oracle Net Services for any customer configuration such as single node, multi-node RAC, Active Data guard, Streams and Oracle Internet Directory (OID).
  • Resolving Oracle Networking Performance issues for various dedicated or shared server connections.
  • Supporting oracle networking issues with 8i (8.1.7), 9i, 10g and 11g (11.1) versions of Oracle Customers.
  • Doing a POC (Proof Of Concept) / Creating Oracle Customer environment in order to reproduce customer issue in house.
  • Coordinating with Oracle Development to provide faster resolution to identified Bug.
  • Creating useful Metalink Notes in order to contribute to Oracle Support Knowledge Management every quarter and was awarded KM Champion Award of quarter as well.
  • Guiding new Hire and training them for OCS procedure for team.

Confidential

Assistant Systems Engineer

Responsibilities:

  • Configuration and installation 3 Node RAC on Oracle 10gR2 databases in dedicated server mode using ASM on Sun Solaris OS.
  • Configuring TAF, FAN and Load balancing in 10g RAC.
  • Configure Physical standby Dataguard using Oracle 10g for Disaster Recovery.
  • Install and configure Oracle 10g Grid for the monitoring of RAC databases.
  • Tested and implemented many backup and crash recovery scenarios on test environment (9i/10g), using RMAN.
  • Configure Incremental and full Backup on Oracle 10 and 11g Databases.
  • Duplicate and refresh Oracle DB from Production to QA and DEV boxes for testing purposes.
  • Migration of databases from Single Instance to Oracle 10g 3 Node RAC with 2.5TB -6 TB of database.
  • Performance tuning of Oracle Databases at initialization Parameter file to improve Database performance.
  • Identifying the poorly performing queries using Explain Plan, TKPROF, STATSPACK, AWR reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace & SQL Tuning Advisor.
  • Sql tuning of Multi Terabyte Databases for improving the application performance.
  • Experience working with different types of Partitioning (Range, List, Composite, Hash) methods.

Hire Now