Nikhil Mistry

  • Sr Oracle Application DBA
  • New York City, NY
  • Member Since May 03, 2023

Candidates About

 

Nikhil Mistry

Summary

·         Extensive experience with the Oracle Database with the necessary insight to ensure that any Oracle implementation will make the best use of the database functionality

·         Upgraded Oracle Application 11.0.3 to 11.5.10.2 and 11.5.10.2 to R12.2.4

·         Upgraded DB version 10.2.0.2 to 10.2.0.4, 11.2.0.1 to 11.2.0.3, 11.2.0.3 to 11.2.0.4

·         Implemented R12.1.3 Oracle Application, Implemented Oracle Revenue Management and Billing application

·         Provided Production support for Oracle Application of various different versions, provided Production support for RMB application, OBIEE application,  Applimation,  Journix application, Demantra Application, Discoverer  to name a few

·         Provided Core DBA support for various Oracle Database versions

·         Planned, designed and implemented Real Application Cluster for High Availability

  • Had proven track record of success in supporting clients and providing insight that can only be obtained from broad range of experience with the Oracle database and integrated packages in JAVA, Web Server, EJB, XML, and Web Logic

Skills

Database

Oracle 7.3.4/ 8.0.4/ 8.0.5/8.0.6/ 8.1.5/ 8.1.6/8.1.7/ 9.0.1.4 / 9.2.0.1/9.2.0.6 10.2.0.2. 10.2.0.4, 11.1.0.6, 11.2.0.1, 11.2.0.2,11.2.03.0.8,11.2.0.4

Tools

SQL Navigator, Precise, Spotlight, Oracle Enterprise Manager, TOAD,  AD Tools, Erwin, All Fusion Harvest Change Manager, Designer, Forms Developer, Reports, Discoverer, IT governance, Kintana, Export, Import,datapump, RMAN, Data guard, grid control, OBIEE, RAC 10g and 11g,Ctrix,

IBM Rational

Training

·         Guru Software:  Oracle 7.3/8.0, Developer 2000, Oracle DBA, and UNIX, 1995

·         Microsoft Solution Framework Courses like Microsoft Infrastructure Deployment; Microsoft Application Development; Microsoft Component Design (All Team Management Courses)

·         By Jeff Hilton Microsoft management Course Instructor 1999

·         Oracle8 Database Administration Certificate (by Ken Stewart)-Kennesaw State University Summer 1999

·         Oracle8 Performance Tuning Workshop (by David Freeman) - Kennesaw State University Summer 1999

·         Oracle8 Backup Recovery Workshop (by Ken Stewart) - Kennesaw State University Fall 1999

·         Tivoli 6.0 Asset Management, Problem Management, Change Management, and Tivoli System Administration

·         By Tivoli/IBM Corporation Guy Mc Clure L.A. CA Winter 1999

·         Coresoft: SAP, R/3, FI/CO, 1996

 

Selected Project Experience

Company

Western Union/Infosys

Duration

February 2016 to Current

Position

Sr Oracle Application DBA

Responsibilities

  • Implementing Oracle R12.2.2
  • Development support
  • User support

 

 

 

Company

US DEPT OF EDU

Duration

July 14 2014 to November 30th 2015

Position

Sr Oracle Application DBA

Responsibilities

  • Oracle application 11i to R12.2.4 upgrade
  • Oracle Federal Financial
  • SOA, Weblogic,
  • OAM implementation and integration to R12.2.4
  • Informatica archive ILM 6.2 to 6.4 upgrade
  • Informatica applimation 11.5.10.2 to R12 upgrade
  • Production support for 11i and  R12 application, Discoverer, OAM, informatica
  • Analyzed and Applied Quarterly Security patches to RAC DB, 11i Application, OAM , Discoverer, Informatica
  • Maintained oracle XML DB Repository
  • Provided End user support for various login issues for 400 users using IBM Rational Ticket System
  • Clone Dev, Test and UAT environments as needed basis
  • IBM Rational Suite
  • C-6 Clearance

 

 

Company

Autotrader

Duration

July 2012 to Jun 2014

Position

Sr. Apps DBA, core DBA and RMB, Webcenter, ODI and Fusion infrastructure  DBA

 

Responsibilities

  • Product Development and user support R12.1.3 Application,
  • 11.2.0.1 Database upgrade to 11.2.0.3
  • Upgrade EBS db from 11.2.0.3 to 11.2.0.3.8
  • GRC Support
  • Oracle Revenue Management and Billing (RMB) Support
  • RMB cm.jar, SPLApp.war, framework code and patches deployment
  • RMB Blue print deployment
  • Clone RMB environment, troubleshoot weblogic issues
  • Web Content Management with IPM, UCM
  • Patching and user support
  • Updated init.ora for XML DB repository with Dispatcher parameter
  • OBIEE implementation 11gR2 database installation, 11.1.1.6.0 BIEE MT installation
  • 32bit RCU (Repository Creation Utility)  installation and support
  • Heavy Fusion Apps environment

 

 

 

Company

Micros system Inc, Columbia, MD

Duration

Jan 2012 to July 2012

Position

Sr. Oracle Application DBA/Core DBA

Responsibilities

  • Production maintenance of 11.0.3 and R12 12.1.1. e-Business instances
  • Major modules support Oracle ERP 12i (GL, AP,  FA, PO, PA, INV, OM  I-Expense)
  • cloned 11.0.3 and R12 e-Business instances as needed using RMAN and hot backup
  • Golden Gate , Data Guard, OEM
  • Old oracle apps with  11.0.3 (8i) database maintenance,
  • Production Support and patch management of 11.0.3 and 12.1.1 oracle e-Business
  • Production Support for 10.2.0.4 Clarify Database and application (CRM)
  • Production Support of 9i Journix Database,
  • Configured XML DB database using xdbconfig.xml file
  • Created daily oracle production apps database clone script to support BI database extraction from Oracle Application database

 

