SUMMARY

• Specialized in Oracle Applications R12/11i Database and System Administration with over 9 years’ experience in Oracle under UNIX environment.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications
• Experienced and proficient with Oracle E - Business Suite Application (R 12 12.2.5/12.1.3/12.1.1/12.0. x, 11.5.7, 11.5.8, 11.5.9 and 11.5.10) and Oracle Applications Server (9i/10g) in Sun Solaris, Oracle Enterprise Linux, Red Hat Linux, AIX and Windows environment
• Expertise in upgrading Oracle Applications from 11.5.10.2 to 12.0.4/12.1.1/12.1.3/12.2.5
• Experience in installing and administering WebLogic, Oracle SOA Suite.
• Performed database installation and upgrades. Experience in setting up HTTP Load Balancing
• Expertise in Implementing SSL for Oracle E-Business Suite Applications
• Expertise in implementing Shared APPL TOP and PCP
• Expertise in troubleshooting Workflow and Notification Issues
• Expertise in installing Discoverer and integrating to ERP Applications
• Implemented 10g Grid Control and applied Applications Management Pack for monitoring Applications
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC
• Experience in Installing and configuring Fusion Applications (IDM and Fusion Apps)
• Configure Oracle GoldenGate for data replication.
• Experience in DR setup with Data Guard using DG broker.
• Experience in implementing and using Oracle Streams & Oracle Golden Gate for Replication.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance issues
• Proficient in Oracle tools and utilities (Net8, Svrmgr, WebDB, OAS 4.0.8, Data Browser, Developer Suite, Export, Import, SQL*Loader, PL/SQL, OEM, IA, SQL Navigator, DB Artisan, ER Studio, Glance, SQL Expert) in UNIX (Sun Solaris, AIX, HP-UX) & Windows environment.
• Experience in general troubleshooting, fire fighting, development of scripts, documentation, issue resolution, and TAR/SR support
• Well versed in implementing System Management and Monitoring procedures
• Strengths include skills in Shell Programming, SQL, SQL*Loader, Import/Export and PL/SQL.
• Well versed with User Management, Performance Tuning, and Concurrent Processing Settings
• Experience in Security Management and Database Auditing
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX)
• Troubleshooting Login, Self Service Application, Jinitiator and Network related issues
• Skilled in handling a heavily customized 11i applications and upgrades.
• Applying RDBMS and Application patches. Sound knowledge in AD Utilities
• Monitor system performance, identify bottlenecks and ensure problem resolution
• Capable of tuning SQL using EXPLAIN PLAN, tracing at user level and TKPROF
• Work independently to ensure that the databases are operating efficiently and ensure proper backup and disaster recovery methods are maintained
• Experienced in Space Management, Memory Tuning and Application Tuning
• Troubleshooting expertise for all tiers (client, middle-tier, database)
• Create and Maintaining the Technical Notes and Documentation.
• Efficient Team Player, hard working, good in analytical and logical problem solving abilities with excellent communication skills.

TECHNICAL SKILLS

Hardware Platforms: Sun SPARC (E10000, E3500, E250, SUN Ultra and R Class), IBM AIX, IBM compatibles (IBM AIX 5L/4.3), DELL, Oracle SuperCluster, Oracle Exadata

Operating Systems: RedHat Linux 4/3, Oracle Enterprise Linux 5.5, UNIX (HP UX 11/10.1/10.20 , Solaris 8/2.4/2.6/2.7 , SCO, IBM AIX 5L/4.3), MS-WINDOWS XP/2000, MS-WINDOWS NT 4.0 Enterprise edition

Forms Servers: Developer 10g/9i, Dev2000 (1.6.1 and 1.3.2, 1.5.1), Dev6i

Application Servers: 10gAS (10gR2, 10gR3), IAS (10222), Weblogic

Programming Languages: SQL, PL/SQL, Unix Shell Scripting

Applications: Oracle Applications R 12 12.2.5/12.2.4/12.1.3/12.1.1 , 11i (11.5.7, 11.5.8,11.5.9,11.5.10,11.5.10.2), JDA, Vertex, EZTax, Moneta, Oracle SOA

GUI: DEVELOPER 6i, ADI, OAM, OEM, Kintana, Quest Stat

Tools: and Utilities: Oracle Tools OEM/OAM, SQL*PLUS And third party tools like Clear orbit, Jet forms, Quest Software (TOAD, SQL Lab), Oracle Golden Gate

Advanced Technology: Distributed Databases (Advanced Queuing, Materialized views), High Availability Options (Real Application Cluster (RAC) and Standby Databases) and Performance (Database, locking, parallel execution, partitions and SQL tuning)

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Oracle DBA/Apps DBA Consultant

Responsibilities:

• Upgrade Oracle Financials Applications 11i to R12.2.5
• Apply patches to Oracle EBS 12.2.5 using adop utility.
• Refresh/Cloning of Oracle EBS 12.2.5 on multi-node environment.
• Migrate Oracle E-Business Suite Financials 11i from Physical to Virtual hosts.
• Migrate Oracle E-Business Suite Advanced Supply Chain Planning 11i from Physical to Virtual.
• Configure Oracle RMAN Catalog database.
• Setup scripts to perform database and archivelog backups.
• Setup backup jobs in CommVault application.
• Refresh/Restore of Oracle Applications EBS 11i/R12 from CommVault.
• Validate the tape backups created by CommVault application.
• Provide System Administration for Oracle Financials and Oracle ASCP environments.
• Application of Oracle EBS patches using adpatch
• Work with users on troubleshooting and resolving issues.
• Troubleshooting SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs and tools like Explain plan, Tkprof & Stats pack.
• Provided 24/7 Production and Non-Production Support

Environment: Oracle Applications 11i (11.5.10.2), R12.1.3, R12.2.5, Oracle 11g, Oracle Enterprise Linux, RHEL, OEM12c, SQL*plus, SQL Loader, Toad, CommVault, Oracle RMAN.

Confidential, Mountain View, CA

Oracle DBA/Apps DBA Consultant

Responsibilities:

• Work on Cross-platform migration of Oracle databases to Oracle SuperCluster with Exadata.
• POC of upgrading Oracle Financials 11i to R12.2.4
• Perform system administration tasks on Oracle E-Business Suite 11i/R12.1.3
• Configuring and tuning concurrent managers.
• System administration tasks like application AOL object setup (users, menus, responsibilities, forms, reports, folders, request groups etc.).
• Troubleshoot issues with Oracle running on Exadata Storage.
• Perform analysis and application of both apps and database patches.
• Setting up printers in Oracle EBS and assisting users in resolving the printer related issues.
• Setting up databases in OEM 12c and monitoring them.
• Cloning of Oracle Applications EBS 11i/R12.
• Adding tables for replication in Golden Gate 12c.
• Work with users on troubleshooting and resolving issues.
• Setting up replication of databases using Oracle Golden Gate.
• Troubleshooting issues in Golden Gate environment using Logdump utility.
• Solved SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs and tools like Explain plan, Tkprof & Stats pack.
• Responsible for providing 24/7 Production and Non-Production Support

Environment: Oracle Super Cluster, Oracle Exadata, Oracle Applications 11i (11.5.10.2), R12.1.3/R12.2.4, WebLogic, Oracle OID 10g/11g, Oracle 10g/11g, Sun Solaris10, Oracle Enterprise Linux, RHEL, OEM12c, SQL*plus, SQL Loader, Toad.

Confidential, Mountain View, CA

Oracle Apps DBA Consultant

Responsibilities:

• Upgrading Oracle EBS from 11i to R12.2.4
• Online patching of R12.2 using adop.
• Upgrade of Oracle Applications (Advanced Supply Chain Planning) from 11.5.10.2 to R12.1.3
• Installation, configuring and maintaining Oracle 11g databases on ASM
• Planned and Upgraded Oracle database from 11.2.0.1 to 11.2.0.3.
• Cloning of Oracle Applications 11.5.10.2 with RAC and ASM.
• Cloning of Oracle Applications R12.1.3 on OEL 5 platform from RMAN backups.
• Build from scratch an Oracle EBS 11i environment on 2/3/4-node RAC with 11g Grid & ASM and setup RAC services.
• To tune and configure Oracle 11g database for optimum performance.
• Coordinate with QA, development support upon production releases.
• Installation and administration of WebLogic Server, Oracle SOA Suite.
• Integrating Oracle EBS with SSO and Oracle OID/OAM.
• System Administration of 11i and R12 instances.
• Configured DR environment with DataGuard using DG broker.
• Application of patches using ADPATCH for development and production issues.
• Setting up of printers in Oracle E-Business Suite 11.5.10.2 / R12.
• Developed backup scripts for Oracle Applications 11.5.10.2 /R12.
• Created Responsibilities and Application Users with proper security.
• Performed Application admin tasks using ADADMIN utility.
• Created and monitored the Concurrent Managers and setup PCP.
• Installed and configured Oracle Apex application.
• Analyzing the requirements and creating the database as per the requirements and the connectivity of clients to the server.
• Worked closely with developers helping them identify and fix issues (eg: User login issues, concurrent managers, OID authentication, vertex connectivity)
• Responsible for identifying gaps with and automating end-to-end Production to non-Production Refresh process.
• Provide technical assistance to all internal/external customers and backup for team members during system problems and implementation.
• Worked with Oracle support on resolution of issues.
• Attend meetings, communicate on technical issues, take input from Product Development and work directly with Oracle support on technical database issues.
• Planned and executed the most DB splits using various methods such as using Oracle standby DBs, CTAS, exp/imp.

Environment: Oracle Applications 11i (11.5.10.2), R12.1.3, R12.2.4, WebLogic, Oracle OID/OAM, 10g/11g, Oracle 10g/11g, Sun Solaris10, Oracle Enterprise Linux, RHEL, OEM, SQL*plus, SQL Loader, Toad.

Confidential, Redwood Shores, CA

Lead Oracle Apps DBA Consultant

Responsibilities:

• Upgraded Oracle Applications from 11.5.10.2 to R12.1.3
• Plan and upgrade of Oracle databases from 10g to 11g.
• Provided go-live support for upgraded Oracle Applications
• Installed and configured Fusion Applications (IDM and Fusion Apps)
• Cloning and Patching of Oracle Databases and Oracle Applications 11i/R12
• Troubleshooting the issues raised by user community and development
• Responsible in platform migration of Oracle Applications R12.
• Performed System Administration activities
• Provide administration support to Oracle Fusion environments.
• Worked on Java Mailer configuration and Workflow Administration
• Monitoring the file systems on production environments
• Resolving issues related to Web server, forms, reports, Discoverer.
• Perform Applications administration using AD utilities
• Discoverer 10g Installation and configuration, EUL upgrade and refresh.
• Maintenance of Concurrent managers and Parallel Concurrent Process (PCP).
• Developing UNIX and SQL scripts for the smooth functioning of database and applications related issues
• Supported the 2- node, 3-node, 4-node RAC environment.
• Configured load balancing on Apache and Forms Servers
• Solved SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs using scripts and tools like Explain plan, Tkprof & Statspack.
• Monitored databases and applications using Oracle Enterprise Manager (OEM) /Oracle Applications Manager (OAM)

Environment: Oracle Applications 11i (11.5.10.2), R12.1.3, Oracle 10g/11g, Sun Solaris10, Oracle Enterprise Linux, RHEL, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, San Diego, CA

Oracle Apps DBA Consultant

Responsibilities:

• Monitoring the Oracle applications and provided 24x7 On-call support
• Managing the patches and dealing with Oracle Support for many production and test/development Instances.
• Cloning of Oracle Applications 11i RAC to RAC and RAC to Non RAC.
• Upgraded Oracle Applications from 11.5.10.2 to R12
• Upgraded 9i databases to 10g (10.2.0.4) databases
• Post go-live support of Oracle Applications R12
• Maintenance of 10g databases and other non-ERP Databases
• Implemented parallel concurrent processing in R12
• Configured ASM on one of the Prod OLTP instance.
• Configured Oracle GoldenGate for data replication.
• Providing support for Oracle applications and also JDA, Vertex, EZTax, Moneta, Ariba, OBIEE, Hyperion, SQL Server databases.
• Implementing and troubleshooting of forms server, report server, Discoverer server, Web Server.
• Maintenance of Concurrent managers and Parallel Concurrent Process (PCP).
• Worked on Oracle 10g new features like data pump, flashback tables, ASM, ADDM, AWR, etc.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listeners running, disk space availability, checking for errors in alert logs etc.
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc
• Worked on Application System Administration. Activities like user setup, defining responsibilities, values sets, flex fields, data groups and request groups, registering applications, menus, forms, reports, concurrent programs.
• Successfully implemented 3-node RAC setup and made the environment stable
• Configured load balancing on Apache and Forms Servers
• Applied the patchsets, oneoff patches, opatch to the Development and production servers
• Monitoring of databases using 10g OEM grid control
• Implemented the Oracle E-business suite Application Management Pack on OEM
• Implemented Shared APPL TOP
• Troubleshooting the issues raised by oracle ERP from both user community and development
• Taking care of the performance issues both at the database level and applications level
• Planned and coordinated weekly maintenance tasks and outages.

