SUMMARY

• Over 12 years of expertise with Oracle versions 11g,10g,9i,8.i.x/8.x,7.x on production sites with more than 15 yrs of IT experience overall. Managed DBA teams, designed and maintained VLDB’s hosting 24 x 7 mission critical online applications.
• Worked with large IT consulting Organizations for implementing enterprise solutions in the areas of Banking, Finance, Retail, and Government. Handled databases ranging from 600GB to 9Tb.
• Designed and Setup up highly available architectures using various features of Oracle 11g/10g/9i RAC, Oracle 11G ASM, Oracle 10g ASM, Oracle 11g/10g Data guard, Oracle Goldengate, Streams, Advanced Replication.
• Worked extensively with SAN solutions from EMC, IBM, HP.Used BCV, Time finder, and SRDF solutions with EMC’s Symmetrix - DMX series, HP’s - XP10000,XP512, IBM’s DS 48000 SAN storage solutions with a combination of clustering solutions from VERITAS, ORACLE, and IBM.
• Performed capacity planning for systems, POC’s and handled system architecture design for varieties of solutions for high performance, fault tolerant mission critical implementations.
• Extensive experience in performance tuning, stabilizing and handling distressed clients dealing with SLA issues, platform instability issues and scalability issues. Handled performance teams and performance efforts to achieve mission critical SLA’s successfully.
• Performed detailed application code reviews and tuned databases and applications by identifying bottlenecks. Used ASH, AWR (10g), Stats pack (9i and below), tkprof, Trace analyzer, Wait analysis and extended trace extensively for application tuning. Optimized batch programs and processes in PRO*C, PL/SQL and custom programs and tuned them to meet the SLA’s.
• Designed and developed strategies and methods for converting data from Legacy to Oracle in a timely manner avoiding extensive downtimes for business. Performed POC’s to illustrate the concepts and to assist in design phases. Coordinated with SCM groups in building environments.
• Developed performance frameworks for meeting SLA’s that also included using oracle options like partitioning, hashing, indexing, REF cursors, external tables, global temporary tables and materialized views for repetitive aggregations.
• Extensive experience in setting up and configuring Oracle application servers 10g iAS R2 and 9iAS and OAS 4.x.Installed and configured applications using forms and reports part the Developer suite 9i,6i,4.5.Installed and configured J2EE components using OC4J containers. Setup high availability architecture for J2EE with 10giAS using Web cache and clustering, Configured and tuned Oracle Application Server 10giAS for optimal response times.
• Extensive experience in implementing DR/enterprise backup solutions strategies and integrating with tools like RMAN, SQL -BACKTRACK, LEGATO, NET BACKUP (VERITAS). Performed upgrades and supported cross platform migrations of applications and databases.
• Lead and managed teams of DBA’s for enterprise and application support. Setup rotation schedules for on call support. Designed and developed frameworks for fault tolerant architectures, performance frameworks to meet SLA’s.
• Designed and developed shell scripts, pl/sql scripts for database monitoring, tuning and maintenance. Implemented automated tools like Oracle 11g Grid control from Oracle, Fog light and Spotlight from Quest, Computer Associates - Wily for Infrastructure Monitoring, Database Monitoring.
• Experience in setting up CA’s Job automation tool-Autosys Release 11. Installing Autosys Server & Remote Agents for the different environments and setup JIL’s for job execution. Setup UWCC and setup security for various supporting personnel such as batch operations and operations group
• Extensive experience in managing Infrastructure services including Rational toolset such as Clear Case, Clear Quest, Functional Tester etc.

Technical Skills: -

Worked on: Cisco R 810, IBM Regatta, Sun E15K,Sun E10k, Sun Fire 4800,E-4500,Sun 6500,Sun E450,IBM P 690,IBM P650/670,IBM RS/6000 (IBM), IBM S-70/S-80, HP-K Class servers, HP 9000 - L class servers, HP-Super Dome.

OS: SUN SOLARIS 2.x, AIX 4.x/5.x ML, Windows Xp/2000/NT, HP-UX 11.x, Linux X64-SUSE,RHEL

Software

RDBMS/Replication: Oracle 11g(RAC),Oracle 10g, Oracle 10g (RAC), Oracle 9i/RAC, Oracle

8.x/8i, ORACLE (7.x), SYBASE 4.x-11, Oracle Goldengate 11,Oracle Golden Gate 10.x, Oracle 11g Data GuardApplication

Servers: 10g Application Server (10giAS R2), Oracle 9iAS, IBM Web Sphere

ERP Solutions: - Oracle Retail-RETEK (13.x,12.x, 11.x, 10.x, 9.x, 8.x, 7, x), Oracle applications 11.x, Oracle E-business Suite 11.x,Peoplesoft 8.x

Backup Tools: RMAN, NETBACKUP

