DBA vs System Administrators
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: DBA vs System Administrators

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    7

    Unhappy

    Hello everybody,
    Please tell me the difference between the job responsibilities of a DBA and a System Administrator if both are there in one institution.

    thank you all
    akber
    Vidhipariprashnena Sevaya
    (sanskrit an Indian Language means
    "Educate yourself to serve others")

  2. #2
    Join Date
    Apr 2001
    Posts
    219
    It varies from shop to shop and depends on each other skill and experience. In some shops DBAs do not get any priviledged access on the machine, while others backup the sys admin and vice versa. This also depends greatly on your skills, experience and desire. Do you have the skills needed to backup a sys admin? If so, you will mostly likely overlap in many areas.

    Where I work we have two types of sys admins. One manages the whole machine and another manages just the domain(A Sun Microsystem thing). I gather statistics on CPU, memory and I/O and how it relates to Oracle, while they focus on other aspects. I tell them how I want the I/O layed out and they implement.

    Watch out there are many sys admins that think a database and a file server are the same and they are not. I have seen a DB machine set up like a file server and it was horrible. The way the sys admin came up with his stats was to move large files around and measure I/O. This is great for a file server, but horrible for a OLTP DB. So keep a watchful eye out for what your sys admins do, becuase it can come back to haunt you.
    ______________________
    Applications come and go,
    but the data remains!

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sysadmins typically manage the box and the box services while DBA's manage the Oracle Software.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828

    Talking

    Hi

    Small shops dont make a difference between sysadmins and dba .They would prefer one person doing both..

    regards
    Hrishy

  5. #5
    Join Date
    Sep 2001
    Posts
    1

    Cool

    Hi All,

    System Admin responsible for the O/S & The server Hardware, Changing Disks & upgrading Memory etc etc., Space left on Disk , system backup Tuning O/s

    Where as DBA is to manage ORacle Database & sometimes application too, Oracle ruotine Backup, space management within Oracle ,
    some of the tasks overlap like Oracle backup , It depends on Individual skills.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width