Manager Oracle

YUVARAJ GANAPATHY

Email : ac27fc@r.postjobfree.com

Mobile : 214-***-****

Authorized to work for any Employer in US

21+ years experience in Database & Applications Administration, Architecture, Performance Tuning, Production Support, DB Migration, DB Upgrades & Disaster Recovery Center Activities.

Expertise in Oracle Exadata X5, X4, MySQL 5.7, MongoDB 3.4, Sql Server 2012 & 2008.

Expertise on E-business Suite R12 & 11i, Retek MOM v13 & v14, SAP, Peoplesoft, Siebel, Banking, Telco Billing & Healthcare Systems Implementations and Administration Support.

Expertise in Banking, Retail, Healthcare, Telecom, IaaS, PaaS and SaaS Domains.

Certifications / Trainings / Workshops :

Oracle 11gR2 Database Administration certified Professional (OCP)

MySQL 5.1 Database Administration certified Professional

MongoDB v3.0 Database Administration Training

AWS (RDS & EC2) Architecture, Implementation, Administration & Support Training

SQL Server R2008 & R2012 Database Administration Training

SOX, PCI & HIPAA Audits, Six Sigma & ITIL Foundation Work shops

Skills Summary :

RDBMS & NoSQL Oracle 12c, 11g, Sybase, MySQL 5.x, MongoDB 3.x, Sql Server 2012 & 2008

Operating Systems Oracle Enterprise Linux (OEL), Redhat Linux, SUN OS, IBM-Aix, HP-ux, Windows

Utilities and Tools Exachk, Smart Scan, DCli, CellCli, Real Application Clusters (RAC), ASM, AWR, GoldenGate, ADDM, RMAN, Dataguard, Grid Control (OEM), MySQL Workbench, HAProxy, OpsManager, ReplicaSet, Sharding, Shareplex, Foglight, DB Vault,

TD Encryption, DB Wallet

Applications Oracle Applications R12.2, 11.5,x, AWS (RDS, EC2), SAP R/3 4.6c, PeopleSoft CRM, Siebel 8.0, Retek (RMS, SIM, RPM, Reim, RTM), ATG E-Commerce, CSG Telco Billing System, Puppet, Servicenow, JIRA, Github

Languages C, Pro*C, SQL*Plus, PL/SQL, T-SQL, Unix and Perl Scripting, JSON

Hardware Exadata X5, X4, X3, Vmware ESXi, Oracle VManager, SUN Servers, HP Servers, Intel Servers, Tivoli ADSM, EMC Storage, Veritas NetBackup

Major Project Accomplishments :

Oracle Exadata X5 & 12c Mulitenant Implementation & Support at Wells Fargo Bank, US

MySQL Percona v5.7 & MongoDB v3.2 Implementation & Support at AD Banker, US

Oracle Golden Gate 22 TB DB Migration & Upgrade Support at JP Morgan Chase Bank, US

Oracle Exadata X4, 11g RAC Implementation & Datacenter Consolidation at Scientific Games, US

Oracle 11g Upgrade & MongoDB Implemenation & Support at Select Comfort, US

Golden Gate & Oracle 10g RAC Implementation & EBS 11i Support at Siemens, US

Exadata X2-2 Implementation, Consoldiation & Migration at St Jude Medical, US

Oracle 10g RAC Implmentation and GoldenGate Implementation setup at Wal-mart, US

Oracle Infrastructure consoldation and Datacenter Migrations from Verizon to Hawaiian Telecom

Oracle and Sybase DBA Support transition from AIG US to India & Philipines Offshore Center.

Telecom Billing Application Production and Database Support Transition from Verizon US to India

Professional Experience :

Client: Wells Fargo Bank, Minneapolis, MN Jan 2017 – Till Date

Principal DBA Architect – Oracle Exadata/MySQL/MongoDB

Manage EXADATA X5, X4, AWS & Mission critical applications databases on 24*7, Setup of MySQL Multi-Master Replication, MongoDB Sharding & Replication.

Perform Oracle 12c Multi-tenant RAC, CRS, ASM, MySQL, MongoDB Installations, Disaster Recovery Center Setup, DataGuard Physical & Logical Standby database, Grid Control Setup, RMAN Backup & Recovery Strategies, Database & Applications Performance Tuning.

Handle EXADATA Patching, DB Upgrades & Migrations, SOX Compliance Audits, DB & Users Security Setup, Capacity Planning, On-Site & Off-shore DBA and Infrastructure teams on 24x7.

DBA Team peer review, Training, Budget, Time and SLA Management Processes reviews.

Co-ordinate with Infrastructure & PMO Teams, Change Control committee Reviews & Approvals, Applications users & Business Users for all deployments, Systems documentation control.

