JAY V. PARIKH

Edison, NJ 908-***-**** add56j@r.postjobfree.com linkedin jay-parikh1

SUMMARY:

Database professional with industry experience in database administration with over 10 years (production/development-OLTP) environments. Engineered systems including Exadata, ODA, Data Guard, supporting disaster recovery and high availability, Golden gate, Shareplex, Proactive Database Monitoring and Performance Tuning, scripting in shell, RMAN Backup and Recovery. Extensive experience in analysis, design, maintenance and documentation of high-level design databases and expertise in transition/implementation of new applications. Oracle Certified DBA Oracle 12C, experienced in the administration of Oracle (12c/11g/10g/9i/8i) RAC with ASM on Unix, Solaris, AIX and Windows platforms.

Extensively worked on tuning the databases like memory tuning for database buffer cache, shared pool and log buffer, identifying and resolving contention for system resources, latch contention, data block contention (free list, init trans) rollback segment header and undo blocks, enqueues, identifying hot spots for I/O contention and suggesting remedies for avoiding excessive I/O wait using Explain Plan, Statspack, SQL Trace, TKprof.

· Migrated Databases from lower to higher versions and Cross-platform data migrations.

· Extensive experience with very large databases (over 15 Terabytes)

· Excellent communication and interpersonal skills together with a positive approach to undertaking challenges.

· Extensive knowledge of AWS cloud

TECHNICAL SKILLS:

RDBMS: Oracle 8i/9i/10g/11g/12c, MS SQL server 2000

Languages: SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash

Operating Systems: Sun Solaris, AIX, Linux (Redhat Linux), HP_Unix, Windows

Utilities: OEM, SQL Navigator, Pl/SQL, Putty, UNIX Shell Scripting, Toad, SQL*Loader, ETL,

SQL TRACE, CRON, Explain Plan, RMAN, OEM, TKPROF, STATSPACK, AWR,

ADDM and Advanced Replication.

Backup Tools: Rman, ARC serve, Veritas, Legato.

Oracle HA: Data Guard, Oracle Advanced Replication, Shareplex (7.2), Golden Gate, RAC

EDUCATION/ TRAINING:

BS in Computer Engineering, University of Central Florida

· ITLE Awareness Classes.

· Data warehouse classes.

· Fire fighting class from Craig Shallahamer

· Oracle troubleshooting class from Tanelpoder

· Hotsos Oracle Performance class

· PMP classes

· Exadata Training

· Golden Gate Training

CERTIFICATIONS:

Oracle 12c Certified Database Administrator (OCP)

AWS Certified Solutions Architect- Associate

VISA STATUS: U. S. Citizen

EXPERIENCE

Fiserv Parsippany, NJ 1/15 – Present

Senior Oracle DBA

· Work in Operations team supporting over 700 Oracle databases (9i/10g/11g/12c) using ASM and Rac technology.

· Maintained and supported Client’s databases including daily monitoring, resolved performance related

issues via table partitioning, instance tuning and performance analysis using ADDM, AWR, ASH report

· Responsible for Installation of 11g Cluster Ready Services on 4 nodes in ASM file system.

· Planned, tested and implemented Oracle RAC Upgrade from 11.2.0.2 to 11.2.0.4.

· Installed, configured and upgraded Oracle Golden Gate from v11 to v12 with bi-direction replication.

· Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify

the resource and performance bottleneck and reorganization for ensuring performance.

· Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning

the same using Explain Plan, TKPROF and SQL tuning advisor.

· Exadata DMA tasks - database nodes and storage cell administration, hardware replacement,

monitoring, patches, db upgrade, migration(go-live)plan, backup and recovery plan etc.

· Assigned Primary DBA role and responsibilities of databases in a full life cycle development.

· Assisted Application developers with application performance issues.

· Daily email of high-level status of databases was setup in cron using AWR difference report and oracle

scripts.

· Worked on several Site disaster recovery tests using Oracle data guard

· Re-engineering RECON monthly purge script to well organize the data and distribute IO.

ENVIRONMENT: ORACLE 12c/11gR4/10g, IBM AIX, Linux, Foglight, Toad, Autosys.

