Post Job Free
Sign in

Oracle

Location:
Edison, NJ
Posted:
May 14, 2015

Contact this candidate

Resume:

Raja Gupta

Certified Oracle DBA Consultant

SUMMARY

Over 18 years of experience in the field of Oracle database administration

and development, having performed traditional functions of installation,

upgrade, configuration, backup and recovery, archiving and performance

tuning on Oracle RDBMS version 8i through 11g on a wide variety of

Unix/Linux platforms and Windows Server for various projects in software,

insurance, financial, pharmaceutical, and telecommunication companies.

EDUCATION

University of Calcutta, India

Masters in Business Management (MBA), Major in Computer Management Systems,

1st Class - 1996

University of Jadavpur, Calcutta, India

Bachelor of Engineering (BE), Major in Construction Engineering, 1st Class

Honors - 1994

TECHNICAL SKILLS

Database Admin: Oracle 12c/11g/10g/9i/8i; SQL Server 2008/2005;

Backup: RMAN, Symantec NetBackup, Datapump

High Availability: Data Guard, RAC, ASM, Grid Control,

Database Mirroring, Log Shipping

Replication: Data Guard, Streams,

Transportable Tablespace, Materialized views

Diagnostic & Monitoring: Oracle Cloud Control 12c, Grid Control

11g, BMC Patrol, Idera Diagnostic Tool

Benchmarking: NeoLoad, Swingbench

Automation: BMC Bladelogic Database Automation; Control-M; Oracle Job

Scheduler

Data Modeling: Erwin Data Modeling, Toad Data Modeler, SQL Developer Data

Modeler

ETL: Informatica

OS: Linux - Red Hat, Oracle; Unix- IBM AIX, Solaris, HP-Unix;

Hardware: IBM Power Machines, Dell Servers, EMC VMAX, Windows

Server, SAN storages, RAID controller (PERC)

Virtualization: VMware ESX 3.5, VSphere 4 and Oracle Virtual Box

Languages: Oracle SQL, PL/SQL, PRO*C, Bash Shell

Scripting, Java

Development: Oracle Forms and Reports, PRO*C, Servlets and JSP

Application: Telecommunication - Billing, Quality Management -

Trackwise, Analytics Marketing - Catalog Management System,

Health Insurance - Pulse, HIPAA Financial - OTCNET

PROFESSIONAL EXPERIENCE

Sanofi-Aventis, NJ

April 2014 - Till Date

. Working as Senior DBA consultant providing Level 3 support for all legacy

and NGDC application databases.

. Involved in provisioning of both single instance and clustered databases

on Grid infrastructure

. Installation of Oracle 12C Cloud Control on Linux.

. Installation, configuration and maintenance of Oracle 12c RAC on 2-node

cluster for Genzyme Trackwise.

. Configuration of Data Guard (physical standby) for starlims production DB

and participating in DR Drills of switchover and failover.

. Scripting and configuration of all types of RMAN backups using shell

scripts and Control-M. In total over 100 HP-Unix and Linux servers, and

over 500 production and non-production databases were configured.

. Patching Oracle RAC environments with latest GI PSU using rolling patch

strategy.

. Conversion of single instance databases/file system storage to RAC/ASM in

production env for Trackwise. In total over 10 mission critical databases

sizes over 500GB converted to RAC.

. Coordinating ORTs and Instance tuning for databases (terabyte size)

migrated from legacy to NGDC environment for Starlims and Trackwise

Application.

. Upgrade legacy databases from 10g to 11g for critical applications.

. Provisioning single instance data guard for RAC databases.

. Providing 24/7 on-call support on all NGDC Amer databases for critical

business applications like Trackwise, Starlims, etc. and coordinating

change requests for production environments using BMC Remedy.

Technology: Oracle 12c Cloud Control, Oracle 11gR2, Grid Infrastructure,

ASM, RAC, Data Guard, RMAN, Oracle partitioning, Datapump, Control-M

CITI/TCS DE

September 2013 - December 2013

. Worked as a DBA consultant and designed the Archiving strategy for OTCNET

application database using PLSQL, Datapump API and transportable

tablespaces.

. Designed the Partitioning strategy using Reference Partitioning for

efficient data purge in OLTP database after data is archived.

. Coding database packages and stored procedures for Check Image Retrieval

reports on OTCNET Archive database.

. Benchmarked application performance using SQL traces on queries for newly

partitioned tables.

. Installation and support of Performance DB environment on 11gR2 RAC and

ASM on Red Hat Linux 6.

. Preparing scripts for running ASM health check.

. Migrating databases from non-ASM to ASM in Integration environment.

. Managing RAC database and it's components in grid infrastructure for

production and validation environments.

. Performance Tuning on application database using partitioning, tuning