Report to Infrastructure Director about Daily & Weekly Status, Issues and Escalations.

Environment : EXADATA X5, X4, Oracle 12c, 11g, MySQL Percona V5.7, MongoDB V3.4, VMware ESXi, AWS, Linux, OEM 12c, Servicenow, JIRA, Github.

Client: AD Banker, Kansas City, MO Aug 2016 – Dec 2016

Senior DBA Architect – MySQL/MongoDB

Installation & Configuration of MySQL 5.7 (5 Nodes) Multi-master Cluster Setup on Linux system.

Installation & Configuration of HAProxy & Keepalived for High Availability and Load Balancers.

Upgrade & Migration of MySQL 5.5 to 5.6 and 5.6 to 5.7 versions, MySQL Cluster Testing strategy.

MySQL v5.7 & MongoDB v.3.2 Backup and Recovery strategies, Implementation & Documentation.

Installation & Configuration of MongoDB (3 Node) Cluster Setup on Linux, Sharding & Replication.

Environment : MySQL v5.7 Percona, MongoDB v3.2, Redhat Linux, MySQL Workbench, OPS Manager.

Client: JP. Morgan Chase Bank, Columbus, OH Dec 2015 – Jul 2016

Senior DBA Architect

Installation & Configuration of GoldenGate v12 on Oracle Enterprise Linux system.

Configuration of GG Downstream & Integrated Capture for Active-Passive & Active-Active replication.

Configuration of GoldenGate High Availability using Oracle DBFS and Active Dataguard.

Performed 22 TB DB migration from IBM-Aix to Oracle Linux with ZERO downtime.

Installation & Configuration of GoldenGate JAgent to work with OEM GG Plug-in

Environment : Oracle 11gR2, GoldenGate v12, IBM-Aix, Oracle Enterprise Linux, OEM Grid Control

Client: Scientific Gaming Corporation, Chicago, IL Feb 2014 – Nov 2015

DBA Architect – Oracle Apps/Core

Migrate Single Instance to RAC, Setup PCP, Configure Active Data Guard, Goldengate replication.

Upgrade of Oracle 10gR2 EBS Database to 11gR2, Upgrade and Configure Portal 10ias to 11g.

Upgrade of Oracle Business Intelligence 10.1 to 11 and Integration with 12c OEM grid control

Migrate EBS to Exadata/Exalogic/Exalytics, Apps tier and database Tier Configuration.

Install & Configure Oracle Content UCM system and Integration with E-Business Suite.

Environment : Oracle 11gR2, 10g, E-business Suite R12.1, OEM 12c, Ad Utilities, RMAN, Dataguard

Client: Select Comfort, Minneapolis, MN Nov 2012 – Jan 2014

DBA Architect – Oracle Apps/Core

Handle EXADATA Oracle 11g RAC, CRS, ASM, Sql Server Installations, Disaster Recovery Center Setup, DataGuard Physical & Logical Standby database, Grid Control & Agents Setup.

MongoDB v2.2 Deployment & Administration Support, Oracle 10g to 11g Upgrades, Deployments, Migration, DB and CPU Patches apply.

Continuous Performance Tuning Review and Management using Grid Control, AWR, ADDM, SQL Analyzer, Explain Plan, Tkprof, Trace Events and RMAN Backup & Recovery Strategies.

Golden Gate Replication uni-directional, bi-directional setup across Oracle and SQL Server.

Lead & Manage On-site and Off-shore DBA teams on 24*7 model Including Infrastructure Support.

Review DB Monitoring and Capacity Planning Processes, Budget, Time and SLA Management, Training sessions to DBA team, Shift schedules, Job Allocations, Datacenter Policy Adherence.

Daily and Weekly Status and Issues Escalations to Senior Director (ISS) & Global DBA Manager.

Environment : EXADATA X4-2, X2-2, Oracle 11g, 10g, MongoDB v2.2, Linux, Sun Solaris, DataGuard, Golden Gate, Netapp, Spatial, Remedy, Oracle E-Business Suite R12, 11.5.x, Precise i3, VMware ESXi

Client: Siemens, Minneapolis, MN Apr 2012 – Oct 2012

Principal DBA – Oracle Apps/Core

Support E-business suite applications modules, Patching, Cloning on on-call rotation (24*7) model.

Perform Oracle 11g and 10g RAC, CRS, ASM, MongoDB v2.0 Installations and Administration, Patching, Replication, Performance Monitoring & Tuning, Query Optimization & Database Security.

Perform Datamodeling, Logical & Physical database design, Physical & Logical Standby database Dataguard Setup, Enterprise Grid Control (OMS) and Agents setup, Nightly Scheduled Jobs Setup.

Perform 11g Upgrades, Migrations, RMAN Backup and Recovery, Streams, Golden Gate Setup.