Database Monitoring: 11G Grid Control, Quest’s Spotlight and Fog light

Enterprise Monitoring Tools: Computer Associates-Wily,Instroscope

Scheduling Software : Computer Associates-Autosys R 11, CA-7,Control - M,Appworx

Configuration Management Tools: IBM Rational Clear Case, IBM Rational Clear quest, Dimensions, PVCS

Testing Tools: IBM Rational Suite (Functional Tester, Performance Tester, Software Architect)

Project Management: IBM Rational Portfolio Manager, MS-Project

Current Project

Client: Confidential - NJ Duration: Role: Performance Architect/Lead. Oracle Retail (Retek) DBA

BARS is a prestigious state of the art technology implementation for a Top tier 1 Northeast America Retailer. This system is expected to be the system of record for core business by the end of the year to improve pricing, inventory, warehouse and supply chain management. This implementation with a net worth of over 100 million USD included the implementation of Oracle Applications-Oracle Retail 13.x (ORMS, ORPM, RIB) and consolidation of several enterprise wide systems through interfaces.

Environment: Oracle 11gR2(RAC),Oracle 11g ASM R1/R2,Oracle 11g Grid Control, Oracle 10g R2 RAC, Oracle 10g ias, Oracle Golden Gate 11.x,Forms 10g,Reports 10g, OEM 2.x.,Oracle Retail 13.x(ORMS,ORPM,RIB), Web Sphere, JBOSS.

Hardware: IBM P3550’s-SuSE Linux 11.x, Cisco R 810 -SuSE Linux X64 11.x, EMC DMX3 SAN storage solution, Linux.

Projects History: -

CMS is a prestigious state of the art technology implementation for Advance Auto Parts in the quest for improved pricing, inventory, warehouse and supply chain management. This system contains very tight SLA’s for system processes and live interfaces to handle time sensitive business processes.

This prestigious implementation with a net worth of over 100 million USD included the implementation of Oracle Applications-Oracle Retail 13.x (ORMS, ORPM, ORESA, ALLOCATIONS, RIB, and REIM) and consolidation of several enterprise wide systems. This allows the AAP management to have up to date information on financial activity, sales activity, inventory status across the corporation to make strategic decisions especially pricing across the board. The ROI is projected to be in less than 13 months.

My responsibilities include

• Installing and Configuring Oracle Retail 13.x
• Meeting of all the SLA’s set for the system to meet business standards
• Leading the performance testing team and ensuring the load testing of the application including the modules(ORMS,ORPM,RESA,REIM,ALLOCATIONS,RIB) is completed in time for Go Live
• Handling Severity -1 issues on database servers, application servers and providing production support
• Handling core performance issues with business process, with the database, overall infrastructure and optimizing the application design as required to meet the SLA’s
• Redesigning processes and procedures to meet SLA’s to cut down batch processing times to 2 hours from 11 hours
• Designing the high availability for all Oracle databases (ranging from 300GB to 5 TB) and Application servers and provided failover procedures using replication and clustering techniques
• Capacity planning for Oracle implementations
• Performance tuning of conversion and cut over activities to complete in 18 hours from a scheduled 72 hours
• Performance tuning of batch programs(PL/SQL,PRO*C), Oracle forms in ORMS,ORPM to meet the SLA’s
• Going Live as per schedule with all the critical business process completely tested for performance with 150% volume, SLA’s met and signed off by business.
• Documenting the detailed results of the performance test for each component complete with artifacts such as metrics from monitoring of infrastructure
• Coordinating and propagating the changes proposed as the result of optimization of various components including Database, Servers, SAN, Network and Application code through Change control process.

Environment: Oracle 11gR1/R2,Oracle 11G ASM, Oracle 10g R2 RAC, Oracle GoldenGate 1.x,Oracle Retail 13.x(ORMS,ORPM,RIB,RESA,REIM etc), Web Sphere, JBOSS, TOMCAT, IBM Rational Clear Case, IBM Rational Clear quest.

Hardware: IBM P550’s with AIX 5.3 ML, EMC DMX3 SAN storage solution, Linux.

Duration:

Role: DBA Manager/ Technical Infrastructure Manager

Confidential is a prestigious and highly successful state wide implementation of the Child Support System implemented by the NJ state. Confidential is a stateless J2EE /Oracle based financials system with a strict SLA of 2 second response times for online transactions. Instrumental in the design of the performance framework that met the strict 2 seconds SLA’s for all online transactions and a state less services based architecture. The system also included the conversion of the data from a 25 year old mainframe system to a temporal Oracle RDBMS based financial system.

