Principal Consultant
ennVee Solutions Pvt Ltd
Total des années d'expérience :16 years, 3 Mois
Project Details
I) Project 1 (US Client)
• Currently working on install and integrate oracle SSO (OAM & OID) with EBS 12.1.3.
• APEX installation, SSL enable for APEX(ORDS) and creating windows service to AutoStart
ORDS service.
II) Project 2 (US Client)
Responsibility-
• Supported to EBS 12.1.3 with Database 12.1.0.2
• Provided support when users sending requests to migrate code for their testing. Multiple requests
handling and replying to users with details.
• If users facing issues to access instances, troubleshooting issues, and making sure that keep
instances available to users.
III) Project 3 (US Client)
Responsibility-
• Provided production support for EBS 12.2.4 instance on OCI with EXADATA DB machines.
• Troubleshooting user’s issues as per Cherwell tickets, patching, cloning, change request activities
for EBS 12.2.4 instance.
IV) Project 4 (US Client)
Responsibility-
• EXCEL4APPS Installation, upgradation and perform required pre and post steps.
V) Project 5 (Internal)
Responsibility-
• Working on Trendz Monitoring tool (ennVee tool) as like OEM to monitor Database, EBS and
other applications like SOA, OBIEE, WebLogic etc
VI) Project 6 (US Client)
Responsibility-
• Worked on Database 19c and EBS 12.2.9 Upgrade Project.
Project Details
I) Project 1
Responsibility-
• Provided production support for EBS 12.2.5 instance 24/7.
• Performed patching, cloning, task migration activities for EBS 12.2.5
instance.
• Administration of EBS-R12.2.5 instances.
• Worked on ETL and reporting tools like OBIEE.
• Supported SSO (OAM and OID) for integrated with EBS 12.2.5
II) Project 2
Responsibility-
• Worked on application upgrade (EBS-R12.1.2 to EBS-R12.2.5)
• Worked on custom top creation, multinode configurations using shared file system.
• Applied WebLogic patches on EBS 12.2.5 instance.
• Integrated SSO with upgraded EBS12.2.5
• Workflow configuration and administration.
• Configured Mobile Application and enabled required applications.
• Implemented Brazil Localization and EMEA Localization. Applied latest
country specific Add-on Localization patches
III) Project 3
Responsibility-
• Worked on Application upgrade (from EBS-R12.1.3 to EBS-R12.2.5)
• Applied Advanced supply chain planning (ASAP) patches.
• Worked on custom top creation, multinode configurations using shared file system.
• Applied WebLogic patches on EBS 12.2.5 instance.
IV) Project 4
Responsibility-
• Providing production support to EBS 12.1.2 with Exadata databases with RAC node.
• Applied Opatches on Exadata for both RAC nodes.
I) Project 1
Client Sunrise foods Pvt. Ltd. Kolkata.
Role Senior Oracle Apps DBA
Responsibility:
I) Worked on Database and Application upgrade (DB-10.2.0.2 APP-12.0.6 to DB-11.2.0.3 APP-12.1.3) and migrated from RHEL-4.4(32-bit) to OEL-6.5(64-bit)
II) Applied RPC patches and product specific patches after upgrade and migration.
II) Project 2
Client Synpack Zipper Bags Pvt. Ltd. Bangalore
Role Senior Oracle Apps DBA
Responsibility:
II) Worked on implementation project to install EBS 12.1.1 and upgrade DB from 11.1.0.7 to 11.2.0.3 and application to 12.1.3 . Also Applied RPC patches over 12.1.3
I) Project 1
Client IDEA Cellular Pvt. Ltd. Pune
Role Oracle AppsDBA
Responsibility:
• Providing support to multi node environment production instance for Oracle
application R12 (12.1.3) and RDBMS (11.2.0.3) with RAC and ASM .
• Upgraded RDBMS (10.2.0.5) to (11.2.0.3) and application (11.5.10.2) to (12.1.3)
• Patching Analysis and patch application.
• Rapid Cloning from production instance to test instances.
• Implementing RFC's on UAT and production instance.
• Diagnose and resolve users issue and close the ticket in BMC tool.
• SSL (HTTPS) Implementation on DEV and UAT instance.
• Created DR server (replica of production server) and doing DR drill quarterly.
• Quarterly applying CPU patches.
• Daily backup of production for application and database using RMAN.
• Implemented PCP (Parallel concurrent processing) in oracle apps.
• Monitoring Tivoli alerts
• Configured shell scripts for monitoring and atomization for smoothly working
of application.
I) Project 1
Client Kirloskar Pneumatic Co. Ltd. Pune
Role Oracle Apps DBA
Responsibility:
• Worked on Oracle application 11i (11.5.10.2) and RDBMS (10.2.0.5) multinode
environment.
• Patch analysis and patch application
• Cloning database and application to test instances.
• Post steps after upgrade of ATG7
• Upgraded Roll UP INV4 to INV23
• Revised user accesses (Created Menus, responsibilities for 17 org, assigned
profiles, assigned security rules)
• Define new programs, request groups.
• All sysadmin task
• Daily Activities and Monitoring
II) Project 2
Client SIOM (Sinhgad Institute of Management) Pune
Role Oracle AppsDBA
Responsibility:
• Worked on R12 installation for giving training SIOM and provided support
for multiple instances.
• Worked on client machine configurations for accessing the front end for users
and resolved the issues of users.
I) Project 1
Client Honeywell Automation India Ltd. Pune
Role Oracle AppsDBA
Responsibility:
• Worked on Oracle application 11i (11.5.10.2) database (9.2.0.7).
• Applied adpatches, localization patches, opatches and used ad utilities when
required.
• Rapid cloning for oracle application.
• Database 9i, 10g installation on windows 2003 server.
• Upgrade Database from 9.2.0.5 to 9.2.0.8 and from 9.2.0.8 to 10.2.0.4
• Database cloning on windows server 2003.
• Applied Critical Opatch for database on windows server 2003 environment.
• Deployed tested queries\scripts on production database when requested.
• Oracle application Sysadmin activities.
• Run the diagnostic scripts and provide the output.
• Resolve the database and application performance issues.
• Oracle client installation(i.e. Report builder, form builder, SQL developer,
Workflow, Discoverer)
• Worked on Exp/Imp utility on schema level, tablespace and tables.
• Resolved the issues related windows database services
• Database backup using RMAN utility.
• Create and alter the database objects as per requirement.
• Database auditing.
• Created duplicate database using RMAN backup.
• Daily DBA/Apps DBA task.
II) Project 2
Client Honeywell Turbo Technology Pune
Role Oracle AppsDBA
Responsibility:
• Created standby database for Production.
• Implemented RMAN backup policy for production database.
I) Project 1
Client PTC Pvt. Ltd. Pune
Role Oracle DBA/Apps DBA
Responsibility:
• Worked on seven different database instances on the different Platforms.
• Daily performance monitoring and taking reports.
• Worked on database security.
• Database backup, restore and recovery.
• Database space management.
• Execute and analyze ADDM, AWR report
• Rebuild indexes and analyze tables.
• Deploy the queries on production after confirmation from development team.
• Provide the required information to management regarding database.
II) Project 2
Client - Rucha Engineers Pvt. Ltd. Aurangabad
Role - Oracle DBA/Apps DBA
Responsibility:
• Upgraded oracle application from 11.5.9 to 11.5.10.2 and oracle database
from 9.2.0.3 to 9.2.0.8
• Rapid cloning for oracle application 11i
• Applied adpatches, localization patches, opatches.
• Worked on adadmin, adpatch, adrelink, adctrl, admrgpch, adident, adconfig utilities.
• Create SR, update SR, OWC session, and download patches from metalink.
• Start and stop oracle database and application services.
• Manually backup of archive log, cold backup in the tape and backup of control file.
• Remove old archives to make space available on mount point.
• Compile Invalid objects.
• Rebuild indexes, analyze tables, and execute packages.
• Add or resize data files for the particular tablespace.
• Database and application tuning.
• Create application users assign required responsibilities.
• Printer installation and configuration in the application.
• Set the profile as per requirement.
• Schedule any program in application when required.
• All the tasks related system administrator and DBA/Apps DBA.
III) Project 3
Client - Novelis (India) InfoTech Ltd, Pune
Role - Oracle DBA/Apps DBA
Responsibility:
• Worked on RAC and Multinode environment for 12.0.6 oracle application and 10.2.0.4
database.
• Worked on several databases (10.2.0.4) which are on windows server 2000, 2003 and
2008.
• Cloning of production instance to development and test instance.
• Patching application.
• Database administration of production, development and test instances.
• System administration functions like creating users, creating responsibilities,
menus and functions.
• Database and server Space management
• Database backup and recovery procedures,
• Deleting old archives on the server.
• Security implementation including routine maintenance activities.
• Providing required information regarding database and application to
management and users.
• Closely monitoring the each database and application to prevent the issues.
MBA- Professional
B.sc (Computer Science)
HSC