SUMMARY:

• Over sixteen (16+) years of experience in IT field and over 12 years in Design, Development, Deployment and Administration of Oracle 7.x/8.x/9i/10g/11g Databases in UNIX and Windows environments.
• Over four (4) years in applications development using \'C\', UNIX SHELL SCRIPTS, SQL, PL/SQL, PRO* C, JAVA, JDBC, EJB, XML, C++, PERL, HTML, Oracle Developer/2000 & Oracle Designer/2000, ERWIN.
• Currently supporting Oracle 9i/10g/11g Databases of size 5 Tera bytes for Web-based applications of under 24x7 high –availability on Solaris 2.x/AIX 5.x/Linux servers for a leading Financial Company.

• Oracle server Installation, configuration, Administration & Troubleshooting.
• Upgrades & Migrations
• Dataguard & Standby
• RAC & Oracle Streams
• Performance tuning & Data modeling ( ERWIN)
• Unix shell scripting & Advanced Replication
• Datawarehousing ( VLDB ) , OLTP & Partitioning
• SAN & Veritas Netbackup.
• EMC symmetrix & BCV backup
• Team Leadership
• Golden Gate

TECHNICAL Skills:

Hardware:
SUN-ULTRA, Pentium-II, SGI Octane/O2, Micro VAX, HP 9000, SUN E5K/E10K, SUN 2900 , IBM RS6000, DEC α, HPLH6000R, SUN CLUSTER 2.2, SUNT5240, EMC Storage Devices,
Compaq Proliant, Pentium

O/S:
Solaris 2.x, SCO-UNIX, IRIX 6.x, Open VMS, WIN/2000, LINUX, NT 4.0, HP-UX 10.x/11.x, AIX 4.3 5.x, DEC UNIX 4.0, Win/9.x, NOVELL, Compaq Tru64

Languages:
C, SQL, PL/SQL, PRO*C, UNIX SHELL SCRIPTS, JAVA, HTML, PERL, C++, C#

RDBMS:
Oracle 7.1/7.3.4/8.0.5/8.1.6/8.1.7/9.2/10.2.0.3/11.1.0.6, SQL Server 7.0/2000, Sybase, Revolution 2000

GUI:
Oracle Developer/2000 (Forms 6.0, Reports 6.0), .net

CASE:
Oracle Designer/2000, ERWIN

ERP:
Oracle Applications 11i, PeopleSoft 8.x, SAP, Oracle Financials 10.x

Others:
BMC SQL_BACKTRACK, RMAN, BMC PATROL, Quest TOAD, VERITAS, CRM, SIEBEL, Oracle Discoverer 2000, NETBKUP, WebLogic server, ATG Dynamo, Quest SharePlex, IVR, Outlook 2000, MS office 2000

Consultant February 2000 - Present

Sr. Oracle Database Administrator December’ 2009 – Till Date
Confidential,NYC ( Consultant)
( Trading, Equities, Fixed income, Global Markets )

• Planned, Designed, migrated multiple Oracle 9i/10g/11g databases from Merrill lynch

To Bank of America platform .

• Migrated Oracle 9i/10g databases from between datacenters using different methods like Seed and Swing,

Fork lift, Datafiles copy .

• Installed, Configured Oracle 10g/11g databases on Red hat linux environments and later

Setup the dataguard between primary and DR sites and migrated database from Solaris to RHEL5.
This project completed for reporting/warehouse databases for trading applications involving netezza.

• Extensively used Datapump for migration of databases as well as for restoration of prod. Data

Into Dev/QA environments.

• Migrated & supported credit reference data platform application from Sybase 12.5 to Oracle 11gr2

In soloris 10 platform.

• Extensively used Oracle 11g features and also implemented best practices in multiple applications.
• Supported 200 production & 300 QA/Dev oracle 10gr2/11gr2 databases for Trading, Equities & prime Brokerage

Applications on 24/7 basis for OLTP and Datawarehouse environments in Dataguard/RAC/STREAMS
Advanced replication/ASM/VCS/EMC SRDF configurations

• Implemented and Supported & troubleshooted Oracle 10g Dataguard & Broker in production environment

for Failover sites as well as performed DR test.

• Supported Credit risk datawarehouse of size tera bytes using partitioned tables and ETL using Informatica.
• Implemented and supported oracle 10g/11g Streams replication between US & UK sites for Global markets.
• Designed , implemented & architected Portfolio tool build integrating countrywide, BoFA & Merril trading data into common

platform which is Oracle 10gr2 running on RHEL5