Environment: Oracle 10g RAC, Oracle 10g Data guard, Oracle 10g Enterprise Manager with Grid Control, IBM Web Sphere 6.x application server, Rational Suite (7.x),ClearCase, Clear Quest, Rational Functional Tester, Rational Requisite Pro, IBM MQ series, Oracle 10giAS Release 2,Oracle 9I Application server(9iAS)/10gIAs,PL*SQL, Pro*C, Oracle Text, Autosys R11.0.

Hardware: IBM P70’s with AIX 5.3 ML, DS 48000 SAN storage solution, Linux.

My responsibilities included

• Handled all the coordination with the NJ State Infrastructure Team (EBSU) for all the activities such as Infrastructure setup, application Deployment, Configuration management and troubleshooting Database issues and production support.
• Participating in design meetings to gather requirements for implementation and documenting solution design for the implementation. Coordinating IV&V group audits as part of State and Federal requirements.
• Installing and setting up system software such as Oracle 10g RAC, Data guard for failover, Autosys, SAS and other application tools. Used GPFS as parallel file system for RAC storage using IBM DS-48000 SAN storage solution.
• Setting up Oracle 10g Streams for high speed replication of data for reporting purposes. Designed and developed automated scripts for monitoring staging message queues and propagating queues
• Installing and Setting up development, testing, qa, training and sandbox databases to handle the various phases of the implementation.
• Developing and designing standards for the database modeling, design, deployment procedures for the NJKiDS application
• Supporting the conversion of data from Bull Mainframe to the temporal Oracle Database design (NJKiDS). Scripting the conversion routines using a built in scheduler.
• Designing the performance framework that was utilized to perform application code reviews, optimize the application design, reconfigure tables and utilize the hardware effectively to meet the strict 2 second SLA’s. Optimized batch programs iteratively to meet the batch window.
• Using Computer Associates-Wily extensively to monitor and diagnose performance issues with the NJKiDS Core Enterprise system.
• Designing a complete failover of the entire infrastructure of NJKiDS application to OARS(DR Site)
• Configuring and Supporting the Rational tools such as Rational Clear Quest, Rational Requisite Pro, Rational Portfolio Manager, Rational Clear Case, Rational Functional Tester and supporting the UCM process as per Rational Methodology.
• Designing file systems layout necessary as per the application design to address requirements for batch programs
• Installing Autosys R 11 Server & Remote Agents for the different environments and setup JIL’s for job execution. Setup UWCC and security profiles for batch operators

InSite is a prestigious, successful C-Store (Convenience Store) automation project for HESS that was aimed as lowering the inventory costs for HESS stores by as much as 15 million a year. This implementation included the consolidation of several enterprise wide systems as ODS for enterprise wide forecasting and reporting. This allowed the HESS management to have an up to date financial activitiy, sales activity, inventory status across the corporation to make strategic decisions.

My responsibilities included

• The stabilization effort for Retek /Oracle based applications including application servers.
• Handling Severity -1 issues on database servers, application servers and providing production support.
• Implementing InSight/Performance Retail (Retek deployment for Convenience Stores customized by Accenture).
• Developing the strategy for upgrading databases from Oracle 8i to 9i (now being upgraded to 10g).
• Handling core performance issues with the database and Optimizing the application design. Redesigning processes and procedures to meet batch SLA’s -cut down batch processing times to 4 hours from 12-13 hours.
• Designing the high availability for all Oracle databases (ranging from 300GB to 2 TB) and Application servers and provided failover procedures using replication and clustering techniques.
• Performing capacity planning reports and providing the enterprise wide space requirements.
• Designing and developing Failover/Fault tolerant load balancing strategies for the Oracle application server based applications, using the advanced features of Oracle 10giAS application server, Web Cache, farms.
• Upgrading Oracle Forms based applications from Developer suite 4.5/6i to 10giAS based web based forms deployment using Forms servlets.
• Used XP-512 and XP-10000 SAN Storage solution along with BCV technology for taking hot backups of all the Oracle databases.

Environment: Oracle 10g,Oracle 9.x,Oracle 8.1.7, 8.1.5, 8,1,6,8.x,Oracle 10giAS Release 2,Oracle 9I Application server(9iAS),Developer 6.i, PL*SQL, Pro*C,Oracle Developer Server 6i,J2EE,Forms 10g,Reports 10g,Discoverer 10g,OEM 2.x.,See Beyond, Web Sphere, JBOSS, TOMCAT.

Hardware: HP-UX Superdome 40 CPU’s and 80 Gig Ram, HP N Class servers with HP’s XP-512, HP-XP 10000 storage solutions.

Duration:

Role: Sr. Oracle DBA/Oracle Performance DBA

Perpetual Financial and Inventory System-PFI was implemented to modernize the inventory system. This system involved consolidation of functionality from 32 systems and the implementation of interfaces to the financials system and ODS. The system included the implementation of Oracle Retail Merchandising system (RMS).

Environment: Oracle 9.x,Oracle 8.1.7, 8.1.5, 8,1,6,8.x,Developer 6.i, Designer 2000,Crystal Reports, PL*SQL, Pro*C, Oracle 9I Application server(9iAS), Oracle Developer Server 6i,OEM 2.x.,See Beyond.

Hardware: IBM P 690-IBM Regatta servers with 32 CPU’s and 90 Gig Ram with EMC DMX –3000 storage solution

Responsibilities included

• Designing and Creating a 6 TB (Terabytes) RMS production database with growth up to 9 TB on Raw file systems.
• Developing partitioning strategy for large tables holding sales and inventory data for the past 8 years. Some tables were partitioned with more than 1000 partitions to ensure optimal distribution of data.
• Designed and developed strategies for data conversion from Legacy to Oracle and meet the set 24 hr window for cut over.
• Used DMX-3000 SAN storage solution for hosting Oracle databases and BCV technology for hot backups to meet SLA’s.

Duration:

Role: Lead Oracle DBA Consumer Business/Center of Excellence-Hosting Services

Supported Client engagements at US Navy Exchange at Virginia Beach and handled Production support for various Consulting Groups part of Deloitte’s engagements. Participated in Conference room pilots, RFP preparations, Solution design sessions, Troubleshooting at client Sites. The tenure also involved the setup/support of the infrastructure for client engagements such as NEXCOM, DISNEY, and HOME DEPOT on various platforms including Sun, HP enterprise servers- and design of an optimal disk storage layout and system capacity planning.

Environment: Oracle 9.x,Oracle 8.1.7, 8.1.5, 8,1,6,8x,Developer 6.i, Designer 2000,Crystal Reports, PL*SQL, Pro*C, Oracle 9I Application server(9iAS), Apache Application server, OAS (4.0.8.x), Oracle Developer Server 6i,OEM 2.x,APPWORX scheduler,Microstrategy 6/7.

Hardware: IBM Regatta’s, Sun Fire 4800,Sun V-880, HP-9000 V class servers with 16-32 Cpu’s and 32 Gig Ram with XP 512 based disk arrays., Sun Enterprise 10K, IBM Series

My Responsibilities included

• Capacity planning and sizing of databases for clients based on input from business
• Helping clients in the design of the infrastructure for enterprise deployment
• Performing benchmarks for various configurations of enterprise layouts
• Designing environments for product lifecycle. Provided On call support to clients.

Duration:

Role: Sr. Oracle DBA/Systems Architect

PRI-Performance Retail Implementation was a prestigious project for Accenture that involved some of the biggest clients of Accenture namely BP, CONOCO PHLLIPS, HESS. The project included a real time Convenience Store Automation that involved the implementation of Oracle Retail -RETEK 9, 10.x enterprise solution.

Environment: Oracle 9.x, Oracle 8.1.7, 8.1.5, 8,1,6,8x,Developer 6.i, Designer 2000,Crystal Reports, PL*SQL, Pro*C, Oracle 9I Application server, Apache Application server, OAS (4.0.8.x), Oracle Developer Server 6i,OEM 2.4,APPWORX scheduler, SeeBeyond-Egate, Micro strategy 6/7.

Hardware: 15 HP-9000 V class servers with 16-32 CPU’s and 32 Gig Ram with XP 512 based disk arrays., 2 Sun Enterprise K), WIN-95/NT based clients.

Client: Confidential

Role: Lead Oracle DBA /Systems Architect

This project involved the implementation of RETEK MERCHANDISING SYSTEM- a highly transactional merchandising system. The project involved conversion of data from old legacy systems into the new merchandising system

Environment: Oracle 8.x, 8.1.5, 8.1.6, Developer 4.5/6.x, Crystal Reports, PL*SQL, Pro*C, DSS agent and Server, Oracle Application Server 3.x /4.x, RMAN, Legato Storage Manager.

Hardware: 10 Sun 4500’s, 5 Sun 6500’s with Sun Solaris 2.6 and EMC SYMMETRIX RAID solution with Time finder and VERITAS volume management and IO, WIN-95/NT based clients.

Client: Confidential

Duration:

Role: Lead Oracle DBA

This project involves the implementation of RETEK MERCHANDISING SYSTEM (RMS 7) and RDW,Peoplesoft HRMS and Financials implementation.

Environment: Oracle 8.x/8.06, Developer 2000, Designer 2000, Crystal Reports, PL*SQL, Pro*C DSS agent and Server, Oracle 7.3.4/8.x, PEOPLESOFT 7.x (HRMS module), PeopleSoft 7.x (Financials –AP/AR/GL), Application Designer, People code, SQR, Crystal Reports, Data Mover

Hardware: IBM-S-70‘s with Storagetek‘s RAID –05 BASED, WITH AIX 4.x and WIN-95/NT clients