Summary

• Have around 13 years of experience as Oracle Applications 11i/R12 DBA Oracle DBA, providing 24x7 support of both Production Development on Various Platforms.
• Experienced in Oracle Apps Administration and Sysadmin tasks
• Installation, Configuration Deployment of Oracle E- Business Suite 11i/R12.
• Experience in Oracle Financials modules GL, AP, AR, PO, CM ,
• Implemented Oracle Apps 11.5.10.2 with Oracle RAC.
• Implementation of High Availability solutions with Oracle 11g/10g RAC, Physical and Logical Standby Databases Data Guard .
• Trouble shooting Forms server, Reports server, Apache server, Jserv, Jinitiator and Workflow.
• Expert in 11i Apps Cloning, Implemented new techniques for Apps Refreshes.
• Applied Patching, Upgrades, framework, SSL For 11i Apps.
• Application and Concurrent Manager load-balancing and Failover, Shared APPL TOP configuration.
• Excellent experience in Installation of Oracle 8i, 9i, 10g in UNIX/LINUX and Windows environment.
• Proficient in Database and Applications Administration activities such as Upgrades, Patches, TAR support, Backup and Recovery, Performance tuning, script development.
• Effective troubleshooting of Database and Performance problems.
• Worked with development teams and data administration staff to enhance Database and application performance.
• Experience with Data Modeling.
• Extensive performance tuning of Concurrent programs, Concurrent Mangers and SSWA
• Very strong in Auto Patch, Upgrade, cloning.
• Expertise in using ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG, ADMRGPCH, ADLICMGR PTS tools.
• Experience on Multi Org
• Production DBA Experience on Oracle releases 11g/10g/9i/8i
• Excellent knowledge in installation and maintenance of Oracle Application Server
• Expertise in configuring various oracle application modules like Discoverer, Workflow
• Management of schemas, objects Partitioning the tables indexes.
• Experience in a variety of different environments like HP-UX, SUN SOLARIS, Linux and Windows.
• Experience in managing very large databases Multiple TB of size .
• Experience in administration of large Oracle database running in SAN environment, setting up databases for bank environment.
• Write Korn shell scripts to monitor and maintain the Oracle Applications database.
• Performed backups and tested crash recoveries using conventional Hot Cold backups and RMAN.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM
• Expertise in installing, maintaining and administering Oracle Applications 11i 11.5.8, 11.5.9, 11.5.10, R12 instances.
• Expertise in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle Applications e-Business Suite.
• Worked on most of the Application modules like HR Payroll, Financial, AR, AP, PO, IREC, OE, INV, OM, Manufacturing, Workflow and SSWA etc.

Operating Systems: Sun Solaris, Suse Linux, Windows W2K/NT/98/95

Databases: Oracle 9i/8.x

ERP: Oracle Applications 10, 11 11i

Web Servers: Apache web server 1.3, Oracle Application Server

Tools/ Packages: Oracle 9i/8i, Putty, Oracle Enterprise Manager, SQL Plus, SQL Loader, Import/Export, TOAD, MS Office Outlook, Cute FTP, Telnet, Kintana

Education: Bachelor of Science in Electronics Technology, Osmania University

Certifications: Oracle 8i Certified Professional Database Administrator

Project Experience:

Confidential

Role : Oracle Developer

Environment: Oracle Applications 11.5.10.2, R12, Sun Solaris, Oracle 10g, Datagaurd, PL/SQL, TOAD, Secure Shell Client, PVCS

Personal Responsibilities / Achievements:

• Alert Handling.
• Provide day-to-day 24/7 Production support for users application databases.
• Work with Oracle Support on SEV 1 TARS
• Provide assistance to project teams for technical issues, diagnosing operational issues and resolve them.
• Troubleshooting and resolving performance issues.
• Create tablespaces, tables, and users for custom built applications.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Responsible for monitoring the scheduled jobs, cron jobs and space management.
• Experience tuning work shifts/ queues and monitoring concurrent managers / workers to watch for runaway jobs and keeping the throughput high.
• Cloning, Patch Management includes analyzing, documenting. Applying patches.
• Managing all the production, development, test, QA instances of both ERP Non-ERP Datawarehouse databases .
• In the process of upgrading to R12.