• Managed Portfolio tool build project from Database requirements , backup strategy, storage requirements

And implementing in Dev/QA/PROD/DR environments.

• Implemented and RMAN database backups ( Disk & netbackup tape ) and restored as per special request.
• Implemented Database releases for multiple complex applications in various environments for multiple trading & equity applications.
• Implemented & supported Database security procedures for global trading databases.
• Migrated multiple applications from solaris environment to CHP domain in Linix environment.
• Extensively worked on capacity planning & performance tuning of various applicatons and databases

In securities domain at Merril and Bank of America as per change control process.

• Implemented various Backups in OLTP & OLAP applications as well as restored from tape Whenever need arises.
• Pro-actively provided Database support to application developers as well as customers for troubleshooting as well as

Improving performance of the applications.

• Managed & implemented complex projects using Oracle 11gr2 databases.
• Migrated Oracle 10gr2 to 11gr2 in Solaris / Linux servers.
• Extensively used clarity Gridapp, autosys, crontab tools for installation & configuration as

Well as administration of Oracle 9i, 10g, 11g databases.

• Implemented Oracle 11gr2 datawarehouse for Precise 8.8.1 vendor application on RHEL5 server.
• Familiar with vendor relations such as Precise, Oracle for new products implementation.
• Interacted & resolved issues with help of oracle customer support for TAR’s raised in metalink.
• Troubleshooted Oracle 9i/10g Production and development databases from user end to Database end on 24x7
• Mentored Database administrators as well as hiring process.

Sr. Oracle Database Administrator September’ 2008 – August’ 2009
Confidential,NYC ( Consultant)
( Trading, Equities, Fixed income, Global Markets )

• Installed, Configured & Designed oracle 9.2.0.6/10.2.0.3/11.1.0.6 on Solaris 2.x/Aix 5.x/RHEL 5.x servers.
• Supported 100 production & 200 QA/Dev oracle 10.2.0.3 databases for Trading, Equities & prime Brokerage

Applications on 24/7 basis for OLTP and Datawarehouse environments in Dataguard/RAC/STREAMS
Advanced replication/ASM/VCS/EMC SRDF configurations

• Implemented and Supported & troubleshooted Oracle 10g Dataguard & Broker in production environment

for Failover sites as well as performed DR test.

• Implemented and supported oracle 10g Streams replication between US & UK sites for Global markets.
• Implemented and RMAN database backups ( Disk & netbackup tape ) and restored as per special request.
• Migrated test database from oracle 10g to 11g and implemented oracle 11g new features.
• Extensively used AWR/ADDM/ASH/explain plan/Grid control and performed application and database tuning.
• Monitored database alerts using Foglight.
• Performed oncall support for every 6 weeks.
• Extensively used Datapump for database refresh
• Pro-actively provided Database support to application developers as well as customers for troubleshooting as well as

Improving performance of the applications.

• Implemented multiple DB releases as per change control process for multiple trading & equity applications.
• Automated Database backups/Datapump export scripts using PERL & unix shell scripts.
• Implemented & supported Database security procedures for global trading databases.
• Extensively used Raw devices and unix filesystems for storing trading data.
• Extensively used OID for all Prod/QA/DEV databases in trading domain.
• Performed capacity planning for multiple production/QA/development databases.
• Guided offshore & onshore DBA team on Various DBA issues and activities.
• Performed BCV backup for VLDB databases.
• Troubleshooted Oracle 9i/10g Production and development databases from user end to Database end.
• Audited production/Dev/QA databases as well as compliance reporting.
• Monitored & resolved foglight alerts from Multiple production databases for various issues.
• Interacted & resolved issues with help of oracle customer support for TAR’s raised in metalink.
• Knowledge of Sybase/SQL server databases as well as datawarehousing products such as Natezza, Teradata

Environment: Oracle 9.2/10g/11g, SQL, PL/SQL on Solaris 2.x/AIX 5.x/RHEL

Sr. Oracle Database Administrator August 2003 – July’ 2008
Confidential,NY ( Consultant)
Projects: Global Wealth Management (Private Banking, Smith Barney,
Legal and Compliance, Investment and Actimize)

