SUMMARY

• Over 10 Years of Experience in the Information Technology domain as DBA Architect, Global DBA Lead and Sr. Database Administrator, Sr. Apps DBA
• Worked on multiple projects of highly complex nature at the same time, Lead a Geographically dispersed Team (Size - 16), provided technical direction/mentoring to the team.
• Extensive experience working with various HA Technologies: Oracle RAC (9i/10g/11g), Oracle Grid Infrastructure (11gR2), Oracle Failsafe, SQL Server Failover Cluster (2005/2008), HP ServiceGuard Cluster ( 11.16/11.18 ), HACMP and Microsoft Cluster Services (MSCS)
• Architected Various DR/HA/Business Continuity Solutions for various Databases and applications ( Oracle EBS, PeopleSoft, SAP, Omega, I2)
• Experience Implementing Oracle Data Guard over long distances (across Global Data Centers) for complex environments ( Oracle EBS, PeopleSoft, SAP, I2 ….) and setup replication using (Oracle streams/Golden Gate/SQL server replication techniques (merge/transactional replications)
• Extensive Hands on experience Architecting and Managing Database Migrations and upgrade Solutions in a data center environment which include … Oracle Cross-Platform, non-ASM to ASM, non-RAC to RAC, SQL Server 2005/2008, Informix 9.4/11.5, MySQL 5.1/5.2 )
• Experience implementing near-zero downtime upgrades/migrations between cross-platforms using GlodenGate/standby/XTTS.
• Extensive experience in various implementations, migrations and upgrades of Oracle EBS 11i/R12
• Experience implementing SSL, SSO/OID using Oracle iAS 10g.
• Proficiency in Installing, Upgrading, Patching, Cloning and implementation of Oracle Apps (Release 12 / 11i / 11) and Proficiency with several AD admin tools like Rapid clone, ADpatch,, ADadmin, ADcontroller, Adsplicer etc…
• Experience working with several Multi-Node and Multi-Tier Environments with PCP and Hardware Load balancer.
• As an experienced Oracle DBA, heavy emphasis and hands on experience dealing with Performance Issues related to all levels ( Apps 11i/R12, RAC, DB Engine, Grid Infrastructure, ASM)
• Hands on Experience Implementing and using Oracle Grid Control 11g.
• Architected various reliable backup and recovery solutions for Oracle, SQL Server, Informix and MySQL databases using various tools
• Extensive Experience in evaluating Hardware and Software Requirements make decisions/help make decisions which are cost-effective and scalable.
• Provided support to internal and external customers enabling the achievement of excellent Customer Satisfaction levels by meeting the SLA/OLA’s and identifying opportunities to extract additional value and reduce business cost and complexity.
• Communicating to the Database Administration team business requirements and priorities - including key business deliverables and expected results; and communicate information effectively to team members and project stakeholders.
• Experience working with various people across the Globe which includes Infrastructure Architects/Managers, Designers, Program/Project Managers, Infrastructure Engineers at all levels (UNIX, Wintel, VMware, Database, Network, Backup, Security and Monitoring Teams…)
• Established process, created troubleshooting guidelines, determined readiness for platform deployments and capacity requirements, and generated reports.
• Developed various Technical Procedures and Policies Documentation.
• Provided L4 support for complex issues on Severity 1 calls.
• Well versed in current IT technology including Windows NT/ 2000/ 2003/2008 , UNIX ( HP-UX, Solaris, AIX), Linux (RHEL, SLES, Oracle Enterprise Linux), Storage arrays, VMware, Backup tools
• Experienced in writing Unix Shell Scripts and Cron Jobs.
• Experienced in Logical and Physical Database Modeling using ERWIN.
• Experienced working effectively in a fast-paced, changing high-tech environment.
• Excellent multi-tasking leadership, interpersonal, technical assessment, communication and influencing skills, with the ability to communicate new concepts, and drive change in process and behaviors.

TECHNICAL SKILLS

Operating Systems: HP-UX 11.23/11.31 , Solaris 9/10, AIX 5L, RHEL 4/5, SLES 9/10/11, Windows 2000/2003/2008/ R2

Databases: Oracle 8i/9i/10g/11g/R2, SQL Server 2005/2008/R2, Informix 9/10

Applications: Oracle EBS 11i (11.5.9, 11.5.10), Oracle EBS R12 (12.1.1, 12.1.3), PeopleSoft 8.9

High Availability/DR: Oracle RAC 10g/11g, Grid Infrastructure, Oracle Clusterware, ASM, Data Guard, Golden Gate, Streams, SQL Server Failover Clustering (2005/2008), Oracle Failsafe 3.4, HP Service Guard Clustering ( 11.16/11.18 ), SQL Server replication (transactional/merge)