Confidential

Role : Oracle Applications 11i DBA

Environment: Oracle Applications 11.5.X 4/7/8/9/10 ,R12, Sun Solaris, Linux, HP, Oracle 9i/8i/10g, RAC, Datagaurd, PL/SQL, TOAD, Secure Shell Client, PVCS

Personal Responsibilities / Achievements:

• Provide day-to-day 24/7 Production support for users application databases.
• Work with Oracle Support on SEV 1 TARS
• Provide assistance to project teams for technical issues, diagnosing operational issues and resolve them.
• Resolving performance issues, SSO related issues and RAC issues.
• Create tablespaces, tables, and users for custom built applications.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Responsible for monitoring the scheduled jobs, cron jobs and space management.
• Experience tuning work shifts/ queues and monitoring concurrent managers / workers to watch for runaway jobs and keeping the throughput high.
• Patch Management includes analyzing, documenting. Applying patches using CoPatch Customized tool of Cisco .
• Cloning of various instances using Cisco custom developed perl script smart clone .
• Managing the more than 1000 production, development, test, QA instances of both ERP Non-ERP.
• Alert Handling.

Confidential

Role s : Oracle Applications 11i DBA

Environment: Oracle Applications 10.7, 11.0.3 11.5.X 7/8/9/10 , Sun Solaris Sun Fire 3800, 4800, 6800 , Oracle 10g/9i/8i, PL/SQL, TOAD, Datagaurd, Net Team, PVCS

Personal Responsibilities / Achievements:

• Cloning the production instance with Rapid clone and Adclone utility.
• Patch Management includes analyzing, documenting and applying patches also using OAM.
• Expertise in Installation of Oracle Applications R11i Single Node and Multi-Node
• Experience tuning work shifts/ queues and monitoring concurrent managers / workers to watch for runaway jobs and keeping the throughput high.
• Creating Responsibilities, Menus, Users, and Printers and maintaining User Security.
• Responsible for monitoring the scheduled jobs
• Migrating all custom programs and reports to production instances. This involves enforcing naming standards, maintaining the custom application top, and setting up concurrent requests.
• Troubleshoot problems with web server, web listener, forms server, and concurrent managers, and database.
• Create tablespaces, tables, and users for custom built applications.
• Maintain Oracle schemas.
• Provide assistance to project teams for technical issues, diagnosing operational issues and resolve them.
• Trouble shooting forms and reports with oracle support
• Provide day-to-day 24/7 Production support for users application databases.
• Work with Oracle Support on SEV 1 TARS
• Alert Handling.

Confidential

Consultant Apps DBA

Responsibilities:

• Maintained Oracle Applications Release 11i on HP UX and RedHat Linux.
• Upgraded Oracle Applications from 11.5.8 to 11.5.9.
• Upgradation of Oracle databases from 8i to 9i
• Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
• Defining Customized Transaction Concurrent Managers their work shifts and specialization rule. Monitor and Troubleshooting Concurrent Manager Issues.
• Collect and analyze performance statistics for resource consumption and performance anomalies. Managing Tablespaces, Datafiles, Rollback segments, Temporary TBS.
• Cloning of Oracle Applications 11.5.8 with Autoconfig.
• Creation of users, assigning responsibilty, creation of customs menu's and responsibility for Oracle Apps 11i. Responsible for automating the scripts for backups, alert checking, database and Appl-top refresh
• Patching and automating the AD utilities.
• Code Migration from PVCS to the various instances, migration of Concurrent Programs, Value sets and Request Sets using FNDLOAD.
• Provide assistance to the client DBAs on technical issues when ever required. Diagnosing operational issues and resolve them.