SUMMARY

Primary skills: Oracle Apps DBA 12.1.3 from 11.5.10
Oracle Core DBA -11gR2 from ,7 with OCP 8i,9i and10g
Oracle HA Solution - RAC, ASM, Dataguard physical and Logical standby
Backup – RMAN using Tivoli, Lightspeed, Commvault, Hitachi Shadow Copy
Replication Technologies- Oracle Goldengate, Streams, Advanced Replication
Oracle OEM Grid Control , Shell scripting
Database Administration on Solaris, HP-UX, OEL, Redhat, AIX

SUMMARY

Over 14 years of Oracle Database Administration with 5 years of Apps DBA experience involving data modeling, database design, development , implementation on multi terabyte databases, preparing strategy on DBA roadmap , customer support and maintenance on Oracle, UNIX and Windows environments.

Over 12 years of strong DBA experience in the setup and maintenance of data warehouse, client server and WEB applications for very large installations.

• More than four years of Data Modeling and Database Design experience including preparing E-R diagrams, Dataflow Diagrams and studying user requirements.
• Administered SQL Server 2000,2005,2008
• Oracle performance tuning using AWR, Trace Analyzer, Explain Plan, statspack, utlbstat / utlestat, tkprof..
• Expertise in UNIX Shell Scripting and Perl programming
• Expertise in writing and debugging of Stored Procedures/Database Triggers/Packages
• Experience in using SDLC processes in development and production environment
• Sound knowledge of ORACLE Database Administration
• Sound Administration knowledge in HP-UX, Linux, Solaris and Windows 2000 that is needed for a Oracle DBA
• Implementation and maintenance of High Availability Dataguard on Oracle 10g.
• Managing and implementing Backup and Recovery strategies.

CERTIFICATION
OCP 10g, 9i ,8i Certified Database Administrator
Attended one day RAC training in Oracle campus in Redwood shores
Attended 5 day Oracle Education Training for Oracle RAC

EDUCATION
Master of Computer Applications

Languages : C, C++, Pro*C 2.2, Perl, Java Operating System : Solaris, AIX, HP-UX, Linux, Windows Database : Oracle 11gR2, 10gR2,Oracle 9I,Oracle 8I, MS-SQLServer,Teradata Hardware : Sun sparc ultra-4, E 450 Model 2400, HP superdome Front End Tool : Designer 9i Data Modeling Tool : ERWin3.51, Visio 5.0 DBA Tool : TOAD, DBArtisan,confio , Oracle Grid control Job Automating tool: Autosys,Tidal

WORK EXPERIENCE

DBA III , Confidential,Rancho Cordova ,CA

Project #1

Period Nov’2010- current Environment HP-UX 11.31 (IA) 11.23(PA-RISC) , Oracle 11gR2, 10gR2, 9i , Hitachi Storage,TSM, Quest Leo Lightspeed backup with Tivoli ,Oracle Golden Gate, SAP BODS, Oracle EBS 12.1.1, 11.5.10 Responsibility

• Oracle 11gR2 installation with GI , upgrade and implementation on HP-UX itanium, Solaris
• Implementing and maintainging multi-terabyte ASM
• Maintaining extensive implementation of Logical standby database
• Hitachi shadow copy implementation for 11gR2 on ASM
• Implementing RMAN duplicate from Active database.
• Implementing Active dataguard and snapshot standby database .
• Moving database from non-ASM to ASM .
• Configuring TDE with 11g Tablespace encryption
• Completely scripted building physical standby ,logical standby database.
• Working on Goldengate to maintain the Enterprise datastore . developing extract/replicate between Oracle and Sql server.
• Configuring Goldengate to use ASM with TDE implementation.
• Using Goldengate to upgrade Oracle DB from 10g to 11g .
• Maintaining SAP bods which is the enterprise ETL tool in Delta Dental.
• Oracle EBS installation, upgrade, patching ,cloning on 12.1.1 and 12.1.3

Cloning the Oracle Applications from Production to Development servers.

Senior Database Admin , Confidential,San Jose,CA

Project #2

Period Aug’2009- Oct’2010 Environment Solaris, RHEL , Oracle 10g, 9i , commvault backup ,Oracle EBS 12.1.1 Responsibility

