Oracle Supply Chain
Resume:
Arjun Juturu
Oracle Applications DBA
Ph# 408-***-****
Summary:
A seasoned enterprise DBA with over 14 years of extensive IT experience working with Oracle ERP Applications. Extensive experience with Oracle Databases and Oracle Applications primarily on UNIX in 7X24 Environments.
Following are my areas of Expertise:
• Over 14 years of experience in the IT industry.
• Mentored DBAs in USA,BRAZIL,FRANCE,Canada,INDIA.
• Implemented Change controls.
• Lead DBAs supporting Global oracle ERP(ebusiness suite) infrastructure.
• Over 12 years of experience as Oracle Applications DBA.
• Administered oracle applications using SYSADMIN responsibility.
• Utilized DBA skills for maintenance and administration of databases.
• Upgrades databases from 7.3.4 to 8.0.5
• Upgrades databases from 8.0.5 to 8.1.7.4
• Upgraded databases from 8.1.7.4 to 9.2.0.4,9.2.0.5,9.2.0.6,9.2.0.7,10.x
• Upgrades databases from 9.2.0.6,9.2.0.7 to 10g R1,R2.11R1,11R2.x
• Migrated Databases from Sun to HP.
• Migrated Databases from Sun to Linux.
• Supporting more than 80 customers on oracle ERP.
• Installed Oracle on Unix, Linux, Windows Platforms.
• Installed and configured oracle, Oracle Application Server, Oracle webdb2.1, Apache on Unix and NT platforms.
• Installed Oracle Applications 10.6,10.7,11.0.3,11.5.8,11.5.9,11.5.10,R12.0.x on Unix Platforms (Sun, HP V-Class, Linux, Windows 2000).
• Upgraded Oracle ERP Applications from 10.7 – 11.0.3, 11.0.3 – 11.5.8,11.5.8 – 11.5.9, 11.5.10 cu2,12.0.2,12.0.6,12.1.X
• Installed 10g database and 10g Application Server for in house built portal site.
• Upgraded Discoverer.
• Worked in Multi Node Installations.
• Refreshed Databases.
• Applied numerous patches for oracle applications.
• Supported Tera bytes of Databases.
• Supported more than 20 Oracle Application Instances at single client.
• Implemented SSL for 11i ERP Database.
• Installed and Implemented Kintana.
• Installed and maintained MRC in 11.0.3,11.5.8,11.5.9
• Maintained ‘Standby Database’ for disaster Recovery
• Backup and Recovery. Using EMC’s BCV technology for backups and using HP’s omni backup software which provides RMAN to back up the database and for recovery purpose.
• Did upgrades from 10.7 to 11.0.3, 11.5.8 – 11.5.9,11.5.9 to 11.5.10 CU2.R12.0.0 – R12.0.2,R12.0.4,11.5.10.2 to R12.1.1
• Supported RAC and SSO environments.
• Implemented RAC for ERP Environments from DBA prospective.
• Installed and upgraded Databases from 9.2.0.x to 9.2.0.7
• Installed and upgraded Databases from 10.0.x to 10.2.0.3
• Installed and upgraded Databases from 9.2.0.x to 11.1.0.7
• Installed R12.0.0 ERP with 10gR2.
• Supported BPEL
• Experience in performance optimization and tuning.
• Good experience in tools and techniques for analyzing, reporting, fixing issues Oracle 10g Database Platform, 10gAS,Toad,Oracle XMLPublisher, Patch software installation, Work flow mailer.
• Applied Quarterly CPU patches.
• Implemented DST.
• Worked Remotely for Customers.
• Did Remote ERP upgrades to clients.
• Did Remote DB upgrades.
• Did Remote Support to multiple clients.
• Good knowledge of Servers, Security and Network Administration
• Worked on advanced configurations of Database and ebusiness suite, including hardware load balancing, external-facing applications, Advanced Supply Chain, RAC, shared storage.
I am considered a valuable asset to the company due to my work, dedication, innovative ideas and clear perception. I build strong relationship with my fellow workers and users to establish a steady flow of communication.
Jun 10 – Present (Net Logic Microsystems, Lead Oracle Applications DBA, CA)
• Working on implementing High Availability using Grid cluster 11gR2 and ASM for Oracle Business suite R12.1.2 without RAC.
• Implemented SSL setup for iexpense for Ebusiness Suite Module on Linux and managed oracle ERP R12.0.3 instances.
• Upgraded oracle applications from R12.0.3 to R12.1.2 with db 10.2.0.4.
• Created new instance for ASCP R12.1.1 with 11.1.0.7 (64bit)
• Upgraded ASCP instance from R12.1.1 to R12.1.2
• Installed and configured Demanta7.3.1 both internal and external tiers.Oracle selected NetLogic implementation for NorCal OAUG Training Day 2011 at the Santa Clara Convention Center, January 13, 2011.
• Upgraded and Migrated oracle database (10.2.0.4) from 32bit to oracle database 11.2.0.1psu-3 64 bit on OEL5.X.
• Migrated R12.1.2 applications from 32 bit to 64bit.
• Installed and configured Oracle UPK content management software.
Mar 10 – May 10 (IBM, Lead Oracle Applications DBA, CA)
• This is a hosted environment.
• Supported multiple customers using oracle ebusiness suite R12.1.2.
• Supported multi node and Rac enabled instances.
• Did cloning of applications and databases for different customers.
Nov 09 - Feb 10 (Agilent Technologies, Lead Oracle Applications DBA, CA)
• Implemented and Supported Advanced Supply Chain Plannning on R12.1.1 and 11g. (This Major work involves setting up a separate planning R12.1.1 Oracle ebusiness suite instance, setting database links between primary ERP instance and planning instance, setting ssl, setting HA (High Availability)
• Implementing Phase one oracle Fusion. (SOA,WEB LOGIC,BPEL,EM)
(The major portion of the work I worked on is phase one HA of Database)
Dec 07 – Nov 09 (Core Services, Sr Oracle Applications DBA, CA)
• Upgraded oracle ebusiness suite from 11.5.10.2 to 12.1.1
• Supported more than 100 customers in oracle ebusiness suite.
• This is a hosted environment.
• Implemented and Supported Advanced Supply Chain Plannning on R12.1.1 and 11g, R11.5.10.2 and db 10.2.0.4
• Supporting all versions of ebusiness suite from 11.0.x to R12.1.1.
• Database versions 8i,9i,10Rx,11Rx.
• Migrated databases from server to another server.
• ProActively monitoring for performance issues, database issues, Applications issue through Monitoring tools and scripts
• Performing clonings, patchings, routine applications dba tasks.
• Troubleshooting database issues, performance issues, Printer issues.
• Upgraded databases, ERP applications to different versions.
• Worked with oracle support to fix database bugs based on proactive monitoring for ora-600,7445 errors in the log files.
• Did database migration projects.
• Created DR and tested DR for oracle ERP and Oracle Financial Analyzer.
• Restored purged data from tables using oracle hot backup.
• Lead database migration projects.
• Worked on RAC enabled instances
• Installed Portal, oracle applications server.
• Installed and configured UPK
• Has extensive experience on ASCP support.
• Implemented SSO/OID with E-Business Suite
• Installed 10gias10.1.4.0.1 infra as part of sso implementation
• Configured Portal with E-Business Suite
JUL 07 – Sept 07 (HD, Sr Oracle Applications DBA, CA)
• Supported more than 45 databases and Oracle Applications 11.5.7 (Financials, CRM)
• Supported DR instances
• Did DB refreshes, Applications refreshes.
• Worked on Month End close refreshes.
OCT 06 – JUN 07(Oracle Corporation, Principal DBA, CA)
• Did upgrades from 11.5.8 – 11.5.10 cu2
• All the customers supported are in Linux.
• Worked in Hosting environment.
• Did upgrades from 11.5.9 – 11.5.10 cu2
• Did UAT upgrade from 11.5.10 cu2 – 12i
• Did db upgrades from 9.2.0.x – 10g R2
• Worked on RAC enabled instances.
• Worked on SSO enabled instances.
• Implemented and Supported Advanced Supply Chain Planning on R12.1.1 and 11g, R11.5.10.2 and db 10.2.0.4
• Worked on DMZ enabled instances.
MAY 05 – OCT 06 (Cisco Systems, Inc., Sr Oracle Applications DBA,CA)
• Did test upgrades from 11.5.8 - 11.5.10
• Did database upgrade from 8.1.7.4 - 9.2.0.6., 9.2.0.5 - 9.2.0.6
• Supporting all flavors of Oracle Applications (11.5.7 – 11.5.9)
• Involved in upgrade from 10.7 to 11i in later part as part of production support team
• Did many ERP and Non ERP Clonings.
• Applied numerous patches
• Member of SOX team in implementing security on db side.
• Supporting many DR databases.
• Involved in Day to Day activities.
• Supported SSO enabled Oracle Applications.
• Supported and implemented RAC enabled Oracle ERP Environments.
• Did patching and cloning of databases extensively.
MAR 05 – MAY 05 (Juniper Networks, Sr Oracle Applications DBA,CA)
• Supported more than 80 databases and Oracle Applications 11.5.9 (Financials, CRM)
• Supported DR instances.
JAN 05 – Mar 05 (GE Consumer & Industrial, Sr Oracle Applications DBA, Fort Wayne, Indiana)
• Upgraded 11.5.7 Oracle Applications with 8i database to 11.5.9 and 9.2.0.5
• Supported Oracle Applications after go live.
• Did refreshes during Upgrade.
• Applied patches to both Database and Applications.
• Installed ADI.
JUNE 98 – DEC 04 (Sanmina Corporation, Sr Oracle Applications DBA, CA)
ORACLE DBA DUTIES:
• Performing oracle duties on HP/UX Super Dome, V-class production servers, Sun Server Version 2.6
• Involved in upgrade from 10.6 character to 10.7 NCA implementation.
• Upgraded 10.7 NCA to 11.0.3 on Sun Platform.
• Migrated 11.0.3 on Sun to HP V-class.
• Implemented multi languages in 11.0.3 (French, Finnish)
• Upgraded 11.0.3 to 11.5.8 on HP Unix Platform.
• Upgraded 11.5.8 to 11.5.9 on HP Unix Platform.
• Upgraded Discoverer from 4.1.36.x to 4.1.48.6
• Implemented Multi Node Installations in 11.0.3, 11i.
• Installed and maintained MRC in 11.0.3 and in 11i.
• Supporting Remote standby database as a DR site.
• Supporting 7 x 24 Oracle production database
• Installed and Configured forms server for NCA.
• Installed and Configured Appletviewer, Jinitiator.
• Configured Listener.ora for multiple instances.
• Doing day to day duties and supporting users.
• Installed Discoverer 3.x,NoetixViews.
• Configured Discoverer 3.x in Apps mode.
• Maintaining the database and schema objects.
• Wrote scripts to catch invalid objects in the database.
• Created parameter files and control files to setup the environment for the database.
• Created Month end database and reporting instance.
• Refreshed Reporting, Development, Test instances with Production Instance.
• Supporting more than 20 Development and Test instances.
• Installed and configured oracle 8I, oracle applications server, oracle Webdb on sun 2.6, NT.
• Installed French NLS, Finnish NLS on oracle applications 10.7 NCA,11.0.3.
• Refreshed Databases .
• Installed and Configured OFA (Oracle Financial Analyzer) and Express Server.
• Installed and configured OEM, Quest Software Tools (Shareplex, Toad, Spotlight).
• Installed and Configured Applications Desk Top Integrator 6.x(ADI)(GLDI 3.x,4.x,6.x,7.x).
• Extensively tuned Database Performance for optimal performance.
• Supporting 20Tera Bytes of Data.
• Supporting multiple production Instances.
• Upgraded Oracle Database from 9.2.0.2 to 9.2.0.4.
• Installed and Configured 9iAS,10g web server.
• Implemented SSL for 11i ERP Database.
• Installed 10g database and application server for portal application developed by Sanmina-SCI.
ORACLE FINANCIALS SYSTEM ADMINISTRATOR:
• Involved in System Administration of oracle financial applications by defining Responsibilities, Users, Logical Database, Oracle ID, Report Security Groups.
• Monitored concurrent manager and its concurrent process.
• Defined Workshifts to concurrent Managers.
• Tuned concurrent managers for performance.
• Wrote scripts to monitor long running jobs / reports with invalid parameters.
• Created Secure users for HR implementation.
• Installed and configured GLDI.
• Applied patches intensively.
Nov 97 – Jun 98 Software Engineer, BVS Inc., Sunnyvale, CA 94086
ORACLE DBA DUTIES:
• Installed Oracle 8.0 and oracle 7.3 on windows NT.
• Maintained the database and schema objects.
• Assisted in database tuning
• Involved in backup/recovery.
• Configured database to help minimize fragmentation.
• Created parameter files and control files to setup the environment for the database.
• Performed oracle duties on Sun/Solaris system.
• Wrote backup procedure to do weekly cold backups and daily archive log backups.
• Performed Backup and Recovery duties using Enterprise Manager.
• Administerd windows NT like setting up user accounts,setting up group accounts,
Securing network resources with share permission, Auditing and monitoring resources.
• Developed Forms using HTML and connected to server using Asps and validated data using Java script.
• Migrated data from legacy sytem to open interface modules in financials using SQL*loader.
• Migrated Data Base from Oracle 7.3.2 to Oracle 8.0.4.
ORACLE FINANCIALS SYSTEM ADMINISTRATOR:
• Involved in System Administration of oracle financial applications by defining Responsibilities, Users, Logical Database, Oracle ID, Report Security Groups.
• Monitored concurrent manager and its concurrent process.
• Defined Workshifts to concurrent Managers.
• Comfortable in any interface programming, Developing forms, reports in Oracle financials.
• Extensively Involved in Interface programming like :
• AP : Imported Invoice Information, Bank Information into Oracle Payables.
• GL: Worked on journal Import to transfer the data from the interface tables to General Ledger.
• Involved in Migration of SQL*Forms2.3 forms to Forms4.5 and reregister them using AOL and tested the forms at different levels.
• Designed forms to aid the Purchasing department to keep track of vendors for whom no tax ID is recorded and maintained address, contact, telephone number and 1099 type for each vendor.
• A report to display item purchase statistics like the last purchase price, PO number,Vendor, date and other details, number of pending POs and Requisitions, quantity onHand and other information.
• Developed a report to show List of purchase orders raised for each month.
• Created custom forms with vendor specific information to aid the payables department to keep some information secure from other users in department. Used Quick picks, Quick codes, Who features of AOL in customizing forms.
EDUCATION:
BS, MS
PROFESSIONAL TRAINING:
ITIL certified.
Oracle Applications setup & Interface programming.
Oracle Database Architecture.
Oracle Performance & Tuning.
Oracle Backup & Recovery.
Oracle Replication.
HP Omni Backups.
Contact this candidate