Oracle APPS DBA vs Oracle DBA

Posted on by Osama Mustafa in Others
Name Different In One Thing Apps , Both Are DBA for the same corporation but before going further you need to know what the definition for both of them what APPS DBA mean and What Oracle DBA mean ?

Oracle DBA ( Database Administrator ) is the person who responsible for administration , Monitor , tuning and recover database ( Failure cases ) For Oracle Database this Person Called Oracle DBA.

Lot of Jobs and Tasks for this Person

  • Installing and upgrading the Oracle server and application tools
  • Allocating system storage and planning future storage requirements for the database system
  • Creating primary database storage structures (tablespaces) after application developers have designed an application
  • Creating primary objects (tables, views, indexes) once application developers have designed an application
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Ensuring compliance with your Oracle license agreement
  • Controlling and monitoring user access to the database
  • Monitoring and optimizing the performance of the database
  • Planning for backup and recovery of database information
  • Maintaining archived data on tape
  • Backing up and restoring the database
  • Contacting Oracle Corporation for technical support
    For More Information Read oracle Documentation Here.
    in he big company that required 24/24hr monitor for more than one database therefore you cannot assign everything to this person he will be killed. So two kind of DBA appeared to reduce Tasks 
    Development DBA   & Production DBA each one of them has it’s own job and Tasks.
    Development DBA: 
    well from the name you can see it’s person who works closely with developers team to make sure database design and performance are working find without any problems.
    Production DBA
    Person who responsible to ensure that Database for this company is healthy and running without any problem it’s not easy job since this type of Database is the main database for company so you have to ensure it’s working fine or you will be fired.
    I mention before of my blog how to become DBA and what you need to do that ? Good understanding of the Oracle database,  understanding of the underlying operating system ,  how Oracle acquires and manages resources, knowledge of both database and system performance tuning,communication skills , management , and ability to handle multiple projects and deadlines all this Hints to become DBA. Read my Post About “how to become DBA” Here 
    After you have small knowledge about DBA tasks and What he is doing ? Let’s talk about APPS DBA.
    Simply the equation :
    ORACLE APPS DBA = Application* + Database.
    *Which Application is Fusion Middle Ware Products from Oracle.
    If you are aware of all the previous tasks  then you are able to be Oracle APPS DBA, Oracle APPS DBA include all Oracle DBA tasks and it’s very huge subject to learn and explorer.
    So the Task for APPS DBA :
    • All Oracle DBA tasks.
    • Patching
    • Cloning 
    • Maintenance Oracle Application.
    • Installations Oracle EBS.

    So as conclusion Oracle APPS DBA is an Oracle DBA because of this he can switch easliy between this job Role, and don’t let this disappointed you also Oracle DBA can switch to APPS DBA but he must read LOT.

    Thank you 
    Osama Mustafa  

    Published by Osama Mustafa

    Osama considered as one of the leaders in Cloud technology, DevOps and database in the Middle-East. I have more than ten years of experience within the industry. moreover, certfied 4x AWS , 4x Azure and 6x OCI, have also obtained database certifications for multiple providers. In addition to having experience with Oracle database and Oracle products, such as middle-ware, OID, OAM and OIM, I have gained substantial knowledge with different databases. Currently, I am architecting and implementing Cloud and DevOps. On top of that, I'm providing solutions for companies that allow them to implement the solutions and to follow the best practices.

    14 thoughts on “Oracle APPS DBA vs Oracle DBA”

    1. Hello Osama,I think if I am not mistaken, you wrote a topic > Poor Man's Dataguard before? How do I search it from here?

      Like

      Reply

    4. this is very good nice article. this is very useful for Oracle Apps DBA students.==========================================================This is very nice article. This is very use ful for Oracle Apps DBA Learners.http://www.bytesonlinetraining.com/oracle-apps-dba-online-training/===========================================================hi sir. i want to do Oracle Apps DBA training.Oracle Apps DBA ONlINE TRAINING Thanks for providing valuable information.

      Like

      Reply

    11. QA Training Hub is best Python Programing Online Training Center in India. Python Online Training provided by real time working Professional Mr. Dinesh. Data Scientist and RPA Expert with 18+ years of industry experience in teaching Python. PYTHON Online Training Course concepts:Introduction to ScriptIntroduction to PythonDifferent Modes in PYTHON PYTHON NEW IDEsVariables in PythonString Handling in PythonPython Operators and OperandsPython Conditional StatementsPython LOOPSLearning Python StringsSequence or Collections in PYTHONPython ListsPython TUPLEPython SetsPython DictionaryPython FunctionsPython ModulesPackages in PythonPython Date & TimeFile Handling in PythonPython OS ModulePython Exception HandlingMore Advanced PYTHONPython Class & ObjectsPython Regular ExpressionsPython XML ParserPython-Data Base CommunicationMulti-ThreadingIntro to Web scrappingIntro to Data AnalyticsIntroduction to Machine Learning with PYTHONIntro to Data ScienceIntro to Internet of ThingsPlease Contact Mr. Dinesh Raju India: +91-8977262627, USA: : +1-845-493-5018Mail: info@qatraininghub.comhttp://www.qatraininghub.com/python-online-training.php

      Like

      Reply

    Leave a Reply

    Fill in your details below or click an icon to log in:

    Gravatar
    WordPress.com Logo

    You are commenting using your WordPress.com account. ( Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. ( Log Out /  Change )

    Cancel

    Connecting to %s

    This site uses Akismet to reduce spam. Learn how your comment data is processed.