Programming: UNIX Shell scripting, SQL, PL/SQL, Java

Modeling: Erwin

Virtualization: VMware 3.x/4.x, Oracle VM

Other Tools: OEM Grid Control, OEM 10g/11g, Oracle iAS 10g, TOAD, HP Dataprotector, HP OpenView (OVSD, OVO, OVPM, DBMON/DBSPI), TSM TDP, SQL Loader

PROFESSIONAL EXPERIENCE

Confidential

Sr. DBA Architect/Lead

Responsibilities:

• Design/Architect the solutions to migrate/consolidate/upgrade various Databases (Oracle -1500+, SQL Server - 400+, Informix - 50+) of varying sizes (5 Gig - 12 TB) across the Globe to 3 HP Datacenters for demanding client in Confidential .
• Perform various migrations/upgrades including Cross-Platform Migrations, non-RAC to RAC, non-ASM to ASM
• Planned and executed database upgrades (multiple scenarios/multiple versions) in multiple environments; Lead an upgrade team which was responsible to perform the upgrades over 500+ Oracle Databases.
• Implement High Availability/Business continuity solutions using Oracle RAC 10g/11g, Grid Infrastructure (11gR2), Oracle Failsafe, SQL Server Failover Cluster (2005/2008), HP ServiceGuard Cluster ( 11.16/11.18 ), HACMP and Microsoft Cluster Services (MSCS)
• Implement DR over long distances (across Continents) using Data Guard (Oracle) and SQL log shipping (SQL Server) for mission critical databases and setup replication using (Oracle streams/Golden Gate/SQL server replication techniques (merge/transactional replications).
• Implement Oracle online Patching for database one-off patches, Oracle RAC rolling upgrade for database patches, PSUs and CPUs, Cluster Ready Services (CRS) rolling upgrade, Oracle ASM rolling upgrades.
• Experience implementing near-zero downtime upgrades/migrations between cross-platforms using GlodenGate/standby/XTTS.
• Add/remove nodes from Oracle RAC clusters based on the requirements.
• Involve in Performance tuning on the newly implemented systems as well as on the existing systems by employing various techniques.
• Analyze, design and implement Oracle Applications R12/11i to support business in multiple countries.
• Upgrade Oracle Application environments from 11i to R12, 11.5.9 to 11.5.10.2 and 12.1.1 to 12.1.3.
• Implement SSL for internet facing Tiers.
• Install/Configure/Integrate Oracle Apps R12/11i with SSO/OID/Portal/Discover using iAS 10g.
• Setup/Install/Configure OEM Grid Control Server(s) 11g to monitor/manage multiple databases (both RAC and non RAC).
• Member of Architecture and Design team of HP for about 5 Years; actively participated in the meetings/discussions regarding implementation of various solutions/cutting edge technologies and purchase of Hardware/Software required for Data Centers.
• Provide L4 support for complex issues on Severity 1 calls.
• Work with various people across the Globe which includes IT Architects/Managers, Designers, Program/Project Managers, IT Engineers and communicate information effectively to team members and project stakeholders.
• Responsible for providing technical database expertise and/or solution delivery support for maintaining performance and reliability of database solutions.
• Participate as needed in meetings of the IT team to address the IT strategies, their integration, their progress and/ or issues needing problem management and Root Cause Analysis.
• Communicate complex issues in both oral and written form in terms clearly understood by technical and non-technical audiences.
• Managing production support activities for various Databases which hosts the business critical applications including Oracle E-Business suite, PeopleSoft, SAP, i2, OMEGA and the ongoing health monitoring, maintenance and upgrade of those system.
• Preparing Reports and producing metrics to utilize them to support strategic planning and decisions.
• Architected various backup and recovery solutions for the Databases using various methods.

Environment: Oracle 9i/10g/11g/11gR2, SQL Server 2000/2005/2008/ R2, Informix, Oracle Applications 11i/R12, Oracle iAS 10g, SAP, PeopleSoft FSCM 8.9/9.1, PeopleTools 8.49/8.51, HP-UX PA RISC/Itanium, Solaris 9/10, AIX, SLES/RHEL/OEL, Windows Server 2003/2008, VMware/vSphere, HP Service Guard Cluster 11.16/11.18 , MSCS, Oracle RAC, SQL Failover Clustering, Data Guard, Log shipping, Replication using Oracle streams/Golden Gate, SQL Merge/Transactional Replication, HP OpenView (OVSD, OVO, OVPM, DBMON/DBSPI), OMS, OEM Grid Control, TOAD, SQL Loader, HP Data Protector, HP 9000 Containers, HP Virtualization, TSM TDP, RMAN, BR*Tools, BCV, HP Storage Mirroring, eVaulting, HP XP/EVA SAN, TDMF SAN Based Replication.

Sr. Database Administrator Lead

Responsibilities:

• Lead a DBA Team of size 4 which supports 24*7 operations.
• Implemented and maintained Oracle RAC 10g with RAC standby environment configured using Data Guard.
• Installation, configuration, migration and upgradation of Oracle 8i/9i/10g Databases and SQL Server 2000/2005 Instances in Production, QA and Development Environments.
• Setup and maintenance of OEM Grid Control.
• Database Trending and Reporting on a regular basis
• Review and design database structures to support business requirements including logical and physical database modeling.
• Installation, configuration and upgradation of Oracle iAS 10g.
• Setup RMAN solutions for all Oracle Databases - created RMAN repository, wrote scripts for backup, integrated RMAN with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques - Restore and Recovery.
• Validated production backups and cloned/Refreshed the development/UAT environments on a regular basis.
• Analyze existing program logic in order to help develop new and improved logic.
• Implemented Oracle Auditing on a few databases and written scripts that create HTML reports out of the Audit tables for suspected activity and automatically e-mail it to stakeholders.
• Monitoring and tuning Database Performance by identify system/database bottleneck areas using AWR/ STATSPACK Reports.
• Tuning of SQL, PL/SQL using Hints, Explain Plan, TKPROF and DBMS Profiler and perform wait analysis/ tuning
• Experienced in writing PL/SQL Stored Procedures, Triggers, and Java Stored Procedures.
• Resolved Inconsistency Issues, Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.
• Mentored Developers/DBA’s and supervised their work for accuracy and improvement.

Environment: AIX 5L, Suse Linux, Windows Server 2003, Oracle 8i/9i/10g, SQL Server 2005TSM TDP, RAC, Data guard, OEM Grid Control, TOAD, Site scope Monitor, UNIX Shell Scripting.

Confidential, NJ

Sr. Database Administrator

Responsibilities:

• Installation, configuration, upgradation and management of Oracle 8i/9i Databases instances that are/would are in Production, QA and Development.
• Consolidation and cleaning up of databases.
• Involved in the Physical and Logical Database Design using ERWin Data Modeler.
• Automated the monitoring of the databases. Worked on implementing a centralized strategy to monitor all the oracle databases using Oracle Management Server/ OEM (9i).
• Designed and implemented Backup and Recovery strategies for Oracle database using exp/imp and RMAN TSM TDP.
• Involved in migrating the SYBASE 12 Adaptive Server data to Oracle 9.2.0.6 using Oracle Migration Workbench.
• Deployed Oracle Database Security using administrator defined roles and privileges.
• Implemented Database Security by forcing the database to use user profiles and created triggers and functions to restrict a few users to use a few applications.
• Performed Database trending, reporting, collecting the statistics of all the instances with home grown scripts ( Shell scripts and VBScripts)
• Installed and Configured Remote Diagnostic Agent (RDA) to gather detailed information about Oracle Environment and in turn used to aid in problem diagnosis.
• Performance tuning by resolving Inconsistency Issues, Shared Memory Allocations, long Transactions, Locking Issues and Deadlocks.
• Killing sessions requested by users and/or jobs running much longer than expected time.
• Adding space to the data files to accommodate growth of tablespaces and resolved Disk Contention issues.

Environment: Oracle 8i/9i, Sybase 11.x/12.x, SQL Server 2000, DB2, AIX 5L, Sun Solaris 2.7, Windows NT/2003, TSM TDP for Oracle, SAN, DataStage, Cognos ReportNet, Oracle Management Server, Site Scope Monitor, TOAD, Humming Bird, Reflection.

Confidential

Developer/DBA

Responsibilities:

• Developed and supported databases and database software for Oracle Version 7, and 8. Most projects involved database and application design, developing and coding. Technical papers were written for team members to disseminate features, problems, and solutions.
• Analyze and identify the user and processing requirements of the system.
• Design and develop database architecture (ERD) using ER tool and Designer 2000.
• Create program specifications for programmers.
• Involved in Data Maintenance, used Explain plan, SQL Hints, Table and Index Partitioning to improve the Performance.
• Used SQL*Loader, Export, Import in order to Extract and Load Data.
• Scheduled the Export, Cold Backup, FTP and Database Monitoring Jobs.
• Assist Sr. Oracle DBA in day-to-day Administration.
• Test and debug system modules.
• Investigate and submit system requirements (both for hardware and software).
• Provide system specifications and prepare technical design document - i.e. creating system data model (normalization and entity-relationship diagram, identifying and documenting system outline & flow to screen layouts, outputs specifications, etc.).
• Review design and development of test plans/prototypes performed by other team members.

Environment: Windows-NT, Oracle 7x/ 8x, Designer 2000, Forms 4.5, Reports, OEM, Pro * C, OAD, Export/Import Utilities.