SHASHI KAUSHIK
Kaushiksbk@hotmail.com
#714-515-2737
EXPERIENCE SUMMARY
•	Over 14 years of IT experience in Administrating Oracle Production Databases
and Oracle Application Administration as well as in Development, testing using
Oracle. Supported production databases 10g, 9i, 8i and 8 and Oracle Applications
11.5.7 and 11.5.8.
•	Certified Oracle DBA (OCP) for 10,9i, 8i,8 and certified PMP.
•	Supported OLTP databases with complete release cycle, tracking and managing
the database changes using Clear Case/ Clear Quest.
•	Supported data warehouse databases of more than 3 T size.
•	Implemented Data Guard for replication and fail-over of databases. Tuning
SQLs, Memory, SGA and other init.ora parameters for optimal performance of
database.
•	Replication using Oracle replication and Shareplex and Oracle Streams.
•	Extensive experience in working with Oracle support in resolving TARs,
escalating tars, applying patches and upgrading Oracle Applications.
•	Excellent team member experience working in a team environment,

CERTIFICATIONS: 
•	Certified ORACLE 10g, 9i, 8i DBA and 8 DBA from Oracle (OCP).
•	Certified PMP from PMI.org.
•	Oracle 9i RAC Training from Oracle Coporation.

PROFESSIONAL EXPERIENCE

Deloitte, Inc.
Feb’ 07 –Present
Responsibilities
•	Designing and developing databases. Supporting developers on day to day basis.
Preparing data scripts for defects.
•	Supporting multiple Oracle 10g databases, periodically refreshing DEV, Test,
PAT and Stress environments using backups data pump export. 
•	Managing database scripts for different builds, version controlling  and
preparing scripts for release to court, testing release scripts etc.
•	Writing PL/SQLs to support developers to fix issues related to database.
•	Upgrading databases from 9i to 10g, preparing documentation to write down the
instructions to upgrade court databases. Applied CPUs.
•	Writing shell script to run batch jobs and monitoring databases.
•	Performance tuning databases, query tuning, slow performance, etc.
•	Supporting Logical standby database to reporting purposes using 9i.

Ameriquest, Inc.
Feb’ 04 –Feb’07
Responsibilities:
•	Leading a team of 4 DBAs to support various Database environments for
Ameriquest Mortgage.
•	Supporting Oracle 10g and 9i production OLTP database for Ameriquest
mortgage.
•	Supported data warehouse database of more than 3 Terabytes.
•	Performed number of schema refreshes from production to test and dev using
data pump.
•	Implemented Logical standby database to reporting purposes using 9i.
•	Implemented Shareplex for replication of production EMPOWER database for
reporting purposes. 
•	Planning and taking backups and disaster recovery plans. Using RMAN to backup
and restore/refresh databases.
•	Applied Server patches to upgrade from Oracle Server.

Network Appliance, Inc.
Feb’ 01 – Feb’ 04
Responsibilities:
•	Lead a Team of 3 DBAs to support various database environments.
•	Administration of 9i, 8i and 8 databases.
•	Capacity planning and disaster recovery strategy in case of disaster. Goal was
to achieve 99.9999% availability of production databases.
•	Performance tuning databases, SGA, memory and init.ora parameters for best
performance of databases.
•	Backup/restore of databases using Netapp’s snapshot technology.
•	Replication of database using Shareplex for reporting purposes.
•	Replication of database using Data Guard.
•	Wrote shell scripts to take backup and monitor databases. 

Millennium Vision Corp.
Sep’97 – Feb’01
Responsibilities:
•	Data modeling to design and implement the database.
•	Managing Rollback Segments and Temporary Segments. Reducing contention for
Rollback Segments. 
•	Tuning Memory allocation, tuning I/O and reducing contention.
•	Tuning SQL statements to improve the performance of SQL statements. 
•	Supported Production and Data warehouse databases.
•	Taking cold and hot backups and designing and implementing Backup/Recovery
strategies. 
•	Supporting to clients for their day-to-day problems.
EDUCATION
•	MS in Computer Science