advisor and TKPROF traces.

. Restoring databases in development and QA environments using Datapump and

Transportable Tablespace.

. Performing planned DR drills of switchovers and failovers to Physical

Standby DB.

. Troubleshooting issues in production database and root cause analysis.

Technology: Oracle 11gR2, Grid Infrastructure, ASM, RAC, RMAN, Oracle

partitioning, Datapump, PLSQL, Bash Shell script, Data Guard, Red Hat Linux

5/6

Sparta Systems, NJ

December 2011 - August 2013

Oracle DBA Responsibilities

. Involved as a Lead DBA for logical and physical design of Trackwise

Database.

. Created ERDs for various subject areas using TOAD Data Modeler and

reverse engineered the Trackwise DB for creation of schema reports.

. DBA involved in designing ETL STAR schema for Trackwise BI and Analytics.

Working with performance engineering team in reviewing and tuning codes

for ETL, stress testing with Neoload, supporting Webfocus reporting

application on reporting database.

. Created database packages, stored procedures for Trackwise Analytics and

data conversion projects.

. Tuning hotspot application codes - SQL queries, DB procedures using

TKPROF traces and explain plans.

. Benchmarked application performance with performance engineering team

using NeoLoad for small, medium and large size deployments.

. Documented customer facing database tuning and best practices guide for

flagship product trackwise for Oracle 11g and 10g.

. Supporting all production databases hosted in-house and customer sites in

OLTP, data warehouse and reporting database environments.

. Installation of Oracle 12c release 1 on Linux 6 and documentation of new

features.

. Migration of production databases from non-ASM to ASM for GE Healthcare.

. Applied Oracle CPU April 2013 patch on all in-house customer databases on

Linux.

. Performance Tuning on databases Terabyte in size for GE Healthcare on

11gR2 RAC on Red Hat Linux using AWR, ADDM, ASH, tuning advisor and

TKPROF traces, copying in-houses databases from production to development

environment using Transportable Tablespace and Datapump.

. Upgrade of key customer databases from 10g to 11gR2. In total 30 customer

databases upgraded in less than a month.

. Troubleshooting issues in live customer databases and root cause

analysis.

SQL Server DBA Responsibilities

. Installation of SQL Server 2008 R2 on Windows Server 2008R2 64 bit and

Vmware

. Administration and support of all in-house application databases.

. Planning for Backup, maintenance and disaster recovery of production

databases.

. Documented new features of SQL Server 2012 edition.

Technology: Oracle 12c, Oracle 11gR2, Grid Infrastructure, ASM, RAC, Oracle

10g, RMAN, Oracle partitioning, SQL Server 2008R2, Red Hat Linux 5/6, Bash

Shell scripting, Windows 2008, Idera SQL Diagnostic Tool, TOAD Data

Modeler, NeoLoad

Comverse Technology, NJ

April 2010 - December 2011

. Worked as a level 3 support Oracle DBA.

. Partitioning of production databases for telecom providers like UTS group

and GTEL.

. Created stored procedures and packages to incorporate business rules for

prepaid and postpaid billing.

. Physical design and Capacity planning of key customer databases.

. Performance tuning of Data warehouse reporting application thru creation

of materialized views and partitioning of some of the customer tables.

. 24/7 rotating DBA support for all mission critical production databases

hosted at various prepaid and postpaid customer sites.

. Installation and support of Production databases on 11gR2 with ASM and

RAC on Red Hat Linux

. Installation of Oracle Grid Control 11g on Red Hat Linux.

. Upgrade of some key production databases from 10g to 11g.

. Moving of key production databases to new servers on SAN storage.

. Implementation of Oracle Data Guard solution for creation of physical

standby database on ASM for all production instances in Kievstar.

. Developed shell and RMAN scripts for level 0, level 1 and archive log

backups for customer VOX (part of French Telecom)

. Troubleshooting issues in live customer databases and finding root cause

analysis.

. Restore and recovery of key production database for Reliance

Telecommunication after hardware failure and corruption of current

backup.

. Advised offshore customers on how to improve performance in their

production databases.

. Mentoring junior Oracle DBAs and offshore coordination experience.

. Documenting the installation, switchover, and failover procedures for

Data Guard and Knowledge transfer to offshore DBAs

Technology: Oracle 11gR2, Oracle 10g, Grid Control 11g, ASM, RAC, Data

Guard, RMAN, Oracle partitioning, Red Hat Linux 5/6

NFI, NJ

November 2009 - April 2010

Oracle DBA Responsibilities

. Implementing RMAN incremental update backup.

. Refresh of model and development databases from production using RMAN

cloning.

. Recovering client production database from data block corruption.

. Implementation of Oracle Data Guard solution for creation of physical

standby database for all production instances.

