DBA Roles and Responsibilities

Written by

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

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

DBA Roles and Responsibilities Types of DBA

Comments

221 responses to “DBA Roles and Responsibilities”

June 13, 2009

Jitendra

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

Regds Jitendra

Reply
1. January 7, 2010
  
  SANTOSH KUMAR
  
  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
  
  Reply
  1. January 27, 2011
    
    rajesh
    
    its good go a haed
  2. February 1, 2011
    
    Jugal Shah
    
    Thanks Rajesh
  3. July 15, 2011
    
    Navneet Vedi
    
    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..
2. August 31, 2015
  
  SUPREETH KUMAR
  
  HELLO SIR,
  
  I am working for a government project on sql dba support for 4 years but i did not explore much knowledge on DBA as the activities are very routine and not related to core DBA.So i know want to grow my knowledge on sql server dba now.So can you please suggest me how to step furthur?
  
  Reply
  1. April 19, 2016
    
    harikrishna
    
    which project
December 12, 2009

sumudu

thanx this helped for ma exam.nice !!

Reply
December 13, 2009

vamsi

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.

Reply
1. December 14, 2009
  
  JShah
  
  Yes Sure
  
  Reply
2. October 11, 2011
  
  Veerendra (Wipro)
  
  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.
  
  Reply
  1. October 10, 2012
    
    srinivas
    
    Hi Veerendra,
    well said
February 24, 2010

Subho

Hi ;It’s too good ……..

Reply
1. February 24, 2010
  
  Subho
  
  Subho :
  Hi ;It’s too good ……..
  
  i want to be a mysql dba ;can u help me to do the same …
  
  Reply
March 19, 2010

shagun gupta

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.

Reply
1. March 19, 2010
  
  JShah
  
  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.
  
  Reply
2. April 4, 2015
  
  amit
  
  this time what you do
  
  Reply
June 9, 2010

Rehan

could you please advise sqlserver2005 64 bit Recommended server configuration

Reply
1. June 29, 2010
  
  JShah
  
  You need to consider the proper processor and RAID configuration. and SQL Server level opt out for EE edition
  
  Reply
June 17, 2010

lucky vyas

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

Reply
1. June 29, 2010
  
  JShah
  
  You can do Microsoft certification for your DBA skills. During the campus interview you can ask for DBA position.
  
  Reply
June 19, 2010

priya

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.

Reply
1. June 29, 2010
  
  JShah
  
  Hi Priya,
  
  For oracle DBA you need to done the OCP and must have good hands on 8i,9i,10G,11G 🙂
  
  -Jugal Shah
  
  Reply
June 27, 2010

mushir

its help

Reply
June 28, 2010

gopinath

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?

Reply
1. June 29, 2010
  
  JShah
  
  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
  
  Reply
June 28, 2010

Shekhar

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…

Reply
June 28, 2010

Shekhar

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…

Reply
1. June 29, 2010
  
  JShah
  
  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
  
  Reply
  1. November 27, 2012
    
    reddappa
    
    sir now i am doing sql server dba course, pl tell me jobs are their
  2. November 27, 2012
    
    Jugal Shah
    
    Send me your resume once you done with the course, i will try in my circle.
  3. January 5, 2013
    
    karthik
    
    jugal sir i’m forwarding my resume .
2. February 11, 2011
  
  Naga Satish.K
  
  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
  
  Reply
June 29, 2010

Srikanth

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?

Reply
1. June 29, 2010
  
  JShah
  
  Yes. For Linux Admin, If you have good knowledge in MySQL, it will be considered as advantage.
  -Jugal Shah
  
  Reply
July 8, 2010

sunil

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.

Reply
1. July 8, 2010
  
  JShah
  
  Sunil!!! It will be good option for you.
  
  Reply
August 3, 2010

shekhar

Thanks Jugal…

I am sending a mail to u please help me…

Reply
August 11, 2010

tabitha