• Installed, Configured & Designed and deployed Oracle 9i/10g databases on Solaris 2.x/Aix 5.x/Linux servers in Production/UAT/ Development environments Globally
• Independently handled Production databases for Global Wealth management Group (Legal & compliance, Investment Research, Private banking, Smith Barney groups).
• Supported 150 production and 200 development databases for OLTP as well as VLDB on 24x7 (ONCALL, OFF HOURS and BUSINESS HOURS).
• Planned & Designed Database Capacity requirement for various financial applications.
• Designed & Implemented Actimize vendor application in oracle 10.2.0.3 database on Solaris server.
• Designed & Created and architected Business Intelligence databases of size Tera bytes involving BI/ETL tools.
• Managed BI / Actimize/ Risk system/BASEL/CCS/Legg Mason trading system Projects in Private banking,

SB & Legal and compliance groups.

• Performed Data integration, Cleansing & transformation in private bank datawarehouse.
• Designed and implemented transactional/ODS and datawarehouse systems for Private bank and Legal & Compliance groups.
• Implemented ETL solutions using Abinito and oracle procedures in transactional/ODS and datawarehouse systems
• Extensively used pl/SQL blocks and conversant with bulk insert statements.
• Performed Data modeling using Erwin tool.
• Deployed & implemented various application schemas for multiple projects successfully in dev/UAT/Prod

Environments.

• Troubleshooted Oracle 9i/10g Production and development databases from user end to Database end.
• Implemented Security features like Roles & privileges in datawarehousing as well as

Transactional databases as per Database security guidelines

• Performed Database and Application Tuning using OEM/TOAD/Shell scripts//STATSPACK/TKPROF/EXPLAIN PLAN/AWR/ADDM

Implemented Database releases in UAT/PROD environments as per Change control process

• Installed two node RAC software and configured databases.
• Extensively used srvctl, crs_, crsctl commands in RAC databases.
• Built parallel queries on RAC databases.
• Created services for various application needs.
• Applied various patches to RAC databases.
• Extensively worked in monitoring of databases for fragmentation, capacity planning, checking on errors in alert.log files for ORA-600 & ORA-7445 and resolved thru’ metalink / SR’s.
• Extensively coordinated with storage/ SA teams for multiple projects in SmithBarney/PrivateBanking/Legal & compliance.
• Extensively worked on Perfomance tuning of SQL queries and databases In Dev/UAT/PROD environments.
• Extensively used exp/imp, SQL*loader for logical backups and refreshing of Databases.
• Coordinated with Backup group for database backups using BCV and later Used for COB test as well as for recoveries.
• Coordinated with Storage group for configuration of SAN to Databases on Solaris servers.
• Designed, Configured & tested CCS database ( SIEBEL CRM) in Oracle 10.2.0.2 in Dev/UAT/PROD environments in EMC/SRDF mode.
• Implemented and supported Partitioned tables in all the environments.
• Extensively used RDA/streams for health check of databases.
• Implemented Shareplex for database replication in Oracle 10g databases.
• Extensively used vi, awk, sed and CRON utilities in day to day DBA activities.
• Implemented Oracle security patches for every six months.
• Followed Change control procedures for problem resolution and implemented DB releases in UAT/PROD databases.
• Extensively used Export/Import & Datapump utilities for refreshing databases.
• Extensively used shell scripts for backups with Compression techniques.
• Implemented Oracle Streams for database replication for reporting as well as Batch loading puropose.
• Performed Database recoveries whenever required.
• Implemented Grid control & ASM in Oracle 10g databases in test environment.
• Implemented various Oracle 9i/10g features in development & Production databases.
• Automated Database shutdown & Startup and backups using Korn shell scripting
• Configured &Supported Oracle 9i/10g dataguard in production environment.
• Monitored & Managed Oracle 9i/10g databases using OEM/TOAD/GRID control & shell scripts.
• Monitored unix servers using various administrative utilities.
• Configured BMC SQLBACKTRACK/RMAN to Netbackup server for logical and hotbackups
• Documented the various database from Project study to Project went live as well as During BAU.
• Configured & tested Oracle 9i/10g databases in Dataguard mode including failover and switchover modes.
• Guided, trained and managed 8 oracle DBA’s for multiple projects.
• Involved in setting up of backup jobs for FS and databases using Autosys scheduler
• Documented Design strategies of DBA projects.
• Designed & Architected Logical & Physical databases as per application requirements.
• Designed and implemented DB security procedures for different users as per Application requirements.
• Performed Cloning of databases as per request from the development team.
• Reorganized fragmented tables in production databases whenever required.
• Implemented DDL & DML as per the database releases in Production & development Environment
• Planned, Designed & Upgraded Oracle 9.2.0.4 databases to oracle 9.2.06.
• Planned, Designed & Upgraded Oracle 9.2.0.6 databases to oracle 9.2.0.8
• Planned, Designed & migrated Oracle 9.2.0.8 to 10.2.0.3

