Career Overview

• Over 15 years of consulting experience in IT industry working and managing technical projects extensively in Oracle technology. Excellent experience in all aspects of project lifecycle including feasibility analysis, design, documentation, implementation, and user training. Experienced in managing multi-site, multi-shore DBA/development teams.
• Being Certified DBA in 10g, 9i, 8i and 7.x releases, holds strong knowledge in implementing various database solutions like RAC, Data-guard, Oracle Streams, Replication, and ASM etc. as well as in performing various DBA activities like capacity planning, installation, upgrade, storage management, system troubleshooting, system monitoring & performance tuning, backup & recovery.
• Extensive experience in installing, configuring & managing Oracle E-Business in a multi-tier environment with MLS, NLS functionalities, cloning of environments, applying patches, managing life-cycle of development/test/pilot/prod environments and overall system management of Oracle E-Business Suite.
• Excellent interpersonal and communication skills, both oral and written.

Summary of Experience

• Confidential, (12/2004-Present) – Senior Technical Architect, Technical Project Lead, DBA Lead

• Confidential, (2/1997-12/2004) – Senior Principal Consultant

• Confidential, (8/1997-6/1998) – Senior Database Analyst
• Confidential, (12/1994-08/1997) – Database Analyst & Application Developer

Education

B. S. in Mechanical Engineering.
Certifications - OCP in Oracle 10g, 9i, 8i, 8.0, 7.3 Database Administration
Professional Trainings

• Oracle 11g New Features for Administrators(USA)
• Oracle Express Server Foundation, Oracle University (USA)
• Oracle 9i RAC, Real Application Clusters, Oracle University (USA)
• Oracle 9i New Features For Administrators, Oracle University (USA)
• Oracle 8i New Features For Administrators, Oracle University (USA)
• Oracle Application Server 4.x Administration, Oracle University (USA)
• Oracle 8 Backup & Recovery Workshop, Oracle University (USA)
• Oracle 8 Parallel Server Training, Oracle University (USA)
• Oracle 8 Performance Tuning, Oracle University (USA)
• Oracle Database Administration Boot camp, Oracle University (USA)
• Professional Training in Unix, C, C++, Oracle programming, ITC (IND)

Capabilities

Management Tools: MS project, MS Excel/Access, MS PowerPoint, MS Visio, Oracle AIM Methods.
Applications: Oracle Applications R12, 11i & 11.0.x (Financials, Order management, Projects, Supply Chain and Manufacturing Suites & CRM Modules), various custom developed applications.
Middle Tier Products: Oracle Weblogic, Oracle Identity Management Suite, Oracle Business Intelligence Suite, Oracle Application Server – Apache, OC4J, Jserv, Forms, Reports, Discoverer.
Clustering Products: Veritas Cluster Server, Microsoft Cluster Server (MSCS), Oracle Cluster manager, IBM HACMP and HP Service Guard.
Database Products: Oracle Database Server 11g, 10g, 9i, 8i, 8.0.x & 7.3.x, Microsoft Access.
Change Management Tools: PVCS, Test Director, Kintana, Ringmaster, Harvest, Remedy and Clearquest.
Performance Management Tools: Oracle Grid Control (OEM), Oracle Application Manager (OAM), Quest’s Products like Foglight & Spotlight, Mercury’s Load-Runner 7.x, HP Openview, Database Utilities like Statspack, SqlTrace, Tkprof, Various Unix Utilities like sar, vmstat, iostat, pmap, glance, topas, truss.
Backup Products: Veritas Netbackup, EMC’s BCV, Database utilities like RMAN, Export/Import etc.
Scheduling Products: Appworx, Autosys, UNIX Cron & Windows Scheduler.
Languages: SQL, PLSQL, Shell scripting with SED/AWK, Perl, Preliminary knowledge of Java/C/C++.
Operating Systems: HPUX, AIX, Solaris, Redhat/Suse Linux, Windows 95-2003.
Hardware: Sun Enterprise Server Series, HP Server Family, IBM pSeries/iSeries, Sun StoreEdge Family, EMC Storage Family, NetApps Storage Devices.

Confidential, (5/2008-Present)
Role: Senior Technical Architect & Lead
Products: Oracle CRS, ASM, Data-Guard & Database 11g/10g/9i, Grid Control 10g, Oracle eBusiness Applications(11.5.10.2, R12), Oracle Identity Management Suite 10.1.4, OBIEE Suite 10.1.3, GoldenGate, Mercury Load-Runner.
Platform: Solaris Fire server Series, HP DL server series (AMD/Intel), EMC dmx storage, Sun Storedge storage.

