Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: July 07, 2016 - 1:29 pm UTC

Last updated: December 19, 2018 - 1:48 am UTC

Version: 11g

Viewed 10K+ times! This question is

You Asked

What is different between Oracle DBA and Oracle apps DBA?

I so many websites where some of them used term Oracle DBA and some of them Oracle apps DBA?


and Connor said...

An "DBA" typically is either

- production DBA (looks after the day to day running of the database - backups, recovery, tuning, patching, software installation, security)

- development DBA (helps in in the design process, code review, tuning, deployment etc)

- both

An "Apps DBA" also has a skillet to manage the installation, running of the suite of Oracle Applications products (financials, accounts, etc etc).

Typically an Apps DBA is a role more closely aligned to that of Production DBA, with an additional focus on Oracle Applications software.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, July 08, 2016 - 8:22 am UTC

suppose when a company requires employee , they chose first oracle apps dba then oracle dba.
Am I right?
Chris Saxon
July 08, 2016 - 8:41 am UTC

It depends upon what software the company uses. If there's no Oracle Applications, then there's no need for an "Apps DBA"!

Note that these definitions are slightly loose - a particular company or recruiter may mean something different when they use these terms. But Connor's definitions are the commonly accepted ones.

Chris

Update.

Vikas Dixit, December 18, 2018 - 7:16 am UTC

Hi

having 5 years of Oracle DBA ,I would like to switch to APPs DBA ,on which points should I work hard or where to start ..
Connor McDonald
December 19, 2018 - 1:48 am UTC

Well...you'd need to learn the infrastructure/architecture around Apps.

So you'd want to skill up on:

Weblogic
Forms/Reports

and the way Apps uses those components, and the schema design etc.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.