Hi Sir,

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

Reply
1. October 22, 2010
  
  JShah
  
  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
  
  Reply
August 14, 2010

Vinayak

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

Reply
August 14, 2010

Vinayak

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

Reply
August 18, 2010

Hareesh

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

Reply
1. September 7, 2010
  
  JShah
  
  Try for MSSQL DBA and it will be good option for you.
  
  Reply
September 5, 2010

Ajay

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

Reply
1. September 7, 2010
  
  JShah
  
  DBA would be the best option for you .
  
  Reply
October 19, 2010

Hri Kumar

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.

Reply
1. October 22, 2010
  
  JShah
  
  You can go for SQL DBA
  
  Reply
October 21, 2010

Virender Chauhan

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

Reply
1. October 22, 2010
  
  JShah
  
  I recommend to installl SQL Server 64 Bit edition.
  
  Reply
November 11, 2010

mohan

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

Reply
1. November 11, 2010
  
  JShah
  
  Work on backup/restore, SQL Server troubleshooting, performance and tuning etc
  
  Reply
November 22, 2010

Anand

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.

Reply
1. December 3, 2010
  
  JShah
  
  Both are RDBMS and best.
  
  Reply
November 22, 2010

Anand

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

Reply
1. December 3, 2010
  
  JShah
  
  Plz send me email on jugal.shah@sqldbpool.com, I will guide you.
  
  Reply
November 27, 2010

majid ali

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…

Reply
1. December 3, 2010
  
  JShah
  
  Yes Sure.
  
  Reply
January 2, 2011

2010 in review « SQLDBPOOL.COM

[…] 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 […]

Reply
January 12, 2011

riddhi

mast ans 6

Reply
1. January 12, 2011
  
  Jugal Shah
  
  Thanks!!!
  
  Reply
January 24, 2011

arvind bhujang

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…

Reply
January 27, 2011

Pavan

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

Reply
1. January 27, 2011
  
  Jugal Shah
  
  You can start your next job as PL/SQL Developer. Mean while do OCA certification. Change to oracel DBA
  
  Reply
March 11, 2011

ramesh

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

Reply
1. March 15, 2011
  
  Jugal Shah
  
  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.
  
  Reply
March 18, 2011

manoj

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

Reply
1. March 21, 2011
  
  Jugal Shah
  
  You can check out my article DBA roles and responsibilities.
  
  Reply
March 18, 2011

parag

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.

Reply
1. March 21, 2011
  
  Jugal Shah
  
  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…
  
  Reply
April 26, 2011

Balu Rajeev

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

Reply
May 28, 2011

Robin

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.

Reply
1. June 1, 2011
  
  Jugal Shah
  
  You have to start learning the SQL Server DBA responsibilities and download the DBA roles and responsibilities file from the SQL Download Page.
  
  Reply
May 30, 2011

zahid shah

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

Reply
1. June 1, 2011
  
  Jugal Shah
  
  Download the DBA roles and responsibilities documents from the SQL Dowloads page.
  
  Reply
June 1, 2011

pavan

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,

Reply
1. June 8, 2011
  
  Jugal Shah
  
  You can go for ID profile.
  
  Reply
  1. June 8, 2011
    
    Jugal Shah
    
    I mean instruction designer profile.
June 20, 2011

chandra

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

Reply
1. July 11, 2011
  
  Jugal Shah
  
  I really suggest you instead of clearing interview with the help of questions/answers, study the SQL Server architecture… read it as DBA perspective…
  
  Reply
June 23, 2011

srihari22187

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?

Reply
1. July 11, 2011
  
  Jugal Shah
  
  You can check the page How to Be DBA on my blog, and focus on each responsibility…
  
  Reply
July 25, 2011

Nethaji

Hi,

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

Regards,
Nethaji

Reply
1. July 27, 2011
  
  Jugal Shah
  
  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…
  
  Reply
August 23, 2011

