We provide IT Staff Augmentation Services!

Oracle Developer Resume Profile

AZ

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.

Hire Now