Company

Snyder’s Lance, Charlotte, NC

Duration

Nov 2011 to Jan 2012

Position

Application DBA/Core DBA

Responsibilities

  • Lead the upgrade project,  ERP database from 11.2.0.1 to 11.2.0.2 for 3.5 T size of database and production support for R12 ASCP, Demantra and e-Business 11.5.10.2 with (GL, AP,  FA, PO, PA, INV, OM modules)
  • 11g RAC database with ASM, evaluated with oracle team for SAN to EXADATA migration but company decided not to go with EXADATA due to cost and dual storage maintenance

 

Company

Welch’s, Boston, MA

Duration

April 10 to Nov 2011

Position

Application DBA/Core DBA

Responsibilities

  • Technical lead DBA, monitoring offshore DBA team to support 24x7 environment
  • Responsible for leading team and provide weekly task with execution plan if needed, cloned and refreshed instances as needed using RMAN
  • Implemented DR site for EBS database and Application for Production and QA system
  • Recently completed DR testing for all production systems, Data guard, 11g R2 RAC, ASM
  • Implemented RFS transportation for companywide production databases
  • Responsible for patching analysis and scheduling matching company downtime
  • Responsible for change order moving from test , QA , Prod respectively
  • Responsible for technical project management for web method and Demantra upgrade
  • Involve in R12 ongoing upgrade project with major modules (GL, AP,  FA, PO, PA, INV, OM, HR, PAY)
  • OBIEE Team interaction and providing support regarding OBIEE and EBS ETL schedule and troubleshoot
  • Managed project for Upgrade web methods database to 11g and application
  • Managed Project for Upgrade Demantra database to 11g and application.
  • Managed Project adding informatica for GL module in e-Business for data archiving to control the db growth which is 100G/yr

 

Company

E.ON USA, Louisville, KY

Duration

January 08 to April 10

Position

Project Lead/Sr. Oracle Apps DBA

Responsibilities

  • Reason for Leaving: DBA services outsourced to overseas data centre after contract completed
  • Team lead for E-Business application upgrade and production support project
  • Production support for most manufacturing and Fin. Modules like (GL, AP,  FA, PO, PA, INV, HRMS, PAY , OM), user support for development, patching, cloning
  • Upgrade, added DMZ node for i-Expense, and ASCP, upgraded Discoverer to latest Version
  • 10.2.0.2 database upgraded to 10.2.0.4 for pre-requirement  for OS migration and 11i to R12 upgrade
  • Extensively used RMAN for cloning, refreshing and standby db creation
  • Ervin for data modelling

 

 

PRIOR Employment History

Date

Customer

Role

March 07 to Dec 07

American Honda, Marysville, OH

Oracle Apps. DBA

Oct 06 to Apr 07

PBGC, Washington DC

Oracle Apps DBA

Oct 05 to Sept 06

US Army

Oracle Apps DBA

May 05 to Oct 05

APS, Phoenix, AZ

Oracle Apps DBA

Jan 2005 to April 2005

Canon Europa, Amsterdam, Europe

Oracle Apps DBA

Nov 2004 to Jan 2005

HP/Delta Airline, Atlanta, GA

 

Aug 2003 to Nov 2004

Cincinnati Public School System, Cincinnati, OH

Oracle Apps DBA

Feb 2001 to June 2003

Georgia Automation Commission, Atlanta, GA

Oracle Apps DBA

Nov2000 to Feb 2001

T-Manage, Raleigh, NC

Oracle Apps DBA

April 2000 to Nov 2000

Americord, Inc, Lumber City, GA

Oracle DBA

Dec 99 to April 2000

Lexmark International, Lexington, KY

Oracle DBA

June 1999 – Dec 1999

State of Georgia, GA

Oracle DBA

April 1999 – June 1999

University of South Florida, Tampa, FL

Oracle DBA

Jan 1996 – April 1999

Gajjar Engineering CO, GA

DBA/Systems Administrator

Qualifications

 

AS, Finance/Accounting – Kennesaw State University

Bio Science – Gujarat University

 

Training

Ø  Guru Software:  Oracle 7.3/8.0, Developer 2000, Oracle DBA, and UNIX, 1995

Ø  Microsoft Solution Framework Courses like Microsoft Infrastructure Deployment; Microsoft Application Development; Microsoft Component Design (All Team Management Courses)

Ø  By Jeff Hilton Microsoft management Course Instructor 1999

Ø  Oracle8 Database Administration Certificate (by Ken Stewart)-Kennesaw State University Summer 1999

Ø  Oracle8 Performance Tuning Workshop (by David Freeman) - Kennesaw State University Summer 1999

Ø  Oracle8 Backup Recovery Workshop (by Ken Stewart) - Kennesaw State University Fall 1999

Ø  Tivoli 6.0 Asset Management, Problem Management, Change Management, and Tivoli System Administration

Ø  By Tivoli/IBM Corporation Guy Mc Clure L.A. CA Winter 1999

Ø  Core Soft: SAP, R/3, FI/CO, 1996

 

  • Experience:
    15 Years
  • Birthday:
    12/31/1969

Contact Us

This website requires cookies to provide all of its features. By using our website, you agree to our use of cookies. More info