kiran singh

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?

Reply
1. September 2, 2011
  
  Jugal Shah
  
  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.
  
  Reply
  1. June 6, 2012
    
    ramesh
    
    hi
    
    i need your website for knowing about dba roles
  2. June 7, 2012
    
    Jugal Shah
    
    can you enlighten your request?
2. September 2, 2011
  
  kiran
  
  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?
  
  Reply
  1. September 12, 2011
    
    Jugal Shah
    
    Nope, but if you are working in the same domain, your domain related experience will be counted.
August 30, 2011

Mike

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

Reply
1. September 2, 2011
  
  Jugal Shah
  
  SQL Developer role will be a good option
  
  Reply
September 19, 2011

ramu

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

Reply
1. September 20, 2011
  
  Jugal Shah
  
  yes… both the options are good…
  
  Reply
  1. September 23, 2011
    
    ramu
    
    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
October 12, 2011

ram

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

Reply
1. October 12, 2011
  
  Jugal Shah
  
  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.
  
  Reply
December 5, 2011

harish

is Oracle DBA is better or SQL DBA is better. Need suggestion im a fresher…….btech mech

Reply
1. December 6, 2011
  
  Jugal Shah
  
  You can’t get directly role as DBA, you have to start with the database developer and than you can go to DBA track. Both are good.
  
  Reply
December 6, 2011

Harish

will SQL DBA rocks …………

becuase i going to start my training in SQL DBA for 6 mnths…

Reply
December 25, 2011

Ramakrishna

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.

Reply
1. December 28, 2011
  
  Jugal Shah
  
  Yes, If you have passion to be DBA, Go ahead and do it. Best Of Luck!!!
  
  Reply
February 3, 2012

sonal

hello sir,
i have student bca.
i get full info. of sql server…
u with me?
thanks

Reply
February 3, 2012

KULDEEP

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.

Reply
1. February 3, 2012
  
  Jugal Shah
  
  focus on DBA roles and responsibilities mentioned on my site and start learning it.
  
  Reply
February 10, 2012

ketaki

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…

Reply
1. February 10, 2012
  
  Jugal Shah
  
  start with the PL/SQL developer role and side by side look for the DBA roles and responsibilities… that way you can be DBA.
  
  Reply
February 18, 2012

saikat

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?

Reply
February 24, 2012

sid

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

Reply
1. February 26, 2012
  
  Jugal Shah
  
  To start with the programming is the good start. I suggest you first 1 year try with the programming, next SQL Developer and last SQL DBA. It will be best for you.
  
  Reply
March 2, 2012

viren

Hello sir

Our company Need one DBA with more that 4 to 5 year Exp
so what Criteria should required for DBA

Reply
March 24, 2012

Kasirajan

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

Reply
1. March 24, 2012
  
  Jugal Shah
  
  yes it will be best.
  
  Reply
April 4, 2012

Lakshman Chand Yalavarthy

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!

Reply
1. April 11, 2012
  
  Jugal Shah
  
  You can go through DBA roles and responsibilites page on my site, try to explore on all the areas.
  
  Reply
April 7, 2012

Bharat

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

Reply
1. April 11, 2012
  
  Jugal Shah
  
  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…
  
  Reply
April 10, 2012

patan

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

Reply
1. April 11, 2012
  
  Jugal Shah
  
  Are you doing T-SQL development or writing any software code?
  
  Reply
April 17, 2012

pravin

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

Reply
1. April 18, 2012
  
  Jugal Shah
  
  Yes if you are getting any opportunity go for it. But make sure DBA handles the databases where the company lives.
  
  Reply
  1. May 17, 2012
    
    Madhusmita Dash
    
    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……….
  2. May 21, 2012
    
    Jugal Shah
    
    Check out my article steps to be DBA, there i explained the roles and responsibilities of the DBA
April 30, 2012

karthik

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

Reply
May 11, 2012

Sonveer Singh

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