Verizon Wireless, Warren, NJ 7/07-1/15

Sr. Oracle DBA/Team Lead

Oversaw all aspects of the database, including database architecture design, through implementation, administration, monitoring, tuning, backup, migration and support.

· Design a new data archival mechanism for Verizon Wireless to keep data for seven years. Wrote a stored

procedure which takes inputs for archival month duration of different tables and it generates a flat file of the data.

· Managing Customer Care Reporting database ranging to 15 Terabyte.

· Migrated production Reporting Database from Oracle 10.2.0.5 to 11gR2.

· Extensively involved in Data Center Migration and Disaster Recovery plans and Implementation. Migration

includes Cross platform migration, and upgrade [HP- UX to Sun Solaris].

· Lead the Tech refresh project successfully migrating CCES application from single database into RAC to provide

better performance and manageability with near zero downtime and without any post migration issues in a planned

time frame.

· Handle performance-related issues during Oracle Upgrade using home grown scripts comparing 10g and 11g same

sql comparison base on Elapsed time, CPU time and executions.

· Managed database on Cluster environment with failover and Switchover logic using using Veritas Cluster

Services (VCS)

· Attended technical meeting during design phase of features going in particular deployment and provided SQL

enhancement recommendations. Supported monthly application releases.

· Perform Data Warehouse operations like loading data into reporting database using SQL*Loader into temporary

table, Exchange table with original table, Rebuilt Indexes and Gather statistics after loading data.

· Setup OEM for monitoring all databases in a centralized server.

· Experience with ETL tool Dmexpress to load daily data into tables using CDC method.

· Lead the efforts of conducting/maintain CPU/PSU and back port patches across Enterprise systems.

· Converted non partition table to partition tables with local indexes for better table management and performance.

· Participated in the evaluation of Golden Gate replication tool to replace Shareplex tool.

· Conduct Shareplex/Oracle High Availability trainings to the Enterprise team members.

· Communicate status reports and issues to the Manager on timely basis.

ENVIRONMENT: ORACLE 11gR3/9I/10g/11gR2 Enterprise Edition, ASM, Data Guard, Sun Solaris, Veritas storage foundation, DMExpress, OEM, Toad, Golden Gate, Shareplex

Checkfree Investment. Newark, NJ 10/05 – 7/07

Oracle DBA

Analyzed existing environment from SPOF (single point of failure) and provided architectural alternatives for system redundancy and performance to host 24x7 mission-critical applications.

· Monitored replication process (using Quest Shareplex, Advanced Replication and Data Guard) between production

databases and disaster recovery database.

· Performed unit testing, load testing, stress testing and tuned database response time.

· Performed corporate disaster test for site failure.

· Co-ordinated the migration of schema changes from Test to Pre-Production, then to Production.

· Developed and executed new backup, recovery and archiving policies and procedures. Tested procedures

completely and ensured DBA staff is fully trained in recovery operation.

· Performed Shareplex upgrade from 4.5 to 5.3 on various systems.

ENVIRONMENT: ORACLE 9i/10g,IBM AIX v5.2, Toad, SQL Navigator, WebLogic, VSS, Autosys.

VNU, Inc. New York, NY 06/04 – 10/05

Sr. Oracle DBA/Team Lead

The client is a hosting company. It publishes over 50 business publications, stages over 50 trade shows and conferences and operates more than 200 business-to-business electronic products.

· Managed Oracle Multimaster Replication databases for production and development.

· Supported Oracle partition and materialized views (snapshots) on multimaster replication environment.

· Implemented physical Oracle Data Guard for 500 Gig database.

· Work closely with branch managers/supervisors in maintaining uninterrupted daily operations.

· Configured and implemented RMAN utility for backups and recovery.

· Conducted database monitoring, debugging, troubleshooting, performance tuning and other database administrator

duties

· Rebuild intermedia indexes (TEXT indexes) periodically for high transaction tables to minimize fragmentation.

ENVIRONMENT: ORACLE 9i/10g, Oracle Webdb 3.0, Sun Solaris v5.8/v9.0, Oracle 10g (10.1.2.0) AS Oracle Portal, Toad, Perl, WebSphere.