• Fixed the database corruption for the 1.2TB Adobe Online ecommerce store database
• Worked on moving the ecommerce DB to a 4 node RAC cluster running on Veritas CFS and SFRAC
• Working on a 2TB Oracle datawarehouse running on 3 node RAC using ASM on RHEL .
• Implemented a Readonly and hot standby for 3 node RAC and perform switch over
• Working on Redesigning of the Enterprise Datawarehouse for performance issue .
• Migrated single instance database to RAC database.
• Performance troubleshooting on RAC environment
• RAC switchover test exercise for a 3node rac into 1 node physical standby
• Cloning single instance database to RAC
• Implemented a read only reporting standby for a 4 node RAC
• Extensive work on partitioning covering range, hash,list, subp artitioning template, extensive work on materialized view, query rewrite, partitioned mv, fast refresh,mv purge
• Extensive work on parallel processing, query tuning using parallel server process
• AWR report analysis and tuning
• Involved in Design and troubleshooting performance issues for a TB datawarehouse project running on Oracle 10g 2 node-RAC in Linux x86-64.
• Creation of standby database for RAC , switchover testing . and creation of reporting database with scheduled log apply.
• Using Cross platform for moving oracle database from solaris to Linux .
• RMAN recovery using tabeslpace point in time and skip method.

Senior Oracle DBA, Confidential,Pacheco, CA
Project #2
Period : Feb’2008- Jul\'2009
Environment: AIX 5.3, Solaris 9, 10. Oracle 8i, 9i, 10g, SQL 2000,SQL 2005, Teradata V12,Oracle EBS 11.5.10 , EBS 12.1.1

Responsibilities

• Installation, upgrade , patching and maintenance work on EBS 12.
• Implemented a 2 node solaris RAC on ASM with physical standby and logical standby
• Created a RAC deployment planning and installation document for the team.
• Performed RAC upgrade , downgrade , Node Addition, Node deletion,
• Configure RAC TAF.
• Working on failover in VERITAS cluster configuration.
• Creating physical standby , broker configuration and maintenance of DG environment
• Regular one-off and quarterly Oracle Security patching
• Performed production recovery
• Using Oracle Streams to replicate a set of tables across different application (Active-Passive)
• Working extensively on application using partitioning .
• Database characterset change
• Implemented Security and Auditing for 9i and 10g databases for centralized EIS monitoring
• Database upgrade from 8i to 10g.
• Database and Grid control upgrade to 10.2.0.4
• Performance tuning and regular troubleshooting.
• Regular Administration activities.
• Scripting for hot backup ,data pump .and rman for Solaris,AIX .
• Implemented a utility using pl/sql to switch database password resets from the database group to helpdesk unit thus saving a lot of man-hour for database group.
• restore , recovery and refresh of oracle databases
• Administering people soft, Hyperion database.
• SQL2000 to SQL2005 upgrade
• used SQL2005 integration services to create a clone database
• SQL server database backup /point in time restore.
• Log shipping configuration and automation in SQL2005
• SQL Server installation , DTS , job creation, maintenance plan
• SQL Server cloing , upgrade from 2000 to 2005 , user creation , application installation
• Teradata database creation, user ,roles,profile creation.
• Writing bteq ,fastload scripts
• Creating Teradata incident with Teradata to resolve issues

Oracle DBA, Confidential,Concord, CA Project #3 : Smart Link Project Period : June’2007- Feb\'2008 Environment : Solaris 8, 9, Suse Linux, Oracle 9i, 10g, vmware, ubuntu, Windows

Description:

This is a project by which all the transport carriers in bayarea (AC transit, BART, MUNI..) will be connected via one smart card. The commuter will be having only one point payment system.

Responsibilities

• Implementing RMAN backup strategy and writing extensive RMAN scripts across all the production stand alone and data guard databases
• Extensive Involvement in implementing 10g Grid control for one point monitoring and Administration of all the databases
• Migrating Oracle db from windows to Solaris using STREAMS
• Extensive use of data dump to refresh schemas between test and production
• Using Oracle Streams to do online refresh
• Building 9i,10g dataguard and creating and synching standby using RMAN
• Install, upgrade for Oracle 10g from the 9i on Solaris, Linux .and Windows Server
• Extensive performance troubleshooting and regular maintenance activities.
• Using rsync, SCP, perl, ksh scripting.
• Implementing Oracle Partitioning for the tables creating I/O bottleneck.
• Exploring TDE for the application storing customer credit card information
• Creating extensive outlines(9i db) and sql profile (10g) for the third party CRM application

Pivotal, mtrx.

• Using Oracle Logminer to read archive log content to assist application troubleshooting.
• 27*7 On call support for all the databases

