Submit Article

If you would like to submit an article, click the button below.

Navigation

<-- Back to Current Category

Career Track

By: Free Oracle, Aps.net, C#, Oracle Apps training, Mon Jan 2nd, 2006 01:08:03 AM

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

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

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

Average salaries (nationwide):

Entry (less than 1 year of experience): Administrator $49,000

Analyst $40,967

Junior (1-2 years of experience):

Administrator $52,289 Analyst $49,710

Emerging (3-5 years of experience):

Administrator $66,067 Analyst $56,472

Experienced (6-9 years of experience):

Administrator $76,716 Analyst $66,652

Advanced (10+ years of experience):

Administrator $91,098 Analyst $80,648

About the author: Exforsys is a community of developers specializing in C, C++, C#, Java, J2EE, .NET,

PeopleSoft, SAP, Siebel, Oracle Apps., Data warehousing, Oracle/SQL Server/DB2 and

Testing. Please visit http://www.exforsys.com for more tutorials and for IT Interview questions http://www.geekinterview.com is an

open database.

If you are an IT Geek, please visit http://www.myitblog.com, to post your blogs about

all Tech related fields.

Sign In