SUMMARY:

• Passionate technologist with over 19 years of professional IT experience, including extensive works with Oracle Database Projects, Design, Installation, Implementation, Up - gradation, Migration, Patching, Backup & Recovery, Database/Application Performance Tuning, Database High Availability, Data Protection, Data Extraction ( ETL) and Oracle Business Intelligence by using various technologies e.g. Peoplesoft ERP Tools, HCM 8.9/9.1, Oracle 8i/9i/10g/11gR2/12c, RAC 11gR2, Clusterware, RMAN, Golden Gate, Oracle Streams, Oracle Golden Gate Architect, Replication & Active Data Guard (11gR2/12c), OEM Grid Control, Oracle BI Discoverer, Informatica, Oracle ASM and Cognos COMPASS BI /OBIEE(10g/11gR2) on various platforms including Oracle Engineered system Exadata Machine(x2-2,x2-8), Sun Solaris, HPUX, AIX, Linux and Windows Server 2003/2005/2008.
• Self-starter, convincing communicator, experienced dealing with oracle VLDB in OLTP and OLAP environment. Planning, implementing & tuning both transactional & warehousing data systems, Involved in the Web servers, Fusion technologies, EBS Applications, Middleware, databases, Operating System, Virtual Machine, Servers, network and Storage system and Cassandra installation, upgrade and management..
• Extensive experience troubleshooting and resolving complex problems, including, but not limited to, Database and Applications Performance, Database Recoverability, and High Availability scenarios, servers migrations, upgrade planning, Hyperion Planning, Hyperion Financial Reporting Studio, implementations, troubleshooting/root cause analysis and performance tuning suggestions, proposals, presentations, case study preparations, building POCs for new projects in various domain e.g. Oil & Gas, financial & banking institutions, Telco, manufacturing, media, Utility, energy, healthcare and insurance.

WORK EXPERIENCE:

Confidential

Sr. Oracle DBA/ Team Lead

Responsibilities:

• Responsible for establishing, managing and supporting NLNG’s IT strategy in general & database infrastructure strategy in particular for the for the company.
• Upgraded 10gR2 databases to 11gR2/12c on 5.5 RHEL 6 .
• Resolved Exadata flash caching issues and optimizing for tiered caching.
• Involved in oracle 10g/11gR2 production database performance tuning.
• Fixed Oracle 11gR2 performance issue after 10g Upgrade using SPM.
• Worked with 11g OEM Grid Control for database performance monitoring.
• Unified methodology based on industry standards for Exadata machine.
• Evaluated Exadata technology implementation plan.
• Managed Oracle 12c Active Data Guard (read-only access to a physical standby database) for queries, sorting, reporting purpose.
• Successfully completed first initial and MTP pass PT 8.53.11 upgrade from PeopleSoft Tools 8.52.13 in Demo and development on Oracle Linux 6.1 Exadata and windows server 2008 servers.
• Zero downtime database migration using Oracle GoldenGate 11gR2.
• Oracle GoldenGate replication - Uni directional, Bidirectional, Disaster Recovery setup, Transformation, Troubleshooting, tuning GoldenGate processes.
• Installed and configured Goldengate Oracle 11gR2 on Exadata machine for ETL purpose.
• Migrated databases using GoldenGate and RMAN for 2 node oracle 12c RAC.
• Resolved replication issues in Goldengate, Automating tasks using cron for Goldengate restart
• Worked on Peoplesoft applications e.g HR, FS, EPM, CRM and Peoplesoft tools.
• Troubleshoot & tuned Memory, paging, IO, CPU related issues.
• Configured PeopleSoft HCM 9.2 upgrade environment needed to start upgrade process i.e. setting up change assistant, setup PeopleSoft Update Manager (PUM), downloading template from oracle support, creating change assistant 8.53.11 job and follow through all the steps in change assistant job to finish the upgrade.
• Installed and configured Oracle SES on Linux servers with all PeopleSoft 9.2 applications documentation and PeopleSoft search from inside application
• Fixed 10g/11g database shared pool, Buffer Cache and lock contention.
• Installed & managed Tuxedo,Webserver Peoplesoft application & PeopleTools.
• Dealing with PeopleSoft Application and Peoplesoft DBA support mainly PeopleSoft HCM, HRMS, CRM, FSCM, EPM applications on Oracle 10g/11g.
• Successfully installed PeopleSoft 9.0. Systems.
• Designed and Implemented Peoplesoft Security Models and supporting Peoplesoft Security related issues.
• Expertise in Tuning web server/load balancing for optimal performance of HCM and SCM applications using appropriate "PIA" heap size configurations in multiserver web server environment and configuring VIP.
• Managed & support PeopleSoft application, upgraded Peopletools version, dealing with Peoplesoft application performance tuning issue
• Extensively worked with Oracle 11g new performance features e.g. SQL Matrics, Alert, Baseline, STS, SQL plan baseline and SPA.
• Provided MAA solutions and disaster recovery plans for business continuity.
• Migrated RAC 10gR2 on Linux from 10gR2 on Windows environments.
• Resolved Oracle 11g slow database issues using ADDM & AWR reports.
• Troubleshoot Database wait events using various oracle traces e.g 10046.
• Configured OEM 12c on Exadata X3-2 machine.
• Set Up Exadata x3-2 for Cloud Control 12.1.0.2
• Prepared document and applied Exadata QFSDP (Quarterly Full Stack Download Patch).
• Installed,configured,monitored & manage Golden Gate for replication and dealing with CDR(Collision Detection and Resolution) on Goldengate Replication setup.
• Setup Database Migration best practices on Non-Exadata to Exadata Machine.
• Planned for upgrade/consolidation/Migration of databases on Exadata Machine.
• Implemented Data Guard 11gR2 on Exadata for DR purpose.
• Implemented Exadata features e.g. HCC, smart scans & Storage Indexes.
• Moved & upgraded database 12c on Windows to Exadata X2-2 11gR2.
• Currently specializing in Exadata X2-8. Great piece of technology.
• Installed EBS R12.2.0 on Sun Solaris 10 with oracle 11gR2 using RapidWiz.
• Installed EBS R12.2.0 on AIX 6.1/7.1 with oracle RAC 11gR2(Multi-nodes)
• Upgraded & Patched EBS R11.5.10.2 to 12.2.0/12.2.4 on SunS10/AIX7.1.
• Cloned & Refreshed EBS 12.2.4 on SunS10/AIX7.1 for TEST/UAT Env.
• Migrated EBS R11.5.10.2 to 12.2.0/12.2.4 from Linux to AIX7.1 Env.
• Providing DBA support to development staff in order to optimize performance.
• Created Physical standby 10gR2 database on Windows.
• Implemented Oracle recommended DB security system on Production Databases.
• Setup/maintained/supported 10gR2/12c Data guard with Grid Control technologies.
• Configured and supported TSM /Galaxy with RMAN backup & Recovery system.
• Converted non-RAC database to RAC 11gR2 on Exadata X2-2 machines.
• Migrated Oracle 10gR2 to Exadata X2-2 OEL 5.5 with ZFZSA backup.
• Setup Active data Guard database 11gR2 Local and remote protection.
• Installed Tuxedo (bea),Webserver (weblogic, websphere), Peoplesoft application and PeopleTools to manage Peoplesoft application server, process scheduler.
• Implemented Data Guard Fast, automatic database and client failover
• Maintain/ Monitor strategy for the operations and support in 24X7 environments.
• Cloned /Refreshed test database from production DB using RMAN backup.
• Upgraded EBS 11i to R12 on RAC with Oracle 11gR2/12c on HP/RHEL 5.3.
• Set-up standard procedure/documentation/training for Oracle Provisioning team.
• Standardized Oracle documentation for Oracle Install /patch / adpatch/ upgrade.
• Wrote shell/Python scripts for daily database automatic monitoring and email alerts.
• Root-cause analysis & recommendations for performance improvement.
• Integrated Oracle SOA Suite 11g with Oracle EBS R12.
• Administering Oracle Apps servers (Install/patch/upgrade/clone) with LAMP
• Install EBS R12 on Sun Solaris using (RapidWiz) configure with RAC 12c.
• Setup/maintained/supported 10gR2 Data guard with Grid Control technologies.
• Installed & configured 3-node 11gR2 Grid Infrastructure (11.2.0.1) on Linux.
• Installed & configured 3-node RAC with RAC Grid Infrastructure on Linux.
• Created & Configured ASM diskgroup DATA and FRA RAC Database
• Designed active-active multi instance SQL Server 2008 failover solution.
• Monitoring and troubleshooting of routine maintenance jobs and processes
• Upgraded & migrated from SQL Server 2005 to Server 2008 R2.
• User training, Documentation, Troubleshooting and on-call 24x7 pager support
• Created & Configured Database listener using db port.

