SUMMARY

• Certified Database Administrator professional with 11.5 years of experience in implementation, maintenance and support of production e - business suite applications & Oracle Core Databases.
• More than 8.5 years of experience as Oracle Apps DBA (11i and R12, 12.1 and 12.2) and have expertise in Cloning, Patching, Implementations, Upgrades, Migrations, Backup/Recovery, Customizations, Integrations, Troubleshooting and Performance tuning . Also having good experience on SYSADMIN tasks (Audit Trail, Printer Setup, and Profile Options etc.), User Account management - creating users, disabling users, responsibility management. Managing concurrent managers, ensure system is running smooth, monitoring throughput.
• My area of proficiency includes Advisory Consulting, Supporting PROD, UAT, VAL, SIT and DEV environments, Performing Database and e-business suite upgrades, providing effort estimates for installation and upgrades, Hardware Sizing.
• Oracle Applications DBA hands-on experience on platforms: LINUX, SOLARIS, HP-UX and AIX.
• Good Exposure and experience in WebLogic administration and Shell scripting.

TECHNICAL SKILLS

ERP: Oracle Applications 11i and R12, 12.1.3 and 12.2

Databases: Oracle 9i, 10g and 11g (RAC), 12c

Platform: RHEL, HP-UX, Solaris, AIX, Windows 9x/ 2000/2003/2008

Application Servers: Oracle 10g Application server and Web Logic 11g

Monitoring Tools: Oracle Enterprise Manager, Solar wind

Ticketing Tools: Service Now, REMEDY, BMC Patrol, Front range

Other Tools: TOAD, SQL Developer, Putty, Winscp, VNC, VMware and others.

Programming: Shell scripting, automation.

PROFESSIONAL EXPERIENCE

Confidential, Foster City, CA

Oracle Apps DBA ( Oracle Applications DBA/Oracle DBA )

Responsibilities:

