SUMMARY

• Over 10 years of extensive experience in Oracle Applications and database installation, maintenance and administration, Fusion Middleware Install and Maintenance, Excellent experience in design, development and implementation of systems in a wide variety of cutting edge environments.
• Good experience in Oracle E - Business patching, upgrading, Load balancing, PCP, database and applications migrations, Shared appltop, discoverer, workflow, grid control plugins, Oracle Database Production support, PSU and CPU patching, Dataguard (Physical Replication) and Goldengate and Streams (Logical Replication) support and configuration etc.
• Oracle E-Business Suite administration EBS and database upgrades from multiple versions to the latest versions in multiple platforms including database conversion between different endian formats.
• Oracle E-Business Suite administration EBS 11i, R 12 12.1 / 12.2 involving Oracle E-biz cloning, patching, user administration, application upgrades, DMZ configurations and troubleshooting developer, functional and business user issues.
• Oracle Database administration (installation, backup configuration using RMAN, applying security updates and bug fixes, upgrades, cloning and user administration) of 9i/10g/11g/12c on RAC and ASM wif dataguard (Physical / Logical) & active dataguard (ADG).
• Experienced in Space Management, Query Tuning and Application Tuning Cloned Oracle applications R12 and Databases.
• Data security through encryption.
• Capacity Planning and implementation.
• Leading and Managing the offshore / On site model wif 24 X 7 Production support.
• Experience of handling OLTP and DATAWAREHOUSING databases ranging up to 12 TB.
• Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM).
• Performance tuning of the databases including query tuning using SQL profiles and creating required indices, etc.
• Good Experience in managing and configuring Weblogic Server.
• Strong database, application and development tool troubleshooting expertise. Experienced in physical database design, architecture, modeling. Hands on database performance tuning and instance tuning for both RAC and NON-RAC environments.
• Installation and configuration of Grid Control 11g and 12c.
• Fusion Middleware 11g and 12c.
• SCAN listener configuration in 11gR2 RAC environments.
• Worked on11g RACand handled it wif the halp ofsrvctl, ocr, ocrcheck, ASM etc.
• Apex installation and database migration from OEL server to Amazon AWS cloud database RDS.
• LDAP and Active Directory for Single Sign On (SSO).
• Identity Management Suite (OID)
• SOX Compliance environments
• RMAN backups to disk, tape or ASM.
• Microsoft Azure Cloud server database migration.
• SQL and PL/SQL Tuning using SQL Profiles or Baselines or Hints.

TECHNICAL SKILLS

ERP: E-Business Suite R12.2.4, R12.1.3, 11.5.10.2, 11.5.9.

DATABASE: 9i, 10g, 11g

Development Tools: APEX, SQL Developer

DB Management: TOAD, OEM 11gR2/ 12c, Kintana

Operating Systems: Unix Flavors, RHEL, Solaris 5.9/5.10, IBM AIX 6.1/7.1, HP-UX, Windows Server

BI/Reporting tools: OBIEE 11.1.1.5, SOA

Application Servers: Oracle Application Server 10g, Oracle WebLogic Server 11g

Tuning Tools: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ASH, ADDM, SQLT

Programming: UNIX shell Programming (Bourne, corn), Perl, SQL, PL/SQL, HTML

PROFESSIONAL EXPERIENCE

Confidential - Sunnyvale

Lead Oracle Apps DBA -Consultant

Responsibilities:

• End to End Support for Production EBS 11i and R12 instances.
• Oracle Finance ERP Production Maintenance.
• AP, PO, GL, AR modules.
• Support for 11gR2 Production databases.
• Daily backups and daily EBS refresh instances.
• Performance tuning for existing and new concurrent programs.
• SQL Tuning for Journal Import and Customer Merge concurrent programs.
• Hyperion ARM and FDMEE SQLs tuning.
• Working wif Oracle support for resolution on Workflow Mailer issues.
• Resolve long running issues such as Gather Stats, Markview Hot Sync, etc.
• Support Kintana database upgrades from 10g to 11g.
• Supported the agile upgrade.
• Migration of the databases and applications between different file systems on different filers.
• Implemented new monitoring cron scripts for database maintenance and alerting the teams.

Environment: Sun Solaris, EBS 11i/R12, RDBMS 11gR2, Agile, Markview and Kintana

Confidential

Lead Oracle Apps DBA -Consultant

Responsibilities:

• Migrated database from HP UIX to RHEL6 64 Bit, Upgraded the database from 11.2.0.2 to 11.2.0.4
• Oracle Finance ERP Production Maintenance.
• Upgraded the Applications from 11.5.10.2 to R12.2.4
• Configuring shared application tier wif load balancer Using Hardware Load Balancers wif Single Web Entry Point
• Installed and configured 11g web discoverer and integrated wif E-Business suite
• Configured the applications wif SSL and installed the signed certificates.
• Advanced cloning of R12.2.4 application file system to non-prod instances.
• Maintaining production, development & test databases and applications.
• Oncall support on 24/7 in current month for stabilizing the latest R12.2.4 applications
• Configured and developed monitoring shell scripts to trigger an alert if services are down.
• Advanced cloning methods of R12.2.4 from multimode to single node
• Applied patches using ADOP wif different adop options.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Reviewed the procedures and methods used to manage the staging and production data feeds all via materialized views (replication).
• Installed and configured Single-Sign On and Implemented SSL Security.
• Oracle Access Manager (OAM).
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users
• Installed OEM 12c and configured all the targets to be monitored.