Confidential

Sr. Oracle DBA/ Team Lead

Responsibilities:

• Upgraded Oracle 10gR2 databases to 11gR2 & 12c on Exadata on RHEL 6.2E.
• Installed Oracle Apps R12 on Linux and AIX 5L5.3 environments,
• Researched & Recommended proactive DB performance tuning best practices.
• Installed EBS R11 on RHEL 6.2 E using Rapidwiz method.
• Installed EBS R12 on RHEL 5.3 using (RapidWiz) configured RAC11gR2.
• Provided Oracle Exadata Implementation Service.
• Setup active-active/passive multi instance SQL Server 2008 failover solution.
• Evaluated SQL Server configuration & recommended best practices.
• Performance Tuning & recommendations SQL Server, Query optimization.
• Data captured /propagated on 2 nodes using Oracle Streams methodology.
• Setup/maintained/supported 10gR2 Data guard with Grid Control technologies.
• Worked with TSM / disk/tape backup infrastructure
• Installed, maintained & tuned RAC 10gR2 on Exadata with EBS R12 on Solaris.
• Maintain/ Monitor strategy for the operations and support in 24X7 environments.
• Clone/Refresh planning with RMAN (Backup/Recovery) of production databases.
• Installed EBS 11i/R12 with 9i/10gR2 (RAC/non-RAC) on RHEL 5.3.
• Setting standard procedure/documentation/training for Oracle Provisioning team.
• Upgrade oracle binaries database Oracle 9i to 10g in RAC environment.
• Performance problems in Siebel application (Oracle 10g on Solaris)
• Root-cause analysis & recommendations for performance improvement.
• Administering Oracle Apps servers (Install/patch/upgrade/clone)
• Install EBS R12 on Sun Solaris using (RapidWiz) configure with RAC10gR2.
• Setup/maintained/supported 10gR2 Data guard with Grid Control technologies.
• Experience working with TSM / disk/tape backup infrastructure
• Installation & Administration of RAC 10gR2 with EBS R12.
• Maintain/ Monitor strategy for the operations & support in 24X7 environments.
• Clone/Refresh planning with RMAN (Backup/Recovery) of production databases.
• Installed EBS 11i/R12 with 9i/10gR2 (RAC/non-RAC) on AIX multimode.
• Setting standard procedure/documentation/training for Oracle Provisioning team. problems in Peoplesoft environment (Oracle 10g on Solaris)
• Root-cause analysis & recommendations for performance improvement.
• Administering Oracle Apps R12,11i instances (Install/patch/upgrade/clone)
• Install EBS R12 on Sun Solaris using (RapidWiz) configure with RAC10gR2.
• Data capture/propagate between 2 nodes using Oracle Streams methodology.
• Setup/maintained/supported 10gR2 Data guard with Grid Control technologies.
• Experience working with TSM / disk/tape backup infrastructure
• Installation & Administration of RAC 10gR2 with EBS R12.
• Maintain/ Monitor strategy for the operations & support in 24X7 environments.
• Clone/Refresh planning with RMAN (Backup/Recovery) of production databases.
• Installed EBS 11i/R12 with 9i/10gR2 (RAC/non-RAC) on AIX multimode.
• Worked with Peoplesoft and BEA Tuxedo 8.1
• Setting standard procedure/documentation/training for Oracle Provisioning team.

Environment: Oracle 8.x/9.x/10g/11g, 11gR2 RAC/Dataguard, SQL Server 2008, SQL, PL/SQL, RMAN, UNIX Shell/Python Scripts, Oracle Enterprise Manager/Grid Control, Linux x86 (32/64bit), AIX, E-Business Suite 11i/R12, DAC and Informatica, Exadata X2-2

