TECHNICAL SUMMARY
Oracle DBA (10 yrs.), Production Support (7 yrs.), Performance Tuning (7 yrs.), Oracle 9i (4 yrs.), Oracle 10 g (4 yrs.), RAC (1 1/2 yrs.), Sybase (2 yrs.), Solaris (8 yrs. – on & off), Dataguard (2 yrs.), DB Artisan (1 yr.)

TECHNICAL SKILLS
Software: Oracle 10g/9i/8i/8.x/7.x, Oracle 9iAS, PL/SQL, Sybase 4.9, (DB-LIB), CCP/RT (Tuxedo), Ingres QUEL, SQL), NMAKE, SCCS, C, C++, KSH, Perl, CSH, AWK, Turbo Pascal, 8086, Assembly, Fortran 77
O/S: Sun Solaris, Sun OS, HP UX, UNIX System V, BSD 4.3, Windows

EDUCATION
MS, Computer Information Science

NATIONALITY
US Citizen

PROFESSIONAL EXPERIENCE

CONFIDENTIAL, 08/2010 --- Present
Oracle DBA

• Upgrade 11g Grid Control to 12g Cloud control.
• Install and Maintain Three Node RAC Databases with ASM.
• Set up Three Node RAC replication to single node Data Guard Database.
• Wrote autosys job to monitor Data Guard replication using SQL and Ksh script.
• Fine tuning adhoc queries and recommending changes to queries and database parameter changes.
• Refreshing 11gR2 Databases using Duplicate Active Databases (Rac and Non-Rac)

Confidential,10/2008 --- 08/2010
Oracle DBA

• Supporting complex back office environment consisting of 50 plus Production and 200 plus non-production

Databases, running on Linux/Solaris environment.

• Migrated few oracle 9i databases to 10.2.0.4 and set up grid as will as OMS agent for PROD databases.
• Tuned adhoc queries using 10046 trace and AWR reports.
• Diagnosis performance issue with truss (tusc,strace), lsof, pstack.
• Setup ASM 10g database instance on Sun M5000 machine running with Solaris 10.
• Install and configure RAC Instances on Linux OS.
• Fine tune RAC performance using strace and OEM.
• Support RCA databases running on Linux.
• Familiar with OS utilities like truss, dtrace, sed, nawk etc
• Supported DR testing for 20 plus Production databases.

Confidential,10/2007 – 10/2008
Oracle DBA

• Supporting Trading system which is being used by 3000 plus users on Sun Server running on 9.2.07 Database.
• Wrote monitoring scripts which lists 20 top CPU consuming queries using OS utility and Data Dictionary views.
• Wrote scripts to generate reports for top Consuming resources using perfstat tables.
• Tune batch as well as adhoc queries using 10046 and 10053 events.
• Created standby and used standby to refresh QA and UAT systems.
• Restricted rows level access by setting VPD to few critical tables.
• Tuned rman backup so that backup time reduced by 50% of backup time.
• Tested upgrade process from 9i to 10g Database.
• Configured grid environment for 10g Databases.

Confidential, 08/2006 – 10/2007
Oracle DBA

• Supporting 12 Terabytes of production 9.2.0.6 Oracle Database on HP-UX superdome machine.

This involves tuning of queries as well 7/24 support.

• Modified rman script so that backup is taken directly to TAPE Library instead of Disk.
• Setting up OEM 10.2.1.0 catalog Database to monitor 9i and 10G Databases. This involved setting up

agents and configuring all major alerts.

• Upgrade 9i Oracle Database to 10g Release 2 Database using dbua utility.
• Applied Oracle security Patches in Development, Test and Production environment.
• Maintaining partitioned tables, creating new partition, rebuilding global and local indexes.

Confidential, 01/2000 – 07/2006
Oracle DBA

• Installed 10G Release 2 Software on HP-UX and Solaris Servers.
• Upgraded 9i Databases to 10G release 2 Databases.
• Implemented RESUMABLE_TIMEOUT at database level.
• Installed Oracle 9i Application server and configured Apache web and Forms Server, IFS, ifs mgr etc.
• Installed Oracle 9i Database Server, created transactional as well as Data Warehouse Database.
• Created a snapshot from Transactional Database to Data Warehouse Database.
• Automated refresh from PROD to DEVP Database.
• Wrote 9i Database Backup scripts for 7/24 system Using RMAN, this involves installing MML for EDM, creating Catalog database, Registering Database in EDM as well as in Catalog and writing Shell script which reads from RMAN configured file and accordingly backup hot, cold to EDM tape using multiple Channels.
• Upgraded Oracle from 7.3.4.2 to 8.0.6.3 and 11.0.3 Oracle financials.
• Responsible for setting up Web server and form server on application box.
• Responsible for setting up development, patching and QA environment.
• Refreshed database from production to development and patching environment using EMC BCV sync/split.
• Refreshed APPL_TOP and CUSTOM_TOP, re-linking APPL_TOP for the development environment.
• Applied patches on PATCH and production instances.
• Unsecured, Generated DBC files and setting the profile for the development environment
• Wrote monitored scripts, Reorg of database objects etc.
• Involved in installing and setting Matrix Server for load balancing.
• Configured shareplex for reporting Instance, Activate configuring, Monitoring Sync and created appropriate Indexes for the performance.
• Familiar with ad patch, ad admin and ad relink.
• Configured Ariba application for four business units and wrote scripts to automatically sync to DEBUG server and start application.
• Set up Oracle Dataguard as asynchronous mechanism. This was implemented to replicate OEM Catalog database.
• Responsible for performance Monitoring using Quest Central 4.0 and homegrown scripts to monitor each session and SGA.
• Used TUSC (truss) to monitor UNIX process whenever any performance issue.

Environment: Oracle 10g/9i/8i/7.x, Oracle Financials 11.0.3, Oracle 9iAS, RMAN, Shell Script, Sun Solaris (12K Server), HP UX

ORACLE DBA CONSULTANT 03/1989 – 01/2000
Projects were as follows:

Confidential, (New York, NY) 05/99 – 12/99
Oracle DBA

• Responsible for setting up stand by environment for the PeopleSoft 7.0 running on HP-UX 10.20 with Oracle 7.3.4.4. Test standby switch over by changing machine name and IP address.
• Migrated Oracle and PeopleSoft from T600 to K570 HP Box with EMC Symmetric.
• Wrote Hot Backup script and Alert Script for space management.
• Tuned PeopleSoft application queries.
• Created snapshots to replicate tables from production database to data warehouse instance.
• Installed and configures EBU with omni back for backup and recovery.

Environment: Oracle 7.3, PeopleSoft 7.0, HP-UNIX 10.20