SUMMARY

• More than 9 years of experience in oracle applications and oracle database administration (Oracle Applications 11.5.7 to R12 and Oracle Database 9i to 11g). Experience include Installation, upgrade, migration, System maintenance, Cloning, patching, user support, TAR management, Database security, Trouble shooting database design, Documentation, Performance tuning, Backup and Recovery, Space management and Integration of third party products.
• Experience and proficient with Oracle E - Business suite applications (11.5.7, 11.5.8, 11.5.9, 11.5.10.2 12.0.4 , 12.1.2 and 12.1.3) in Sun Solaris, Red Hat Enterprise Linux, AIX and Windows environment
• Performed Applications installations, upgrades of 11i and R12 (single node and multimode)
• Experience in installation, configuration and administration of Web Logic Server 8.x/9.x/10.x and 11g in various environments
• Experience in Oracle Application up gradation from 12.1.1 to 12.1.3 and 12.1.3 to 12.2.4.
• Good Experience on Installed and Maintained SOA/BPEL
• Experience in Maintenance, Patching, Cloning/Refresh of Oracle Applications and Oracle Database
• Experience in High Availability solutions with Oracle 10g & 11g RAC, ASM and Standby (DATAGUARD)
• Experience in the Switchover and Failover activity for Oracle EBS.
• Experience in Oracle Enterprise Manager, RMAN, Apache, HTML, and Schema Manager
• Experience in Registration and Configuration of Printers in Oracle Apps.
• Expertise in administering Oracle 11i&R12Instances using AD utilities such as adadmin, adctrl, adsplice, admerge, adpatch, autoconfig etc
• Expert in SQL,PL/SQL and Unix shell scripting
• Experience on Application System Administration and AOL activities on EBS like assigning the roles, creating the users, scheduling the concurrent requests and purge the tables
• Well versed in implementing and managing System Management, Monitoring procedures, User Management, Performance Tuning, Concurrent Processing Settings and Database Auditing
• Extensive knowledge on Oracle tools and utilities (Export, Import, SQL*Loader, PL/SQL, OAM, SQL Navigator, TOAD, Data Load, SQL Expert) in UNIX (Sun Solaris, AIX, HP-UX, Linux)
• Extensive Knowledge on Oracle Applications Sys-Admin functions like User Management, concurrent manager setups, Request sets, data groups, Profiles, and OAM
• Capable of tuning SQL using EXPLAIN PLAN, DB Stats pack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and tracing at user level and TKPROF
• Experience in Oracle Work Flow administration for Oracle EBS
• Maintaining SLA promptly. User level security implementation. Experience in implementing three-tier security architecture. Experienced in Space Management, Memory Tuning and Application Tuning
• Experience in Security Management and Database Auditing
• Efficient Team Player, hard working, good in analytical and logical problem solving abilities with excellent communication skills.
• Support bi-monthly application releases with their database changes in Prod and Non-Prod environments.
• Hands on experience in situations where on-call 24 x 7 support for mission critical databases and Production support required.

TECHNICAL SKILLS

ORACLE APPS: Oracle E-Business Suite 11.5.8/11.5.9/11.5.10/ R12

RDBMS: Oracle 9i, 10g and 11g

Operating Systems: UNIX (Sun Solaris 5.9, 5.10, HP-UX 11i, Linux x86), Windows NT

TOOLS: SVRMGR, SQL Plus, SQL*Net8 Assistant, SQL Loader, dbverify, tkprof,STATSPACK,Opatch, Oracle AD Utilities, Oracle Applications Manager (OAM), Oracle Enterprise manger (OEM),Telnet, Humming Bird, Putty.

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripts

JVM: Oracle BEA Jrockit, Sun JDK

Web Server: OHS Web Server, Sun One Web Server

Application Server: Weblogic Server 10g, 11g

PROFESSIONAL EXPERIENCE

Confidential - New York, NY

Oracle Application DBA

Responsibilities:

• 24x7 Production database administration
• Involved in Up gradation from Oracle Applications 12.1.1 to 12.1.3
• Involved in developing a disaster recovery (DR) plan for Oracle Applications R12 and successfully executed DR test
• Involved in OEM Configuration on Oracle 11g.
• Setup and Configured Oracle DATAGUARD using RMAN backup for physical standby database.
• Involved in the configuration of workflow mailer for EBS
• Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers & Troubleshooting problems, resolved the view log/out files issues of concurrent requests.
• Involved on Application System Administration and AOL activities on EBS like assigning the roles, creating the users, scheduling the concurrent requests and purge the tables
• Applied mini-packs, CPU patches, family packs using ADPATCH, ADCTRL utilities
• Monitoring the error logs and fixing the problems on Web Logic environment
• Involved in Changing APPS password Using FNDCPASS utility.
• Implemented AUTOCONFIG in the Apps environment and used ADCONFIG, ADBLDXML commands
• Involved in the configuration of Printer for oracle EBS
• Installing OEM agents and monitoring databases through OEM
• Constantly supporting Business with Production issues, implementing daily changes and performing Administration tasks
• Daily DBA activities such as schemas creation, space management in database, tables export and import
• Applied RDBMS patches using Opatch
• Defining Customized Transaction Concurrent Managers their work shifts and specialization rule. Monitor and Troubleshooting Concurrent Manager Issues.
• Implemented maintenance plans, scheduled scripts for concurrent request details, table space growth, archive log monitoring and many other maintenance activities.
• Closely worked with Oracle Consulting Team for a successful implementation on many issues, Tar support (sev1).
• Creation of users, assigning responsibility. Working with system admin teams for issue resolution in various oracle SR’s.

