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.
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.
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.
- 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.
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.
View all posts by Osama Mustafa
14 thoughts on “Oracle APPS DBA vs Oracle DBA”
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?
Yes , Use the Search Bar in my blog m, if you cannot find it contact me please
Thanks for sharing the informationFor more info : Oracle Certification Courses
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.
Hello Osama,can you please share poor man's dataguard email@example.com
I will send it to you
Its Really Useful….. oracle training in chennai
nice blog and good imformation Oracle Apps DBA Online Training
This comment has been removed by a blog administrator.
nice post SQL Server DBA Online Training
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: firstname.lastname@example.org://www.qatraininghub.com/python-online-training.php
nice thank you for sharing SQL Server DBA Online Training bangalore
Hello Osama,can you please share poor man’s dataguard article? email@example.com is the email id. thank you.
What artcile ?