Sunday, December 21, 2008

DBA Roles and Responsibilities

Click Me to Check How to be DBA?


DBA Responsibilities




  • Installation, configuration and upgrading of Microsoft SQL Server/MySQL/Oracle server software and related products.

  • Evaluate MSSQL/MySQL/Oracle features and MSSQL/MySQL/Oracle related products.

  • Establish and maintain sound backup and recovery policies and procedures.

  • Take care of the Database design and implementation.

  • Implement and maintain database security (create and maintain users and roles, assign privileges).

  • Database tuning and performance monitoring.

  • Application tuning and performance monitoring.

  • Setup and maintain documentation and standards.

  • Plan growth and changes (capacity planning).

  • Work as part of a team and provide 7x24 supports when required.

  • Do general technical trouble shooting and give consultation to development teams.

  • Interface with MSSQL/MySQL/Oracle for technical support.

  • ITIL Skill set requirement (Problem Management/Incident Management/Chain Management etc)



Types of DBA




  1. Administrative DBA - Work on maintaining the server and keeping it running. Concerned with backups, security, patches, replication, etc. Things that concern the actual server software.

  2. Development DBA - works on building queries, stored procedures, etc. that meet business needs. This is the equivalent of the programmer. You primarily write T-SQL.

  3. Architect - Design schemas. Build tables, FKs, PKs, etc. Work to build a structure that meets the business needs in general. The design is then used by developers and development DBAs to implement the actual application.

  4. Data Warehouse DBA - Newer role, but responsible for merging data from multiple sources into a data warehouse. May have to design warehouse, but cleans, standardizes, and scrubs data before loading. In SQL Server, this DBA would use DTS heavily.

  5. OLAP DBA - Builds multi-dimensional cubes for decision support or OLAP systems. The primary language in SQL Server is MDX, not SQL here


Application DBA- Application DBAs straddle the fence between the DBMS and the application software and are responsible for ensuring that the application is fully optimized for the database and vice versa. They usually manage all the application components that interact with the database and carry out activities such as application installation and patching, application upgrades, database cloning, building and running data cleanup routines, data load process management, etc.

Download SQL Server Interview Question
Posted by at
Labels: , ,