• Leading the project of Enterprise-wide Oracle Grid Control Rollout. Proposed and planned high available solution of Oracle Grid control with use Oracle Clusterware for database and multiple OMS with Cisco load balancer and Oracle Dataguard. Also worked with different teams of DBAs and application owners of various business applications, for implementing efficient monitoring strategy, oracle software provisioning, and integration of support ticketing system with Remedy Plug-in.
• Assisted in implementing SSO for Oracle EBS application with Active Directory authentication. Installed and configured Oracle Identity Management Suite in high availability configuration with 2 nodes OID/SSO and 2 nodes RAC as DB repository. Troubleshoot various Active Directory & OID integration problems.
• Performing a role of Technical Lead in implementation of new R12 Oracle E-Business modules(SCM modules) with upgrade of current production from 11.5.10.2 to R12 as well as migrating to 4 node DB cluster(10.2.0.4 stack) and 4 node Application servers. Involved with day-to-day operation of DBA such as performance tuning, backup/recovery, troubleshooting database issues, migrating code/database changes, installing/upgrading oracle software(CRS, ASM, DB etc) etc. Also assisting in various Oracle E-Business system administration tasks such as installation, configuration, cloning, patching, performance monitoring & tuning, trouble-shooting variety of technical issues of Oracle Applications R12 as well as 11.5.10.2.
• Involved in migration project of Brio to OBIEE Suite. Helped install and configure 10.1.3 OBIEE Suite with 10.1.3 Oracle Application Server (Linux RHEL5) and 2 node 10.2.0.4 RAC Database (Linux RHEL5) as repository. Assisted in developing data model, data extraction procedure and migrating database objects. Tuned adhoc queries and BI reports.
• Also working as Senior Technical Architect and providing subject matter expertise for HA implementation, performance tuning, change management process, tier-monitoring strategy, exploring and planning new solutions based on business requirements etc. Evaluated end to end architecture of few existing business critical production systems for HA operation, performance management and better manageability. Provided detailed project plan to implement all the findings. In effort of Software license cost reduction, proposed and assisted with database consolidation, platform migration to Linux, database software upgrade and data archiving.

