We provide IT Staff Augmentation Services!

Tech Lead - Oracle Apps Dba Resume

Louisville, KentuckY

SUMMARY:

  • Over 10 years of IT experience working as Oracle DBA, Oracle Applications DBA, SOA Administrator and OBIEE Administration in large scale Support, Implementation and Upgrade Projects.
  • Upgradation of Oracle E - Business Suite to R12.2.3 from R12.1.3, R12.2.5 from R12.2.3 and R12.2.6 from R12.2.5
  • Installation and configuration of 11i and R12.1.X and R12.2.X
  • Implementation, configuration of Load balancer, DMZ, SSL and SSO setup
  • Installation of Oracle WebLogic server, SOA, OBIEE
  • Worked as a Production Support DBA providing 24*7 support for EBS applications accessed by users across the globe, provided On-call and day-to-day support.
  • Experienced in working as a team as well working individually on various projects according to the requirements.
  • Developed scripts for the various simple to complex DBA tasks (day to day DBA tasks, cloning, reporting statistics, re-indexing, checking integrity, backup and recovery)
  • Installing, Maintenance of Oracle E-Business suite 11i and upgrading of Oracle database Oracle E-Business Suite R12 - Installation & Maintenance
  • Documenting, applying patches that included mini-patch sets, standalone patches, Family packs
  • Cloning application using Rapid Clone from dual node to dual node, dual node to single node
  • Administration of Oracle Database versions 9i/10g/11g/12c involving database installations, cloning, upgradation, Data Guard and backup configuration using RMAN/Hot backups, applying patches (PSU/CPU, bug fixes) & User administration.
  • Expertise in administration of Real Application Cluster (RAC) / Automatic Storage Management (ASM).
  • Expertise in Space Management, SQL query tuning, Application tuning
  • Experience in creating database Objects like Tables, Stored Procedures, Views and functions.
  • Expertise in administration of Golden Gate

WORK EXPERIENCE:

Tech Lead - Oracle Apps DBA

Confidential, Louisville, Kentucky

Application: Oracle Applications 11i, R12.1.3 and R12.2.3

Database: Oracle database 9i/10g/11g/12c

O/S: Linux/RHEL AS 6.1

Responsibilities:

  • Upgradation of R12.1.3 to R12.2.3, R12.2.3 to R12.2.5 and R12.2.5 to R12.2.6
  • Expertise in OBIEE, which includes Implementations, Upgrade, Cloning, Patching and Integration with EBS
  • OBIEE Upgrade from 11.1.1.7 to 11.1.1.9
  • OBIEE Migration from 11.1.1.9 to 12.1.1.0
  • Upgrading database 11g to 12c
  • Installing and Managing OBIEE 11g
  • Implementation, configuration of Load balancer, DMZ and SSL setup
  • Implementation of Java Web Start (JWS)
  • Applying Patches (R12.2.3, R12.1.3) with different teams involved in the process
  • Maintaining the uptime of all Production instance 24x7
  • Providing issue resolution to customers within SLA
  • Carrying Cloning of single as well as multiple node architecture.
  • Experience in Fusion Middleware like Weblogic/SOA/OBIEE
  • Worked on Rehost project (EBS, OBIEE, Weblogic Server, Demantra application)
  • Communicating out scheduled activity within tight timelines
  • Performed the table reorg, based on the user request.
  • Working Experience in Demantra/Agile/OTM
  • Quarterly review of PSU/CPU patches and applying as requested.
  • Solving day-to-day user Problems
  • Considering future growth, reorganization of database and space management of database as per need
  • Monitoring and Troubleshooting of Apache, Forms, Conc. Manager, and Servers.
  • Experience in setup of cronjobs using crontab for Production Environment to receive alerts related to TS issues, OS level space issues, locking issues, log alerts, etc.
  • Expertise in administration of Real Application Cluster (RAC) / Automatic Storage Management (ASM).
  • Expertise in Space Management, SQL query tuning, Application tuning
  • Expertise in administration of Golden Gate

Oracle Apps DBA

Confidential

Environment: Oracle Applications 11i,R12.1.X

O.S: Sun Solaris 10,Linux/RHEL AS 6.1,AIX

