Post reply

DBA Roles

  • December 19, 2007 at 9:04 pm

    #73937

    Hi,

    can any one explain DBA Roles.

    Thanks

  • December 19, 2007 at 9:36 pm

    #761649

    Following are the DBA Role:

    Daily Tasks

    The following tasks should be completed on a daily basis:

    Check to make sure the SQL Server is still online and that you still have connectivity.

    Check the NT and SQL Server logs for any errors or problems.

    Ensure that no SQL Server job has failed.

    Resolve any problem tickets.

    Close any outstanding change tickets.

    Perform the necessary backups, whether transactional or complete.

    Check the general health of the server (space, CPU utilization, memory) to confirm there are no issues.

    Track locking issues, including deadlocks, blocking, and lock timeouts.

    Weekly Tasks

    The following tasks should be completed on a weekly basis:

    Perform necessary database backups.

    Remove any unneeded space from the transaction log and data files.

    Perform any necessary index tuning, including defragmenting the indexes.

    Execute UPDATE STATISTICS if auto-update statistics has been turned off.

    Monthly Tasks

    The following tasks should be completed on a monthly basis:

    Perform necessary database backups (including a complete backup of the OS and supporting third-party application files).

    Apply any patches or service packs for SQL Server.

    Run System Monitor to confirm that your server is operating close to its baseline. Update your baseline documentation to reflect this month’s numbers.

    Perform a complete system restore of the server’s database onto a new server from a random day. Check the health of the restored database afterward by running DBCC CHECKDB.

    Run sqldiag.exe on your server and document the results into a central repository.

    Test your alerts to confirm that they still work.

  • December 19, 2007 at 11:03 pm

    #761656

    Heh... You forgot some.... 😀

    Protect the data, at all costs.

    Protect the server the data is on, at all costs.

    Help most developers tune queries while teaching them what good set based SQL actually is and why it's important to an RDBMS.

    Answer the bloody phone.

    Conduct code reviews before promoting code.

    Promote code.

    Find queries hogging the CPU/Disk.

    Find the developer responsible for the above.

    Find the manager for the above.

    Pummel them both until they agree to rewrite the code today!

    Answer the bloody phone.

    Answer 10,000 dumb questions per day because lots of folks really have no clue how to write SQL correctly.

    Tell managers why the code they want to go in, isn't (dangerous to the data or the system).

    Attend project meetings where the users usually think they know more about correct database design than you.

    Document the "system" because the users were wrong.

    Answer the bloody phone.

    Help repair totally undocumented code that broke in the face of scalability.

    Help repair totally undocumented code that broke because someone wanted it real bad and that's the way they got it.

    Help developers figure out what the undocumented SQL does.

    Answer the bloody phone.

    Find out which undocumented code is causing the deadlocks even if it's embedded in Jave or C#.

    Write reports on the deadlocks and why the server "seemed sluggish" today and every day.

    Write "Code Guidelines" to prevent undocumented code in the future.

    Buy a new bat with a nail in it to help you enforce the new "Code Guidelines".

    Answer the bloody phone.

    Explain to migration experts why PL/SQL and T-SQL cannot be run in SQL Server and Oracle, respectively.

    Answer the bloody phone.

    Explain to everyone from the President of the Company down to the Janitor why no one can have "SA Privs" and why they can't use xp_CmdShell without going through a proxy.

    Attend 10 hours of "Sensitivity Training" each week because people think you're too mean just because you made 2 developers cry and 1 leave the country.

    Drink too much beer because deep in your heart, you know you're not mean enough.

    Answer the bloody phone.

    Interview more *&*&^&$%$# Developers that you're gonna have to train all over again.

    Answer the bloody phone.

    What the heck, it's a living 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • December 20, 2007 at 7:03 am

    #761743

    Depends on production DBA, development DBA, etc.

    Lots of debate on this:

    http://qa.sqlservercentral.com/articles/Administering/dbaroles/517/

    http://qa.sqlservercentral.com/articles/Administering/thevalueofadba/1806/

    http://qa.sqlservercentral.com/articles/State+of+the+Business/deathoftheproductiondba/432/

    http://qa.sqlservercentral.com/articles/Certifications/3176/

    http://qa.sqlservercentral.com/articles/Miscellaneous/2989/

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • December 20, 2007 at 7:29 am

    #761757

    Actually, those are pretty good links... Thanks, Steve.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • December 20, 2007 at 8:21 am

    #761774

    Thanks for the replys

  • December 21, 2007 at 8:37 am

    #762151

    Jeff, I hope you didn't scare PR away, although it made me laugh. 😀

  • December 21, 2007 at 11:06 am

    #762223

    It was kind'a real life spoof... for some of us, though, it's closer to the truth than I care to think 😀

    Glad it made some laugh 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • December 21, 2007 at 12:56 pm

    #762302

    Oh you certainly did. Almost to the coffee over keyboard point. Especially the bat.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 26, 2011 at 10:46 pm

    #1344299

    hi Guys

    i am Abhijeet Dhamane i am working with Wipro Technologies and i have 14months of Exprieance in unix

    abd i want to do DBA so pls suggest me some institute In hyd which is good and some certification for same Thanks

    Regards

    Abhijeet Dhamane

    9550259720

  • June 27, 2011 at 5:58 am

    #1344434

    Wrong post... removed comments.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply