SQLAuthority News – SQL SERVER Database Administrator Job Description

I have previously written article about SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer. I have received quite a lot of request to update it or post something similar. Writing SQL Articles are easier then writing Job description for DBA. I have read many job description and job posting at Best SQL Jobs and found following job description.

DBA Job Description

The Data Base Administrator (DBA) is responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the company. It is extremely important to the company that on-line processing database systems offer the highest reliability and performance possible. The DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives. Trains and develops technical support and applications staff to better utilize on-line processing databases environment. Provides and designs tools to assist in the management of the database and transaction processing environment.Works to provide a working model of our transaction processing environment for capacity assessment and planning.

Develops a methodology for the ongoing assessment of database performance and the identification of problem areas. Develops a security scheme for the database environment, as well as assisting in disaster recovery if necessary. Provides leadership during the development and enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of applications. Work with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments. Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process. Work with vendors in evaluating and implementing new technologies.

Required Experience

  • BE or BS Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred
  • 2 -3 years IT operation with strong understanding of database structures, theories, principles, and practices
  • 3-5 years Microsoft SQL Server experience
  • Understanding of, and experience with, server-client computing and relational database environments
  • Experience with data management and data processing flowcharting techniques
  • Knowledge of reporting and query tools and practices
  • Good understanding of the organizations goals and objectives
  • Good interpersonal, written, and oral communication skills
  • Technical documentation skills
  • Ability to present ideas in user-friendly language
  • Self motivated and directed, with keen attention to detail
  • Able to prioritize and execute tasks in a high-pressure environment
  • Experience working in a team-oriented, collaborative environment
  • Good written and oral communication skills

Required Skills

  • SQL Server 2005
  • Database Administration
  • Database Tuning
  • Database Management
  • Database Security
  • RDBMS
  • Bachelor’s Degree

Reference : Pinal Dave (https://blog.sqlauthority.com)

Database, DBA, Software Development
Previous Post
SQL SERVER – Ideal TempDB FileGrowth Value
Next Post
SQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks

Related Posts

9 Comments. Leave new

  • Hi Pinal,

    Nice post on DBA job description. Could you also provide a career path for DBA? I have seen that most of the time people think about PM or managerial role in IT. So what is your opinion about this. Is DBA a good career option?

    Harsh Shah

    Reply
  • hi pinal

    actually m mca & have software testing exp. & now m thinking to jump in dba job so what would i’ve to do for it.plz tell me

    Reply
  • Majeed Jaffer
    June 14, 2008 9:35 am

    Hi Pinal,

    Nice post on DBA job description. Could you also provide a career path for DBA? I have seen that most of the time people think about PM or managerial role in IT. So what is your opinion about this. Is DBA a good career option?

    Majeed Jaffer

    Reply
  • hi…m doin mca….n m thinkin of makin career in dba coz it seems intrsting…..bt m totally confused as i dnt hv enough knowledge about it…can ne 1 tel me wat r d certifications require for it,wat is its scope in the future ???IS IT A GOOD CAREER OPTION as compared to the odr IT jobs…

    Reply
    • Just forget if you haven’t already. One of the prerequisites is needing to speak English and write properly, not in some weird abbreviated text speak.

      Reply
  • I want to information about the sql server dba. I know sql server meaning, but dba meaning database administration, what kind of dba. how many type are dba. can you explain to me.

    Reply
  • Hi this is pooja,i have the exp in s/w develpoment .but i wanna to mke my career as a DBA.Can u tell me dat will it be good for m y carrer or i should still run my carrer in development.

    Reply
  • Hi Pinal Sir,
    I have more then 5 years of IT experience with strong understanding of database structures, theories, principles, and practices.
    I want to become Database Administrator in future that’s why Now I am looking for my first SQL developer job. I am reading SQL Server books and practicing for developing my skills.
    but i am not getting right job oppourtunity for this profile. Please guide me, what should be my approach to get first SQL developer job. And please also share your story of getting your first DBA job. it will be helpful for me.

    Thanks

    Reply
  • Ravindra Sardesai
    June 25, 2016 10:29 am

    I am in IT from last 25 years I have worked more on vb6 with sql server and Crystal Reports. I also worked on VB.net. My Designation is Project Manager since last 6 years, but I have not worked as project Manager. I am planning to work on SQL Server related job profile. which profile will suite me o I have to do something to make myself match for any profile. Thanks

    Reply

Leave a Reply