Oracle SR Creation and Follow-ups, Performance Tuning using Grid Control, AWR, ADDM, Explain plans, SQL Analyzer, Tracing Events, DB Architecture Design, Recovery contingency tests.

Perform VPD Setup, Database and Application Audits, Users Security, DB Monitoring, Capacity Planning, Training sessions to DBA team, Off-shore Team Co-ordination, Change Management Control, CRONTAB and Oracle Job Scheduler Setup, DB Process documentations.

Status Reporting and Issues Escalation to DBA Manager and Senior Delivery Manager.

Environment : Oracle 11g, 10g, MongoDB v2.0, Redhat Linux, VMware ESXi, DataGuard, RAC, ASM, RMAN, Streams, Golden Gate, Veritas NetBackup, OEM 12c, Remedy, Oracle E-Business 11i, SAP.

Client: St. Jude Medical, Minneapolis, MN Nov 2010 – Mar 2012

Principal DBA – Oracle Apps/Core

Oracle 10g to 11g Upgrades and Database Migrations at different data center locations.

Participated in Exadata X2-2 Implementation, Exadata Patching and maintenance, Oracle 11g RAC, CRS, ASM Installations, Oracle Enterprise Manager 12c (OEM) & High-Availability setup.

Manage Laboratory Management (LIMS) & Clinical Applications databases, DB Architecture Design, SOX Database & Application Audits, Review Users Security, Golden Gate Setup, DB Capacity Planning & Performance monitoring, DB Patches, DB Cloning, RMAN Backup & Recovery.

Co-ordination with System Administrators, Business, Applications users & Change control process.

Lead Off-shore/Near-shore DBA team, Defining standard operating procedures, Mentoring to DBA team, 24x7 Production Support, Budge & Time Management, DB Process documentations.

Weekly Status updates and Issues Escalation to Senior DBA Manager.

Environment : Exadata X2-2, Oracle 11g, 10g, Redhat Linux, Sun OS, VMWare ESXi, DataGuard, RAC, ASM, RMAN, Golden Gatev10, DB Vault, NetApp, OEM 12c, Remedy, LIMS, Clinical Applications.

Client: Wal-mart, Bentonville, AR Jul 2008 – Oct 2010

Principal DBA – Oracle Apps/Core

Oracle E-Business Suite 11i applications Installation and Administration, Patching, Cloning, Oracle 9i to 10g Upgrades, Deployments, Migration and 24x7 Production Support, Setting up of Oracle Streams, Advance Queueing, RMAN backups, DB Vault and TD Encryption.

Oracle 10g RAC, CRS, ASM, Sql Servers Installations, Disaster Recovery Center Setup, DataGuard Physical & Logical Standby database Setup, Enterprise Grid Control & Agents setup.

Performance Tuning using Grid Control, AWR, ADDM, SQL Autotraces, Explain Plan, Tkprof

DB Architecture Design, Disaster Recovery (DRC) operations & Contingency Tests, VPD Setup, SOX Database and Application Audits, Users Security, DB Monitoring, Capacity Planning.

DBA Team Management, Budget, Time and SLA Management, Training sessions to DBA team, DBA Shift schedules, Co-ordination with System Administrators and Applications users, Change control & Data center policy adherence, DB Process documentations.

Environment : Oracle 10g, Sql Server 2005, Sun Solaris, DataGuard, RAC, ASM, RMAN, Streams, VPD, OEM, ERWIN, Remedy, Oracle EBS 11i, ATG E-commerce.

Client: Citigroup, St. Louis, MO May 2007 – Jun 2008

Senior Oracle Apps DBA

24x7 Database Production Support, On-call Rotation, and Offshore DBA team coordination.

Architecture & Design Logical, Physical databases, Datawarehouse, STAR schemas Management.

Oracle Applcations 11i & Siebel CRM Installations, Configuration & Patch Management, DB Creations, Configuration Changes, Patch Upgrades, RMAN Backup setup, Database Security.

Continuous DB Performance monitoring, DB Sox compliance & Audit trails, Change control, Quarterly Disaster Recovery contingency tests, DB Process Improvements and Documentations.

Daily status meeting with Offshore DBA team, Technical discussions with Business users, escalation and report of Weekly status to DBA Manager.

Environment : Oracle 10g, 9i, IBM-Aix, Oracle E-Business Suite 11i, Siebel CRM 8.0, RMAN, Veritas Netbackup, OEM, Precise i3, Foglight, Spotlight.

Client: Hawaiian Telecom (Bearing Point, Dallas, TX) Sep 2005 – Apr 2007

Senior Oracle Core/Apps DBA

Oracle E-Business Suite R11i, RAC, CRS Installations, ASM & Database Creations, Cloning, Patch Upgrades, Database Monitoring, Schema Management,