Confidential, 2/20/05-5/2008
Role # Senior Technical Architect & Lead
Products: Oracle Financials, Order Management, Supply Chain and Manufacturing Suites with CRM modules, Oracle Database 8i, 9i & 10g, Oracle 10gAS for wireless field service and Discoverer, Ringmaster, Harvest, Clearquest, OEM, Foglight, HP Openview, Mercury Load-Runner, Appworx, Vertex, Adaytum, VistaPlus.
Platform: AIX (IBM pSeries 630-670, EMC dmx 3000/DMX3.

• Technical Co-Lead in Environment/Server Management team. Performed a role of Technical Architect, Database Administrator as well as Application System Administrator during the life of project.
• During pilot/build phase, assisted Project Management team in making decisions for Hardware vendors, various software vendors for patch management, change control, code management, monitoring different components of end-to-end service delivery, enterprise scheduling etc. Helped in designing development infrastructure for Off-Shore development centers, mainly setting up Oracle tools, UNIX access, and Change management tools etc in Citrix Metaframe Servers.
• Throughout project duration, executed various DBA tasks like installation, upgrade, configuration, space management, user/role management, performance tuning (sql tuning, tkprof), trouble-shooting various issues of the database. Assisted in designing and implementing database backup/recovery strategy with RMAN and Veritas Netbackup. Also worked in setting up reporting environment, which involved setting up of BCVs and automated cloning with Rapid-Clone Technology of 11i as well as Discoverer 4.1.48/10g setup as Adhoc-reporting tool. Worked with Unix-admin in setting up database for cold failover with HACMP software.
• Performed various Oracle 11i application related tasks such as installation, configuration, cloning, patching, performance monitoring & tuning, trouble-shooting various issues of Oracle Applications 11.5.10, Custom Concurrent managers setup, Printers setup, Tech-stack upgrades including database upgrade, iAS 1022 upgrade, JDK upgrade, Jinitiator upgrade, Forms/Reports Patch-sets etc. Setup SSL and load-balancing with the help of Cisco load-balancers. Also set up Oracle Interactive center with the help of 9iAS/10gAS Wireless component. Helped in implementing various 3rd party tools for Oracle 11i Application such as Appworx for enterprise scheduling, RingMaster for patch management.
• As part of R2 requirements, helping Customer to evaluate and setup new DEV and QA environments with importantly Oracle 10g RAC with ASM solution to Load-Balance the additional expected workload and to provide active failover, Oracle 10g Data-guard for implementation of Disaster Recovery strategy. Installed and configured 10gR2 RAC on 2-node AIX pSeries platform with ASM as shared storage and 2 Gigabit Ethernet as interconnects and other 2-node cluster as Standby (Proposed solution is MAA architecture – Maximum Availability Architecture). Setup RMAN backup and recovery procedure in MAA architecture. Tested different failure scenarios against the RAC and Standby configuration.

Confidential, (12/2004-2/2005)
Role: Senior Technical Architect & Lead
Products: Oracle Financials (11.5.9), Oracle Database 8i, 9i & 10g, Oracle 9ias (1.0.2.2 as well as 10gAS for Discoverer), Forms/Report Server 6i, Noetix-Views, Veritas Storage Foundation for Oracle RAC 4.x, PVCS, Foglight, BMCPatrol, Mercury Load-Runner, Autosys.
Platform: AIX (IBM pSeries 630-670), EMC Symmetrix Series.

• Contracted mainly to lead and implement certain solutions – High Availability and scalability of Database with RAC and Data-Guard Architecture and use of cost effective Linux platform as middle tier of Oracle 11i Architecture.
• Successfully led the effort of migrating existing 2 node (AIX) install of 11i to 6 node 11i install with 4 Linux servers as Apps-Tiers with Shared APPLTOP configuration and 2 AIX servers as DB node in RAC Configuration with Veritas Storage Foundation for Oracle. Evaluated for performance, availability with connection load balancing, impact of 11i patching and administration. Implemented PCP (parallel concurrent processing) to distribute batch-processes load across 2-nodes.
• Installed and configured Oracle Data-Guard. Tested failover and switchover operations. Implemented procedure/script to resolve issues related to Standby database Architecture e.g. Archive gaps, backup/recovery thru’ RMAN.
• Also assisted in day-to-day DBA as well as Apps DBA administration, maintenance and tuning work for existing production, dev and test environments.

Confidential, (9/2001-1/2003)
Role: Performance Tuning Team Lead
Products: Oracle Financials, Order Management, Supply Chain and Manufacturing Suites (11.5.5, 11.5.7), Oracle Database 8i & 9i, Oracle 9ias (1.0.2.2), Forms/Report Server 6i, TickMark, Ringmaster, OEM2.x, 9i, Load-Runner 7.x, Test Director, PVCS.
Platform: Solaris 2.8(Sun Hardware E4800, E6800, E15K & EMC 8730)

• Performed a role of Technical Architect, Application System Administrator & DBA and Technical Lead in performance tuning team.
• Performed installation, configuration, cloning, patching, monitoring & tuning, trouble-shooting/diagnosing Oracle Applications. Used and administered third party tool Ring Master for central patch management of Oracle Applications. Used TickMark for tracking configuration changes of Oracle Applications.
• Performed a benchmarking of Oracle 11i Order Management and Financials modules at Sun Center (SOATC Center) in Palo Alto, California and then in Portland, Oregon. Implemented performance tuning strategy with various tools like Load-Runner 7.x, Oracle Enterprise Manager 2.x & 9i and some UNIX utilities. Assisted in designing SLGs, load models of Load-Runner for performance testing as well as for benchmarks. Analyzed the benchmarking results and recommended various tuning options like optimized database server init.ora parameters for required concurrency of users, efficient database layout for better IO throughout, custom code changes, optimized runbook of batch processes, optimized parameter/profile options settings of various batch processes as well as forms, implemented of performance patches for various modules of application as well as for application components like form server, jinitiator.
• Involved in technical code reviews for the extensions and custom programs that integrated with Oracle Applications. Set up Oracle Applications security through creation/management of new/existing responsibilities, menus, functions & users. Registered custom concurrent programs, set up new concurrent mangers for fast, slow, long short running queues, implemented multiple workflow engines for better throughput of deferred activities of sales orders. Assisted in building and setting up run-book of batch processes according to business requirements of MHE.