Chenoa Inc., Edison, NJ 8/02 – 06/04

Sr. Oracle DBA/Developer/System Administrator

Worked for a major insurance (annuity) client: AIG SunAmerica, for the set up of both deferred and payout products by developing functionality required to major insurance company’s payout business into the deferred system.

· Installed, created and upgraded Oracle databases as needed for development and QA effort. Worked with

Application team to design and implement common database objects and resources (tables, views, packages, stored

procedures and triggers etc.).

· Extracted the delta between the different production/development Database schemas through SQL, Toad and shell

script and then applying the changes to the combined system.

· Performed database tuning using Oracle Statspack, DBA Studio, Spotlight and TOAD.

· Maintained all the Oracle databases (QA/Staging and production) and helped developers in trouble shooting and

resolving all issues related to SQL, PL/SQL and WebSphere. Mentored the developers and helped them

resolving, tuning and programming issues.

ENVIRONMENT: ORACLE 8i, Windows 95/2000, Dell Power Edge 2650/2550, Toad, Veritas, Pr_tracker, MKS-Toolkit, WebSphere, VSS and PVCS.

PETERSON ASBESTOS CLAIMS ENTERPRISE (PACE) Lawrenceville, NJ 7/01-8/02

Senior Oracle DBA/Unix Administrator

Pace is a representative company for 10 producers of asbestos or asbestos related products to settle the meritorious asbestos claims on a speedy and cost effective basis. It serves as an interface between the company and the injured party.

· Installed, configured and supported numerous databases including: Oracle8i on Linux/Windows 2000/NT 4.0

platforms and Oracle 7.3.4. database on VMS 7.1 system.

· Periodical cloning of production Database and rollover to development and test environment.

· Various DBA activities like performance tuning and day-to-day database monitoring activities.

ENVIRONMENT: ORACLE 8i/7.3.4, Developer 2000/6i, Oracle Forms 4.5/6.0, Erwin, Redhat Linux 6.2/7.1, Open VMS 7.1, Windows 95/2000, SQL Navigator, ARCSERV.

CS Integrated, NJ 8/00 – 7/01

Oracle DBA/Unix Administrator

· Implemented the standard Oracle Environment (SOE) for CSI that includes consistent set of scripts and directory

structure across all hosts in the Oracle environment.

· Was responsible for migration of multiple Oracle 7.3.4 Instances from AIX 4.3.4 to Oracle 8i on Compaq

Tru64 UNIX. Created/Migrated database objects like tables, indexes, procedures and triggers.

· Re-organized tablespace contents, in order to reduce fragmentation.

ENVIRONMENT: ORACLE 8i/7.3.4, Compaq ES40/ Tru64 v5.1, IBM-RS 6000, AIX 4.3.4, Toad, OEM.

Champion Mortgage 4/98 – 08/00

Database Administrator/Unix and Windows NT Administrator

· Overseeing all aspects related to Day to day DBA activities including System Performance Tuning, database refesh, applying patches and handling on-call rotation.

· Wrote Standard documentation for database environment, security guidelines, object-naming standards, data synchronization and backup/recovery procedures.

· Created scripts to automate data processing, data validation, loading and updating data using SQL*Loader and database triggers.

ENVIRONMENT: Oracle 8.0.5/7.3.4, HP-9000, Windows NT, ERwin, SILVERRUN, Visual Basic.

Lucent Technologies 10/95 – 04/98

Database Administrator

· Was responsible for Oracle databases Administration on multiple SUN and NT environment

· Upgraded Databases to newer Oracle Releases and migrated data.

· Tuned for maximum performance for various nightly batch jobs drastically.

ENVIRONMENT: SUN SPARC ULTRA II, SOLARIS 2.51, WINDOWS NT 3.51, ORACLE 7.X

CITICORP 9/94 – 10/95

Programmer/Database Administrator/Desktop Engineer

· Designed, developed and implemented Bank Customer Information system to perform basic banking operations

using PRO*C, Forms 3.0, Reportwriter 1.0.

· Developed data and application security standards. Designed and implemented change control procedures.

Contact this candidate