Reply
1. May 21, 2012
  
  Jugal Shah
  
  Start with the SQL Developer Role… and than DBA
  
  Reply
June 4, 2012

mustafa

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.

Reply
1. June 7, 2012
  
  Jugal Shah
  
  first give the MCTS and than MCTIP
  
  Reply
June 19, 2012

Tejsingh

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

Reply
1. June 19, 2012
  
  Jugal Shah
  
  Market is good Oracle and SQL DBA. There are so many new things to learn.
  
  Reply
June 22, 2012

Sanjay Kumar Mall

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.

Reply
July 3, 2012

Sambhaji R. Patil

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.

Reply
July 6, 2012

Nandan

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

Reply
1. July 8, 2012
  
  Jugal Shah
  
  Plz check SQL DBA roles and responsibilities page on my site
  
  Reply
August 14, 2012

Patan

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

Reply
August 21, 2012

Luv kumar singh

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

Reply
September 10, 2012

Debasish

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

Reply
1. September 17, 2012
  
  Jugal Shah
  
  yes, you can with the DBA…
  
  Reply
September 27, 2012

Karthik

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

Reply
October 5, 2012

ashok

hi! please let me know what is the difference between sql server dba and sql dba…

Reply
1. October 9, 2012
  
  Jugal Shah
  
  Both are same 🙂
  
  Reply
November 3, 2012

shravan

hi sir
I’ve completed BCA ….how can job with sql….and requirnment
Plz guide me…..
thanks
shravan

Reply
1. November 6, 2012
  
  Jugal Shah
  
  I will suggest you to start part time MCA. You can try L1 SQL DBA job. Go for the SQL Server Certification and professional course.
  
  Reply
November 15, 2012

Afua

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.

Reply
1. November 16, 2012
  
  Jugal Shah
  
  Yes, You can start the career as BI Developer & T-SQL Developer
  
  Reply
December 13, 2012

sagar

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.

Reply
1. December 20, 2012
  
  Jugal Shah
  
  you can google “SQL Monitoring tool”and get the number of tools for sql server
  
  Reply
January 20, 2013

S Nair

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.

Reply
January 20, 2013

S Nair

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

Reply
January 21, 2013

Asif

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,

Reply
January 24, 2013

Nirmal

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?

Reply
February 16, 2013

Richard

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

Reply
1. February 19, 2013
  
  Jugal Shah
  
  I suggest take the degree first
  
  Reply
March 13, 2013

Richard

Sir,
Please is oracle OCA equivalent degree

Reply
1. March 19, 2013
  
  Jugal Shah
  
  No it is just certification
  
  Reply
April 4, 2013

raj

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.

Reply
1. April 10, 2013
  
  Jugal Shah
  
  Go for the Oracle certification, it will help you.
  
  Reply
June 19, 2013

vamsiswetha

hi,i am swetha searching job on mysql dba will you please help me on replication.

Reply
1. June 21, 2013
  
  Jugal Shah
  
  please post ur question will help u
  
  Reply
June 25, 2013

sameer

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

Reply
1. June 27, 2013
  
  Jugal Shah
  
  Go for PL\SQL developer
  
  Reply
October 15, 2014

shankar

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

Reply
1. October 19, 2014
  
  Jugal Shah
  
  You can start with DBA roles and responsibilities and learn advanced level from youtube videos and blogs.
  
  Reply
  1. October 21, 2014
    
    shankar
    
    Thank you much Mr.Jugal shah i follow your guideline if you can send good source link and materials to improve my skills towards DBA roles
December 1, 2014

ram

Hi Sir, I am working as a PHP developer for the last 5 years, Now I am planning to be MySql DBA. Is it my right decision to switch now? Please help me as I am worried, how will be the things there after.

Reply
1. December 3, 2014
  
  Jugal Shah
  
  Yes it is right decision, MySQL DBA market is good.
  
  Reply
January 7, 2015

