Resume

Sign in

Developer Oracle DBA Oracle

Location:
Clifton, NJ
Posted:
March 20, 2019

Contact this candidate

Resume:

TANVY PAREKH

WOODBRIDGE,NJ

732-***-**** ac8ujy@r.postjobfree.com

PROFFESIONAL SUMMARY – DBA

8+ years of experience as Oracle DBA in the Production, Development & Staging Environments.

Experience in designing and implementing High Availability strategies

Experience in huge data migration, transfers using utilities such as SSIS, BCP, datapump

Experience in RAC setup on RHEL, creating ASM disk groups & ASM instance

Configuring TAF & managing database services

Preform ongoing database maintenance, patching and upgrading for Oracle

Plan, test & implement backup & recovery strategies using RMAN & datapump

Plan, test & implement database refresh procedures using data migration techniques, shell scripts, auxiliary database, cloning

Performance tuning memory & sql statements utilizing diagnostic tools such as AWR, Explain plan, SQL Trace, SQL Tuning Advisor, TOP commands, partitioned tables

Experience in creating SSIS packages for data migration; experience in creating SSRS reports

SKILLS & TECHNOLOGY-

Oracle versions 9i,10g 11g, 12c; RAC & ASM, Dataguard; OEM Grid & Cloud, AWR, VPD

Shell scripting & PL/SQL Procedures, Triggers, Functions

Oracle FGA & audit procedures, database profiles

SQL Server Versions 2008 R2, 2012, 2016; SSIS & SSRS

BIDS, SSMS, SSIS, SSRS, Toad, Win SCP, Putty, Oracle Developer, Visual Studio, SQL Server Profiler, JIRA, SCRUM, TFS, Office 365, ConnectWise, Oracle support, Metalink, Erwin tool for E/R Models

PROFFESIONAL EXPERIENCE-

June 2018 - Current Ungerer & Company [NJ, USA] DBA/Developer (Permanent)

Design E/R Models & solve critical database issues; space management

Apply PSU patches & design data migration plans

Implement Oracle FGA using custom made PL/SQL procedures, custom made functions to setup Oracle’s VPD & database maintenance tasks

Test & Implement Oracle’s RMAN backup & recovery policies

Performance tuning & designing database refresh procedures for test environments

[Environment- 2 node RAC Oracle 11gR2, SQL Server 2012, MySQL]

January 2018 - June 2018 OnPoint Intl. LLC [NJ, USA] Sr. DBA/Developer (Contract)

Performed initial installation/creation of 11g Oracle databases

Implemented conceptual database designs and logical models

Planned and implemented backup and recovery strategies

Performed capacity planning for database growth, user management & space management

[Environment- standalone 11g production & development databases, initial setup]

June 2012 – July 2017 Citiustech (Mumbai, India) Oracle DBA (Permanent)

Worked on numerous US Healthcare domain projects for clients GE (General Electric), Hyland software, Ability Networks)

Working with clients, information architects, system admin and developers to define information flow helping to transform business requirements into environment specific databases

Monitoring and supporting production, development, staging and test environments (exclusive RAC db.)

Configuring TAF & database services, testing failover operations for RAC

Performed ongoing patches both rolling & downtime patches

•Performed Database Refresh from Production to QA, Staging and Development databases using shell script.

•Implementing BDD code and packages in the staging environment

•Configuring RMAN backup & testing recovery including flashback recovery

•Maintaining Recovery catalog database

•Creating RMAN auxiliary instance for developers testing environment

•Creating & Managing application users using Authstore application, post database refresh

[Environment- Max db. size 17 TB, OS- RHEL 5.x, Sun Solaris 5.10, Production (3 node RAC), Staging & Testing db.]

December 2011 – June 2012 Magna Infotech [Mumbai, India] Sr. DBA/Developer (Contract)

Monitoring and supporting production, development, staging and test environments (exclusive RAC db.)

Developing and maintaining operational standards/procedures for Oracle

Optimizing database uptime/availability and performing database audits

Creating physical standby for failover and monitoring log sync operations

Managing user accounts

Performance tuning sql and instance

[Environment- Max db. size 5 TB, 2 node RAC setup, standalone databases & physical standby]

March 2011-December 2011 In-Solutions Global [Mumbai, India) Oracle DBA (Permanent)

& July 2007-June 2008

•Oracle Standalone Db. Installation, Design & Maintenance for new project at client side BOBCARDS.

•Implementing Physical Standby Db. on Production environment & Performing DR Drill activity

•Database Purge from Production to the Legacy database

•Monitoring databases for redo log gaps, database users & quota management, creating database objects & index management, DB Links, import & export of data using Datapump

•Creating, Scheduling & Monitoring database backups using RMAN & OEM

•Generating Explain plan, Statspack report & troubleshooting database performance issues

[Environment- Max db. Size 2 TB, Oracle 9i & 10g R2, RHEL 4x; Production & Test db. Standalone with physical standby]

EDUCATION & CERTIFICATES-

H.S.C. (Mumbai University, India)

Advance Diploma in Computing & Multimedia (3 years, full time). City College, LONDON.

O.C.P.- Oracle Certified Professional (9i)- YEAR 2004

M.C.S.E.- Microsoft Certified Solutions Expert- BI (Sql Server 2012)- YEAR 2014

PERSONAL DETAILS-

Date of Birth – 06/14/1981

Location- Woodbridge, NJ, USA

Work Authorization- Green Card



Contact this candidate