Area of Expertise

Overall 14 years in Oracle Database and Data Warehouse Administration. Installation, Configuration and Administration of Oracle 11g/10G/ 9i /8i/ 7.x on both Unix and NT servers. Including very large databases (Terabytes DB).Capacity Planning, Re - allocation and proactive approach in Monitoring Databases. Implemented multiple Oracle Instances with multi-node RACRMAN Backup and Recovery. Physical (Hot & Cold) backups and logical backups using Export/Import. Extensively use of shell scripting. Updateable and Multi-Master OracleReplication setups. High availability support with Raid5 and Raid1. Informatica(ETL) complex mappings design, development and deployment. OLTP system Tuning using hints in queries, running bstat/estat, Explain Plan, TKPROF, eliminating chained rows and avoid flushing shared pools. Log Minor, locally managed Table spaces, Transport Table spaces, and Partitioning of tables and Intermedia indexes.Data modeling using Erwin tool. 24x7 on call Technical Support in Monitoring, Managing and solving production database issues. Strong analytical and problem solving skills coupled with excellent written, verbal and inter-personnel communication skills. Oracle Data Guard. Oracle Security Patches. Oracle database upgrade.

Technical Experience

RDBMS

Oracle 11g/10g/9i/ 8i / 7.x, MS SQL Server, MS Access

Software Tools

ERWin, BPWin, SQLNet8, OEM, SQL*Loader, Server Manager, RMAN, Intermedia text, TKProf, Import/Export, Toad, SQL Enterprise manager, Connection Manager.

GUI

Designer 2000 & Developer 2000(Forms4.5/5.0/6.0,Report 1.2,SQL*Reports 2.5) Informatica6.2.

Languages

C, JAVA, SQLPlus, PL/SQL, Perl, Embedded SQL, SQL*Net Pro*C, JDBC.

ETL Tool

Pure*Integrate, Informatica 6.2

O.S.

SunOS 2.6/2.7/2.8/5.8, AIX, HP-Unix11.0, WindowsNT4.0/2000, Linux86-64 AS4.0

Professional Experience

Sr. Oracle DBA Feb

Confidential, New Jersey

Responsible for administrating/maintaining/Monitoring/Upgrading the Production/Dev/Test and training databases for products e.g. PKS, ViewPoint, ClinProd, QAAD, GCDMS, EDC Central Designer,EDC Central Coder, EDC Inform, Primavera, LotusNotes and Ellie.

• Successfully installed Oracle9i RAC to support Clintrial applications.
• Successfully upgradedEllie application database on development, test and production environment, Validated and documented the upgrade as per Eisai Standard Procedure. Setup backup procedures and monitoring scripts.
• Successfully configured Ellie- HR Connector on development, test and production environment, Validated and documented the upgrade as per Eisai Standard Procedure.
• Successfully configured Ellie-EDNA Integration on development, test and production environment, Validated and documented the upgrade as per Eisai Standard Procedure. Setup backup procedures and monitoring scripts.
• Successfully upgraded ViewPoint application database on development test and production environment, Validated and documented the upgrade as per Eisai Standard Procedure. Setup backup procedures and monitoring scripts.
• Successfully upgraded database of the EDC modules - Inform, Central Designer, Central Coderand Central analysis. Thirty-three servers and twenty-one database instances are involved in this upgrade. Completed production readiness state by applying latest patches, setting up the backup and monitoring agents.
• Part of Disaster Recovery team.
• To meet the objective of maintaining the high standard of the database security in firm, deployed Oracle Security Patch released on Oct-2009 on all Eisai, WCL, EMR and Baltimore Oracle databases. Notified and communicated to Business as well as Vendor application team for their respective application for above Security Patch release.
• Performing Day-to-Day DBA tasks - performance & tuning, database design, system security, database installation configuration, patching, technical database support.
• Maintained databases on a 24/7 basis with on call weekend support.

Sr. Oracle DBA June'2005 - Dec'2005

Confidential, New Jersey

Responsible for administrating/maintaining the production databases for online products e.g. Government Pricing, Medicaid, Cars, Sales, HR, Validate(IRMS), EDMS.

• Maintained the database on a 24/7 basis with on call weekend support.
• Configured RMAN Catalog, Automated RMAN backup script and part of disaster recovery.
• Designed physical/logical database using Erwin tool.
• Wrote extensive shell scripts to monitor health of the database.
• Performed Day-to-Day DBA tasks - performance & tuning, database design, data modeling, system security database installation, technical support, and investigation of new technologies.
• Supported SQLServer 2000 databases.
• Migrated Oracle9i to 10g in test environment for online product Medicaid and Cars.
• Tested all the new features of Oracle10g in test environment.

