PROFESSIONAL SUMMARY:

• A highly accomplished Oracle/EBS Certified Professional with 13+ years of hands on expertise with DB & Apps Administration, Installations, Configurations, Upgrades, Migrations, Patching, Cloning, Performance Tuning, Backup/Recovery, Space Management, DB security, Auditing, Troubleshooting, DB Design, Oracle metalink support, Shell Scripting, Documentation and 24/7 mission critical production support.
• Hands on exposure with OLTP / Data warehouse database systems managing large environments
• Oracle EBS 11i / R12 applications on 10g/11g/12c/exadata databases with RAC/ASM & Mysql dbs
• Hands on exposure with VMWARE, Microsoft SQL Server 2005, 2008 and 2012 environments
• Oracle Apps DBA activities on 12.2.5, 12.2.4,12.1.3, 12.1.1, 12.0.4, 11.5.10.2, 11.5.10, 11.5.9, 11.5.8
• Performed snapshot, snap mirror database volumes using NetApp snapshot technology
• Handle Patch management, cloning, code migrations, release management etc.
• Handle performance tuning of both Apps and DB layers and configure ERP products.
• Expertise with 10g/12c OEM , RMAN, SPARC/REMEDY ticketing system, STAT/Kintana/Panaya tools
• Well exposure on Financials on Purchasing, Accounts Payable, Accounts Receivable, General Ledger
• Profound knowledge on Fixed Assets, Property Manager, Inventory and workflow services
• Expertise with multi node shared file system, SSO/OAM with OID/Portal, SSL and DMZ
• Well exposure on Hyperion and Fusion middleware components and administration, support
• Hands on Installing and upgrading E - business suite R12.2 from R12.1
• Expertise with Web logic, OBIEE, Workflow Builder, Hyperion, People Soft and Informatica
• Well exposure on SOX, FDA audit and compliance procedures
• Performed System roll-outs and change management during project implementation
• Trouble shooting Concurrent Manager issues and setting up PCP
• Disaster recovery and high availability (setting up logical/physical data guard with RAC)
• Handled Installations, Configurations, Upgrades, Migrations and 24/7 support
• Implemented Logical/rman/hot/cold/snap backups and recovery, disaster recovery
• Handled Complete/incomplete db recovery, recovering data files, block corruption etc
• Expertise with exadata in large scale industries and dataware house environments
• Handled 10g/ 11g RAC administration and its components in various unix and windows flavors
• Sound knowledge on Data modelling, data/system integration, data management etc.
• 12c/11g/10g/9i databases administration on Sun, HP, AIX, RHEL and Windows platforms.
• Sysadmin activities define conc programs, request sets, profile settings, user/responsibility mgmt
• Handled Printer settings, concurrent manager setups, workflows setups.
• Cloning/refresh of Oracle Applications/Databases from Production to TEST, DEV, QA, UAT
• Handled Monitoring, Patching, performance tuning, troubleshooting Appl/DB issues in a 24x7
• Profound knowledge and hands on Oracle 10g, 11g, 12C features, OEM, ASM, and Grid Control
• Database Performance Tuning and Network Trouble Shooting using TNS configuration
• Management of tablespaces, tables, views, synonyms, indexes, database links and materialized views
• Engaged in collecting SqlTrace, TKPROF, Explain plan, Statspack, AWR, and ADDM.
• Handled Database performance, hit ratios, I/O, lock, and latch contention.
• 10g/11g features, Data Pump, Flash-Back Recovery, Grid monitoring, and Recycle bin.
• Loading data from flat files using external tables, SQL*LOADER.
• Database growth on daily basis, modification of databases, addition of tablespaces, datafiles
• Table reorganization, index rebuild, gather stats/analyze tables periodically etc
• Oracle Support processes for technical requests using Metalink.
• Escalations process, raising/open p1 bridge, gather respective teams and lead the call
• Expertise with SQL, PL/SQL programming, shell/perl/cron scripting
• Handled mission critical 24/7 prod environments to ensure high availability

PROJECT EXPERIENCE:

Confidential, NY

