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 7×24 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

About these ads

161 thoughts on “DBA Roles and Responsibilities

    • 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.

  1. 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.

    • 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.

  2. 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…..

  3. 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.

  4. 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?

  5. 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…

  6. 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…

  7. 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?

  8. 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.

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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.

  14. 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

  15. 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

  16. 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.

  17. 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…

  18. Pingback: 2010 in review « SQLDBPOOL.COM

  19. 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…

  20. Hello Sir,

    Need your help – I have 3.4 Years of Exp in Mutual Fund Industry in Operations Department and my educational qualification is B:com. I have basic SQL skills & VBA and interested to change my domain into Oracle DBA. Please suggest whether I am eligible for Oracle DBA, if so do i need to start my exp in Oracle DBA as fresher or my previous experience will count?

    Regards,
    PV

    • 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.

  21. 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..

    • 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…

  22. HI
    I am a .NET developer with 3.8 year year experience in .Net an SQl. I have knoledge in Procedures, Function, and some sql features like cursor,etc. Also I created Database for one ERP project for a co-operative society which is working fine for last 12 months. Now I am working in retail application for a CMMI level 5 company and I am forced to become DBA. But still I dont know what is the roles and responsibilities of DBA.

    Can u please help me to find From where I need to start….?. Actually I am little bit tensed because of that….

    Thanks in advance
    Balu

  23. 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.

  24. 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

  25. 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,

  26. 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

  27. Hello Sir,

    I Completed My B.Tech Information Technology then i worked Web developer where i handled Mysql, then i quit that job now i am doing Windows System administration Job, here i use MSSQL server 2008 and Windows Server 2005. I want to become a SQL Server DBA. So please say How i become a sql server dba?

    • 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…

  28. Hi,

    my qualification is B.Com and have experience of 7 yrs in accounts & finance field, since 1&1/2 year am working as project controller and maintaining a software in addition i have done basics in computers. i found intresting in doing DBA. will some one suggest me, should i have to join course for DBA or no?

  29. 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

  30. 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).

  31. Hi Sir,

    I am working as system administrator. I have 2 years of experience. I want to jump into dba administrator and i am looking for a good institute to do oracle dba course. Is it a right decision?

    Please advise me.

  32. Currently i am working in wipro technologies as a PROGRESS DEVELOPER (progress 4GL). i did OCA 11g certification and i want to be a ORACLE DBA. i have no working experience in oracle only some basic training by wipro. please clarify me how can i be a DBA.

  33. hello sir,
    this is ketaki, hv done M.Tech in bioinformatics. and currentlly m preparing for oca certification…pls suggest me the proper way to be dba…

  34. Could you please mention the difference of administrative dba/oltp and warehouse/olap regarding:

    1.Roles
    2.Job opportunity
    3.Compensation

    Is there any special courses certification/courses for olap dba?

  35. hello sir,
    i am pursuing in b.tech in final sem under traning . i am just confuse in which fiel should i go …
    i like to go in database but in this the job are less …i am totaly confused. please give me sugestion wheter i should go for dba or not ..as i am not comfortable in programming.

    thanks
    sid

  36. Hi ,

    I am a .Net devloper with 4yrs experience, recently i got a offer for sql devloper in the banking domain. Can i choose with this offer , if i go how would be the scope in future. can any one suggest .net or sql or work in both will be best?.

  37. Hi,
    I have 2years experience as oracle DBA . I do want to shift for another company with the same role. Can you please tell me what will their expectations on me and how and where can i find some opportunities with my experience and qualification!

  38. Hi Jugal,
    I had 2.5 yrs of experience in Functional & DB testing as well as Production Support.During same i had gone through Shell Scripting as well so i had small knowledge on each aspect.Just before 3 months back i switch to new company joined as a Java developer cum Black Box tester but am on bench.There is an opportunity to work as SQL DBA in same company but under different account. Though the reason of my switch was to work on new technology am pretty much new to Development ,my question is can i go for DB profile ? How is the career growth prospectus in same. Please let me know for your guidance.
    Thanks

    • Yes, there is good career growth in DB development and administration. If you can try for SQL Server and Oracel experties… there are very rare people who has knowledge on both the technologies…

  39. I have 1 year exp in sql server and i changed my company now my position is jr software programmer but here my project manager said your the DBA like that … so i dont know what is the difference between developer and DBA..Please can you help me… And send details to my mail id ….

  40. i have completed b.com and now i am doing job in electronics com as a application support engineer from last 6 months and i have interested in SQL dba please give me suggestion whether i should go for dba or not ..as i am not comfortable in my own job and send detail to my mail id

      • Hi ,
        i m joining in a company as a oracle DBA and i m a fresher.I have some knowledge in oracle.So,kindly guide me how i can improve myself and what are the job responsibility for a fresher DBA.what i have to do……….

  41. i am graduate in cse in 2011 and i am thinking to start my career as DBA is it having a gud life… plz help me out with your suggestions….

  42. sir

    i am graduate in Bsc IT and 2 years deploma from niit .i am working in As a mis executive but i want to go for sql dba plz guide me how to go for sql dba profile as a fresher level….

  43. sir
    i have completed MCA in 2011 pass out .i have good knowledge on sql server dba .i am planing for certification plz tell me certification path.which exam i have to give.plz give me suggestion.

  44. Sir,
    I had completed Mca in 2010 i am working as system administrator for a company, i want to know job opening are good and more for sql dba or oracle dba which is good in opportunities and growth wise..

    please help me…

    Regards
    Tejsingh

  45. hello Sir

    I have done mca in 2010 and 1 years exp in manual testing . i have left my job from polaris.
    currently i have joined a new company as a sql developer but there are no any work so i am not learn .
    please help me how to improve my skill.

  46. I have done BA (Economics) in 2008 and 4+ years exp in Application Support Admin.
    Market is good Oracle and SQL DBA. There are so many new things to learn.
    please help me how to improve my skill.
    My Contact Num 9699514661.

  47. Hi I was working as oracle based application support and maintenance and Now I have designed a Complete architecture of POS in SQL server 2008 I just want to covert my profile as core DBA
    Please guide me

  48. Respected Sir,
    Currently am Working As a SQ L server DBA with Exp of 1 year..Am Creating Stored Procedures and Fully Working with .net Developers..I need to know what over all responsibilities for me..Please Help me out …

    Thanks & Best Regards
    Patan

  49. Respected sir,
    I completed my b.tech last year in CSE and i am still a fresher . I want to be a DBA but i am totally confused what kind of DBA i should be . Sir what is the difference between sql server dba,Mysql dba,Sql dba etc. . I know only SQL ,please suggest me sir

    THANKS;
    Luv

  50. Hai Sir,
    I’ve completed BCA and also MBA in IT (Distance course). Currently i am working in network platform.I want to do DBA. Is this helpful for me?
    Plz guide me…..
    thanks
    Debasish

  51. Hi sir

    I’ve completed B.Tech IT in the year 2009 and i m having exp of 2 years in Telecom(Hardware installation), Now i am looking to work in IT industry and I’ve knowledge in Sql server 2005. Is it possible to change the domain?….. Pls guide me…….

  52. am a student of ipmc i want to be a database developer, partaking in software engineering, i want to know after deploma can i become one my reason is that i completed jhs then after i went for my course.

  53. Hi Sir …
    this is sagar and u r video presentation is well , sir but i want to know the real time tools for monitoring, backup and query tuning.

  54. Hi Sir,

    can u suggest me any training center for mysql dba.Would be nice if they provide real time/hands on training on advance concepts.

  55. Actually after My B tech in IT I wanted to get into administration as i was not much interested in coding. did oracle DBA (10g) from a instsitue
    Got a job where i was interviewed for a oracle position but the job had 99% to do with mysql dba(i finished my oracle certification while i worked)
    I worked around 6 months as mysql dba but had to quit & had a pretty long break due to personal reasons.So now i am very much out of touch with what i learnt.
    But as you said in one of ur post,i am able to learn mysql stuff through trial and errors compared to oracle but for faster learning in advance concepts i think i need much help.

    Please guide me on what must be my next course of action.
    I have sql, basic system admin knowledge as well.
    Sorry for my long post.Thanks

  56. Hi,
    I have 4 years experience in .Net and now am in the 5th year. I want to Ask does Application DBA includes (Administrative,
    Development, Architect,Data Warehouse DBA) Because I am doing all of them, and even more roles like sometime Tech. Support and many other things.

    Regards,

  57. Sir,
    I m a B.E(ECE)2012 passout(fresher) ,for past 6 months i m doing a course in Informatica data integration tool(ETL tool),i have basic knowledge of mysql.what additional skills should i develop for getting an entry level DBA job / IT job?

  58. Sir,
    I am a high school graduate and i am taking a proffesional course in db.
    Is this a right path or i have to go college first.
    Please advice me

  59. Hi, i am ravi planning to keep a resume in job portal with 3+exp as oracle dba. recently i have learnt oracle11g dba.
    i have long gap after my graduation and i took 6 years to complete my graduation later i worked for it company in general administration. i do not have good academic record. in my +2 i have 39.5%. will all these be considered while shortlisting resume? now i am 31 yrs. is ther any possibility to get job as oracle dba. and i did MCA but i did not get certificate due to internal marks issue. kindly advice.

  60. Hi Sir,
    I am working as a PSL (Programming Scripting Language) developer for 2.5yrs which is designed by our company. I have knowledge on stored procedures.triggers,functions and index. i want to change the company but no other companies are using PSL. So i am planing to change the stream to Oracle DBA or PL/SQL developer. Can you please suggest which is the best and suits to my experience. Please email to my mail Id : ramsameer24@gmail.com

    Thanks,
    Sameer

  61. Hi Sir ,I am Shankar ,now i am working as a software product support engineer we use sql server 2005.2008.20012 installation configuration and backup recovery process works we do, our company is very small and which having only one product hotel management software system specific application(not an online based) now i am decided move my Career SQL DBA
    Please help me towards this how i can improve DBA skills ..

Thanks for the comment, will get back to you soon... Jugal Shah

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s