Environment: Oracle 9.2/10g, SQL, PL/SQL on Solaris 2.x/AIX 5.x/LINUX

Oracle Database Administrator February 2000 – July 2003
Confidential,CO ( Consultant)
Projects: MALTS (OLTP)/METIS datawarehouse

• Administered databases of nearly 2 TB in size.
• Installed, Configured, & designed Oracle 8.1.7/9.2 databases On Solaris 2.x, HP-UX 11.x, AIX 5.x servers in Production environment
• Established and maintained Oracle Advance security and integrity controls.
• Designed logical & physical data modeling and created high quality databases using

ERWIN tool.

• Designed , architected & Managed Logical structures like Tables, indexes, clusters,

Database links, Snapshots & physical structures like db files, log files.

• Replicated, monitored & managed Oracle 8.1.7/9.2 databases using Quest Shareplex
• Configured Users to Oracle databases using SQL*NET & Net8.
• Configured & Supported BMC PATROL on unix servers for database monitoring facility to SOS
• Configured & supported EMC RAID /SRDF on unix servers in SAN environment
• Monitored unix servers using administrative utilities
• Designed database tables using various normalization techniques and database Design rules.
• Supported Oracle production and development databases on 24x7 high -Availability.
• Provided On-call support for more than 100 production & 200 development Databases.
• Installed, configured BMC sqlbacktrack on Solaris 2.x servers to ADSM server for logical and physical backups & performed Database disaster recoveries whenever required.
• Planned and performed database recoveries.
• Created Partitioned Tables, indexes & materialized Views in Oracle 8.1.7/9.2

databases as per specifications.

• Configured & tuned Oracle 8.1.7/9.2 databases for Multi-threaded Architecture for load

Balancing as per required for certain applications.

• Created database monitoring scripts in development & production boxes
• Created & implemented export & import and backup shell scripts as per specifications.
• Developed & tested 10000 lines of SQL, PL/SQL code in database triggers, stored procedures, functions & Packages as per requirement.
• Performed Database & application tuning
• Planned, Designed & Migrated Multiple databases from Oracle 7.3.4 to 8.1.7
• Planned, designed & migrated multiple databases from Oracle 8.1.7 to 9.2.
• Configured & supported Oracle 8.1.7/9.2 production databases for distributed database option as per requirements.
• Refreshed Oracle databases using Export/Import utilities on test, development & Production servers.
• Automated weekly & monthly reload of data into OLTP & Data warehousing databases using SQL*LOADER in direct, conventional & parallel mode.
• Oracle application server/ 9iAS was installed & configured for high-availability

Databases using n-tier solutions for web-based implementation

• Configured & Supported Oracle 8.1.7 databases for parallel server using Sun Cluster 3.0
• Configured & supported Oracle 9.2 databases with Real Application Cluster option.
• Configured, implemented & Supported Oracle 8.1.7/9.2 databases for Multi-master, Standby, Snapshot, Symmetric replication & Oracle Advanced replication as per Specifications from Application staff.
• Configured OEM (performance & diagnostics) & DBA studio to Oracle 8.1.7/ 9.2 databases and monitored, tuned, planned for Capacity of databases.
• Configured RMAN with veritas Netbackup to Oracle 8.1.7/9.2 databases for database backups & performed Disaster recoveries whenever required.
• Cloned Oracle 8.1.7/9.2 production databases as per specifications.
• Configured & tested BEA Weblogic server & JDBC in J2EE for Oracle 8.1.7/9.2 Databases and implemented Web-Based applications.
• Reorganization of databases (Tables, Indexes & clusters) performed as and when required.
• Configured & supported Oracle production databases for Intermedia option.
• Configured & supported Oracle 8.1.7/9.2 databases using two phase commit and Data synchronization.
• Implemented Oracle Standby/DataGuard databases on Oracle 8.1.7/9.2 as per specifications from Mission critical application staff.
• Configured & tested Oracle 8.1.7/9.2 databases for Advanced Queuing as required by certain applications.
• Monitored Oracle 8.1.7/9.2 production databases using Quest Toad, DB-Artisan, spotlight
• Documented Oracle production databases as per DBA standards.
• Configured & supported Oracle 8.1.7/9.2 production databases for Oracle LDAP & Oracle internet Directory option.
• Configured & tested Oracle 8.1.7/9.2 databases in failover mode as required for certain Applications.
• Hiring of new Consultants
• Guided junior level DBA\'s in advanced DBA activities.