Oracle Consultant, Confidential,San Francisco, CA Project #4 : Electronic Claims Filing Period : Jul’2005- June’2007 Environment : ia64 hp superdome server SD32B, Oracle 10GR2, Java, C, perl

Description: This is a Claims information system database. This is a 300g+ database which stores and controls the California state wide workers insurance claims.

Responsibilities

• Managing schema objects and space allocation parameters for storage structures.
• Tuning SQL statements and Trouble shooting performance problems
• Implementing Oracle 10g , 9i New Feature as Undo Management, locally managed tablespaces, multiple block size tablespaces, partitioned tables & their maintenance
• Designing backup strategies, writing scripts for automated hot backup of database using RMAN and normal backups. Database cloning using RMAN.
• Performance tuning of SQL and PLSQL Scripts,
• Usage on ADDM, AWR, ASH, sql profile, 10g Grid control.
• Automating Administrative tasks by scheduling Jobs, Alerts, and writing UNIX k-sh script to automate most of the jobs using cron. resolving problems, troubleshooting and ensuring continuous operational excellence while resolving issues such as backup failures, job failure ,locking issues, space issues
• Extensive experience with SQL, PL/SQL, Import, Export, SQL*Loader, RMAN. Managing Data Files, redo log groups & Redo Log files, Controls Files and Archive log files
• Snapshots replication.
• Knowledge on UNIX administration, usage on Glance, top, sar, vmstat.
• Extensive scripting using ksh, awk, perl.
• Developed few standalone components using Java and C.

Oracle DBA. Confidential,CA Project #5 : Enterprise decision support system. Period : May’2005- Jul’2005 Environment : Sun OS 5.8, Oracle 9iR2, Autosys,Perl,

Description: This is a sales and distribution decision support system . Development of database interface between an Oracle Warehouse database and an OLTP System(SAP R3). The interface was built to load Customer, Product and Sales from OLTP system to the Warehouse database on nightly basis. The interface essentially implements an ETL model using PL/SQL, SQL LOADER and batch jobs..

Responsibilities

• Oracle 9i Installation
• Implementing Oracle 9i New Feature
• Database cloning and using export and import mechanism
• Undo Tablespce Development
• Performance tuning of SQL and PLSQL Scripts,
• Performance Enhancement
• Writing PL/SQL scripts, procedures and packages

Oracle Consultant, Confidential,San Francisco, CA Project #6 :My Customer View Period : Sep’2004- May’2005 Environment : Sun OS 5.8, Oracle 9iR2, Autosys,Perl, NDM Description:

This project basically receives information about wholesale customers from the other various wells fargo banking application and consolidate it and presents to the customer . This presentation is build based on varying business requirement upholding the banking policy.

Responsibilities:

• manage change control,project change requests, and defect management in upcoming project
  releases.
• Using Autosys as the batch job running interface .
• Extensive PL/SQL coding for data cleaning and data transformation.
• NDM data transfer method is used while transmitting the different SOR data into MCV..
• Coding of SQL Loader control files and PL/SQL procedures for loading data into Oracle Tables.
• Huge perl scripting with Oracle DBI for creating a backbone for all the batch jobs.
• On Call Pager support during the batch window that runs at night .
• Handling ll the production maintainance and Change request ,trouble ticket .
• Trouble shooting the defects or any db issues and coordinating with the Bank internal customers
• The single poiint MCV db backend support.

Oracle DBA, Confidential,San Francisco, CA Project #7 :Electronic Claims Filing Period : Dec’2001- Sep’2004 Environment : HP UX 11.0, Oracle 8.1.7.3, Designer 6i, Designer 9i Java, Web Forms Description:

This is a claims processing system. The present system was built on Acu-COBOL .It is now architected to a normalized relational architecture based on Oracle 8i which saves lot of administrative/ maintainance overhead with a single point of changing functionality requirements controlled by Designer 6i.

Responsibilities:

• Designing the Interface system for the migration of Data from Microfocus-COBOL to ORACLE.
• Installation of Oracle 9iR2 on HP UX 11 and set up of development environment
• Extensive PL/SQL coding for data cleaning and data transformation.
• Automating the file transfer using FTP through shell scripts.
• Coding of SQL Loader control files and PL/SQL procedures for loading data into Oracle Tables.
• Korn Shell Scripting using AWK and SED
• Using AWK for dynamic generation of Oracle DDL Script from COBOL copybook.
• Using Java for writing jdbc program for CLOB and IMAGE data.
• Using Java for Error Analysis from O/S Database Log file.