• Responsible for managing and supporting all Production, Development and Test instances of Oracle Version 11.2.0.3, 11.1.0.7, 10.2.0.4 & Oracle Applications E-Business suite R12.1.3, 12.1.1 .
• Providing EBS Instances as a part of preparing pursuit and Jump-start projects
• Analyzing the existing environments and automating the activities through different tools (wherever possible)
• Maintaining (VLDB) OLTP databases in 24x7 Production environments on Multiple Applications Tiers.
• Extensively work on single Node & Multi Node cloning including RAC databases.
• Implement shared appl top in R12 environments.
• Upgrade Oracle Applications from 11.5.10.2 to 12.1.3
• Upgrade Oracle Database from 11.1.0.7 to 11.2.0.3
• Perform general technical troubleshooting and working with Functional teams for possible solutions for various issues..
• Production support Maintenance activities, written shell scripts for Monitoring production activities.
• Extensively work on tuning the database with STATSPACK/AWR, TKPROF, 10046 TRACE, 10053 TRACE, EXECUTION PLANS, SQL PROFILES, STORED OUTLINES, SQL PLAN BASELINES, SQL HINTS.
• Worked on resolving performance issues, delay in running stored procedure and batch jobs.
• Developed UNIX shell scripts and SQL scripts to carry out routine checks on databases.
• This includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs etc and Building Schema Index bugs.
• Configure SSO, OID and OCA components in the application server.
• Implemented ASCP, Demantra and ODI in R12 environments
• Configured and migrated 10g/11g RAC databases on RHEL environments .
• Handled PCP and middle tier Load balancer setup / troubleshooting
• Handled Weblogic, SOA suite, Oracle EBS R12 installations and configurations
• Backup and restore databases using recovery manager.
• Fixing day to day production support tickets raised by the end-users and the developers.
• Applying Oracle Applications patches (Maintenance Pack, Interoperability patch, Family pack, one off patch, Security patches etc on 12.1.1 instances.
• Implemented security in a DMZ configuration.
• Single Sign on (SSO) and SSL implementation.
• Troubleshot Concurrent service and Concurrent manager issues
• Setup a crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues etc.
• Document standards and operating procedures.

Tools/Special Software: Oracle Applications Release R12, Oracle 9i/10g/11g, SQL*Loader, OEM,TOAD, CA Service Desk Manager.

Confidential, Redwood Shores

Oracle Apps DBA ( Oracle Applications DBA )

Responsibilities:

• Worked on multi node shared file system, SSL and DMZ configurations
• Handled configuration and setup of Dataguard for high availability
• Handled Change, Problem, Release, Incident, Security Management.
• Handled Concurrent Manager issues and setting up PCP
• Maintain/Administer all Online Gaming databases, which are very critical and live all the time.
• Effort estimation, resource planning, client coordination, developing backup Strategies.
• Upgrade Oracle Applications and Oracle Database.
• Apache, Forms, and Concurrent manager issues.
• Autoconfig failures
• Platform migration related issues
• Capacity planning
• Apply PSU/CPU patches.
• RMAN backup & recovery.
• Migrated database from one instance to another instance.
• Sysadmin Activities.
• Support production and development environment.
• Reporting problems and patch issues to Oracle and working towards resolving the same.
• Weekend Support.
• Process Automation.
• Working on change requests as per process
• Incident resolution
• Patch management and change control management.
• Resolving tickets.
• Installations of MYSQL 5.1 and 5.5, Backup support, Refreshes, User management, Performance Tuning, Replication set up in master slave configuration.

Tools/Special Software: Oracle Applications Release R12, Oracle 9i/10g/11g, SQL*Loader, OEM, TOAD, CA Service Desk Manager.

Confidential, Webster, New York

Oracle Apps DBA ( Oracle Applications DBA )

Responsibilities:

• Applying application (adpatch) and database (opatch) patches on DEV, IST, UAT and PROD environments
• Cloning non prod instances from prod (includes DB refresh and complete clone)
• Performing daily production support activities that include monitoring the instances using OEM, Troubleshooting user access and system performance issues, analyzing AWR reports, Code Migrations, health checks of system, Handling Space Issues, working on Oracle SRs and other activities
• Handled sysadmin activities define conc programs, request sets, profile settings, user/responsibility mgmt
• Handled Monitoring, Patching, performance tuning, troubleshooting Appl/DB issues in a 24x7 environment. Taking Full, incremental backups using RMAN
• Handled Printer settings, concurrent manager setups, workflows setups.
• Handled table reorganization, index rebuild, gather stats/analyze tables periodically etc
• Automated Replication Monitoring
• Production and Non Production checkouts
• Patching
• Sysadmin Activities
• Supporting user community
• Oncall Support
• Process Automation
• Production support
• Resolving tickets

Tools/Special Software: Oracle Applications Release 11i, Oracle 8i/9i/10g, SQL*Loader, OEM, Hummingbird Connectivity, Remote Print, Data Loader, PL/SQL Developer

Confidential

Oracle Apps DBA ( Oracle Applications DBA )

Responsibilities:

• Upgrade Planning and logistics: Created upgrade plans for Arrow and provided them 12.1.1 XB7 Patches along with required documentation.
• Techstack upgrade: Helped Arrow with 10.1.2.3, 10.1.3.4 and Java 6 upgrade.
• Upgrade Application Tier: Performed Pre-upgrade checks and helped Arrow upgrade their test/prod instance to 12.1.1 Xb7. Also applied additional critical patches from Financials.
• Expert Help: Provided expert help during Arrow's Upgrade to 12.1.1 XB7

Tools/Special Software: Oracle Applications Release R12, Oracle 10g/11g, Hummingbird Connectivity, TOAD

Confidential

Oracle DBA

Responsibilities :

• Product Design & Development: Initiated, designed and developed the dbc approach for the Customer. Taken active parts in design discussion and contributed ideas to enhance the feature.
• Database Administration: Designed the database, Installed maintained and administered the database.
• Delivery Management: Demonstrated and delivered the product to CS Team and the client.

Tools/Special Software: Oracle Applications Release R12, Oracle 9i/10g, OEM, Hummingbird Connectivity,PL/SQL Developer

Confidential

Oracle DBA

Responsibilities:

• Design & Development: Initiated, designed and developed oracle installer for installing and configuring the prepaid software.
• Testing: Simulated test data, created test plan and ran the testing process.

Tools/Special Software : Oracle Applications Release R12, Oracle 8i/9i, Hummingbird Connectivity