Exforsys

Career Tracks

  1. Responsibilities of an Office Manager
  2. Role of a Copywriter
  3. Career Counselor Responsibilities
  4. The Role of a Commercial Artist
  5. Computer Manager Career Responsibilities
  6. Claims Manager Career Responsibilities
  7. Duties of a Business Analyst
  8. Duties of a Banker
  9. The Role of a Construction Manager
  10. Duties of a Construction Engineer
  11. The Role of a Computer Operator
  12. Duties of a Computer Engineer
  13. The Role of a Computer Programmer
  14. Responsibilities and Duties of a Civil Engineer
  15. The Role of a Chiropractor
  16. The Important Role of a Chemist
  17. The Duties and Responsibilities of a Chemical Engineer
  18. Responsibilities and Specific Duties of a Chef
  19. The Role of a Biologist
  20. The Role and Responsibilities of an Actuary
  21. The Role of a Family Counselor
  22. The Duties and Responsibilities of a Baker
  23. The Duties and Responsibilities of a Building Contractor
  24. The Role of an Agent
  25. The Role of a Property Manager
  26. The Duties and Responsibilities of a Park Ranger
  27. The Role of a Lawyer
  28. Duties and Responsibilities of Air Traffic Controllers
  29. The Role of a Broadcaster
  30. Duties and Responsibilities Related to Being a Retail Store Manager
  31. Career Track: Computer Software Engineers
  32. The Role of a Principal
  33. Career Track: Quality Assurance (Testing)
  34. The General Responsibilities and Duties of an Interior Decorator
  35. Career Track: Computer Programmer
  36. General Responsibilities and Specific Duties of a Preschool Teacher
  37. Career Track: Network Engineer
  38. General Information Regarding the Occupation of an Auditor
  39. Career Track : Network Architect
  40. The Important Duties and Responsibilities of an Agricultural Scientist
  41. Career Track: SQL Server Database Administrator
  42. Career Track: Application Developer
  43. Career Track : Database Administrator Oracle
  44. Career Track: Database Administrator

Ads


Home arrow Career Training arrow Career Tracks

Career Track: SQL Server Database Administrator

Author : Exforsys Inc.     Published on: 30th Jun 2005

SQL Server Database Administrator Roles and Responsibilities :

While Oracle DBA's seem to be the hot property these days, SQL Server Database Administrators are moving into the spotlight as well. As a matter of fact, industry experts suggest that the changes made by Microsoft to its SQL server version 7 seriously impact the responsibilities of a database administrator. While many suggest that there are actually two types of SQL DBA's (development and production) the responsiblities do not differ much from a regular DBA.

Ads

On the development side, a DBA is responsible for designing and implementing databases and applications often including front-end development or GUI. (This denotes a requirement for Visual Basic and/or C++.) As an SQL development DBA, however, candidates will also manage security, indexing and stored procedure design. Most companies, however, do not presently separate development and production at the DBA level.

Educational Requirements :

In addition to the requirements of a DBA, all SQL Database Administrators will be expected to have a strong background in Windows NT or Windows 2000 and will be required to perform Windows administration as well. Knowledge of networking is also required. Familiarity with Microsoft technologies is an important factor for potential SQL Server DBA's. All phases of database development including analysis, design, construction, implementation, and maintenance and support are valuable skills.

Experience in all phases of the database development life cycle (analysis, design, construction, implementation, maintenance, and support) will make you a much more valuable candidate, as well. MCDBA certification would definetly be a plus for this position. Other knowledge includes :

  • Microsoft Visual Studio
  • TCP/IP Network Protocol
  • Windows 2000 Server
  • Microsoft IIS
  • Microsoft MTS
  • HTML, XML, Java
  • Microsoft Exchange
  • Crystal Reports
  • ERWIN
  • VISIO

Ads

Salary Potential :

(As reported by the U.S. Dept. of Labor)

Average salaries (nationwide):
Administrator
Analyst
Entry (less than 1 year of experience):
$49,000
$40,967
Junior (1-2 years of experience):
$52,289
$49,710
Emerging (3-5 years of experience):
$66,067
$56,472
Experienced (6-9 years of experience):
$76,716
$66,652
Advanced (10+ years of experience):
$91,098
$80,648





 
This tutorial is part of a Career Tracks tutorial series. Read it from the beginning and learn yourself.

Career Tracks

  1. Responsibilities of an Office Manager
  2. Role of a Copywriter
  3. Career Counselor Responsibilities
  4. The Role of a Commercial Artist
  5. Computer Manager Career Responsibilities
  6. Claims Manager Career Responsibilities
  7. Duties of a Business Analyst
  8. Duties of a Banker
  9. The Role of a Construction Manager
  10. Duties of a Construction Engineer
  11. The Role of a Computer Operator
  12. Duties of a Computer Engineer
  13. The Role of a Computer Programmer
  14. Responsibilities and Duties of a Civil Engineer
  15. The Role of a Chiropractor
  16. The Important Role of a Chemist
  17. The Duties and Responsibilities of a Chemical Engineer
  18. Responsibilities and Specific Duties of a Chef
  19. The Role of a Biologist
  20. The Role and Responsibilities of an Actuary
  21. The Role of a Family Counselor
  22. The Duties and Responsibilities of a Baker
  23. The Duties and Responsibilities of a Building Contractor
  24. The Role of an Agent
  25. The Role of a Property Manager
  26. The Duties and Responsibilities of a Park Ranger
  27. The Role of a Lawyer
  28. Duties and Responsibilities of Air Traffic Controllers
  29. The Role of a Broadcaster
  30. Duties and Responsibilities Related to Being a Retail Store Manager
  31. Career Track: Computer Software Engineers
  32. The Role of a Principal
  33. Career Track: Quality Assurance (Testing)
  34. The General Responsibilities and Duties of an Interior Decorator
  35. Career Track: Computer Programmer
  36. General Responsibilities and Specific Duties of a Preschool Teacher
  37. Career Track: Network Engineer
  38. General Information Regarding the Occupation of an Auditor
  39. Career Track : Network Architect
  40. The Important Duties and Responsibilities of an Agricultural Scientist
  41. Career Track: SQL Server Database Administrator
  42. Career Track: Application Developer
  43. Career Track : Database Administrator Oracle
  44. Career Track: Database Administrator
 

Comments