Murthy

After taking professional training, how to prepare for certification for MSSQL?

Reply
January 14, 2015

praveen

Hi sir, Please give me reply for this, What are the roles and responsibilities for 1 year experience people in MS SQL Server DBA.

Reply
1. February 3, 2015
  
  Jugal Shah
  
  1 year experience DBA role fit into L1 Support. Incident Handling, First level support, installation, configuration
  
  Reply
February 19, 2015

Nitin Talwani

Hi Jugal Currently I am working on Acitve Directory Support three years experienced and am planning to go to SQL Database. however I dont have real time experience in SQL, I know the basics knowledge of SQL, Here I am very much worried whether should i go to SQL Developer or SQL DBA . Please help me to get the right choice for future.

Reply
1. February 24, 2015
  
  Jugal Shah
  
  I think SQL DBA is good option for you.
  
  Reply
March 31, 2015

Ajay

Hi Jugal, I have 2years Experience in Data Center as a Support and IT-Ops Team. Now i want to go with a perticular domain.Which is better for me. Please suggest.

Reply
1. April 23, 2015
  
  Jugal Shah
  
  Cloud and Big Data is the best option.
  
  Reply
May 3, 2015

chandani sharma

actually i am working as a application support but my work based on sql database only so what is better for me sql DBA or oracle DBA

Reply
May 15, 2015

Abhinav Gaur

Hey Jugal,
Thanks for sharing your valuable knowledge with us. Your articles are really helpful for the engineers like us who wants to start their career in SQL and I liked one the most that you always reply to the comments you get on your post. Actually I need a suggestion from you that I’ve been working as programmer for 6yrs but from the begininng for my career sql has always been my interest and have been working on Visual Basic , crystal report and sql server since then so now I want switch as sql developer or sql dba so wat would you suggest to me wat should I do? I have been doing some tasks in sql server like installations database backup scheduling, Import & Export and the most interesting for me is T-Sql ( queries , stored procedure, functions, views etc) for 4.5yrs . So what my next step should be to enter in SQL career ?

Reply
1. July 24, 2015
  
  Jugal Shah
  
  next step is SSIS/SSAS and SSRS
  
  Reply
June 18, 2015

geetha

Hi Jugal, I have 6 years experience in php and 3 years experience in sqlserver development.
Now I want to convert to sql DBA. Is this a good decision?

Reply
July 14, 2015

manohar

1. pls tell me Defference b/w Sql dba vs Oracle Dba min 3 points
2.Defference b/w Sql server vs Sql Dba
3.Can SQL Dba need to learn like DDL,DML,TCL ?

‘

Reply
1. July 24, 2015
  
  Jugal Shah
  
  1. MSSQL and Oracle both are RDBMS system. MSSQL runs on windows only whereas Oracle is platform independent. They follow the diff. architecture.
  2. both are same
  3. Yes
  
  Reply
August 15, 2015

NaveenSB

Hi jugal,

Im having experience of 3 years as a system administrator. Here in this role im even handling oracleDB servers on linux platorm. So i know things like building oracle server, taking backups and troubleshooting Db connectivity issues.

Now my question is if i change my domain to oracle DBA will my past experience will count to get a job.

Regards,
Naveen SB

Reply
1. August 17, 2015
  
  Jugal Shah
  
  Yes. It will. DBA should have also server administration knowledge.
  
  Reply
August 31, 2015

SUPREETH KUMAR

Hello sir,

I am working as a sql dba for a government project for 4 years but i have not explored much knowledge on core dba as we have routine activities and which are not related to dba.I want to grow my knowledge on sql server dba so i request you to suggest how i can proceed furthur for a successfull dba career.

Reply
1. September 16, 2015
  
  Jugal Shah
  
  start reading and practicing DBA day to day tasks
  
  Reply
September 13, 2015

manoj

which is better and having more future scope ms sql server dba or oracle dba