. Tuning database and resolution of performance issues using ADDM, AWR, ASH

reports, SQL tuning and access advisors, tkprof traces and explain plans.

. Supporting production releases and builds.

. Installation of PSU 10.2.0.4.3 which includes Oracle Jan2010 CPU update

in production environment.

. Daily support for production issues and tuning and production rollout

changes.

. Primary Oncall support for production databases in 10g and 11g.

. Deployment of change control.

SQL Server DBA Responsibilities

. Installation of SQL Server 2008 R2 on Windows Server 2008R2 64 bit.

. Optimization of queries using execution plans, tuning advisors and

tracing,

. Implementation of Disaster recovery using database mirroring and log

shipping.

. Creating maintenance plan for SQL server databases.

. Restoring development database data from production in SQL server

. Creation of reporting databases using log shipping.

. Implementation of maintenance plans for backup for all production and

development databases.

Technology: Oracle 11gR2, Oracle 10g, RMAN, Oracle partitioning, SQL Server

2008R2, IBM AIX, Windows 2008

Cover-All Technology, NJ

January 2009 - November 2009

Oracle DBA Responsibilities

. Installing Oracle10g for production in Red Hat Linux machines.

. Coding shell scripts for optimizer statistics collection, RMAN and export

backup in Red Hat linux environment.

. Implementing RMAN incremental update backup.

. Refresh of model and development databases from production using RMAN

cloning.

. Recovering client production database from data block corruption.

. Migrating application databases from Windows 2003 to Red Hat Linux

environment using RMAN CONVERT Database.

. Migrating database from windows 32-bit to 64-bit environment.

. Implementation of Oracle Data Guard solution for creation of physical

standby database for all production instances.

. Replication of data from Production to Model using Oracle Streams

. Tuning database and resolution of performance issues using ADDM, AWR, ASH

reports, SQL tuning and access advisors, tkprof traces and explain plans.

. Supporting production releases and builds.

. Rebuilding entire linux server in a very important production environment

after file corruptions, including installation of OS, creating logical

volumes using Red Hat Linux LVM, installation of Oracle software,

application of patchset 10.2.0.3 and recreation of all application

databases from tape backups, completed within 24 hours.

. Daily support for production issues and tuning and production rollout

changes.

. Primary Oncall support for production databases.

. Partitioning key production databases for easy manageability, space

saving and performance enhancement.

SQL Server DBA Responsibilities

. Tuning queries for application using index compression, partitioning and

indexed views.

. Implementation of maintenance plans for backup for all production and

development databases.

. Supporting all production and development databases.

Technology: Oracle 10g, RMAN, Data Guard, Oracle partitioning, SQL Server

2008R2, Red Hat Linux 5, Windows 2008

Bloomberg Financial, NJ

February 2008 - July 2008

. Prepared SQL and PLSQL scripts to set up business data as per requirement

for BDAP application.

. Stress testing database packages and procedures for evaluation of

performance in MODEL environment.

. Taking initiative in meeting development team on weekly basis, helping in

troubleshooting performance issues, reviewing PLSQL package codes,

tracing the code to detect waits and bottlenecks.

. Involved in tuning Oracle database packages and SQL statements using

explain plan and tkprof utilities. Benchmarking top DB time/buffer gets

consuming SQLs in Performance environment.

. Deployed database changes in staging, UAT and Production environments.

. Troubleshooting database performance using AWR and ADDM reports.

. Restoring Dev/QA databases from Production environment data using Oracle

Data Pump.

. Perform migrations of programs and database changes between Development,

QA and production environments and supporting change controls.

Marsh & McLennan, NJ

November 2006 - February 2008

Oracle DBA Responsibilities

. Creation of database schema and setting up of database security.

. Tuning of Oracle database packages and stored procedures with autotrace,

explain Plan and tkprof utility in conjunction with SQL tuning and SQL

access Advisory utilities of ADDM.

. Actively involved in data modeling aspects of different subject areas of

application projects.

. Installation of 10g databases in production on IBM machine

. Installation and configuration of Oracle 10g on Red Hat 3.0 ES in MODEL

environment.

. Creation of databases and templates using DBCA and SQL scripts and

related parameter file configuration.

. Planning and implementing Backup and Recovery of the production database

using RMAN.

. Restoring Dev/QA databases from Production environment data using RMAN.

. Assists with impact analysis of any changes made to the database objects.

. Proactive Database monitoring using ADDM.

. Installation and configuration of Quest Foglight on UNIX system.

SQL Server DBA Responsibilities

. Administering Clustered SQL Server 2005 Database, preparing maintenance

plans and jobs for daily backups of production database.

. Installation SQL Server 2005 and applying Service Pack patches.