Oracle DBA, Confidential,Mountainview, CA Project #8 : Precision Pricing Period : Dec’00-Oct’2001 Environment :Sun OS5.8,Oracle8i,ERWin3.51,MS-SQLServer,TOAD,DBArtisan, Developer/2000 –Forms 6.0 , Reports 6.0, Pro*C, Perl Description:

This is a pricing and Revenue Optimization product which is used for recommending optimized prices and forecast the demand of the product in different channel segment e.g like internet,retail considering the past sales history and current inventory . SQL Loader, PL/SQL procedures and shell scripts are used for loading the Oracle tables. DTS jobs are used to populate the SQL Server tables. The External interface System is built using Developer/2000 –Forms 6.0 ,Reports 6.0 and pro*C to take care of the future Reporting and Planning needs of the Company.

Responsibilities:

• Data Modeling and coordinating with DBAs/Sys Admins to finalize the user schema and space requirements.
• Specifying business guidelines and preparing requirement specifications for the development team
• Reverse engineering and forward engineering using ERWin from SQLServer to Oracle at the initial stage of migration.
• Using Pro*C for Back End Reporting
• Performance Tuning of SQL queries using indexes and proper join conditions in the correct order as well as checking the execution plan. Application tuning using Hints, dynamic creation and dropping of indexes
• Creating DTS jobs to load data into SQL Server tables and coding stored procedures for data validation.
• Creating entries in the Crontab for automating the data loads in UNIX.
• Using Win CVS
• Preparing test logistics/scenarios and planning for production deployment
• Assisting PM in signing off deliverables on time.
• Extensive Back End coding using PL/SQL and T-SQL
• Using Pro*C for Back End Reporting
• Application tuning using Hints, dynamic creation and dropping of indexes
• Developed an utility to generate Control files for Sqlloader use for the entire schema
• Migration of complete sqlserver product development to Oracle
• Extensive Shell scripting using k-shell
• Developed an utility to generate dynamic incrementation of sequence to be in sync with the external interface e.g. dataloader
• Using Oracle8i features of Global temporary tables,extend the management materialized view.
• The Batch Program was rearchitectured for smooth plug n play for modularization
• Developed perl utilities for day-to-day development needs
• Writing necessary shell scripts integrating with PL/SQL program unit for purge jobs
• Developed a module in T-SQL for DB Comparing in SQLServer.
• WebLogic configuration, connection pooling and developer troubleshooting

Oracle DBA, Confidential, Project #9 : G2 System Client : Confidential,Atlanta Period : Sep2000 –Nov2000 Environment : Oracle 8i, Sun OS 5.6, ERWin 3.51, TOAD,Pro*C Description:

This is a website development Project involving Conversion of existing flatfile driven Perl internet application to oracle8i driven powered by BEA Weblogic Commerce Server coupled with Weblogic Server 5.1 to meet the dynamic increasing industry requirement .

Responsibilities:

• Oracle Schema creation by studying the Usecases. Database Design using ERWin 3.51
• Integrating with WLPS Schema and Zope Schema.
• Installation of Oracle 8i on E450
• Enabling Spatial Option for Geocoding ..
• Using Partitioning , Transportable Tablespace,RMAN feature
• Analysis of Redo Log using Logminer for security purpose.
• Data mapping and Data porting .
• Preparing Backup and Recovery Strategy.
• Writing Batch jobs to clean DB in specified interval.
• Weblogic Connection pooling configuration and Troubleshooting

Oracle DBA, Confidential,Pune,India Project # 10 : MicroJ Plus Client : Confidential,Pleasanton Period : Jan’00- Aug’00 Environment : Oracle 8i, Sun OS 2.7, Windows NT, Erwin 3.51, Oracle Tools & Utilities like Export, Import, SQL*Loader, TOAD, Pro*C on Windows Description:

This is a web based Staffing Project Here the existing legacy system is reverse engineered and remodeled to make it web enabled. The emphasis was to make a central point database administration and enhancement of the Searching capabilities which reduces the time for finding a right candidate according to his skills, experience and preferences and information pertaining to a candidate like timesheet filling, paychecks payment, leaves.

Oracle Developer/DBA, Confidential,India Project # 11 : multiple inhouse projects with DBA on the Seeds Marketing System Period : Dec’97- Jan’00 Environment : Oracle 7,8i, Digital Unix 8200, Sun OS 2.7, Developer 2000,Pro*C, Oracle Tools & Utilities like Export, Import, SQL*Loader