Sr. Oracle Apps DBA

Responsibilities:

• Support DBA activities on Oracle EBS/Sybase Databases of Dev/Test/Uat/Prod/DR environments.
• Upgraded EBS from R12.1.1 to R 12.2/12.2.5 and implemented 12c Database on exadata platform.
• Engaged in Installation & Build of EBS DEV, SIT, TEST, UAT, PROD & DR environments.
• Involved in installing and configuration of 13c Oracle Enterprise Manager on cloud infrastucutre
• Handled Analyzing Patches, prerequisites and technology stack bug fixes on EBS environments.
• Perform applications code migrations/Database Deployments by STAT/Panaya/Kintana tools
• Handled configuration of EBS products: Financials, HRMS, HCM, Order Management & iProcurement
• Experience of database migration from commodity (non-exa) to exadata environment
• Clear understanding of Exadata features: Flash cache, Storage Index, HCC and IORM
• Exposure of Luns, Cell Disk, Grid disk, Exadata hardware and Cell Storage software
• Administering exadata cell/storage server using utilities of CELLCLI and DCLI
• Experience with exadata bundle patching including Storage cell, DB server, PDUs/network switches
• Engaged in Installation & Configurations of Multitenant Databases of 12c
• Performed patching of Databases (PSU, CPU, one-off )
• Involved in upgrade & migration of Database from 11g to 12c on exadata machines
• Handled creation, configuration and Management of Data guard and Data guard Broker
• Engaged in managing All protection modes of Data Guard Databases
• Performed Recovery of Primary from Standby Databases
• Performed RMAN backups, recovery and clones
• Handled Golden Gate and Oracle Stream installation, Configuration and Management
• Engaged in Database Refreshes from PRD to TST/DEV/UAT
• Strong knowledge on basic concepts of RAC and ASM
• Performed creation, configuration and Management of Oracle RAC, ASM
• Engaged in Database and PL/SQL Performance tuning
• Involved in interpreting AWR and ADDR, TKPROF and Explain Plan reports
• Handled TOP wait Events, Type of Indexes, Fragmentations, HWM, Statistics & automation of tools
• Support EBS environments using ADOP, cutovers, patching, cloning, migrations, releases
• Perform regular backup/restores on all the EBS/Database Environments.
• Perform patching to all the EBS products (Financials/HRMS/SCP etc.)
• Apply security to all the users on all the EBS applications and databases.
• Perform Disaster recovery activities on EBS application/Database servers
• Expertise on end to end administration of Oracle EBS 11i / R12.1 / R12.2 on RAC/ASM
• Expertise on troubleshooting cluster / asm storage related issues.
• Expertise on PCP and middle tier Load balancer setup / troubleshooting
• Expertise in troubleshooting Oracle EBS issues related to Concurrent Manager / OPMN / Workflow etc
• Performed Oracle DB admin tasks like Backup, Restore, DB refreshes, clones etc
• Performed Clones of Oracle Applications R12 instances using NetApp snapshot technology
• Application Code migrations, FNDLOAD, Apps bounce/restart etc through ITSM/CR/SPARC requests
• Handled Cloning and Refreshing Oracle Database/Application Instances.
• Performed Oracle Database Patching and Tax updates.
• Performed Database Health check and Space Management.
• Performance tuning of DB ( exa cell servers / disks) and Apps through various scenarious
• Supported RAC instances (4 node) using SRVCTL utility.
• Maintained databases on 10g/11g/12c including all daily activities and DBA jobs.
• Handled Hot, Cold, Logical, net backups using RMAN/SNAP for backup and recovery.
• Engaged in writing Python/Shell/Perl scripting for various activities at DB/Apps admin
• Supported PROD environments 24/7 regular/oncall, rotational basis along with support teams

Confidential, CA

Sr. Oracle Apps DBA Lead

Responsibilities:

• Administration of Oracle 11g/12c RAC, sybase databases & R12 Applications on RHEL 64 bit environments
• Handled 10g/11g databases conversion to RAC and 12c with exadata environments
• Performed Applications code migrations using Kintana / Panaya tools.
• Configured Oracle ERP products: CRM, EPM, Financials & HRMS with EBS 12.2 applications
• Experience of database migration from commodity (non-exa) to exadata environment
• Clear understanding of Exadata features: Flash cache, Storage Index, HCC and IORM
• Exposure of Luns, Cell Disk, Grid disk, Exadata hardware and Cell Storage software
• Administering cell/storage server using utilities of CELLCLI and DCLI
• Experience with exadata bundle patching including Storage cell, DB server, PDUs/network switches
• Performed Oracle web logic server (12.2.1) configuration with EBS.
• Handled issues of Financials of Purchasing, Accounts Payable, Accounts Receivable, General Ledger
• Handled issues of Fixed Assets, Property Manager, Inventory and workflow services
• Patch/Release management through patch wizard and change management process.
• EBS R12 Applications support on 11g/12c databases with RAC/ASM using SRVCTL
• Configuration and implementation of Japan language with EBS R12
• Oracle discoverer configuration and setup with oracle EBS
• Handled Oracle EBS issues related to Concurrent Manager / OPMN / Workflow etc
• Performance tuning of both Apps and DB layers (Cell Servers/disks) in exadata environments
• Web logic, SOA suite, Oracle EBS R12.2 installations and configurations
• SSO/OAM with OID/Portal and DMZ/SSL setups and configurations during cloning process.
• EBS upgrade from R12.1.3 to R12.2.5 and Oracle Database from 11gR2 to 12C
• Oracle DB admin tasks Backup, Restore, Disaster recovery, Data guard setup, Golden gate
• DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL using NetApp snapshot technology
• Oracle production instances and web logic servers on exadata environments
• Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
• Periodic Cold/Hot/snap/rman backup & recovery processes
• Performed Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
• Performance tuning using Explain Plan, SQL*Trace, TKPROF, AWR reports
• Configured Standby database for disaster recovery and data guard setup for high availability.
• Handled Load balancing, databases/schema/table re-organization for faster performance.
• SQL tuning and assisted developers with coding on PL/SQL
• Monitored database performance through alerts, alert log, enterprise manager and awr reports
• Hands on Shell/Perl scripts, cron jobs, backup scripts
• Health Check of Databases, Applications and monitored performance
• Handled critical Database recovery from Block Corruption and a physical datafile drop
• Handled the process of analyzing tables every night through a cron/manual script
• Security and access to database by granting and revoking roles to and from users.
• ASCP, Demantra, ODI, Financials, HRMS modules configurations in R12 environment
• Supported mission critical PRD environments 24/7 oncall and offsite.

Confidential, TX

Team Lead

Responsibilities:

• Oracle, mysql Database Administration on UNIX/SUN, DB2, Sybase environments.
• 11gR2 database Installation, Configuration on Linux
• Supported Weblogic, OBIEE, OID, Hyperion, SOA and Informatica environments
• Configured multinode shared file system, SSL and DMZ with EBS
• Configuration and setup of Dataguard for high availability
• Configuration of 11g RAC for 3 nodes on Red Hat Linux
• Handled Change, Problem, Release, Incident, Security Management.
• EBS upgrade from 11i to R12 and Oracle Database from 10g to 11g
• Clones of Oracle Applications R12 instances from PROD to DEV,TEST, UAT
• Configured financials, HRMS, CRM and Manufacturing modules with EBS
• Logical backups, Hot/Cold Backup and Recovery and Database Refreshes.
• Incomplete/complete recovery of data files, tablespaces, control files
• Handled critical database block corruptions using media/tape backup
• Oracle Software 10g/11g on Sun Solaris platform.
• Handled database space requirements and adjust for future needs.
• Performed database Performance Tuning using AWR, and ADDM
• Network Trouble Shooting using TNS configuration, listener/sqlnet settings.
• Handled database memory usage, cpu usage, hit ratios, I/O, locks/latch contention.
• Performed FNDLOAD, Export/Import, expdp/impdp, Materialized Views, Replication.
• Performed Disaster Recovery Drills, documented database and application validation steps.