Environment: Oracle Application R12, Database: 11.2.0.3, RMAN, Sun Solaris, Linux, AIX

Confidential, Columbus

Oracle Application DBA

Responsibilities:

• 24x7 Production database administration
• Involved in Upgradation from Oracle Applications 12.1.1 to 12.1.2
• Cloning from Multimode to Single node on development instances
• Installation, configuration and administration of Web Logic Servers
• Deployed applications in WAR, JAR and EAR formats in Domain and Clustered environments of Web Logic Application Server
• Constantly supporting Business with Production issues, implementing daily changes and performing Administration tasks
• Defining Customized Transaction Concurrent Managers work shifts and specialization rule
• Implementation, Troubleshooting forms server, report server, Discoverer server, Web Server and Maintenance of Concurrent managers and Parallel concurrent Process (PCP)
• Applied mini-packs, CPU patches, family packs using ADPATCH, ADCTRL utilities
• Applying Security Patches at regular intervals as per Oracle recommendations
• Performing Applications admin tasks using ADADMIN utility
• Monitoring concurrent managers, stand alone managers and make sure jobs are run normally
• Monitoring the performance of the database, resolving user and printer related issues
• Installed 11g Grid in test environment for monitoring the Non-Prod instances
• Registered customized applications, created responsibilities, customized menus, attached menus to responsibilities and assigning to users
• Daily DBA activities such as schemas creation, space management in database, tables export and import
• Taking daily and weekly database backups using RMAN
• Involved on Application System Administration and AOL activities on EBS like assigning the roles, creating the users, scheduling the concurrent requests and purge the tables
• Worked on Workflow mailer configuration and issues
• Installing agents and monitoring databases through OEM
• Work with oracle support on several sev1 and sev2 issues

Environment: Oracle Application R12, Database: 11.2.0.3, RMAN, Sun Solaris, Linux, AIX

Confidential -MD

Oracle Application DBA

Responsibilities:

• Oracle Applications Upgrade from Oracle Applications (E-Business Suite) 12.1.1 to R12.1.2
• Applied mini-packs, CPU patches, family packs using ADPATCH, ADCTRL utilities.
• Analysis of patches and application through Adpatch process and troubleshoot issues during patching process...
• Involved in database migrations cloning Oracle Applications production system, for testing and development purpose using rapid clone.
• Involved Cloning using Rapid clone utility.
• Responsible for managing production, development & test databases and applications.
• Conduct database maintenance tasks and troubleshoot issues related to concurrent manager and Apache, forms, and report server types.
• Merge of patches using admrgpch to reduce the patch downtime.
• Applying Oracle Applications patches Maintenance Pack, Interoperability patch, Family packs, and CPU patches, Patch Sets.
• Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps.
• Continuous Performance monitoring and Database Tuning and application using OEM
• Used Oracle Application tools for maintaining database and application like adpatch, adadmin, adctrl etc
• Applied RDBMS patches using Opatch
• Involved on Application System Administration and AOL activities on EBS like assigning the roles, creating the users, scheduling the concurrent requests and purge the tables
• Perform SQL tuning and assist developers with coding PL/SQL.
• Storage management using Oracle Automatic Storage Management (ASM)
• Query Performance tuning using Explain plan and Automatic Workload Repository (AWR) reports.
• Refresh QA and Development databases for bi-monthly application releases.
• Test and apply Oracle Patch Set Updates on a half-yearly basis across all the environments.
• Support bi-monthly application releases with their database changes in Prod and Non-Prod environments.
• Work with Oracle Support through Service Requests for database issues.
• Linux Scripting for scheduling jobs for repetitive and on-demand jobs.
• Cloning the instance from the production to Test, Development instance to test and simulate few technical challenges, coordinate with testing and development teams.
• Applying patches for enhancement, fixing bugs using Opatch utility.
• Strategies for planning Backup activities and written scripts to automate the process
• Managed Schema objects, used Export and Import.
• 24x7 Production Oracle Applications Maintenance, Support and Administration.

Environment: Oracle Application R12, Database: 11.1.0.7, RMAN, Sun Solaris, Linux, AIX

Confidential, TX

Oracle Application DBA

Responsibilities:

• Support and Administration of Production and Test Instances.
• Administrating the oracle Applications with ad utilities like adpatch, adadmin
• Trouble shooting regarding to patching issues
• Cloning Oracle Applications from production to test
• Involved in Changing APPS password Using FNDCPASS
• Applied various Patches using adpatch on Application file System.
• Reduced the timelines of patching using features admrgpch
• Troubleshooting various issues related to Apache, JServ and Concurrent manager
• Maintaining Oracle Application File System using AD Utilities
• Performed System administration activities like creating users, assigning Responsibilities
• MonitoringTablespaces for space usage and adding required space whenever it reaches threshold.

Environment: Oracle Applications 11i, Oracle 9i, RMAN, Sun Solaris, Linux, AIX

Confidential

Oracle Application DBA

Responsibilities:

• Support and Administration of Production and Test Instances.
• Applying CPU and PSU patches on Oracle RDBMS.
• Cloning Oracle Applications from production to test
• Ensuring security by creating and managing profiles for DB users.
• Checking the alert log and trace files for errors
• MonitoringTablespaces for space usage and adding required space whenever it reaches threshold.
• Refreshing database from production to test environment as per application team requirement.
• Raising SR’s and searching and downloading patches from Metal ink and applying them.

Environment: Oracle Applications 11i, Oracle 9i, RMAN, Sun Solaris, Linux, AIX