Reply
1. September 16, 2015
  
  Jugal Shah
  
  both but cross skill dba has good future scope
  
  Reply
September 21, 2015

Ajay

i have done my graduation B.COM and worked with telecom VAS revenue sales , now there is no feature plz suggest which course will help

Reply
September 21, 2015

manoj

but i have heard oracle is used in 81% of the companies……………..and from what should i start to be oracle dba

Reply
1. December 9, 2015
  
  Jugal Shah
  
  Most of the companies you will get the SQL/Oracle/MYSQL/Postgresql all together.
  
  Reply
October 1, 2015

siva

hi,

i was in production support for 3 years and now moving to sql developer dba
is it a right move.any one there

Reply
1. December 9, 2015
  
  Jugal Shah
  
  It is actually good move. You will get both the production support and development experience.
  
  Reply
December 18, 2015

Pritam

Hello Jugal,

Can you suggest me ,which technology is better MS SQL or ORACLE ?.
Which Technology has more jobs???
Which Technology has better onsite chances.???

Reply
December 30, 2015

Dattatray Sonavane

Hi Jugal,I am Dattatray Sonavane, working as a Windows 2003/2008 server admin for last 8 years but not finding any proper growth. So I looking for SQL DBA courses so I can switch My career to SQL DBA admin…so please help me to know course I can go for & from which Institute….Thanks

Reply
January 22, 2016

Divya

Hello sir…
Its Divya Srivastava from varanasi,
at present, i m pursuing BCA .6 sem i want to be DBA ,but i m not getting proper way and proper knowledge..kindly help me that what should i do for be dba

Reply
January 22, 2016

Divya

hello sir…
its divya srivastava
at present,i m pursuing BCA 6 sem. I want to be dba ,but i m not getting proper way and proper knowledge.Can you kindly help me,that what should i do for be dba

Reply
1. January 26, 2016
  
  Jugal Shah
  
  go through the DBA roles and responsibilities and start learning that online.
  
  Reply
January 30, 2016

Trupti

hello sir,
I have done B.E. In Computer Science. I have done course in Oracle 11g DBA. Now i am getting job as Oracle/sql support profile in insurance company. Will this experience help me to switch Oracle DBA position ?

Reply
February 21, 2016

Raj

Hi
i have 8 years It exp.currently i am into development sql dba.
can i change to production sql dba kindly advise

Reply
February 23, 2016

riaz

am confused with 2 questions.,
1, SQL DBA or MSBI DEV which one have to take…
2, How about future of SQL DBA.. there is Oracle DBA which is used more than SQL.
please suggest me..

Thanx in advance.

Reply
February 25, 2016

Server Responsibilities Resume – Job Resume Format

[…] DBA Roles and Responsibilities Resume jim . cornwell – mcse – mazzaroth, Responsibilities: maintain support microsoft nt 4.0 server tcp/ip, exchange server 5.5, iis 4.0 server web-based internet/intranet, winproxy server. […]

Reply
February 28, 2016

Server Responsibilities Resume – Job Resume Format

[…] DBA Roles and Responsibilities Wintel & windows server support profile – slideshare, Wintel & windows server support profile 1. kuldeep pathakwintel server engineermob: 962-044-0010email: komalhahi@gmail. kuldeep.pathak@accenture. […]

Reply
February 29, 2016

Akshay Bhosale

Hello Sir,
I’m Akshay From Satara, I have completed BCA in 2015 and Doing Job in Wipro as a Technical Engineer. But i Want to switch my Profile to DBA. So Which DBA Is Good for future Growth. PLZ Help

– Akshay Bhosale

Reply
March 20, 2016

Application Architecture Roles Responsibilities | Architecture Fan

[…] DBA Roles and Responsibilities – SQLDBPool – SQL Server … – 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. […]

Reply
April 13, 2016

Sathya Ravi