Responsibilities:

  • Performed the Applications Upgrade from 11.5.10.2 to R12.1.3
  • Worked new host projects on Tricore (Datacenter) servers
  • Configured DR setup for new build instances.
  • Administration of Oracle Database versions 10g/11g/12c involving database installations, cloning, backup configuration using RMAN/Hot backups, applying patches (PSU/CPU, bug fixes) & User administration
  • Working on New R12 implementation environments
  • Providing issue resolution to customers within SLA
  • Carrying out scheduled activity within tight timelines
  • Worked on 11g RAC and handled it with the help of srvctl, ocr, ocrcheck, ASM etc.
  • Cloning of single as well as multiple node architecture.
  • Monitoring Concurrent Manager, its operations & Troubleshooting problems, resolved the log/out files issues of concurrent requests.
  • Daily monitoring the database alert log files & trace files for any error messages, periodic checking table spaces, Undo TS & index status.
  • Cloning of SOA of instance
  • Integration of Discoverer 10g with eBusiness Suite

Oracle APPS DBA

Confidential

Applications: Oracle Applications 11i, R12

Database: Oracle database 9i/10g/11g

O.S: Sun Solaris 10

Responsibilities:

  • Upgrading Database 10g to 11g (10.2.0.5 to 11.2.0.4) in Production.
  • Maintaining the uptime of all Production instance 24x7
  • Performed the table reorg, based on the user request.
  • Check Invalid objects in the database
  • Check space on all Tablespace and Tempspaces
  • Checks there are no DBMS JOBS with the status of failed or broken.
  • Check Oracle Alert process for the errors and warnings
  • Check any long-running operations on Database
  • Review the AWR report for all database
  • Performance Tuning and Maintenance for all database
  • Check Concurrent Manager are running and any alert log in Concurrent Manager log file
  • Check Workflow Managers are running and any alert log in Workflow log file
  • Purge Concurrent Request and/or Manager Data program status.
  • Check the status of the scheduled jobs
  • Check any long running concurrent requests
  • Doing all R12 SYSADMIN activities like user ID and responsibility creation, assignments
  • Concurrent Manager Tuning
  • R12 Application cloning

Oracle APPS DBA

Confidential

Environment: Oracle Applications 11i,R12

O.S: Sun Solaris 10

Responsibilities:

  • Actively Participated in DATA CENTER MIGRATION for Development, Staging & Production Instances
  • Performed the Applications Upgrade from 11.5.10.2 to R12
  • Working on more organized Ticket based environment for issue resolution
  • Providing issue resolution to customers within SLA
  • Carrying out scheduled activity within tight timelines
  • Applying Patches (PSU, CPU, INDIA Localization and RDBMS)
  • Cloning the instances from Production to development (Using SRDF Replication and RMAN)
  • Maintaining the uptime of all instance 24x7
  • Participating weekend plan meeting and process meetings.
  • Implementing load balancer, DMZ and SSL
  • Installation and configuration of 11i and R12
  • Working on New R12 implementation environments
  • Upgrading database 9i to 10g & 10g to 11g
  • Implementing Distributed application tier to shared application tier file system
  • Implementing NLS support for Oracle Applications
  • Convert character set from US7ASCCII to UTF8
  • Configured Dedicated JVMs and Troubleshooting JVM related issues.
  • Discussing and Implementing backup & restore policies
  • Performed physical backups and recovery and restoration of database.
  • Responsible for scheduling and monitoring backups.
  • Performed tablespace reorg.
  • Upgrade forms version 19 and JRE upgrade.
  • Tracking invalid objects, compiling & validating the invalid objects.
  • Filing SR’s, coordinating with Oracle corp. for support.
  • Managing Oracle Applications using Utilities like AD Utilities like adctrl, adpatch, adadmin.
  • Performed tracing for various user sessions and for various concurrent Programs.
  • SYSADMIN Activities like Concurrent Manager Management, User Creation, etc.
  • Added the off-cycle product by using AD Splice
  • Reduced the patch timing by using merging patches and options.
  • Monitoring memory and CPU utilization
  • Fixed ora-600 errors by applying opatches.
  • System Administration for Oracle Apps which includes creation and maintenance of Users, Responsibilities, Profiles, Concurrent Program etc.
  • Created the custom tops to meet the development requirement
  • Increased the concurrent manager processes as per development and Functional team requirement depends on the server load
  • Monitoring Concurrent Manager, its operations & Troubleshooting problems, resolved the log/out files issues of concurrent requests.
  • Daily monitoring the database alert log files & trace files for any error messages, periodic checking table spaces, Undo TS & index status.

Hire Now