Career Overview

• Over 20 years experience in IT industry consulting database technology, managing technical projects and managing operation support teams as well as design-n-build teams.
• Experienced in managing DBA/development teams across geographical regions. Has very good leadership, interpersonal and communication skills. Holds excellent experience in all aspects of project life-cycle including feasibility analysis, design, documentation, implementation and user training.
• Being Certified Oracle DBA, holds strong knowledge in consulting and managing various Oracle solutions like Oracle RAC, Oracle Data-guard, Oracle Streams, Golden Gate, Oracle ERP and Oracle middleware products.

Technical Skills

• Management Tools: MS project, MS Excel/Access, MS PowerPoint, MS Visio
• Applications: Oracle Applications Financials, Order management, Projects, Supply Chain and Manufacturing Suites CRM Modules , various custom developed applications.
• Middle Tier Products: Oracle GoldenGate, Oracle Weblogic, Oracle Identity Management Suite, Oracle Business Intelligence Suite, Oracle Application Server Apache, OC4J, Jserv, Forms, Reports, Discoverer.
• Clustering Products: Oracle Clusterware, Veritas Cluster Server, Microsoft Cluster Server MSCS , IBM HACMP and HP Service Guard, Redhat Clustering Service.
• Database Products: Oracle Database Server, Preliminary knowledge of IBM DB2 Microsoft SQL Server.
• Performance Management Tools: Oracle Grid Control, Foglight, Precise, BMC Patrol, HP Openview.
• Backup Products: Veritas Netbackup, EMC's BCV, Database utilities like RMAN, Export/Import etc.
• Scheduling Products: Appworx, Autosys, UNIX Cron Windows Scheduler.
• Programming Languages: SQL, PLSQL, Shell scripting with SED/AWK, Perl and Preliminary knowledge of Java/C/C .
• Operating Systems: Redhat/Suse Linux, HPUX, AIX, Solaris, Windows Server.
• Hardware: Oracle Exadata Machine, Sun Enterprise Server Series, HP Server Family, IBM pSeries/iSeries, Sun StoreEdge Family, EMC Storage Family, NetApps Storage Devices.

Recent Projects/Jobs

Confidential

Manager of Database Admins

• Managing a team of 12 DBAs to support line of business of Fixed Income, Commodity Currencies in Global Banking and Market division of Bank of America. Also co-managing global shared service which is offshore DBA teams across Mexico, India. Responsible for BAU activities across portfolio of roughly 280 Oracle instances which include escalation in terms of performance, availability other operation and change management activities.
• Also responsible for delivering any new requirement in the form of design build of Oracle architecture including Oracle RAC, Oracle Standby, Oracle Goldengate replication, Oracle Exadata, Oracle Data integrator products. Worked with delivery/engagement managers, project managers and internal customers in brain storming, planning, designing, implementing new database solutions. Worked with Project Managers in managing the resources across projects, forecasting resource requirements for projects in pipeline as well as in managing the project activities.
• Very hands on in resolving various BAU related issues for example troubleshooting database performance, database availability as well as engineering problems during design Build phase for new delivery. Worked on designing workload management for database consolidation on Oracle Exadata, SQL regression issues during Oracle 11g migration, on SQL scaling problems on Oracle RAC environment as well as data quality issue in replication environment.
• Managed a critical project of SQL server migration to Oracle Exadata appliance for regulatory application. Project involved managing on-boarding of Exadata Appliance into data center, negotiating Oracle platinum support agreement, designing appropriate backup recovery strategy, defining approach of workload management via Oracle resource manager, resolution of various performance issue as well as data migration related issues.
• Worked with Global Information Security team in defining and managing Oracle security baseline. This involved global roll out of Symantec Enterprise security manager. Managed global implementation of database xml audit and other security related features of Oracle database.
• Worked closely with shared technology group to manage the health and product currency of Foglight, Oracle Grid Control, BMC BDA provisioning, RMAN catalog, Central Inventory, HPDMA release management infrastructure.
• Assisted Oracle Engineering team for improvement in Oracle standards related to OS requirements, network requirements, database layout other tool requirements.
• Worked with Product Management Group in assisting license management with vendors other support related agreement and contracts as well as in defining chargeback rates to internal customers. Involved in defining and implementing Oracle Platinum support for Exadata Appliance as well as Oracle SSC support for critical applications.
• Worked on various operation automation and engineering projects including implementation of IPCenter operation management software and its automation, Maximo to ITSM transformation project, self-serving release management via HP DMA etc.

Confidential

Lead Database Engineer

• Worked as Senior Technical Architect and SME in multiple projects with different business teams in evaluating different Oracle Solutions for HA RAC , Replication GoldenGate, Streams , Disaster Recovery DataGuard, EMC SRDF . Assisted in planning these solutions, implementing it and in setting up operational support for it with change management process, tier-level monitoring backup strategy. Assisted in day-to-day operational support of production databases with security management, space management, performance tuning and data troubleshooting. 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.
• Led the project of Enterprise-wide Oracle Grid Control Rollout. Proposed and planned high available solution of Oracle Grid control with use RAC configuration 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.
• Assisting in upgrade of current 11.5.10.2 Oracle E-Business implementation to R12. Involved with day-to-day operations of DBA such as performance tuning, backup/recovery, troubleshooting database issues, migrating code/database changes, installing/upgrading oracle software CRS, ASM, RACDB 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.
• 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.
• 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.

Confidential

Technical Consultant Consulting Database and Oracle E-Business solutions

• 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.