Also involve business/technical analysis/support of pharmaceuticals products GP/MEDICAID/CARS from vender of IMANY Inc.

Sr. Oracle DBA April\'2004 - May'2005

Confidential, New York

As a Senior Oracle DBA, I maintained the Production Data Warehouse environment running oracle databases on sunfire 4800 servers connected to EMC and Sun StorEdge T3 disk arrays, using Informatica as the ETL tool and Siebel for marketing purposes.

Worked on Prospect CRM project. Prospect data (Leads) that comes from different sources like LAD (Leads Address Database), Fair Isaac (Direct Mail) etc is loaded into Data Warehouse and then is passed on to the CMDM Data mart / PROSPECT PREBUILD so that the Siebel Analytics / Marketing can pull lists and campaign to the prospects / win-back customers.

• Responsible for administrating the CRM Data Warehouse, Data Mart and Informatica ETL tool repository.
• Responsible for maintaining the database on a 24/7 basis with on call weekend support.
• Migrated SAN from T3.
• Configured RMAN Catalog, Automated RMAN backup script for leve0 and level2 and wrote UNIX scripts to compress backup sets
• Developed complex mappings in Informatica.
• Evaluated Oracle 10g.
• Used RAID 5 and RAID 0+1 for disk mirroring.
• Wrote extensive shell scripts to monitor health of the database.
• Table Partitions.

Sr. Oracle DBA Mar\'2003 - Mar'2004

Confidential, New York

Worked as Sr. Oracle DBA / Business Analyst for production, development and test databases.

Responsibilities:

Created and configured the databases for production, Test and development environments. Upgraded the Oracle from 8.1.7.3 to 9.2.0 in development, test and production databases. Implemented the recommendation of oracle databases for optimal performance and good throughput. Refreshed the Test and development databases with the production data. Analyzing and rebuilding of indexes. Created Rollback segments with different storage parameters. Designed Backup & Recovery strategy for 24x7 for all above products, Written Hot & Cold Backup scripts for the Production databases. Written shell scripts in Ksh to run stored procedures and scheduled them on crontab to run daily.

• Installed and upgraded several oracle 8i patches.
• Veritas clustering.
• Configured Intermedia text.
• Configure RMAN utility for backup and recovery.
• Work with Veritas on Sun Solaris.

Sr. Oracle DBA / Business Analyst- Nov\'2000 - Dec'2002

Confidential, New Jersey

Worked as Sr.Oracle DBA / Business Analyst for production databases of the following products:

• TakeOverStock Report provides a unique blend of pertinent facts, industry research, legal analysis, and regulatory insight.
• VentureXpert and RB Web are the sources for comprehensive analysis of investment activity and performance of the private equity industry.
• International financing Review (IFR) is the industry's leading publication for all-inclusive coverage of the international capital markets.
• SDC Platinum™ provides the most detailed information available on new issues, M & A, syndicated loans, private equity, project finance, poison pills, and more,
• ShareWorld is the only all-inclusive online source for securities ownership intelligence.

Responsibilities:

Created and configured the databases for production, Test and development environments. Worked with Business groups for collecting the business requirement and converting them into database design. Upgraded the Oracle from 7.2.3 to 8.1.7.3 in development, test and production databases. Automated the process of Paging and mailing to the DBA's if there were any ora errors in the Alert log files with shell scripts. Implemented the recommendation of oracle databases for optimal performance and good throughput. Designed Backup & Recovery strategy for 24x7 for all above products, Written Hot & Cold Backup scripts for the Production databases. Used new 8I features like Online DE-Fragmentation and also created and used function-based indexes etc. Written shell scripts in Ksh to run stored procedures and scheduled them on crontab to run daily.

• Implemented multi-master advance replication between four servers.
• Implemented Connection manager to connect with JDBC using MTS.
• Configured Intermedia text.
• Configured RMAN utility for backup and recovery.
• Work with Raid5 on HP and Sun Solaris.

Data Warehousing administrator and DBA

Feb\ 24/7 Confidential, New Jersey

Responsibilities:

• Consolidated data around 600 GB from multiple sources both intra-and inter company.
• Minimized performance impacts to transactional systems by having management information in separated relational databases and/or On-Line Analytical Processing (OLAP) data cubes.
• Provided an accessible long-term store for corporate data.
• Data export and import using SQL*Loader, import & export utilities
• Developed the strategies for backup and recovery procedures
• Creation of SQL scripts to automate database operations and monitor Performance.
• Management of Tablespaces, Rollback Segments, Redo Logs and other database objects
• Data modeling with Analyst/Programmers and Performance tuning with the help of V$ Views, Oracle Trace, Explain Plan & other custom scripts Database & user security.