SUMMARY:

• Result oriented, self - driven, motivational professional with 12+ years of Oracle DBA Experience with Multi National companies.
• Experience in Supporting Oracle Database for Data warehouse systems and OLTP systems(Expertise in EXADATA, GoldenGate, RAC, ASM).
• Expertise in Data Analysis, Database Design, Installation, Testing, Migration, Upgrade, Administration, Tuning, Backup and Recovery.
• Expertise in managing Very big 22 TB size databases.
• Expertise in Databases from Oracle 10g to 12C.
• Snap clone, Data Guard expertise.
• RMAN cloning with Duplicate database.
• Experience in Oracle Database Encryption
• Experience with APEX.
• Experience in Oracle 12C CDB/PDB
• Oracle GoldenGate Configuration and performance tuning.
• Vey good knowledge on GoldenGate Veridata.
• Oracle OEM 12c and 13c configuration using EMCLI.
• Expertise in working with SAP Databases, BRTools, transformations, Upgrades.
• Experience on Performance Tuning & Capacity Planning pro-active and re-active actions for optimal performance complying with business SLA’s
• OEM Installation, configuration, and maintaining.
• Working Closely with Client requirement and maintain SLAs.
• Presenting Service Delivery Reviews to customer.
• Implementing Operational Excellence plan and team coordination and meeting deadlines.
• Expertise in all aspect of Systems Development and complete Project Life Cycle in Oracle Technologies with Software Development including requirements, Analysis, Design, Development and Documentation.
• Strong Communication, Presentation and Analytical Skills. Proven Skills as an efficient Team Lead in System Analysis, Designing, Development, Customization, Migrating and Documentation

TECHNICAL SKILLS:

ERP: Oracle Re12/11.5.10 cu2, SAP FICO

BI Tools: SAP BI4.1(BODS, Webi, IDT), TM1

Operating Systems: Windows, UNIX flavors( Solaris, AIX 4.3.3, Linux)

Languages: SQL, SQL*PLUS, PL/SQL, C

RDBMS: Oracle 12C- 7.1, SQL Server, Ms-Access

GUI Front end tools: Developer9i/6i Forms 9i/6i, Reports 9i/6i

Developer/2000 Forms 4.5, Reports 2.5, VB 5.0BRTools:

Other Software: SQL*Loader, Office2000, TOADDesigner6i, Discoverer 4i/3i, Clear Case, Data loader, Remedy, ServiceNow.

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Oracle DBA, GoldenGate (Oracle, SQL Server)

• Installation, Configured and suport uni-directional Oracle to Oracle replication using GoldenGate.
• Configured Backup configurations and setup OIP backup with netbackup team.
• Implementing Peformace and tuning of the queries proactiviely.
• Installed and Configured Heterogenous replication from Oracle to Sql Server.
• Installation and configuration of Oracle RAC 12C on 4 node.
• Cloning using Snap clone, testmaster.
• Refresh Database using Duplicate RMAN.
• Applying PSU patches every quarterly.
• Oracle Database refreshes from production.
• Tested RAT(Real Application Testing) using OEM, captured production workload and tested on QA.
• Working with Oracle team during patching on Exadata Servers.
• Working with Exadata ILOM Console.
• Performance tuning on Exadata.
• Patching on Exadata.
• Monitoring and collecting information using Exachk and Oswatcher.
• Upgraded databases to 11.2.0.4 to configure ZDLRA backup.
• Upgraded databases to Oracle 12C.
• Installed Oracle 12C Container/Pluggable DBs.
• Implemented Database Audit policys. snap clone using OEM and testmaster.
• Cloned Production database using OEM.
• Configured ZDLRA backups on OEM.
• SQL profile using OEM and coe script.
• Workload distribution and on-call rotation and attending all Sev 1 calls and guiding team
• Encrypted Oracle database with TDE, Wallets and key rotation with OKV(Oracle Key Vault)
• Setup Datagaurd for new prod environment, tested failover and switch over.
• Upgraded OEM 12c to OEM 13C.