Environment: Oracle Applications 11i (11.5.10.2), R12, Oracle 9i/10g, OBIEE, Hyperion, Sun Solaris10, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer, SQL Server.

Confidential, Atlanta, GA

Oracle Apps DBA Consultant

Responsibilities:

• Monitoring of multiple production instances of versions R12 & 11i residing on various Operating systems such as Linux, HP-UX.
• Supported 4 highly volume based production instances and 10 dev and test systems.
• Multi-node installation of R12 applications.
• Patching and Cloning of Oracle Applications using adpatch &Rapid clone utility.
• Monitored databases and applications using Oracle Enterprise Manager (OEM) /Oracle Applications Manager (OAM)
• Configured backup of ERP systems using RMAN.
• Developed Shell Scripts for daily monitoring of databases, Applications, RMAN backup and backup validate.
• Supported the 2- node RAC environment.
• Upgraded database from 10.2.0.4 to release 11.1.0.6
• Discoverer 10g Installation and configuration, EUL upgrade and refresh.
• Providing high database availability and data protection using Data Guard.
• Installed Oracle Data Integrator 10.1.3.5 to integrate with PeopleSoft GL modules.
• Configuring and tuning concurrent managers.
• Perform system administration tasks like application AOL object setup (users, menus, responsibilities, forms, reports, folders, request groups, request set etc.) and Purge AOL tables.
• Creation of new users and assigning of responsibilities.
• Successful set up of a new custom Schema and making it fully functional.
• Analysis and application of both apps and database patches.
• Solved SQL and PLSQL performance issues like wait events by proactive monitoring of long running jobs using scripts and tools like Explain plan, Tkprof & Stats pack.
• Assisting users in resolving the printer related issues and setting up new printers.
• Developed Unix Shell scripts and SQL queries
• Worked on TAR, coordinating with Oracle for SEV 1/2 issues.
• Provided 24 x 7 on call support for Production databases.

Environment: Oracle Applications R12 (12.1.1/12.0.6 ), 11i (11.5.10.2), Oracle 9i/10g, Sun Solaris 8, Netapps, OEM, SQL*plus, SQL Loader, Toad, Oracle Discoverer.

Confidential, CA

Oracle Apps DBA Consultant

Responsibilities:

• Cloning of Oracle APPS 11.5.7 Instance on HP-UX 11.0 platform
• Upgraded Oracle Applications 11.5.7 to Oracle Applications 11.5.8 on HP-UX 11.0 platform
• To tune and configure Oracle 8i Database for optimum performance.
• Perform System Administration activities
• Applied the patches using ADPATCH utility
• Setting up of printers in Oracle E-Business Suite.
• Developed backup scripts for Application 11.5.7
• Created Responsibilities and Application Users
• Performed Application admin tasks using ADADMIN utility
• Work closely with development, testing team and resolve issues.
• Maintenance of Concurrent Managers
• Create scripts to verify all instances are up and running and send alerts if they are down
• Verified that all Application Services are on-line
• Provided on-call production support as and when Schedule and in emergency situations.

Environment: Oracle 8i, Oracle Applications 11.5.7/11.5.8 E-Business Suite, OEM, SQL*plus, Imp/Exp, RMAN, SQL, PL/SQL, SQL*loader, tkprof, HP-UX 11.0, Windows2000.