Environment: RHEL6, Oracle Apps 12.2.3 and Oracle database 11.2.0.4, Discoverer 11g, Demantra 7.3.1.5, BI Publisher 11g

Confidential

Senior Oracle Apps DBA -Consultant

Responsibilities:

• Upgrade of Oracle EBS from 11. .1.3. DB 11.1.0.7 to 11gR2.
• Maintained the customizations after the upgrade as they were before upgrade.
• Created a daily clone environment from PROD. This will run daily to clone PROD and the technical team can test and rectify the issues on it before implementing in PROD.
• Goldengate setup, support and maintenance.
• Resolve issues wif goldengate extract and replicat processes.
• 24x7 Production support of Oracle Applications Administration
• Configured and setup DMZ Public URL Successfully wif customer defined responsibilities
• Registered customized applications, Apps. Users, created responsibilities, customized menus, attached menus to responsibilities and finally this to users.
• Configuring SSL IMAP workflow mailer
• Discoverer upgrade to 11g
• Configured daily backup jobs which in turn take care of the copy part for daily clone of PROD.
• Created weekly PROD automatic restart job which takes care of cleaning of stale sessions and runs a sample request by sending the request log in mail to confirm the restart success.

Environment: -Oracle 11g, EBS 11i / R12 on Unix (Red Hat Linux)

Confidential

Lead Oracle Apps DBA -Consultant

Responsibilities:

• Migration of oracle database 9i from AIX to RHEL5
• Upgrade database from 9.2.0.4 to 11.2.0.3 in RHEL5, OATM migration of the database
• Upgraded Oracle Applications from 11. .1.3
• Discoverer upgrade to 11g and integrating wif EBS R12.1.3
• 24x7 Production support of Oracle Applications Administration
• Maintaining production, development & test databases and applications.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Created new application messages and then generated message file for application.
• Cloning the oracle applications Production to Non Production
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10g & 11g database.
• Planning and Administration of backup and recovery strategies.
• Created new custom tops as per the requirement.
• Created new application messages and then generated message file for application.
• Worked closely wif users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems wif solutions for future reference.

Environment: RHEL5, Oracle Applications 12.1.3 and Oracle database 11.2.0.2

Confidential

Lead Oracle Apps DBA -Consultant

Responsibilities:

• Migration of oracle database 9i from AIX to RHEL5
• Upgrade database from 9.2.0.4 to 11.2.0.3 in RHEL5, OATM migration of the database
• Upgraded Oracle Applications from 11.5.8 to R12.1.3
• 24x7 Production support of Oracle Applications Administration
• Maintaining production, development & test databases and applications.
• Configuring SSL IMAP workflow mailer
• Discoverer upgrade to 11g and integrating wif EBS R12.1.3
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user
• Created new application messages and then generated message file for application.
• Cloning the oracle applications Production to Non Production
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10g & 11g database.
• Planning and Administration of backup and recovery strategies.
• Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.
• Created new application messages and then generated message file for application.
• Created new Concurrent managers, Purged concurrent requests table and Implemented PCP.
• Worked closely wif users group to ensure timely implementation of an ERP.
• Provided application support to users and created a log of all the problems wif solutions for future reference.

Environment: RHEL5, Oracle Applications 12.1.3 and Oracle database 11.2.0.2

Confidential

Oracle Apps DBA

Responsibilities:

• Maintaining production, development & test databases and applications.
• Daily clone job using RMAN duplication for database.
• Daily database restart job.
• 24x7 Production Oracle Applications Administration.
• Applied patches using ADPATCH, ADCTRL utilities.
• Created test environment through cloning production environment for developers to test on live data.
• Implementation, customization and personalization of Oracle iProcurement.
• Generated reports and financial consolidations wif Oracle Hyperion Financial Management.
• Installed other supporting products for financial module like Oracle Essbase for modeling complex business scenarios and DRM/MDM.
• Advised and made recommendations to improve the overall database design.
• Monitored performance and availability of the VIS application (a high-availability web-based application running Oracle10g RAC on HP-UX cluster wif EMC SAN).
• Involved in developing a disaster recovery (DR) plan.
• Perform SQL tuning and assist developers wif coding PL/SQL.
• Continuous Performance monitoring and Database Tuning and application using OEM Tuning Pack, Diagnostics Pack and STATSPACK.
• Configuration of Workflow Notification Mailer, OAM, OEM10g.

Environment: RHEL4 and Solaris 5.9, EBS 11.5.10.2 and Oracle database 10.2.0.2

Confidential

Oracle Apps DBA

Responsibilities:

• Monitoring and maintain the database growth on daily basis, Modification of databases, Addition of tablespaces, datafiles and Modification of tablespaces, datafiles. Modification and addition of primary storage objects.
• Daily backup monitoring and validation. Backups use RMAN, BCV Split, etc.
• Weekly apps and database clones.
• 170 Markview configuration in non-prod environment during clones.
• Schema refreshes using exp/imp or datapump.
• Issues resolution for all the users related to database connection or performance.
• Database links issues and materialized views refresh validation checks.
• Worked on gather statistics on production instances as a part of performance tuning.
• Concurrent Manager monitoring and configure them to serve more requests during the month or close.
• Workflow monitoring and management. Continuous check on the mailer Queue and rebuild the queues when needed to improve the performance of the mail flow.

Environment: Linux RHEL5 and AIX 6.1, EBS 11.5.10.2 and Oracle database 10.2.0.3