Confidential, NY

DBA Manager/ Consultant

Responsibilities:

• Setting up Oracle 9i,10g RAC on AIX, Sun Solaris & Linux(SUSE10)
• Root-cause analysis for specific performance problems 10gR2 on HPUX.
• Performed SQL Server security compliance audit for SQL databases.
• Implementation of SQL Server operational automation for backup/restore, Audit, and related maintenance
• Standardize SQL Server environment by designing guidelines for SQL Server installation, configuration, storage specifications, CPU, Memory, account and security to follow best practices and standards
• Performed high-level health-check/ Identified major performance bottlenecks of SAN/NAS storage, operating system & database tiers
• Cloned Oracle Apps EBS 11i & Oracle Databases 10gR2 on multiple nodes.
• Trained DBAs in order to achieve best oracle performance tuning results.
• Managed strategy for the operations & support in 24X7 environments.
• Worked on Professional Training Resources Management Systems
• Worked on Customer Support & Maintenance System (Design & Development)
• Worked on Decision Support System(DSS) in Inventory Management
• Installation, configuration, upgrading & migration of Oracle software (9i, 10g) & tools. Applying patches under UNIX, Linux & Windows platform

Environment: Oracle 8.x/9.x/10g, 10gR2 RAC/Dataguard, SQL Server 2008, SQL, PL/SQL, RMAN, UNIX Shell Scripts, Oracle Enterprise Manager/Grid Control, Linux x86 (32/64bit), AIX, E-Business Suite 11i/R12, DAC and InformaticaConfidential

DBA Project Manager/ Consultant

Responsibilities:

• Setting-up Oracle9i,10gR2RAC with ASM on AIX, Solaris & Linux(RH/SLES)
• Implemented 2 node Oracle 10gR2 RAC cluster ware with EBS11i environment.
• Worked on high availability environment implementations (R11Apps +10g RAC)
• Setup & maintained multiple lab environments (9i/10gRAC) on RHEL & SLES.
• Configure ASM, OCFS & NFS with 10gR2 database
• Setup Oracle 10g (10.2.0.3) RAC with ASM on SLES10 on Egenera system .
• Database Performance monitoring using HP-OPENVIEW
• Migrating strategic applications currently on Sybase to Oracle 10gR2.
• Managing Data Guard/Streams/10g-RAC on variety of UNIX platforms.
• Working knowledge of MS SQL Maestro 7.10 tool.
• Installation, configuration, upgrading & migration of Oracle software (9i, 10g).
• Set up Database upgrade strategy from 8i/9i to 10g (RAC/Non RAC)
• Setup Oracle 10g Data Guard on AIX, Solaris & Linux.
• Troubleshoot Oracle 10g database production performance issues.
• Worked on Oracle10g on AIX & Linux (RAC, Non RAC) installation strategies.
• Setup Oracle 10g Data Guard on Solaris & configured RMAN hot backups
• Installed oracle 9i/10g databases on AIX machine.
• Database cloning / refresh using RMAN hot backups.
• Provided technical expertise for installation of Oracle Applications E-Business Suite 11.5.10.2 with 10gR2 RAC.
• Experience managing multiple Oracle production databases on multiple OS platforms in a 24*7 service environment.
• Experience troubleshooting Oracle database problems such as performance, corruption & recovery using STATSPACK/AWR & DBMS PACKAGES.

Environment: Sun Solaris 9, HP-UX, Windows NT, Oracle Designer.

Confidential

Oracle DBA, Team Lead

Responsibilities:

• Migration of Oracle data 8i, 9i to Oracle 10g.
• Upgraded RAC 9i to 10g on RHEL using OCFS
• Setup Oracle 10g Data Guard on AIX machine reducing downtime of the system.
• SAP R/3 System Skills: SAP Basis experience,
• Executed standard system & SAP housekeeping jobs using SAP tools.
• Worked on Data Guard, Oracle Streams, and RAC on variety of UNIX platforms.
• Data migration & advanced system tuning for the data load
• Worked on RMAN & EMC’s BCV with Oracle Databases.
• Basis Project Management based on the SAP ASAP terminology.
• Provided capacity planning for SAP instances, networks, UNIX machines & PCs.
• Installed Oracle Applications R11i in single node & multimode using Sunsolaris
• Oracle9i/10g Database Administration for SAP on Sun Solaris.
• Upgrade oracle production databases & migration of data.
• Provided production & development database troubleshooting & support
• Tuned & configured Oracle database for 9i improved functionality.
• Monitored Oracle database and servers health checks & integrity
• Ensure optimal database performance through monitoring & tuning tools.
• Managed AQ Databases in oracle 8i.
• Ensure RMAN hot backup & restore procedures using Netbackup/TSM.
• TSM/Netbackup, clone oracle production databases using RMAN technology.
• On-call 24X7 site support

