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.