x

Sql server Role

Hi , I am working as a .Net Programmer and also work with SQL Developer, Now i m interested to move to Core Sql Server development area, so I need some clarifications. Can any one tell me ,What are Sql develope role and Sql DBA Role ( What I am expect is , what topics covered to sql developer and what are DBA )
more ▼

asked Aug 30 '10 at 01:07 AM in Default

Jaleel gravatar image

Jaleel
11 4 4 5

(comments are locked)
10|1200 characters needed characters left

4 answers: sort voted first

Jaleel, as always "It Depends".

If you are lucky enough to work for a company with clear roles, where a database developer only does work on the database engine and no GUI work, then you could take the following points:

A SQL Developer would be responsible for the physical database design. They would normally receive a requirement spec and translate this to a database model. This includes table structure (tables, columns, indexes), data access objects (view, stored procedures, functions) and permissions as per requirements (database/application roles and permission assignments). A SQL Dev. that solely works on these objects would liase with the .NET programmer and provide the data access objects to allow the .NET dev to build the application that would interact with the database. The advantage being, a SQL Dev. would learn his craft in more detail and use methods that are not necessarily known to the hybrid .NET/SQL Developer.

A SQL DBA would be responsible for the database engine itself. They are responsible for making sure that the database server is kept in order - backups are made of databases, backups are tested, patches are reviewed and installed, system resources are plentiful (CPU, RAM, Hard disk etc), the database system is performing well (monitoring resources and queries). They would also be directly involved with the SQL Developer, helping with design decisions. Quite often the DBA would be called in at the beginning of a project to help highlight possible pitfalls/new technologies that could be used.

Ideally, the DBA would have developer experience, to understand how the two roles work. This can sometimes include a third role - Development DBA. This DBA would also take a larger part of the SQL Dev. work. They may be responsible for the architectural decisions (table design etc.) which are then passed to the SQL Devs to be programmed.

I hope this helps you understand the differences a little better.

more ▼

answered Aug 30 '10 at 02:14 AM

WilliamD gravatar image

WilliamD
25.8k 17 19 41

Thanks WilliamD!

   Ur answer cleared my doubt... but it with some questions!

Mirroring,clustering,replication,log shipping,SSIS , SSRS,SSAS and like these works under by DBA Or Developer

Thanks in advance,
Aug 30 '10 at 03:47 AM Jaleel

Mirroring, Clustering, Replication and Logshipping are DBA features.

SSIS, SSRS, SSAS are more developer oriented, as they are solution features as opposed to back-end.
Aug 30 '10 at 03:50 AM WilliamD
Fantastic answer. Of course, that really only applies to companies that have clear divisions between those roles in many places (all I have experienced personally) the divisions are much more murky.
Aug 30 '10 at 01:11 PM TimothyAWiseman
@TimothyAWiseman - too true, the roles are generally rather fuzzy. I am lucky at my current company. They understand the advantages of this approach and have a pretty good setup. This is around about the 3rd year, and someday soon we hope to get permanent testers too :o)
Aug 30 '10 at 01:24 PM WilliamD
(comments are locked)
10|1200 characters needed characters left

You might want to check similar questions discussed here and here and also [this][3] article from simple-talk website about development DBA.

[3]: http://www.simple-talk.com/sql/database-administration/what-use-is-a-development-dba/
more ▼

answered Aug 30 '10 at 06:49 AM

DaniSQL gravatar image

DaniSQL
4.9k 33 35 39

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x32
x31

asked: Aug 30 '10 at 01:07 AM

Seen: 875 times

Last Updated: Aug 30 '10 at 04:01 AM