Confidential, MA

Sr. Consultant

Responsibilities:

• Installation of Oracle 10g/11g on RHEL, SUN, DB2, Sybase
• Database creation for Testing and Development
• Applications upgrade from R11i to R12.1.1 on RHEL
• Oracle HRMS products configurations with R12
• Clones of Oracle Applications R12 instances.
• Periodic backup of the databases on 9i/10g/11g
• Backup & Recovery procedures to ensure consistency.
• Oracle Recovery Manager (RMAN), and standby database
• Hot/cold/snap/rman backups and backup validations
• Import/Export, Impdp/Expdp, Flashback, ADDM and AWR.
• Performance tuning using explain plan, trace, tkprof, awr reports
• Environment setup, database design, rdbms data modelling.
• Database cloning and refreshes to setup test and development database
• Standby database for disaster recovery and data guard for high availability.
• Load balancing, databases/schema/table re-organization for perrformance.
• Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
• DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
• Oracle production instances and web logic servers.
• Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
• Periodic Cold/Hot/snap/rman backup & recovery processes
• Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
• Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports
• Mission critical PRD environments 24/7 oncall and offsite.

Confidential, CA

Sr. Apps DBA

Responsibilities:

• System roll-outs and change management during project implementation
• Concurrent Manager issues and setting up PCP
• Disaster recovery and high availability (setting up logical/physical data guard with RAC)
• Installations, Configurations, Upgrades, Migrations
• Logical/rman/hot/cold/snap backups and recovery, disaster recovery
• Complete/incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Handled large data in large scale industries and dataware house environments
• Configuration of oracle business accelerators with EBS R12
• Handled Data modelling, data/system integration, data management etc.
• Performed Oracle Apps DBA activities on 12.1.3, 12.0.4, 11.5.10.2 on Oracle, DB2, Sybase
• Supported 10g/9i databases on Sun, HP, AIX, RHEL and Windows platforms.
• Sysadmin activities define conc programs, request sets, profile settings, user/responsibility mgmt
• Printer settings, concurrent manager setups, workflows setups.
• Cloning/refresh of Oracle Applications/Databases from Production to TEST, DEV, QA, UAT
• Monitoring, Patching, performance tuning, troubleshooting Appl/DB issues in a 24x7 environment.
• Oracle 10g, 11g, 12C features, OEM, ASM, and Grid Control
• Database Performance Tuning and Network Trouble Shooting using TNS configuration
• Designed Tablespaces, tables, views, synonyms, indexes, database links and materialized views
• SqlTrace, TKPROF, Explain plan, Statspack, AWR, and ADDM.
• Database performance, hit ratios, I/O, lock, and latch contention.
• Mission critical 24/7 prod environments to ensure high availability

Confidential

Oracle Apps DBA

Responsibilities:

• EBS R12 Applications on 11g/12c databases with RAC/ASM using SRVCTL
• Configuration of Arabic language with EBS R12
• EBS 11i cross platform migration from Win bit to Linux 86-64bit
• PCP and middle tier Load balancer setup / troubleshooting
• Oracle EBS issues related to Concurrent Manager / OPMN / Workflow etc
• Handled financials of Purchasing, Accounts Payable, Accounts Receivable, General Ledger
• Handled Fixed Assets, Property Manager, Inventory and workflow services
• Performed performance tuning of both Apps and DB layers on DB2, Sybase, Oracle
• Weblogic, SOA suite, Oracle EBS R12 installations and configurations
• SSO/OAM with OID/Portal setups and configurations during cloning process. upgrade from R11.5.10.2 to R12.1.1 using oracle database 10gR2
• Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
• DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
• Oracle production instances and web logic servers.
• Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
• Periodic Cold/Hot/snap/rman backup & recovery processes
• Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
• Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports
• Standby database for faster disaster recovery and data guard setup for high availability.
• Load balancing, databases/schema/table re-organization for faster performance.

Confidential

Oracle DBA Consultant

Responsibilities:

• Oracle databases, Applications on RHEL Linux 64 bit environments
• 10g databases administration and monitoring using 10g OEM
• 10g Databases cross platform migration from HP to Linux.
• Patch management and release management through change management
• EBS R12 Applications on 10g databases with RAC/ASM using SRVCTL
• Configuration of SSL certificates with EBS R12 for apps security
• Middle tier Load balancer setup / troubleshooting
• Oracle EBS issues related to Concurrent Manager / OPMN / Workflow etc
• Performance tuning of both Apps and DB layers.
• Weblogic, SOA suite, Oracle EBS R12 installations and configurations
• SSO with OID/Portal and DMZ/SSL setups/configurations during cloning process.
• Upgrade from R12.1.1 to R12.1.3 and implemented 12c Database
• Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
• DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
• Oracle production instances and web logic servers.
• Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
• Periodic Cold/Hot/snap/rman backup & recovery processes
• Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
• Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports
• Standby database for faster disaster recovery and data guard setup for high availability.
• Load balancing, databases/schema/table re-organization for faster performance.
• SQL tuning and assisted developers with coding on PL/SQL
• Database performance through alerts, alert log, enter prise manager and awr reports
• Shell/Perl scripts, cron jobs, backup scripts

Confidential

Oracle Apps DBA

Responsibilities:

• Installation of Apps R12 on RHEL, SUN, HP and AIX
• Clones of Oracle Applications R11i/R12 instances.
• 10g database cross platform migration from SUN to RHEL
• Periodic backups of the databases on 9i/10g using RMAN
• Backup & Recovery procedures to ensure consistency.
• Oracle Recovery Manager (RMAN), and standby database
• Hot/cold/snap/rman backups and backup validations
• Import/Export, Impdp/Expdp, Flashback, ADDM and AWR.
• Performance tuning using explain plan, trace, tkprof, awr reports
• Handled environment setup, database design, rdbms data modelling.
• Performed database cloning and refreshes to setup test and development database
• Standby database for disaster recovery and data guard for high availability.
• Load balancing, databases/schema/table re-organization for perrformance.
• Oracle DB admin tasks Backup, Restore, Disaster recovery, data guard setup
• DB/Apps refreshes/clones from PRD to DEV, TST, UAT, VAL
• Application Code migrations, FNDLOAD through ITSM/CR/SPARC/REMEDY requests
• Periodic Cold/Hot/snap/rman backup & recovery processes
• Export, Import, Expdp, Impdp, Flashback, ADDM and AWR.
• Performance tuning using Explain Plan, SQL*Trace, TKPROF, Statspack, AWR reports

Confidential, NJ

Programmer Analyst

Responsibilities:

• Handled Oracle Apps DBA activities on 12.1.1, 12.0.4, 11.5.10.2 application versions
• Performed System releases, code deployments during project implementation
• Concurrent Manager issues during programs run time on month end process
• Disaster recovery and high availability (setting up logical/physical data guard with RAC)
• Logical/rman/hot/cold/snap backups and recovery, disaster recovery
• Complete/incomplete recovery, recovering data files, tablespaces, control files, block corruption.
• Configuration of oracle business accelerators with EBS R12
• Data modelling, data/system integration, data management etc.
• 10g/9i databases on Sun, HP, AIX, RHEL and Windows platforms.
• Sysadmin activities define conc programs, request sets, profile settings, user/responsibility mgmt
• Printer settings, concurrent manager setups, workflows setups.
• Cloning/refresh of Oracle Applications/Databases from Production to TEST, DEV, QA, UAT
• Monitoring, Patching, performance tuning, troubleshooting Appl/DB issues in a 24x7 environment.
• Oracle 10g ASM, OEM / Grid Control to monitor PRD/DEV databases effectively
• Database Performance Tuning and Network Trouble Shooting using TNS configuration
• Database growth on daily basis, modification of databases, addition of tablespaces, datafiles
• Table reorganization, index rebuild, gather stats/analyze tables periodically etc
• Oracle Support processes for technical requests using Metalink.
• SQL, PL/SQL programming, shell/perl/cron scripting and helping developers in robust queries