Oracle Applications Dba Resume
Indianapolis, IndianA
SUMMARY
- Over 10+ years of experience in Oracle DBA and Oracle Applications DBA providing 24/7 support of various production Platforms.
- Through understanding of Oracle Applications Architecture.
- Experience in managing very large databases (Multiple TB of size).
- Installation, Configuration & Deployment of Oracle E - Business Suite 11.5.10, R12.
- Hands on experience in Installation, implementation, upgrade and maintaining R12, 11.5.10.2, 11.5.10, 11.5.9 E-Business Suite applications.
- Experience in a variety of different environments like HP-UX, SUN SOLARIS, Linux and Windows.
- Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Backup and Recovery, Performance tuning, script development.
- Implementation Backup and Recovery through Oracle RMAN, Cold Backup and Hot Backup’s for Oracle Application Databases, to automate process.
- Implemented and Configured the Oracle OEM 12c to maintain E-business applications.
- Performed Applications System Administration tasks like registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, and Creating APPS Users etc.
- Trouble shooting Forms server, Reports server, Apache server, Jserv, Jinitiator and Workflow.
- Expert in R12 and 11i Apps and database cloning, Implemented new techniques for Apps Refreshes.
- Applied Patching, Upgrades, framework, For R12 and 11i Application.
- Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF.
- Oracle Applications System Administration security functions and AD Utilities.
- Application and Concurrent Manager load-balancing and Failover, Shared APPL TOP configuration.
- Performing cloning activities over the weekend to minimize the downtime.
- Ad utilities for various tasks and configuring the printers for Apps.
- Administering Concurrent Manager and Concurrent Requests.
- Writing the shell scripts for database backups, alert and monitoring the database and OS performance.
- Collecting the Patch update report regularly and analyzing the impacts and applying on the Test instance for its implications. Applying the same on the PROD after a successful testing.
- Administering the Users and Responsibilities.
- Diagnosing the Application using the Oracle Application Manager.
- Creating and maintaining the Request sets and Request groups.
- Proactive Monitoring and Maintenance of Oracle Applications
- Creating & maintaining all databases code migrations required for development, & testing.
- Applying CPU, latest database patchsets & critical patches for oracle database.
- Performing ongoing tuning of the database instances such as analyzing database objects, rebuilding the indexes and validating the structures. Resetting database parameters.
- Backup Administration (Export & Import, RMAN, Hot backup, Cold backup)
- Handling the critical refresh activities for database to reproduce the issue for the development team.
- Installing the new versions of the Oracle RDBMS and its tools that access the Oracle Database
- Planning and implementing Backup and Recovery as per the backup policy & enforcing security.
- Expert in Troubleshooting databases, applications and development issues.
- Excellent written and verbal communication skills.
- Result oriented, self-motivated, team player, ability to work independently.
TECHNICAL SKILLS
Operating Systems: HP-UX, AIX, Sun Solaris, Red Hat Linux, Windows NT.
RDBMS: Oracle 9i, Oracle 10g, 11g, Sql Server.
ERP: Oracle E-Business Suite R12.1.3, R12.1.1, 11.5.10.2, 11.5.9.
High Availability: ASM, Data Guard, RAC, OC4J Load Balancing
Languages: SQL, PL/SQL, UNIX, Shell Scripting.
Tools: RMAN, Enterprise manager 12c, OAM, SQL*PLUS, SQL*Loader, TOAD, Shareplex, VMware, Solix EDMS, Markview, Apex, Remedy, Peregrine, HP Archiving.
Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR,ADDM.
Middleware: APEX, Fusion Middleware 11g, Weblogic, SOA, OBIEE Oracle 9iAS, Oracle 10gAS, Apache, Forms, Reports.
Apps Modules: Oracle Financials (AR, AP, GL, FA etc), Oracle Manufacturing (ONT, OE, INV, PO) BOM, WIP, CRM (iProcurement, Sales Incentive Compensation, Install Base, iReceivables, iPayment, Mobile Field Service, iSupport, iService, iSupplier, iStore, e-Mail Center, Install Base, Service Contracts etc), MRP, MRO etc, Oracle Projects, HR, Payroll, Oracle Self Service Web ApplicationsCertification Oracle 10g certified Professional
PROFESSIONAL EXPERIENCE
Confidential, Indianapolis, Indiana
Oracle Applications DBA
Environment: Oracle Applications R12.2.4 Operating System: Red-Hat Linux 5.9.
Responsibilities:
- Responsible for performing the R12 upgrade from the R12.1.1 to R12.1.3.
- Handling Day-to-Day application dba responsibilities to support high availability client environments.
- Coordinate with the teams and perform the clone on development, testing and uat environments from PROD.
- Gather the latest patch set details and review the patch dependencies and estimate the time to apply the patches.
- Work individually to troubleshoot the day to day application ongoing issues.
- Proactively estimated, improved and enhanced the performance on both database and application to full extent.
- Scheduling the upgrades/Patching’s activities across the team as per the Development requirements/needs.
- Capacity Planning and Cost Comparison for Upgrade of different environments handling day to day deployments using migration tools and SQL Developer.
- Provide open and timely communications within the group, among other lead DBAs, across the Infrastructure support team and out to the key business partners.
- Performed Applications System Administration tasks like registering new forms, reports, Fixing Printer Issues, Setting Profile Options, Creating/Assigning Responsibilities, and Creating APPS Users etc.
- Troubleshoot Database Performance Tuning issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
- Using utilities like adpatch, adadmin, adctrl, adaimgr, adsplice, licmgr.sh, adrelink etc.
- Installed and Configured 11g OBIEE, Weblogic Fusion Middleware applications.
- Installed and Setting Oracle Enterprise Manager and 12c OEM
- Integrated all the e-business suite database and application environments in 12c OEM.
- Working with Oracle service requests to provide the timely updated to get the fix.
- Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration.
- Implemented Backup and Recovery strategies for the various Environments.
- Actively participated in the team meetings and updated the ongoing and upcoming tasks.
- Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.
- Writing scripts for backup and recovery, Import and export procedure.
- Working with oracle support service requests to give timely updates to resolve the issues.
Confidential, Duluth, Georgia
Oracle Applications DBA
Environment: Oracle Applications 11.5.10.2 Operating System: Sun Solaris 9,10.
Responsibilities:
- Responsible for performing the R12 upgrade from the current environment 11.5.10.2.
- Working on a Huge Environment supporting 2 node RAC with 8 TB production database.
- Responsible to maintain Oracle application 11.5.10.2 in production, Test, dev, training, stage environments.
- Upgraded Existing Application Instances from 11.5.10.2 to R12.1.3.
- Involved in preparing the upgrade strategy and capacity planning.
- Involved in Upgrading Database from 10.2.0.4 to 11.1.0.7.
- Cloning the current production to dev and test environments for the upgrade.
- Applying patches on the database and application for bringing to the base-level for the upgrade.
- Implemented Backup and Recovery strategies for the various Environments
- Provided solutions and execution plans for issues of Migrations, Two-Node, OATM, DB Sizing, Block Size Issues and Load Balancing and Performance Improvements.
- Implemented OATM which reduced the number of table spaces to 12 and reduced the size of the database from 8 terabytes to 6 terabytes, this was greatly appreciated by the client.
- Performed the R12.1.1 upgrade and prepared the steps for reducing the downtime.
- Used the AD utilities to maintain, compile, clone and applying patches during the R12 upgrade.
- Database Administration, Monitoring Extents and growth of Table spaces, Tables, and Indexes. Recreating Indexes. Backup & Recovery
- Actively coordination with Technical Architects to resolve various data related issues of the client and suggested methodologies for Data Cleansing and Migration.
- Troubleshoot and resolve various Tickets raised by Developers.
- Working with Oracle for Sev 1 Tar.
- Interact and coordinate with other teams spread across the globe.
- Taking the responsibility of analysis of the R12 patch releases and its implementation.
- Regular Application and database Cloning and patching activities
- Capacity planning and Additional disk planning for the growing databases.
- Created Clone Server of production server to test the R12 upgrade.
- Maintain user profiles at the site, application, and responsibility and user level.
- Attending the Meetings to understand the technical and functional needs and expectation from the DBA team during the process of the R12 upgrade.
Confidential, White plains, New York
Oracle Applications DBA
Environment: Oracle Applications 11.5.10.2 Operating System: Sun Solaris 9,10.
Responsibilities:
- Responsible to maintain Oracle application 11.5.10.2 in production, Test, dev, training, stage environments.
- Taking complete responsibility of analysis of new patch releases, applying the patches in dev, test and scheduling the downtime for applying the patches in production.
- Regularly performing the application and database cloning activities.
- Automation of environment wherever possible and feasible
- Capacity planning and Additional disk planning for the growing databases
- Responsible for attending the Change control meeting on behalf of DBA team.
- Technical plan approval for the production turnover.
- Performance tuning of application and database
- Periodical meeting between functional and technical team to understand their needs and expectation from the DBA team.
- Responsible to apply patches on Oracle Application existing servers
- Created Clone Server of production server to test patches.
- Opening and monitoring all TARS with Oracle support and expediting them
- Extensively using AD utilities to maintain, compile, clone and applying patches in Oracle applications.
- Provide system administration & support for Oracle 11i Applications.
- Set up new Oracle Applications users.
- Maintain user profiles at the site, application, and responsibility and user level.
- Involved in Application upgrade from various versions to versions.
- Responsible for fixing the database recovery issues
- Database sizing, tablespace management and security administration
- Capacity planning, Extensive Performance and Memory Tuning, Designing and Tuning
- Managing Concurrent Manager / Processes and Forms Server, etc.
- Maintain user profiles at the site, application, and responsibility and user level.
- Supporting the markview application which was integrated with oracle apps.
- Responsible for monitoring the database backups.
- Applying CPU, latest database patchsets & critical patches for oracle database.
- Troubleshooting databases, applications issues in day to day activities.
- Applied the latest Application technology patches, Family packs and minipacks to make the existing application up to date.
- Collecting the Patch update report regularly and analyzing the impacts and applying on the Test instance for its implications. Applying the same on the PROD after a successful testing.
- Writing the shell scripts for database backups, alert and monitoring the database and OS performance.
Confidential, Bloomington, Indiana
Oracle Applications DBA
Environment: Oracle Applications 11.5.9
Responsibilities:
- Supporting the critical production oracle applications 11.5.9, 115.10 for the client.
- Maintain production, test and development database environments
- Involved in cloning and patching the existing oracle applications.
- Monitoring and managing the tablespaces for all the instances.
- Followed the process for code migrations in the production.
- Involved in troubleshooting the performance issues for the users.
- Monitoring the system usage when scheduled jobs are running in the production
- Troubleshooting the long running concurrent requests
- Involved in preparing documentation on problems faced and steps to resolve for clients
- Responsible for taking the backup of the database on a regular basis.
- Managing and responding quickly to customer requests for escalations
- Monitoring and troubleshooting the database and application issues.
- Responsible for the scheduling the jobs to run on regular basis
- Involved in raising the oracle TAR for the critical issues.
Confidential
Oracle Applications DBA
Environment: Oracle Applications 11.5.7, 11.0.3 Operating System: Red-Hat Enterprise Linux, Sun Solaris 9.
Responsibilities:
- Supporting one of the world’s one of the largest Oracle database (5 TB) with an equally complex Application system having a 65 node architecture.
- Worked with a team of 25 Oracle Apps DBA’s supporting an internal customer base of than 5000+ users.
- Involved in Cloning & Patch Application for all the client environments.
- Supporting a 11.0.3 and 11.5.7 instance (Production Support, testing and Development)
- Troubleshooting database issues such as tablespace, locks, disk space, archives etc.
- Application of Patching, Administering concurrent Manager
- Proactively taking care of user issues w.r.t to various Application Instances
- Monitoring the server load, accessibility and other issues
- Resolving the known errors using the knowledge management
- Contributing to Code Migration and Patch investigation.
- Performing, Web Server/Concurrent Manager troubleshooting, re-linking executables etc.
- Responding quickly to communicate update to the appropriate audience.
- Performing EOQ activities.
- Supporting Shareplex, the Reporting Environment (QUEST Product)
- Installed and upgrade 11.5.8 instance for internal development team.
- Managing and responding quickly to customer requests for escalations.