Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Definition of a Database Architect Expand / Collapse
Author
Message
Posted Sunday, July 20, 2014 12:55 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 8:12 AM
Points: 2,728, Visits: 1,118
Been a loooong time since I last came here, seems like forever and yet remarkably familiar.

Anyways, really got my curiosity peaked at the moment, spend a lot of time on LinkedIN as you do, continually amazed about how many Database Architect are actually out there.

I am confused how you can work as a DBA and then suddenly by magic your next role is a database architect. So i thought I would check the definition of a Database Architect via good old wiki.

A data architect, as defined within Wikipedia, is a person “responsible for ensuring that the data assets of an organization are supported by an architecture supporting the organization in achieving its strategic goals. The architecture should cover databases, data integration and the means to get to the data.

So I don't understand, what is the difference between a DBA and Architect apart from a Architect tends to be considered a more senior role with more money.

Does the Architect handle the design only, or the design and implementation of architecture that encompasses the support of the data assets of an organisation.

Should any DBA who understands architecture and how it fits into supporting the company data, consider themselves a database architect, or am I missing something fundamental here such as certifications for Architects.

Comments and opinions welcome, as I don't really understand the difference.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #1594412
Posted Tuesday, July 22, 2014 1:29 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 8:12 AM
Points: 2,728, Visits: 1,118
No replies after 2 days, 66 views and no opinions, guess this place isn't what it used to be.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #1594947
Posted Tuesday, July 22, 2014 2:08 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 4:32 AM
Points: 741, Visits: 1,306
It more likely the designation you get from a given company then a role basically. if you are working in a organization especially IT related company, they are tends to have difference job designation for front end and back end team. So mostly what i have seen people promoted from DBA to architect. I know its a very common mistake but it happening.
Post #1594954
Posted Tuesday, July 22, 2014 2:10 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:00 PM
Points: 1,932, Visits: 5,035
Silverfox (7/20/2014)
So I don't understand, what is the difference between a DBA and Architect apart from a Architect tends to be considered a more senior role with more money.



Quick thought, the main difference would be the operational aspect of the DBA, something that does not apply to the Architect. Normally one would assume that all Architects are qualified as DBA but not vice versa.
Post #1594955
Posted Tuesday, July 22, 2014 2:19 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 8:12 AM
Points: 2,728, Visits: 1,118
I still don't understand how one person can work as a DBA for one company and then in next role at another company be a architect, it is the difference in skills or experience that I am after.

How do you transition from DBA to Architect, or to put it another way, if I said that I was a database architect at a position, how would someone be able to tell if that is true, what form of questions/experience would back that up.

For all I know, I could have been able to call myself a database Architect for years now, only reason I haven't is because I have not understood the difference in roles.


--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #1594958
Posted Tuesday, July 22, 2014 3:20 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 4:32 AM
Points: 741, Visits: 1,306
Silverfox (7/22/2014)
I still don't understand how one person can work as a DBA for one company and then in next role at another company be a architect, it is the difference in skills or experience that I am after.

How do you transition from DBA to Architect, or to put it another way, if I said that I was a database architect at a position, how would someone be able to tell if that is true, what form of questions/experience would back that up.

For all I know, I could have been able to call myself a database Architect for years now, only reason I haven't is because I have not understood the difference in roles.


you are not the only one here who cannot understand the logic but like it or not these anomalies are gonna stay here for a very long time.
Post #1594977
Posted Wednesday, July 23, 2014 5:55 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 3:22 PM
Points: 552, Visits: 1,615
The distinction doesn't make a lot of sense to me either.

My impression is that a DBA would be skilled in installation, backup/restore, security configuration and other Administrative functions, but not necessary how to build a database from scratch.

An Architect would seem to be someone who could design data schemas and a Developer would create stored procedures, triggers etc.

But from what I've seen, performance tuning seems to be a DBA function, but effective performance tuning would require a lot of knowledge on how queries work and development skills.

So a representation on what Database Administrators, Architects, Developers and Engineers do would seem to require a Venn Diagram with lots of overlap.
Post #1595768
Posted Wednesday, July 23, 2014 6:10 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:45 PM
Points: 6,252, Visits: 7,423
An older article of mine, but it may help.

http://www.sqlservercentral.com/articles/Career/71608/

That said, it's in the perceptions of the bestower to decide if a title is worth it for a person. Said person may not have enough knowledge to know it's undeserved, but it's still there... and no person is going to turn it down simply because of the impression it's given you (and others).

I've also seen architect more recently expanded as a title towards the warehouse architects, which does require a decent amount of training and knowledge to do well.



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1595770
Posted Wednesday, July 23, 2014 7:10 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 21,724, Visits: 15,409
In most cases it is the company that decides on the title they want to call their personnel.

DBAs should be architecting solutions on a constant basis imho.

I have also found that many architects (by title) don't know any better about database design, or data access than a good senior dba would know. I don't consider an architect to be more senior.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1595773
Posted Thursday, July 24, 2014 1:30 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 7:13 PM
Points: 120, Visits: 851
Silverfox (7/22/2014)
I still don't understand how one person can work as a DBA for one company and then in next role at another company be a architect, it is the difference in skills or experience that I am after.

How do you transition from DBA to Architect, or to put it another way, if I said that I was a database architect at a position, how would someone be able to tell if that is true, what form of questions/experience would back that up.


I may not have the depth and breadth of some people in the forum... I don't have gray hair yet , but I've always considered "architects" people with gray hair :) ( "silverfox") sounds like a name that has some ? :)




--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully
Post #1595800
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse