SUMMARY

• Over 7 years of total experience in IT, encompassing a wide range of experience in various Oracle technologies as Oracle Apps DBA: Oracle Databases (9i, 10g, and 11g), Oracle Applications (11i, R12).
• Installation, patching, upgradation, configuration maintenance of Oracle 10g RAC, 11gR2 RAC, Standby Databases (Data Guard), Oracle Apps.
• Experience in managing business/mission critical high availability databases.
• Worked on Oracle Real Application Clusters & Data guard on Linux.
• Hands On Experience in installing, configuring and managing Oracle 11gR2 RAC with ASM
• Expertise in Maintenance, Patching, Cloning, Troubleshooting and Performance Tuning of Oracle Applications E - Business Suite
• Production Experience in administering Oracle Apps 11i, and upgrades from 11.5.8,11.5.9 to 11.5.10,R12
• Hands-on experience on Oracle tools such as 10g and 11g Enterprise Manager and RMAN.
• Expertise in configuring OEM Grid 10g, 11g, 12c.
• Excellent working experience in troubleshooting OEM 10g, 11g, 12c.
• Expertise in scheduling and monitoring backup through OEM.
• Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g and Oracle Apps 11i and R12 in UNIX/LINUX and Windows environment.
• Management of schemas, objects & Partitioning the tables & indexes.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Statspack, AWR, ADDM and OEM Grid Monitoring.
• Experienced in using Data Pump, Flashback Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Experience on Apps cloning from Prod to Development and Testing
• Experience in Apps Patching (HR global patching payroll patching)
• Excellent knowledge in user management, roles, profiles
• Excellent knowledge in Backups and Recovery and Cloning of databases using RMAN.
• Planned and implemented Disaster Recovery & high availability solutions using Oracle Standby Database, Golden Gate
• Delivering Oracle Database performance-tuning services for customers with Explain Plan, Tkprof, Statspack, SQL Trace, AWR, ADDM, OEM Grid Control custom scripts troubleshooting Oracle databases using SQL trace utilities.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, buffer cache, redo mechanisms.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g/9i Oracle 11g (RAC, Data Guard), Oracle Apps

OPERATING SYSTEMS: HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 4.x, 5.x, UNIX and Windows 2003/XP.

LANGUAGES: SQL, UNIX Shell Scripting, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: DBCA, DBUA, RAC 10g/11g, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM, Oracle Golden Gate

PROFESSIONAL EXPERIENCE

Confidential, MN

Sr. Oracle Application DBA

Environment: Oracle 11g and Oracle Apps R12.

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) 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
• Experience on replication technologies like Oracle Golden Gate.
• Configured Oracle Golden Gate unidirectional and bidirectional replication for Oracle-Oracle homogeneous databases.
• Experience in performing the initial load methods using Golden Gate.
• Experience in monitoring and troubleshooting Oracle Golden Gate processes like manager, extract, extract datapump and replicat.
• Experience on data transformations during replication and other GG utilities like logdump for extract process troubleshooting.

Confidential, Minnesota

Sr. Oracle Application DBA

Environment: Oracle 9i/10g and Oracle Apps 11i.

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
• SSL implementation in oracle apps environments.
• Clone and Patch Oracle applications (EBS) 11.5.10.2/R12 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, MN

Oracle Apps DBA

Responsibilities:

• Handling high availability (24/7) database in onsite-offshore model
• Handling Performance issues at the application level and database level
• Applying regular quarterly CPU patches and keeping the databases up to date with the Oracle security updates
• Providing support to 10g RAC databases.
• Rolling patching and upgrades of 10gRAC databases.
• Experience in Configuring the Cluster and Creation of RAC Database.
• Experience in maintaining the Cluster databases using Srvctl.
• Experience with RAC to Non RAC cloning and Non RAC to RAC Migration.
• Experience adding the Cluster node to an existing cluster.
• Taking backup of OCR and VOTING DISK
• Experience on DATAGUARD and Create and maintaining Physical standby database.
• Good experience in Oracle Installations and Oracle database Creation through DBCA, OMF and ASM.
• Creation of ASM databases, ASM instances and administration of ASM Instances and ASM Disk groups on CORE environment.
• Providing support to the data warehouse jobs and tuning queries.
• Upgrading the databases from 9i to 10g.
• Cloning the Oracle home and upgrades.
• Creating health monitoring Unix shell scripts
• Scheduling the health scripts using crontab, mailx.
• Troubleshooting the user access issues.
• Creating User profiles, roles
• Handling Service requests using ITIL tools.
• Working closely with the application teams on scheduling the patching windows.
• Cloning the databases regularly for the reporting databases and stage environments.
• Tuning the database level performance issues.
• Taking AWR reports and analyzing them periodically for better performance.
• Creating Backup schedules and taking periodic backups both offline and online using RMAN
• Participating in corporate DR drills and ensuring the data protection.
• Installation of 9i and 10g application servers.
• Troubleshooting the application server issues.
• Defragmentation of the tables using exp/imp, rug, shrink
• Working with Oracle on critical database bug/issues.
• Creating process documents for the DBA activities and making sure that teams adhere to the process outlined.
• Taking the client requirements and working closely with the business teams on their requirements and providing the solutions
• Creating partitions for partitioned tables periodically
• Managing materialized views and refreshes
• Creating DB links to heterogeneous environments for the data warehouse
• Periodic index management, index rebuilding.
• Training Junior DBAs on DBA activities

Environment: Oracle Enterprise Linux, Oracle 10g, 9i, 8i.

Confidential

Oracle Apps DBA

Responsibilities:

• Administering and maintaining single-tier and multiple-tier Oracle Applications 11i and R12 instances.
• Administering, patching, upgrading and maintaining Oracle database versions 9i, 10g
• Troubleshoot various Applications and database related issues, including performance issues.
• Oracle Applications 11.5.10 to R12.0 upgrade.
• Oracle Applications 11.5.8 to 11.5.10 upgrade.
• Troubleshooting RAC databases
• Troubleshooting Data Guard-related issues
• Implemented Huge Pages for various customer instances to improve their performance
• Performed installation / upgradation / patching of entire E-business suite components on single node / multi node instances.
• Converted single node instance to multi node instance.
• ASCP concurrent processing middle tier addition
• Implemented SSL in Oracle Applications 11i and R12
• Cloned Oracle applications 11i.
• Experience in all AD utilities including adadmin, adpatch, adsplice, adctrl, etc.
• Experience in DMZ Implementation
• Experience in Discoverer 10g and workflow mailer configuration.

Confidential

Java Developer

Responsibilities:

• Involved in database design, import and export activities.
• Designed and developed Application Prototype.
• Developed user interfaces using JSP.
• Used Java Script for Client side validations.
• Developed Struts Action classes, Business Delegate Object, Data Transfer Object, Data
• Access Object classes.
• Implemented MVC design Pattern.
• Optimized system performance by writing stored procedures and calling them Using JDBC callable statements.

Environment: Java 1.6 / J2EE, Servlets 3.0, JDBC, JNDI, JSP, EJB, Web logic Application server, Struts and Oracle 8i.