Oracle Application Dba Resume Profile
EXPERIENCE SUMMARY
- Around 9 Plus Years of Oracle Applications database administrator with 11g RAC experience in 11i and R12 Implementations and Post Production Support projects.
- Knowledge on R12.2.3 Upgrade path experience from 11i.
- Knowledge on adop utility on R12.2.3
- A competitive professional having 9 Plus years of Oracle Application DBA. Expert in Administration of Oracle E-Business Suite 11i and R12 application databases and RAC environments.
- Installation and configuration of R12, 11i with Manufacturing, Healthcare and IT sectors.
- Specialized in Oracle Databases Versions 11g, 10g, 9i , Oracle Apps Database Administration R12, 11.5.10, 11.5.9 .
- Experienced in configuring Oracle Data guard and recovery procedures.
- Configuration and Troubleshooting of Workflow Notification Mailer.
- Written Monitoring scripts for health check of Oracle apps and core dba.
- Worked on Incident management within SLA for all production issues providing RCA for those issues.
- Experience on Advanced Supply Chain Planning ASCP .
- Experience with tools such as OEM, Oracle ADI, XML Publisher and Workflow
- Oracle EBS suite middle-tiers in DMZ.
- Experience on up gradation of Oracle database from 9.2.0.6 to 9.2.0.8 and 10g to 11g and also Oracle Application from 11.5.10.2 to R12 including post upgrade issues.
- User Management setups in R12, 11i environment.
- Experienced in Planning, Installation single and multimode , Backup and Recovery, Cloning, Refreshing Databases on Oracle Applications.
- Experience on Full lifecycle management for Oracle EBS implementation including high availability and disaster recovery management on R12 and 11i.
- Experience on Oracle Applications using multiple languages
- Database Performance Tuning using stats pack, tkprof, AWR .
- Experience with OEM, OAM and Oracle Grid-control.
- Experience on Golden Gate on Oracle 11g.
- Expertise in performance investigation and problem resolution.
- Advance performance Table compression experience on 11g.
- Expert on Oracle memory, storage, and I/O internals.
- Expertise in Explain plan and SQL Optimizer use to resolve the performance issues.
- Oracle Apps performance on Concurrent Mangers and workflow related issues.
- Install, Support and maintain Oracle EBS applications with high availability and DR.
- Experience with Oracle Portal and ODI Administration
- Worked on Setup, configure, implement, test and validate Oracle E-Business Application modules and OID- OAM, Single Sign on.
- Experience with Java and Java Database Connectivity JDBC
- Experience in database reorganization, migration, capacity planning and high-availability
- Expert in RMAN backup process and Restorations.
- Able to write shell scripts for scheduling the jobs as per business requirement.
- Worked on high availability environment implementations R12 Apps 11g, 10g, 11g DB, 11i Apps 11g, 10g, 9i DB
- Experience configuring/supporting various interface adapters JMS, EJB, ODBC, JDBC etc
- Experience on SOA 10g, 11g and WebLogic administration.
- Experience in deployment in SOA suite, creation of Data sources
- Experienced in Oacle Discoverer, Hyperion and OBIEE Deployment, maintenance and upgrades
- Good Experience on OATM utility.
- Worked on Parallel Concurrent Processing PCP as well as debugging concurrent managers and requests
- Worked on disaster recovery and fail over plans
- Good at applying patches of Oracle Applications and Maintenance Activities using AD Utilities.
- Performing Regular Application Health Checkups.
- Installation of Oracle Application with single node and multi nodes in R12 and 11.5.10.2 on Linux/Unix environments.
- Experienced in Space Management, Memory Tuning and Application Tuning.
- Strong knowledge of administration processes and controls to meet security and compliance audit requirements for SOX.
- Worked on Hyperion products as a admin
- Cloned Oracle applications R12, 11i and Databases
- Knowledge on Oracle Fusion Middle ware Technologies like SOA, OTM, BPEL.
- Knowledge on Exdata/Exlogic
- Troubleshooting expertise for all tiers Apache, Forms, Concurrent, Admin, J-initiator and database
- Applied product specific fix patches, family packs, maintenance packs -- all types of patches ad patching.
- Handling the offshore/onsite Team as a Team Lead
- Knowledge and experience with PL/SQL optimization.
- Worked with Oracle for resolving critical and transactional issues through SR's and OWC's.
- Very good experience working with Oracle Applications as Technical Developer.
- Manage project - task estimation, planning, risk mitigation analysis, etc.
- Experience in understanding about software development life cycle SDLC .
- Storage technologies like NetApp snapshots, flexclones, NAS,NFS, luns
- Good at intellectual knowledge base creation-documentation during the project implementation phase and Post production phase
- Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
- Excellent Communication Skills and Presentation Skills, Comprehensive problem solving abilities
TECHNICAL SKILLS
- Database: Oracle 9i, 10g, 11g RAC, MS SQL Server 2000 2005, MS Access.
- Middleware: Oracle Application Server 10g, WebLogic, SSO, OID, LDAP.
- Hardware OS: Linux, UNIX, Solaris 9, 10, Windows 2000/2003.
- Programing: SQL, PL/SQL, Shell Scripts, C, HTML, JavaScript and XML.
- NetWare: TCP/IP, FTP, Telnet, Netscape, and Internet.
- Tools Utilities: RMAN, Data Pump, Dataguard, OEM, Grid Control.
- Oracle Tools: SQL LOADER, Oracle SQL Navigator, TOAD
- Forms 10g/6i/4.5, Reports 10g/ 6i, Discoverer 10g/6i/4i, ,
- ERP Modules: Oracle Applications R12/11i Oracle Receivables, Oracle Payables, General Ledger, Purchasing, Order Management, Shipping, Fixed Assets, Cash Management, Inventory, Advance Pricing, Oracle Workflow, Oracle e-Commerce Gateway and Oracle Projects PA , iExpenses, iProcurement, iSupplier, Oracle HRMS and Oracle Payroll, Bill of Materials, Quoting, Inventory, Configurator, Integrated SOA Gateway.
- Methods: Oracle Applications Implementation AIM Methodology.
- Others: SAN/NAS, Vmware, VERITAS Net Backup.
PROFESSIONAL EXPERIENCE
Confidential
Oracle Application DBA/Performance Expert
Confidential is a global provider of products, services and solutions to industrial and commercial users of electronic components and enterprise computing solutions, with 2013 sales of 21.4 billion. Confidential as a supply channel partner for over 100,000 original equipment manufacturers, contract manufacturers and commercial customers through a global network of more than 460 locations in 58 countries.
Roles and Responsibilities:
- Maintain the oracle application team offshore and onsite including vendor teams.
- Maintain the Oracle Application 11i and R12 instances Including the boundary applications like Weblogic,SOA,Apex Portal applications and Sales force.
- Responsible for installing Oracle Applications R12 in single node multimode
- Applying one-off fixes to Database Oracle Homes non-RAC using Opatch utility
- Cloning Oracle Applications instances on R12
- Using MKS tool while migrating the SOA components.
- Resolving the all kind of performance issues like long running programs or any dead lock related issues and providing the RCA for the all issues.
- Working on Major Performance issues and reduce the long run programs to minimal run time.
- Knowledge on webADI Integration.
- Resolved dead lock issues.
- Tune the queries and resolved many performance issues.
- Upgrade SOA 11.1.1.5 to 11.1.1.7.
Confidential
Oracle Applications DBA /Core DBA
- Confidential , Gilead Sciences has worked to discover, develop and commercialize medications to advance the care of patients suffering from life-threating diseases in areas of unmet medical need.
- In 25 years, Gilead has become a leading biopharmaceutical company with a portfolio of 15 marketed products, a growing pipeline of investigational drugs and approximately 5,000 employees in offices across four continents.
Roles and Responsibilities:
As an Oracle Applications DBA my key responsibilities include maintaining Oracle Application R12/11i Administer development, staging and production environments. Responsibilities, administer maintain Oracle 9i/10g instances, provide end-user support, application of patches, patch management and change control management.
- Implementation of Oracle Applications
- Communicating and interaction with Oracle Corporation Support, Development and other technical staff.
- Reporting problems and patch issues to Oracle and working towards resolving the same.
- Providing Production support for more than ten E-Business suite environments.
- Database Problem Diagnosis, Research, Fix, Testing and Resolution.
- Using the patch wizard tool for patch impact analysis
- Experience in follow established procedure to perform code migrations to Dev, Test and Prod Instances.
- Support for maintenance, troubleshooting of R12 12.1.3 environment.
- Deployed many custom code changes into various instances.
- Setup OXTA configuration for Agile in oracle applications R12.
- Expertise in RMAN Backup and Recovery procedures.
- Configured iSupplier on Oracle application R12 latest 12.1.3 .
- Have expertise in activities like maintaining instances, maintenance of file system and taking appropriate backups for security and consistency
- Validating Creating grants synonyms on Apps schema, Performed jar file/forms generation as a post patch step, relinking the Oracle apps programs.
- Experience in Cloning and Patch Management.
- Resolving the internal500 errors and many other application and oracle errors..
- Experience in Concurrent Managers and Concurrent Programs.
- Regular database activities, backups monitoring and issues resolving.
- Creating users, allocation to appropriate table space, quotas with necessary privileges and roles for all databases.
- Managing archive logs and DB-links.
- Demonstrates ability to solve moderately complex technical problems independently
- Performed cloning from Production database.
Environment: Oracle Applications R12 Multinode, Oracle 11gR1,R2,10g, Oracle Application Server 10g, Linux 5, Database Grid Control, SQL, SQL Plus, PL/SQL,SOA 10g and WebLogic, SOA
Confidential
Oracle Apps DBA/Core DBA
Confidential 500 corporation that designs, manufactures, distributes and services engines and related technologies, including fuel systems, controls, air handling, filtration, emission control and electrical power generation systems. Confidential 190 countries and territories through a network of more than 600 company-owned and independent distributors and approximately 6,000 dealers
Roles Responsibilities:
- Experience in Implementing Oracle Apps 11i on Solaris 10 operating system environment for creating Test and Development environment on different modules Oracle Financials, Oracle HRMS and Oracle Payroll.
- Applied product specific fix patches, family packs, maintenance packs.
- Managed the Team as lead and Subject Matter Expert.
- Troubleshooting expertise for all tiers Apache, Forms, Concurrent, Admin and database .
- Implemented role based user management setup.
- Implemented MWA services and dispatcher setup.
- Experience on Golden Gate on Oracle 11g.
- Configured Oracle Enterprise Manager OEM Grid Control and and Repository in OEM 10G.
- Handling the offshore/onsite Team as a Team Lead.
- Sound knowledge of AD utilities, cloning and System Administration tasks.
- Patch Applications for resolving and fixing bugs.
- Troubleshooting the Applications issue and performance problems.
- Worked on ITSM and Remedy incident management tools.
- Creating and Monitoring Application users, assigning Responsibilities and managing user profiles.
- Configuration of RMAN to perform Backup and Recoveries.
- Created scripts to run RMAN Incremental and Full Backups automatically.
- Planning for Backup and Recovery of Database information and maintaining HOT backups, COLD
- Backups also include RMAN backups.
- Configuration of CLONING the database from PRODUCTION to DEVELOPMENT using RMAN.
- Created scripts to REFRESH the PRODUCTION database to DEVELOPMENT database for Testing purpose.
- Experience in understanding about software development life cycle SDLC .
- Experience in SOA 10g/11g and WebLogic administration.
- Database Performance Tuning using stats pack, tkprof, AWR .
- Configured, maintained and Resolve issues in Standby database.
- Monitor and Troubleshoot Performance issues as reported by users.
- Perform Instance tuning for peak performance.
- Cloning and Refreshing Database instances.
- Configure network component for Load Balancing and security.
- Resolve users Network connectivity Issues.
- Installation of Oracle 9i for Production, Testing and Development environments on Linux and Solaris Platform.
- Setup V Scripts and Unix Shell Scripts Bourn shell for automated DB Monitoring and Diagnosis.
- Performed Database Backup using RMAN and Recover from media failure.
- Proactive monitoring of Table space, Data files, and Logs.
- Use OEM to monitor and maintain the Database / Objects, to refresh the Snapshot Replication Groups.
- Creating documentation during project planning, project execution and project maintenance phases
- Resolving system errors, disk space problems
- Monitoring table space usages
- Customizing autoconfig templates according to the environment requirements
- Relinking applications executables
- Upgrading JDK versions from 1.4.2 to 1.5 and 1.6 and JRE/Jinitiator to 15013.exe
- Tuning Concurrent Managers, Defining Work Shifts, configuring specialization rules Using the AD utilities for maintaining the application systems adpatch, adctrl, adadmin, adrelink
- Day to day troubleshooting of the environments which includes fixing all the issues coming in them and supporting the various components of Oracle Applications - Forms, Apache, Concurrent Manager, DB, Listener
- Good in Documentation and demonstration.
- Weekly Refreshing environments from source environments
- Developing Backup strategies Hot, Cold for weekend backups of important environments
- Managing system configuration by using AutoConfig
- Securing Oracle Applications by periodically changing Apps and schema passwords
- Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS, and FND STATS packages and ANALYZE command
Environment: Oracle Applications R12, Oracle 11g, Oracle Application Server 10g, Linux 5, Database Grid Control, SQL, SQL Plus, PL/SQL.
Confidential
Oracle Apps DBA/Core DBA
- Confidential is a leading provider of student transportation, committed to getting
- children to school safely, on time and ready to learn. Confidential one of the premier transportation firms in the United Kingdom
Roles and Responsibilities:
- Responsible for Backup/restore/tar and Cloning of Oracle Applications to development/test instances and database refresh frequently.
- Provided Production and development technical support to developers/users for all R12 instances, databases, technology stack and applications issues on IBM AIX environment.
- Configure, troubleshoot, Start-up, Monitor performance, Schedule and manage Concurrent programs, forms/reports, Apache server and database issues as and when arises.
- Knowledge on Installation, configuration and troubleshoot issues for Oracle 10g RAC database on ASM grid control on AIX box .
- Work with Oracle support for issues and generate diagnostic reports/logs and help to all developers for SR assistance.
- Invoking the rapid installer for installation of Oracle Application in Test.
- Provided staff augmentation services as an Oracle DBA. Handled prime responsibilities for all DBA activities - Logical/ physical design of databases, defining of roles, profiles etc., backups, performance issues, connectivity to database, creation of database links, upgrade strategies, capacity planning tuning of ORACLE parameters.
- Performed a quick performance tuning review and found problems with concurrent requests, rollback segments, network bandwidth, pinning of stored objects, SGA sizing, and general operational failures.
- Enrolling new users into the application by assigning proper profile and role to user in order to maintain the system security.
- Wrote Awk and UNIX shell Scripts for automating the process of downloading the ftp files from ftp site and unzipping it on to the staging area of the server.
- Install Oracle Applications Release 12.0.4 and cloned applications.
- Involved in Real Application Clusters installation and creating the RAC databases using raw devices and asm instance.
- Migrated from NON-RAC database to RAC database.
- Successfully Added node to the existing cluster database.
- Implementing sound backup and recovery strategies, for rac databases using rman according to the SLA. Taking the backup of voting Disk and OCR as per the backup policy.
- Monitoring and administrating rac database using utilities like srvctl, crsctl, crs stat, olsnodes and ocrconfig.
- Configured Flash Recovery Area, monitoring and working with FRA.
- Created ASM instance and disk groups.
- Migrated non ASM based database to ASM based database.
- Cloning the production database and refreshing the test and development databases to synchronize with production database.
- Perform regular database activities like database health check up, space management.
- Monitoring the scheduled jobs and solving any issues related to failed jobs.
- Managing Table spaces, Data files, Control files, Redo Log files and Archived logs.
- Applied Interim and Patch set Patches.
- Upgraded database from 9i to 10g.
- Security Administration by creating Users with appropriate ROLES and PRIVILEGES.
- Monitoring the System response time and detect for any bottlenecks by using AWR reports and ADDM reports.
Environment: Oracle Applications R12, RAC,Oracle10G, GL, AR, AP, AOL, HRMS, PAYROLL Forms10g and Reports 10g, SQL, SQL Plus, PL/SQL, SQL Loader, Win NT and UNIX.
Confidential
Oracle App DBA
Confidential the captive requirements of the group. Today, LCC has metamorphosed into a global entity for complete card room solutions. The company has a large product repository spanning carding accessories and combing solutions. A long term strategic alliance with Graf, Switzerland enabled LCC to enter the premier league of carding solution providers
Role and Responsibilities
- Full life Cycle experience in successful implementation of 11i/R12 technology solutions
- Responsible for installing Oracle Applications R12 in single node multimode
- Applying one-off fixes to Database Oracle Homes non-RAC using Opatch utility
- Cloning Oracle Applications instances on R12
- Applying Rollup Patches ATG RUP6
- Developing Strategies for Oracle Application Upgrades from a lower version to higher version and performing the upgrades
- Upgrade of individual Oracle Applications product and product families by applying Mini-Packs and Family Packs
- Knowledge of NLS implementation in Oracle Applications
- Frequent Upgrades of tech stack components and applying one-off fixes to 10.1.2 and 10.1.3 Oracle Homes R12 .
- Applying patches using distributed AD
- Working Closely with System administrators, developers, technology Stack team and Server Tech team ora-600, ora-7445 to resolve the bugs
- Creating documentation during project planning, project execution and project maintenance phases
- Resolving system errors, disk space problems
- Monitoring table space usages
- Customizing autoconfig templates according to the environment requirements
- Relinking applications executable
- Performing Discoverer viewer setup, Workflow configuration
- Deciding the naming conventions of data file, redo log files, table space, and segments
- Configuring TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity
- Tracing the alert.log file for ORA messages, Monitoring database to ensure smooth functioning of database
- Installing AS 10g for integrating Ebiz-suite R12 and 11i
- Setting Profile Options site level, User level
- Configuring forms in servlet, socket modes
- Responsible to ensure that the environments are stable and at acceptable performance.
- Responsible for regular interactions with the UNIX teams to troubleshoot OS/Hardware issues
- Customer support over phone, OWC, customer tracking system tool
- Checking backup status to ensure validity
- Cleaning the udump, cdump, bdump directories of large core files.
- Allocating system storage and planning future storage requirements
Environment: Environment: Oracle Applications R12, 11i, Oracle 10g, 9i,Discoverer 10g, INV, PO, AOL, GL, AR, PA, Forms 10g/6i, and Reports 10g/6i, Workflow2.5, iExpenses, iProcurement, iSupplier, SQL, SQL Plus, PL/SQL, SQL Loader, Win NT and UNIX.
Confidential
Oracle Apps DBA/Core DBA
Confidential of Oman, Qatar, Bahrain, Brunei, Tanzania and India. Imtac look wide to a whole new world of possibilities. This fresh vision drills deep into details to offer you the best of everything - location, aesthetics, amenities, conveniences, choices, spaces, fittings and features. We think laterally and approach challenges with new solutions. We have waited for the right investment climate and passed on benefits to our valued customers
- Interacted with the customer to understand their requirements and their Technical queries for planning the installation.
- Prepared the pre req document for the customer requirement
- Responsible for Installation of Oracle Applications on Linux Platform.
- Performed Shared Appl-top installation.
- Familiar in Multi node installation and as well as cloning Rapid and Manual also
- Monitoring and optimize the performance of the Standard Manager Pending Jobs and CPU usage.
- Cloning and maintenance of application system and database on Linux platform.
- Troubleshooting issues related to Concurrent Managers.
- Familiar with Oracle Applications AD-Utilities like AD Administration, AD Controller, Auto config, AD Merge Patch, AD Relink, AD Splice, Auto Patch and Rapid Install, FNDCPASS, f60gen, CONCSUB etc.
- Monitoring the Application System with Oracle Applications Manager OAM .
- Performing Patch analysis, downloading patches and applying patches
- Applied one-off, minipack and maintenance patches
- Reduced the patch time using features like defaults file and merge patch.
- Managing apps password, application user passwords and schema passwords.
- Performed splicing of new offline Product using adspilce utility.
- Resolved the issues like yellow bar and connectivity problems.
- Installing statspack, capturing snaps and Generating stats pack reports
- Created Data Groups, Responsibilities and Users as part of system administration.
Environment: Oracle Applications 11i.9, Oracle9i, GL, AR, PA, OLM, AOL, Forms 6i and Reports 6i, Workflow 2.5, SQL, SQL Plus, PL/SQL, SQL Loader, Win NT and UNIX, Toad.