SQL Tuning, Database Backup, Recovery, Data Replication and Database Refresh.

Siebel CRM 7.8 Installations, Configuration and Patch Management, Database Deployments.

Handle Siebel CRM Product Catalog, EPM Repository, SCM Product Catalog, Fraud Mgmt, Experian Data feed, Rejected CDRs feed, POS and EFT Credit Card Payment Data Interfaces.

Detailed status reports to Senior Project Manager, Process enhancements and documentation, On-going Maintainence, 24x7 Production Support, Datawarehousing support.

Environment: Oracle Apps 11i, Oracle 10g, Sun OS, RMAN, Clearcase, Siebel CRM 7.8

HCL Comnet, Livingston, NJ and Chennai, India Jun 2004 – Aug 2005

Senior DBA Consultant (Senior Manager Band)

Production and Development Support for mission critical Databases and Applications effectively.

Setup & Manage Offshore Production Support DBAs Team, Shift schedules and Work allocations.

Database Creation, DB & SQL Performance Tuning, Capacity Planning, Cloning, Patch Upgrades, RMAN Backup & Restoration, Data center and Database Consolidation.

Interact with Operational Customers, Product Developers and Corporate IT Team to support all business units, DB Support process improvements and on-budget delivery.

Escalation of Operational, Applications and Database Support issues to Vice President IT.

Environment: Oracle 9i, 8i, Sybase ASE 12, Sun OS, SAP R/3, PeopleSoft CRM, OEM, Shareplex, RMAN, TOAD, Veritas Netbackup, CVS, Peregrine

VERIZON, Grapevine, TX and Chennai, India Oct 2002 – May 2004

Senior Technical Analyst – Telco Billing and Databases

Led Kenan Arbor Telco Billing System Migration from version 10 to 11

Analyze Billing/CRM dataflows, Control Points, Data Transfers, Oracle Installations, Database Creations, Upgrades, Database Sizing, DB Backups & Restores.

Setup and Manage Materialized Views Replication, Logical and Physical Standby databases, Tuning Database Performance, adhere Change control procedures.

Integration and System Testing of New Applications, Interact with Business Analysts to enhance existing processes and procedure.

On-call, Weekend, Monthend Production Support 24x7, Status Reporting to Senior IT Manager.

Environment: Oracle 9i, 8i, Sybase ASE 12, Sun OS, HP-Unix, RMAN, EMC, Shareplex, ClearCase.

BHARTI Telecom Service Provider, Chennai, India Jan 2001 – Sep 2002

Assistant Manager – IT, DRC and Billing Support

Manage Disaster Recovery Center, Capacity Planning, Database Security, Production Support, Oracle Installations, Database Creations, Upgrades, Daily Backups.

Plan and Implement Disaster recovery solutions for all production databases, Logical and Physical Standby Databases and Replication setup, SLA and Change management processes.

Hire DBAs, Mentor Billing Applications and DBA teams, Schedule work assignments, Define Billing and DRC standard operating procedures, Manage Budget and Time management.

Interact with Business & Application Team for current systems and processes enhancements.

Vendor Management, Prepare MIS and Status reports timely and submit to IT Head.

Environment: Oracle 8i, MS SQL Server 2000, Sun OS, TOAD, RMAN, Veritas Netbackup,

PT. Sejatibina Delta Informatika, Jakarta, Indonesia & Kuala Lumpur, Malaysia Apr 1999 – Dec 2000

Oracle DBA Consultant

Telco Billing System Data Migration from BSCS 4 to 5 and Oracle DB 7.3 to 8i migration, Malaysia.

Implementation & Data Migration of RETEK system at TOPS Retail Chain in Jakarta (Indonesia).

Oracle Production databases Administration at MAXIS GSM service provider at KL, Malaysia.

Oracle Database Instances creation, Memory Configurations, DB Performance Tuning, DB Backups.

Data Mapping, Data Extraction, Acquisition, Transformation, Data Migration and Validation.

Environment: Oracle 8i, Sybase 11.5, Sun OS, IBM Aix, BSCS Telco Billing system, RETEK (RMS).

CITIBANK N.A, Chennai, India May 1996 – Mar 1999

Data Center Officer

Oracle Development and Testing databases administration & support.

On-going Support of Production Applications, SQL tuning Analysis, patch and system upgrades.

Execution of 12,000,000 Credit Card Customers Pre-Billing, Billing and Post-Billing activities.

Banking customers Monthly Statement generation, Datacenter operations and jobs allocation.

Major modules Handled - Credit Cards Billing Application System, Accounts Payable and Inventory System, Fraud Management System and Collection Management System.

Environment: Oracle 8i and 7.x, Sun OS, Windows, SQL*Plus, PL/SQL, Credit cards Billing System.

Contact this candidate