Environment: Oracle 8.x/9.x/10g,11gR2 RAC/Dataguard, SQL Server 2008, SQL, PL/SQL, RMAN, UNIX Shell/Python Scripts, Oracle Enterprise Manager/Grid Control, Linux x86 (32/64bit), AIX, E-Business Suite 11i/R12, DAC and Informatica.

Confidential

Oracle DBA Project Leader

Responsibilities:

• Primary contact for database performance issues in mission critical systems.
• Administrated Oracle 10g, 9i - Installed, migrated, upgraded, created, monitored
• Allocated & managed disk space. Tuned, backed up & Recovered databases
• Developing, implementing & supporting applications (CIS, Charge Calc
• Payable, Work Management, etc.) Designed for Utilities (Electric & Gas).
• Oracle High Availability Solutions viz. ‘Data Guard’ (Physical & Logical Standby Databases), Oracle9i Replication, 9i RAC.
• Installed & configured RAC on AIX, Linux & Sun Solaris using FireWire & InterConnect device, installing Oracle 9i Cluster Manager.
• Managed & configured RMAN with Oracle 9i databases & wrote RMAN shell/Pythonscripts for automation purposes.
• Tuned large PL/SQL applications performance queries using Oracle tools.
• Generate PL/SQL utilities to assist DBA, Reverse engineer legacy applications to be rewritten in PL/SQL.
• Provide PL/SQL training, instruction, mentoring & support to staff members by preparing & conducting classes, reviewing & critiquing staff members’ work.
• Installed & configured Oracle 9iAS
• Configured Oracle Forms 9i & Reports.
• Analyzed procedure & developed application programs utilizing shell scripting.
• Interface with clients as a troubleshooter & consultant
• Onsite installation & upgrade of Oracle databases
• Extensive database troubleshooting & SQL query tuning
• Evaluated/identified/resolved complex database performance issues.
• Planning & coordination of database backup & disaster recovery
• Database migration from Oracle 7.3.4 to Oracle 9i
• Evaluation of database migration requirements for HW/ AIX Server upgrade
• Learned & performed 3rd tier SAP Basis support administration.
• SGA sizing & analysis of storage requirements
• Index analysis, rebuilding & related tuning
• Data block recovery
• SQL Server Administration, monitoring & Data Transformation Services(DTS)
• Worked on Data Modeling using DBStudio (Embarcadero Technologies)
• Created data marts, data sets, & worked on data warehousing project management & decision support system management.
• Used the Oracle XML classes to query the Oracle metadata & create an XML file describing the database structure.
• Configured site-to-site VPN connections for development team & clients.
• Basic administration of AIX & Linux server.
• Technical training & documentation
• On-call 24X7 site support

Environment: Oracle 8.x/9.x/, SQL Server 200, SQL, PL/SQL, RMAN, UNIX Shell /PythonScripts, Oracle Enterprise,Linux x86 (32/64bit), AIX, E-Business Suite 11i, DAC and InformaticaConfidential

DBA

Responsibilities:

• Designed various Oracle systems: physical/logical data modeling.
• Oracle Server 8i installation & configuration
• Data migration from Oracle7.3.4. to Oracle8i
• Setup Hot & cold backup configuration.
• Oracle Designer/2000 database integrity constraint analysis & data modeling.
• Implement & support of enterprise wide database system.
• Oracle database administration & support.
• Logical & Physical Design of Oracle database using DBrtisan 5.1
• Planned Backup & recovery management.

Environment: Confidential -AIX, Sun Solaris 2.6, Windows NT, WIN 95/97/98/3.1