Hi Jugal, I am currently working as application support engineer 3 years exp. I am looking to go into a domain and chose SQL DBA. Can i chose this domain or should i continue with service desk?

Reply
1. April 15, 2016
  
  Jugal Shah
  
  SQL DBA is good compare to service desk
  
  Reply
May 31, 2016

Anil

How is the market on sql dba ?

Reply
1. July 15, 2016
  
  Jugal Shah
  
  It is good.
  
  Reply
June 9, 2016

sfiroz846

Sir,
I recently completed BE in information technology 2016
I know basic of mysql
And I recently got job as application support L1
And I want to become DBA
….As I am fresher I am so confused….plz give some paths…..

Reply
August 15, 2016

muneer

Hi Jugal,

Your articles are very helpful and easy to understand. I was very much interested in SQL DBA so I did a SQL DBA course for two months and now looking jobs for sql dba,unfortunately from 1 year I am not getting any jobs and not even internships . To be honest from the course I have got good knowledge( not 100%) but I am lacking in real time experience of how actual things will go as a DBA. I have read your previous comments you are very helpful in replying to almost every person. I would like some tips for my career like if at all I get an interview chance what should I expect at interview ? and do companies actually hire for sql dba freshers ? If they don’t, what is the next step should I take ? Please reply me.

Thanks
Muneer

Reply
September 28, 2016

Ram

Hi Sir,

I am working as a Mysql DBA. I an interested in learning Big Data Hadoop from a reputed institute. Does It have any scope and advantage for my career in future. I have knowledge of Java programming language and PHP that’s not an issue.

Should I go for it or not, please suggest ?

Reply
1. October 11, 2016
  
  Jugal Shah
  
  Thank you for your comment. Yes I would suggest to go for it.
  
  Reply
October 5, 2016

Abhay Kumar

i want to learn sql server architecture….
plz help me

Reply
1. October 11, 2016
  
  Jugal Shah
  
  Thank you for posting comment on SQLDBPool.com. I would recommend you to check the https://technet.microsoft.com/en-us/library/cc280361(v=sql.105).aspx for more information architecture.
  
  Reply
October 16, 2016

sandeep s magar

sir i want sql,mysql and ORACLE architecture and rolse and responsiblity want me sir plz releted link share me sir i am feasher sir i will work on DBA in compnay so plz help me

Reply
1. January 30, 2017
  
  Jugal Shah
  
  I would suggest to check it on the Microsoft and Oracle site as you should have the knowledge of architecture and latest feature as well. I will keep in mind to write this post
  
  Reply
November 23, 2016

sourav mishra

as i am a betech gradauate in cs branch in 2016 but i dont have a interest in coding so which course i have to opt computer networking or dbms

Reply
1. January 30, 2017
  
  Jugal Shah
  
  I would suggest try for AWS cloud and DBMS
  
  Reply
February 17, 2017

veera kiran

hi sir,
i have completed the sql dba course recently and i have attended one interview in that the interviewer asked tell me about your project. how can i explain the project. please suggest me..

Reply
September 20, 2017

Manchun Kumar

Thank you for sharing great article for Future scope of Oracle dba. I want to learn oracle dba. I was read the quora article related best online trainer, I just finding https://www.janbasktraining.com/oracle-dba-training can you suggested some other website who is offering oracle training. I want to learn SQL also, please suggest me which one is best trainer for SQL and Oracle DBA.

Reply
November 10, 2017

amar

DBA responsibilities are very well explained over here which gives a better idea about the overall work of dbas .

Reply
December 7, 2017

Ram

Hi Sir, I am working as PHP Developer, MySQL/Mongo DBA, Now I am looking for data science or analytics in Python language from analytixlabs gurgaon. I have 6+ years of experience. Please suggest should I opt for data science/analytics at this time. Though it will be tough to switch profile. Need your suggestion on this, please.

Reply
1. March 18, 2018
  
  Jugal Shah
  
  I would suggest to go for it.
  
  Reply