Oracle Apps DBA Roles and Responsibilities

Oracle Apps DBA role combines the efforts of an Oracle Applications System Administrator, Oracle database administrator and Oracle Weblogic Administrator.

From Oracle E-Business Suite 12.2.x, Oracle has introduced Weblogic as its Web Server to achieve clustering capabilities, application server capabilities and load balancing capabilities.  Because of this, Oracle Apps DBAs should also be good in Weblogic Administration to maintain E-Business Suite environment.

There are mainly 4 types of roles an Oracle Apps DBA have:

Type 1:  L1 Apps DBAs

L1 Apps DBAs mainly involve in help desk activities such as:

  • Answering calls
  • Logging/updating tickets
  • Interacting with L2 Apps DBAs on tasks to be completed
  • Monitoring alerts

Type 2:  L2 Apps DBAs

L2 Apps DBAs mainly work on daily/scheduled/adhoc activities such as:

  • Code Migration Support to Functional Consultants
  • Handling tickets raised by functional/technical/business users
  • Handling Alerts raised by alert monitoring system from Database and applications
  • Tablespace Reorg Activities to improve the performance/to reclaim the unused space
  • Schema Reorg Activities to improve the performance
  • Patch Analysis where there is a patch needs to be applied
  • Patch Application as per schedule
  • Cloning as per schedules
  • Backups and issues related to them
  • Query response time and other Performance Issues
  • Work with Oracle Support by raising SRs on several issues
  • Monitoring Standby Databases and resolve respective issues
  • Regular database maintenance activities (tablespace management, datapump, purging logfiles……)
  • Training L1 Apps DBAs to make them L2 Candidates.

L1 and L2 Apps DBAs are the main teams who will impact SLAs of a client

Type 3:  L3 Apps DBAs

L3 Apps DBAs mainly work on installation/setup related tasks such as:

  • Work on issues which L2 couldn’t fix
  • New Environments Build/Setups
  • Designing Backup/Recovery policies
  • Installing new Application environments
  • Post-Installation tasks of New environments
  • Integrating E-Business Suite with other environments such as (SOA, OSB, OBIEE, OTM, IPM …)
  • Work on integration issues
  • Work on Cluster setups for both applications and databases
  • Work on DMZ setups to E-Business Suite
  • Work on Standby site setups for both applications and databases
  • Interact with Network/OS teams on network setups and load balancer setups.
  • Work on Parallel Concurrent Processing (PCP) Setups
  • Failover capabilities testing of E-Business Suite and database
  • Design Cloning strategies.
  • Work on design related issues.
  • Setting up E-Business Suite with Oracle Access Manager/OID to achieve Single Sign-On (SSO) Capabilities
  • Training L2 team to make them L3 Candidates

Type 4:  Architects

Architects are the ones who design systems from scratch.  They mainly involve in:

  • Attend Client Meetings to understand their expectations.
  • Involve in Business User Meetings to understand their expectations.
  • Design E-Business Suite Architecture with failover/failback capabilities.
  • Design Clustering capabilities of E-Business Suite and databases.
  • Design High availability of E-Business Suite and databases.
  • Design hardware/capacity sizing.
  • Helping L3 Team to achieve their targets and in understanding technologies.
  • Conduct training sessions to L3 team to get understanding of system design.
  • Fix any architectural related issues.
  • Work on integration options of E-Business Suite with other environments such as (SOA, OSB, OBIEE, OTM, IPM …)

Everyone performs a great role in achieving client expectations

For Oracle Apps DBA training, Oracle Weblogic Admin Training, Oracle RAC Training, Oracle DBA, Oracle Fusion Apps DBA training details; please go through my exclusive site http://fusionappsdba.com or shoot me at training@fusionappsdba.com for any questions or concerns.

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."