SUMMARY

• 6+ years of experience in IT industry, as an Oracle Application DBA and core DBA supporting multi Terabyte databases (Cooked/RAW/ASM) on multiple environments.
• Database and application upgrade of Confidential OLTP from 9i to 10g in RAC 3 - node and application from 11.5.10 to 11.5.10.2 (4 node).
• Experience in maintaining and quick problem solving ability for 24x7 Oracle Application databases and core databases.
• Experience in maintaining and monitoring Oracle Application databases in HP-UX, Linux and Windows platforms.
• Experience in Patching (using adpatch, Kintana), Cloning (Rapid Clone and Manual Clone) and using AD utilities.
• Excellent troubleshooting skills in Apache, Forms, Database, Concurrent node issues
• Experience in building up Oracle ERP databases from scratch for quarterly releases
• Proven experience in maintenance of Oracle CRS & RAC 10.2.0.x
• Experience in User & RMAN managed backup/disaster recovery/standby server recovery
• Experience in Workflow Administration in Oracle Application.
• Experience in managing Concurrent Managers, planning for concurrent manager workers as per requirement.
• Experience in maintaining standby databases (Oracle 9i/10g/11g).
• Troubleshooting problems related to user errors.
• Expertise in backup and recovery strategies for production environments.
• Proven ability to interact with end users, good team player and quick learner.
• Ability to work independently with little or no supervision

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g, SQL Server 2000

ERP: 11.5.7, 11.5.8, 11.5.9, 11.5.10.2, Advanced collections

Middleware: Oracle 10g AS, OID & LDAP Server, Names Server

Oracle Tools: Enterprise Manager, Toad, PLSQL developer, tkprof, SQL Loader, statspack, RMAN, dbverfiy, logminer, EXP/IMP, EXPDP/IMPDP, flashback, Wallet manager, ASM, ADDM, explain plan

Other Tools: Remedy, HP Open View, ITG Governance

Operating Systems: Linux, HP-UX 11

Programming: Shell scripting, PLSQL, SQL

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Application DBA

Responsibilities:

• Cloning Oracle Application Instances to build Development, UAT and QA instances
• Applying Oracle Application and database patches (patch analysis and application using adpatch)
• Regular database backup activity
• Table space and data file management, file system management
• Planning database and application outages for maintenance window
• HEAT Ticket solution for Oracle Application and database users
• Implement new changes to monitoring scripts as per new requirements.
• Provide 24/7 support for multiple production instances
• Patch analysis and schedule downtime for applying of patch
• Clone and Patch Oracle applications (ERP) 11.5.10.2 instances.
• Performance tuning in Oracle Applications instances and other production DBs
• Shell scripting for cron jobs & some customization in already created scripts.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards

Confidential

Sr. Oracle Application DBA

Responsibilities:

• Cloning Oracle Application Instances to build Development, UAT and QA instances
• Applying Oracle Application and database patches (patch analysis and application using adpatch)
• Regular database backup activity
• Table space and data file management, file system management
• Planning database and application outages for maintenance window
• Remedy Ticket solution for Oracle Application and database users
• Implement new changes to monitoring scripts as per new requirements.
• Provide 24/7 support for multiple production instances
• Patch analysis and schedule downtime for applying of patch
• Clone and Patch Oracle applications (ERP) 11.5.10.2 instances.
• Performance tuning in Oracle Applications instances and other production DBs
• Shell scripting for cron jobs & some customization in already created scripts.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards

Confidential

Oracle Application DBA

Responsibilities:

• Cloning Oracle Application Instances to build Development, UAT and QA instances
• Created automated clone scripts for Cooked/RAW/ASM instances to reduce manual intervention during cloning
• Oracle Workflow Administration (Notification Mailer issues, workflow migration)
• Applying Oracle Application and database patches (patch analysis and application using adpatch and KINTANA)
• Fix up gradation issues in coordination with Oracle Support
• Regular database backup activity
• Oracle Application System Administration (managing concurrent managers, user creation, creating responsibility, menu and functions, register new applications, managing profiles)
• Table space and data file management, file system management
• Planning database and application outages for maintenance window
• Remedy Ticket solution for Oracle Application and database users
• Key player in preparing upgrade plan
• Implement new changes to monitoring scripts as per new requirements.
• Led Non-prod and tech support team
• Provide 24/7 support for multiple production instances for NA and Europe
• Patch analysis and schedule downtime for applying of patch
• Provided training and support to new resources in team
• Worked closely with different teams to consolidate work
• Implement enterprise RMAN repository on Oracle 11g.
• Implement Oracle Enterprise Manager (OEM) 10g Grid Control on 11g repository database.
• Support Oracle Apps (ERP) 11.5.10.2 upgrade activities on Shared Application Tier Environment involving OM/INV/WSH/PO/QP/AR/AP and GL modules.
• Clone and Patch Oracle applications (ERP) 11.5.10.2 instances.
• Performance tuning in Oracle Applications instances and other production DBs
• Shell scripting for cron jobs & some customization in already created scripts.
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards

Confidential

Oracle Application DBA

Responsibilities:

• Patching, Cloning and other maintenance activities.
• Level 3 support for troubleshooting issues.
• Pro-active maintenance and looking after system health in production environments.
• Administering third party products like Vertex, Ariba, JDA.
• Administering and maintaining other Oracle products like Hyperion.