. Installation of SQL Server 2005 Failover Cluster on dev, QA and PROD

environments.

. Creation of Training databases by restoration of production database in

SQL Server 2005.

. Upgrade from SQL Server 2000 to SQL Server 2005 SP1

. Implemented database mirroring and log shipping for failover, disaster

recovery and Reporting.

. Creation of login accounts, managing roles and accesses for users for SQL

Server Database.

. Build, implement, and review database change scripts in SQL Server 2005.

. Database capacity planning and disk layout configuration for new SQL

server installations.

Bookspan (Bertelsmann AG), NY

November 2004 - November 2006

. Database support for CMS (catalog management system), an Oracle Forms

Application used by Marketing and Sales Department.

. Planning backup and recovery strategies for production databases.

. Upgrading key production databases from 9i to 10g.

. Implementation of partitioning for archiving historical data and tuning

performance of online queries.

. Testing production change control scripts on MODEL db environment and

suggestion for improvement of performance.

. Creation of stored procedures in DB and form level procedures for

application using PLSQL.

. Technical Lead in Oracle forms development team, reviewed and tuned forms

trigger and PLSQL code, suggested performance improvements, coordinating

product quality testing and production rollout.

. Installation and support of Oracle forms 9i, Reports 9i and Oracle

Application Server on unix platforms.

. Capacity planning of production databases.

National Medical Health Card (SXC Health Solution), NY

October 2003 - November 2004

. Creation of application user accounts, maintenance of database scripts,

testing and tuning of database packages developed by application

development team.

. Created and tuned stored procedures for Crystal reports using ref

cursors.

. Created materialized views for reporting application and set up database

scripts for refresh of materialized views.

. Put SQL and PLSQL standards in place to ensure that all application

design and code is produced with proper integrity, security and

performance and perform reviews on the design and code frequently to

ensure the site standards are being adhered to.

. Implemented backup and recovery of the Oracle database using RMAN and

export utility.

. Implements collection of statistics on tables and indexes of the Oracle

database using DBMS_STATS utility.

. Performed migrations of programs and database changes between

development, QA and production environments by deployment of DBCRs and

ADBCRs.

. Setting up of Oracle Shared Server for OLTP environment with concurrent

connections.

. Recovering production database from loss of application data files due to

disk controller crash.

Oxford Health Plans Inc. (United Health Care), CT

October 1999 - September 2003

Oracle DBA Responsibilities

. Supporting databases, reviewing PLSQL codes, tuning applications and

production change controls.

. Developing backup and stats collection scripts for production databases.

. Performance tuning using explain plans and tkprof traces.

. Provided database support for Carewise application, a 24/7 Oncall triage

system used by nurses.

. Created materialized views, developed strategies to replicate data,

tested and documented new Oracle 8i features.

. Tested recovery of database in sandbox environment.

. Installation of software and creation of Test and development databases.

. Coding database triggers and database packages in PLSQL for auto

precertification and authorizations for back end validations and

incorporation of business rules and constraints. Wrote the entire

database package in PL/SQL, over 5000 lines coded. Also coded the

database package in PL/SQL for notification of admission.

. Programmed various adhoc reports for maintenance and quality management

in Oracle SQL, PL/SQL and PRO*C. The clients are NY Attorney general and

CT Department of Health. Extensively coded many Batch jobs in Korn Shell.

Scripting.

Programmer Analyst Responsibilities

. Main Coder/application DBA in carewise Project for 24/7 Oxford On-call

Replacement. Coded 10 forms (On-Call Entry, On-Call Review, admin, etc)

in Oracle Forms 6i. Coded 7 reports (Fax Summary report, Open Action

Report, etc) in Oracle Report 6i and coded batch reports (On-Call

Extract, Women health call extract) in K-shell and Oracle SQL.

. Coded various PLSQL scripts for extracting hospital claim data (~ 5

million) for data warehouse load

. Coded Java applications in JSP and Servlets using Iplanet Application Web

Server for HIPAA. Programmed several utility, business and data action

classes in Java for Shared Service in HIPAA. Main developer for building

10 response pages in JSP for pre-certification, referral and notification

of admission authorizations. Programmed the Open Action and End of Day

Reports in PRO*C.

ITC Infotech, NJ

November 1997 - October 1999

. Worked as a database consultant in various Oracle SDLC projects and

clients like Merck-Medco, NJ and First USA Bank, PA. Developed codes in

PLSQL, PRO*C for backend batch processing and worked as an Oracle Forms

and Reports Developer.

Techna, India

April 1996 - November 1997

. Worked on various projects like Financial Management Systems for Kolkata

Tram Company, Billing Systems for Usha Beltron as an Oracle programmer

coding applications on Oracle Forms, Oracle Reports and PLSQL.



Contact this candidate