83 comments:

  1. JitendraJune 13, 2009 at 3:30 AM

    Hi Sir.Its Very Fine.
    I want to be a DBA .But i am not Getting proper way.Kindly help me.

    Regds Jitendra

    ReplyDelete
  2. sumuduDecember 12, 2009 at 4:33 AM

    thanx this helped for ma exam.nice !!

    ReplyDelete
  3. vamsiDecember 13, 2009 at 3:55 PM

    Hi Sir, At Present,I am pursuing my BTech Final Year CSE Branch. In Future , I want to be a DBA. Can you help me to reach my goal.

    ReplyDelete
  4. JShahDecember 14, 2009 at 8:37 AM

    Yes Sure

    ReplyDelete
  5. SANTOSH KUMARJanuary 6, 2010 at 5:56 PM

    I am 3.8 years .net developer. I have knowledge in SQL Server 2000/2005. Now I want to convert to Oracle DBA. Is this a good decision?
    Are you with me?
    With Regards
    SANTOSH KUMAR

    ReplyDelete
  6. SubhoFebruary 24, 2010 at 1:34 AM

    Hi ;It's too good ........

    ReplyDelete
  7. shagun guptaMarch 19, 2010 at 2:30 AM

    Hello sir,

    i done MCA (2007-2010)and DBA 9i certification also.right now i m doing 6 mnts industrial training.But till now i havnt get any DBA traing.Can you help me wht will i do or in which way i search for it.

    ReplyDelete
  8. JShahMarch 19, 2010 at 4:04 PM

    To get a job as a fresher is somehow difficult, you must have good knowledge of SQL Server as well alone oracle will not help you. Join diffrent job portal and try to search job.

    ReplyDelete
  9. RehanJune 8, 2010 at 8:22 PM

    could you please advise sqlserver2005 64 bit Recommended server configuration

    ReplyDelete
  10. lucky vyasJune 17, 2010 at 12:06 AM

    hello sir...
    at present...i m pursuing...be..6 sem i want to be dba ,but i m not getting proper way and proper knowledge..kindly help me.....

    ReplyDelete
  11. priyaJune 19, 2010 at 1:34 AM

    hello sir...
    at present i am doing mca & i want to be dba i have done oracle8i in bca.plz tell me the full procedure to be a dba.

    ReplyDelete
  12. mushirJune 27, 2010 at 5:45 AM

    its help

    ReplyDelete
  13. gopinathJune 27, 2010 at 9:25 PM

    Hi, this is gopinath. I completed my B- Tech. At present i working as a network administrator as trainee further i would like to do DBA. Is tthis is the correct way? Does dba come under networking field. Please give me full information about DBA. Is it is helpfull for my further career?

    ReplyDelete
  14. ShekharJune 27, 2010 at 11:54 PM

    Hi,

    I am working as system administrator…

    I want to become SQL Server DBA…How can I?

    How is the present market in SQL server DBA?

    Pls Help me…

    ReplyDelete
  15. ShekharJune 27, 2010 at 11:54 PM

    Hi,

    I am working as system administrator...

    I want to become SQL Server DBA...How can I?

    How is the present market in SQL server DBA?

    Pls Help me...

    ReplyDelete
  16. SrikanthJune 29, 2010 at 4:23 AM

    Hi Sir, i completed MCA in 2008 and i learnt Linux Administartion and presently working as a linux admin in a pvt organization. So the thing is i want to learn DBA so is it useful? I get a good job while doing DBA?

    ReplyDelete
  17. JShahJune 29, 2010 at 4:57 AM

    Yes. For Linux Admin, If you have good knowledge in MySQL, it will be considered as advantage.
    -Jugal Shah

    ReplyDelete
  18. JShahJune 29, 2010 at 4:59 AM

    Hi Shekhar,

    Market is always good for masters :), You have to go for professional SQL Server DBA training. I can guide you. Send me an email of jugal.shah@sqldbpool.com

    -Jugal Shah

    ReplyDelete
  19. JShahJune 29, 2010 at 5:01 AM

    Hi Gopinath,

    DBA doesn't come under networking. But it will considered as advantage in your DBA Profile. If you want to go for professional DBA training, please send me an email on jugal.shah@sqldbpool.com

    -Jugal Shah

    ReplyDelete
  20. JShahJune 29, 2010 at 5:02 AM

    Hi Priya,

    For oracle DBA you need to done the OCP and must have good hands on 8i,9i,10G,11G :)

    -Jugal Shah

    ReplyDelete
  21. JShahJune 29, 2010 at 5:04 AM

    You can do Microsoft certification for your DBA skills. During the campus interview you can ask for DBA position.

    ReplyDelete
  22. JShahJune 29, 2010 at 5:04 AM

    You need to consider the proper processor and RAID configuration. and SQL Server level opt out for EE edition

    ReplyDelete
  23. sunilJuly 7, 2010 at 11:30 PM

    Hi,

    Right now i am working with the web hosting company as a IIS administrator. I want to know, is dba is a better option for me or not? If not then suggest me the course which is suitable for me.

    I alredy did mainframe course and didn't get any job as a fresher.

    ReplyDelete
  24. JShahJuly 8, 2010 at 5:30 AM

    Sunil!!! It will be good option for you.

    ReplyDelete
  25. shekharAugust 2, 2010 at 11:22 PM

    Thanks Jugal...

    I am sending a mail to u please help me...

    ReplyDelete
  26. tabithaAugust 10, 2010 at 10:32 PM

    Hi Sir,

    I want to know the difference between sql programer and sql server dba ,is both r same ?

    ReplyDelete
  27. VinayakAugust 14, 2010 at 9:20 AM

    Hello Sir,
    Currenly I'm working on SQL Server 2000/2005. I got 3+ years of exp. I'm looking for to do a DBA but bit confused if I could go for SQL/Oracle. Not sure hows the scope for it. Please gide me. Thanks

    ReplyDelete
  28. VinayakAugust 14, 2010 at 9:21 AM

    Hello Sir,
    Currently I’m working on SQL Server 2000/2005. I got 3+ years of exp. I’m looking for to do a DBA but bit confused if I could go for SQL/Oracle. Not sure hows the scope for it. Please guide me. Thanks

    ReplyDelete
  29. HareeshAugust 18, 2010 at 11:00 AM

    Hello sir,
    i have 10+ years experience in software development and implementation.
    I am self employed and designed & developed many custom made s/w. i have experience in vb6, vb.net and Delphi. i have sound knowledge database like InterBase,MySql, Ms Sql and Oracle. Now i am looking for to do DBA. what is your suggestion Oracle / Ms sql. Is this certification is necessary?

    Hareesh
    Trivandrum

    ReplyDelete
  30. AjaySeptember 5, 2010 at 12:27 PM

    Hello,
    I hv jst completed my B.E Electronics. frm Mumbai univ.
    I am thinking about doin the oracle DBA (OCP) certification course.
    Do you think its a good career option for me. or should I go for networkin

    ReplyDelete
  31. JShahSeptember 6, 2010 at 11:25 PM

    DBA would be the best option for you .

    ReplyDelete
  32. JShahSeptember 6, 2010 at 11:27 PM

    Try for MSSQL DBA and it will be good option for you.

    ReplyDelete
  33. Hri KumarOctober 19, 2010 at 3:21 AM

    Hi Sir,

    I am 4 years experienced , got trained in Oracle and performed the role of a developer for an year later my company gave me Oracle DBA training but due to no projects I am moved into a Microsoft Production support, as a support analyst where I work more on analysing the business rules and providing info to the user , and work in troubleshooting SQL jobs and batch jobs changing the passwords , providing access to the users , taking back ups of the DB .

    Now I need your help in helping me what is the role that I nned to project my self you help is very much required.

    ReplyDelete
  34. Virender ChauhanOctober 21, 2010 at 2:11 AM

    Hello Sir,

    i want know about if we use Windows 2003 64 bit edition and sql server 2005 32 bit edition doet it right to choose? please suggest me what are the demerits about this.

    Thanks

    Virender

    ReplyDelete
  35. JShahOctober 22, 2010 at 8:03 AM

    I recommend to installl SQL Server 64 Bit edition.

    ReplyDelete
  36. JShahOctober 22, 2010 at 8:04 AM

    You can go for SQL DBA

    ReplyDelete
  37. JShahOctober 22, 2010 at 8:09 AM

    SQL Developer can work on the T-SQL coding stuff and BI stuff. SQL DBA work on performance and monitoring and health check of SQL Server

    ReplyDelete
  38. mohanNovember 11, 2010 at 6:06 AM

    Hello sir,
    I have 3 years experience in sql server 2005 but now i have plan for dba tell me is it right or wrong? if it is right give me some responsiblities for sql dba

    Thnks in advance

    ReplyDelete
  39. JShahNovember 11, 2010 at 6:56 AM

    Work on backup/restore, SQL Server troubleshooting, performance and tuning etc

    ReplyDelete
  40. AnandNovember 21, 2010 at 8:57 PM

    hi sir,

    I am fresher and just join a company for the post of IT-support and I am work on sql server.I want to be dba but i m confuse in oracle and sql server. So i want to know wich 1 is better.

    ReplyDelete
  41. AnandNovember 22, 2010 at 3:41 AM

    Is there any classes available for sql server dba certification.
    And what is path of certification?

    ReplyDelete
  42. majid aliNovember 27, 2010 at 9:53 AM

    hello sir,,this is majid ali i am pursuing my bscIT final year i want to become DBA,so please could you help me to reach my goal...

    ReplyDelete
  43. JShahDecember 3, 2010 at 4:14 AM

    Yes Sure.

    ReplyDelete
  44. JShahDecember 3, 2010 at 4:15 AM

    Plz send me email on jugal.shah@sqldbpool.com, I will guide you.

    ReplyDelete
  45. JShahDecember 3, 2010 at 4:16 AM

    Both are RDBMS and best.

    ReplyDelete
  46. 2010 in review « SQLDBPOOL.COMJanuary 1, 2011 at 11:17 PM

    [...] and prosperous new yearHow to change SQL Server Instance Name?Transactions and Locks in SQL ServerDBA Roles and ResponsibilitiesNetwork Troubleshooting Dos CommandsSQL Server 2008 Active-Passive/Active-Active Cluster [...]

    ReplyDelete
  47. riddhiJanuary 12, 2011 at 3:35 AM

    mast ans 6

    ReplyDelete
  48. Jugal ShahJanuary 12, 2011 at 3:52 AM

    Thanks!!!

    ReplyDelete
  49. arvind bhujangJanuary 23, 2011 at 10:45 PM

    hello sir,,this is bhujang am working for private organization as SQL Developer. i want to become DBA,so please could you help me to reach my goal…

    ReplyDelete
  50. Jugal ShahJanuary 27, 2011 at 3:35 AM

    You can start your next job as PL/SQL Developer. Mean while do OCA certification. Change to oracel DBA

    ReplyDelete
  51. rajeshJanuary 27, 2011 at 7:34 AM

    its good go a haed

    ReplyDelete
  52. Jugal ShahJanuary 31, 2011 at 10:44 PM

    Thanks Rajesh

    ReplyDelete
  53. Naga Satish.KFebruary 11, 2011 at 12:36 AM

    Hi Shekar,

    i think now u have an idea on SQL Server DBA. Now i am also learn SQL DBA.

    Please give the guidence to me (or) mail me on details. satishatk@gmail.com

    Regards,
    Naga Satish.K

    ReplyDelete
  54. rameshMarch 11, 2011 at 3:12 AM

    present i am ddoing the java course i am fresher i dont interested in java.i want to go sql dba.tell me fully details on sqldba.tell me

    ReplyDelete
  55. Jugal ShahMarch 14, 2011 at 10:06 PM

    To be SQL DBA, go through DBA roles and responsibilities. Next step is start from basic to architect level reading. MSDN, BOL and Blogs are good source of information.

    ReplyDelete
  56. manojMarch 18, 2011 at 10:42 AM

    hi sir i am manoj i want to start my career in DBA i completed my mca i dont know the roles & responsibilities of DBA kindly provide me helpful information thanking you..

    ReplyDelete
  57. paragMarch 18, 2011 at 12:44 PM

    hi,

    your site very good. am also learn MS Sql 2008 DBA.. am also want to be a very good dba, so how to start ? please give me suggestion.

    ReplyDelete
  58. Jugal ShahMarch 20, 2011 at 10:34 PM

    You can check out my article DBA roles and responsibilities.

    ReplyDelete
  59. Jugal ShahMarch 20, 2011 at 10:34 PM

    Start with Basic SQL Queries, Procedures, Triggers, Function, Database Structure, Table and other database objects. Next is focus on SQL Server Architecture, Backup/Restore, Security...

    ReplyDelete
  60. RobinMay 27, 2011 at 11:28 PM

    I am doing the job as Software developer having knowlede of SQL 2000/2005. I want to become SQL Server DBA…Where and how can i do this? Please suggest.

    ReplyDelete
  61. zahid shahMay 30, 2011 at 12:29 AM

    Hi,

    I am a data analyst in a telecome company, my current role and responsiblity
    to maintin telecome software
    to maintain application server and database server
    backup and recover
    dbcc command for maintaining
    monitoring

    i wnat to becaome a dba

    How i become a sql server dba

    ReplyDelete
  62. Jugal ShahMay 31, 2011 at 10:19 PM

    Download the DBA roles and responsibilities documents from the SQL Dowloads page.

    ReplyDelete
  63. Jugal ShahMay 31, 2011 at 10:20 PM

    You have to start learning the SQL Server DBA responsibilities and download the DBA roles and responsibilities file from the SQL Download Page.

    ReplyDelete
  64. pavanJune 1, 2011 at 7:26 AM

    Hello sir

    I completed my Diploma in ECE and iam working as content analyst, I want to change profile, could u pls guide me which course is best for me,

    ReplyDelete
  65. Jugal ShahJune 7, 2011 at 10:19 PM

    You can go for ID profile.

    ReplyDelete
  66. Jugal ShahJune 7, 2011 at 10:20 PM

    I mean instruction designer profile.

    ReplyDelete
  67. chandraJune 20, 2011 at 3:13 AM

    HI SIR,
    This is Chandra from Bangalore.Now iam working as a programmer,but i want move to dba side.Iam interesting in sqldba.So,please help me on this issue.
    Please forward the interview questions and answers for 3years exp professionals please.Hope i will get it soon....



    Regards,
    Chandra

    ReplyDelete
  68. Jugal ShahJuly 10, 2011 at 10:46 PM

    You can check the page How to Be DBA on my blog, and focus on each responsibility...

    ReplyDelete
  69. Jugal ShahJuly 10, 2011 at 10:49 PM

    I really suggest you instead of clearing interview with the help of questions/answers, study the SQL Server architecture... read it as DBA perspective...

    ReplyDelete
  70. Navneet VediJuly 14, 2011 at 10:37 PM

    Dear SANTOSH KUMAR

    As a developer if you are comfortable then it would be a very good job. Don't merge your
    current profile with the DBA profile as it requires lots of reponsibities and headache..

    Be cool & calm and continue with thesame profile..

    ReplyDelete
  71. NethajiJuly 24, 2011 at 9:45 PM

    Hi,

    I got a role as Application DBA, Pls tell me whether this role is good or not

    Regards,
    Nethaji

    ReplyDelete
  72. Jugal ShahJuly 26, 2011 at 11:34 PM

    It is good role, depending upon what application you got for the support. For example Eagle Pace, Share Point kind of application DBA role are more demanding...

    ReplyDelete
  73. MikeAugust 30, 2011 at 12:30 PM

    Can a IT professional become a SQL DBA administrator without experience in DB? or its better to start as SQL Developer?

    Its C# Developer a better career than SQL DBA/Developer?

    Thanks

    ReplyDelete
  74. Jugal ShahSeptember 2, 2011 at 2:22 AM

    SQL Developer role will be a good option

    ReplyDelete
  75. Jugal ShahSeptember 2, 2011 at 2:23 AM

    You can join DBA course. SQL Server will be a good option for you. Check my site for DBA roles and responsibilities and start with that.

    ReplyDelete
  76. kiranSeptember 2, 2011 at 3:03 AM

    ok.... but will my experience will get counted for the upcoming jobs or have to join as fresher?

    think if am joining as fresher then how many years experience required in the industry for higher positions?

    ReplyDelete
  77. Jugal ShahSeptember 12, 2011 at 8:15 AM

    Nope, but if you are working in the same domain, your domain related experience will be counted.

    ReplyDelete
  78. ramuSeptember 19, 2011 at 6:30 AM

    i want to join sql dba course and i have done b.tech computer science, is it a good option to choose sql dba rather than oracle dba

    ReplyDelete
  79. Jugal ShahSeptember 20, 2011 at 12:16 AM

    yes... both the options are good...

    ReplyDelete
  80. ramuSeptember 22, 2011 at 10:22 PM

    thank you sir for giving reply to my query. plz tell at present sql dba is better or oracle dba according to market implementing technologies

    ReplyDelete
  81. Veerendra (Wipro)October 11, 2011 at 4:31 PM

    Hi Vamsi,

    How r u.How is going everything for you.
    there are 2 platforms in DBA. 1. Oracle DBA 2. SQL DBA. If you are confident to work in Comman User Interface I would suggest you to go for Oracle DBA . Moreover, Oracle DBA has good future.

    SQL DBA is windows based database administration where you can learn quickly. but keep in mind that opportunities are very rare and less for SQL DBA compared to Oracle DBA.

    ReplyDelete
  82. ramOctober 12, 2011 at 12:08 AM

    Hi...I am basically Oracle DBA...with 4 years of experience as Core DBA.... I am getting into a new project where they are telling me to learn MySQL. Pl guide what are the concepts that vary in Mysql from Oracle DBA concepts. What are the concepts that I need to update in Mysql. Pl send me the link of the concepts of Mysql(installation etc).

    ReplyDelete
  83. Jugal ShahOctober 12, 2011 at 12:29 AM

    MySQL is very easy compare to Oracle. You can learn most of the things from MySQL website only. If you face any issue, please post a comment I will reply you.

    ReplyDelete

Subscribe to: Post Comments (Atom)