Confidential, Texas

Oracle DBA and GoldenGate(Oracle, SQL Server,SAP Oracle Database)

• Refreshed the QA systems from production.
• Upgraded from Oracle 11g to 12c.
• Implemented Smart flash cache on Exadata.
• Implemented In-memory tables on Exadata on Oracle 12C.
• Installed and configured Data replication using Oracle GoldenGate 12C.
• Configured Oracle GoldenGate downstream Mining and integrated components for Active-Passive and Active-Active replication.
• Configured GoldenGate High Availability on 4 Node Oracle RAC.
• Installed and configured GoldenGate JAgent plugin for OEM.
• Installed Oracle RAC 12C on 2node cluster.
• Implemented pro-active monitoring scripts for all Databases.
• Implemented Operational Excellence plan.
• Worked on SAP tables, table re-org and rebuilding Indexes with BRTools.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Monitoring and Grid control using OEM
• Configured active datagaurd using OEM
• Recovered critical systems to point in time.
• Refresing database from production to QA.
• Worked on SnapClone using OEM.
• Rebuilding / Monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Planning, budgeting and forcasting and presenting in SDR(Service Delivery Review).

Confidential

Lead DBA(Oracle, SQL Server)

• Installation of Oracle 11.2.4(RAC) on Linux with ASM.
• Implemented the parallel load.
• Creating triggers in for APEX workspace.
• Creating, implementing and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Involved in the Design (Logical & Physical) of Databases.
• Involved in administering Oracle database running on UNIX and Windows Machines to support Oracle database.
• Adopted the best PARTIONING Technique & determined the best INDEX selection to improve the SQL Queries.
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
• Refreshed the QA systems from production.

Confidential

Lead Database Administrator

Environment: Oracle 10g/11g, SQL*Loader, PL/SQL, Unix.

• Tech Migration of servers from Dell servers to IBM servers for Panasonic.
• Confidential (Bank of Tokyo) E-business Interface project.
• Migration of production servers to Re 12.
• Troubleshoot performance issues caused with migration.
• Risk management, planning, scheduling.
• 2 node RAC Installation on Linux 5 servers.
• Database support to Dataware house systems.
• Apex Installation.
• Managing Instances, redo log files, Tablespaces, Datafiles, Indexes, Undo Segments, and Temporary segments
• Developed and implemented Materialized views for better performance of Cognos reports
• Partition Management for fact tables.
• Working with Business/ETL Groups/Data Modelers for design changes.

Confidential, CA

Support DBA & Support Team Lead(Techno-Functional)

Environment: Oracle 11.5.9/11.5.8, GL, AP, AR, Logistics, SQL*Loader, PL/SQL, Forms 6i, Reports 6i, Unix.

• As a Support DBA worked for Robbin Brothers, Zodiac, Econet., Hines Horticulture.
• Worked on Oracle E-business suite on 2 Node 10g RAC & 10g OEM - grid control, SAN servers, as well as multiple production databases on Linux Servers, job role is to administer the RAC databases, Upgrading RAC, Patching, cloning using Rapid clone attending to user development team requests & installations, Proactive monitoring of Database health, ASM storage Administration, Data guard setup & maintenance.
• Supporting 24x7 Oracle cluster environment Databases, Oracle E-business suite 11.5.10, Oracle Database Server 10g on Linux platform, which are controlled and monitored thru the 10g OEM grid control..
• Setup Disaster Recovery solution, using 10g data guard, both physical and logical standby on Linux Environment.
• Cloning, Patching, Concurrent Manager Admin, User Creation and assigning of responsibilities, using various AD Utilities for Application Maintenance, & day to day monitoring.
• Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance.
• Refreshed Oracle development and test environments with production data
• Provided DBA support to application developers, analysts and end users
• Design and implement backup methods and disaster recovery strategies and Responsible for Backup/Recovery using custom shell scripting and using RMAN Tool
• Worked with Oracle support to resolve production problems and apply patches
• Rotated production DBA on-call

Confidential, Schaumburg, IL

Technical Lead and Consultant

Environment: Oracle 11.5.9/11.5.8, PA, OTL, GL, AP, AR, Logistics, SQL*Loader, PL/SQL, Forms 6i, Reports 6i Windows 2000, Sun Solaris Shell Scripting.

Responsibilities:

• Developing High Level and Detail Design of Customer Interface.
• Developed Detail and High Level Design for the Extension of Total Time Accounting to normalize raw cost.
• Designed and Developed Airfare Interface.
• Assisted 5 off-shore team and mentored to meat the dead line.
• Many Interfaces developed specifically for the FEDERAL Government.
• Developed a new Form for Billing Extensions and Customized Correction forms( Inter Department, Web Money etc.,)

Confidential, Provo, UT

Techno consultant

Environment: Oracle 11.5.9/11.5.8, OM, GL, AP, AR, FA, Logistics, SQL*Loader, PL/SQL, Forms 6i, Reports 6i Windows 2000, Sun Solaris Shell Scripting.

Responsibilities:

• Created a custom report for check printing for Australian Users. Three checks will be there in A4 size paper. Checks have to print with signature. Modified prt file for the position of the signature.
• Created reports for the Cost of the Inventory.
• Imported legacy data into Assets through Mass Additions.
• Worked extensively on Auto lock Boxes.
• Created many queries for Discoverer.

Confidential, St. Pauls, MN

Technical Lead & Technical consultant

Environment: Oracle 11.5.9/11.5.8, OM, GL, AP, AR, PA, HR, OTL, Logistics, SQL*Loader, PL/SQL, TOAD, Forms 6i, Reports 6i, Discoverer, Windows 2000, Sun Solaris Shell Scripting.

Responsibilities:

• Worked on Order Import interface in OM.
• Developed an Invoice Interface to import Invoices from legacy system to AR module.
• Extensively worked on customer interface in Receivables.
• Implementation in Inventory module includes defining flex fields.
• Developed many new reports like Customer Order status Report, Backlog Detail Report, Backlog Summary Report, Backlog by Item (Line Level) Report, Cycle Status Report, Open Work Order Report, Sales Rep Commission Report, Customer Profiles Report, Shipping Reports, etc.
• Performed the whole Order Cycle, which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order. Customized a report ‘On time Delivery Analysis Report’ which gives detailed output of how many orders are shipped early, late and on time for each customer.
• Excellent understanding of AOL & Sys Admin, developed new reports, forms, functions, validation sets, request sets and concurrent programs.
• Created new reports Quotations received and Orders booked through TeleSales and integrated with Oracle Applications.
• Developed custom Report RMA, to execute for the required set of books.
• Developed a workflow package to run on Reminder on Thursday for all employees and warning on Monday morning to the employees who did not sent time sheets.

Confidential

Techno-Functional Consultant

Environment: Oracle Applications 10.7/11.0.5 OM, INV, AP, AR, GL, Oracle 8i, Forms 4.5, Reports 2.5, PL/SQL, Stored Procedures, SQL* Loader, SQL*Plus, Windows NT, UNIX, AOL

Responsibilities:

• Implementation of GL, AR, and FA.
• Involved in Reports customization for Oracle Applications 10.7 INV and PO modules.
• Developed Key mappings between External System and the Oracle HRMS System
• In-charge of Service Delivery Module (Transaction Processing, International Accounting and Call Center) from scratch to implementation
• System Study, Functional Design (CAD, DFD, ERD, KBE etc)
• Technical Design (Table structure, Database Design, Form Design, Reports Design Coding, Testing etc)
• Responsible for Server side programming like Stored Procedures and Triggers
• Developed form level Triggers, menus, alerts and screens
• Transferred data between the database and external files.
• Supported the development process by Creating, populating, and supporting development and test databases.