SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Definition of a Database Architect


Definition of a Database Architect

Author
Message
Silverfox
Silverfox
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3554 Visits: 1161
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
Silverfox
Silverfox
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3554 Visits: 1161
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
twin.devil
twin.devil
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2413 Visits: 2675
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.
Eirikur Eiriksson
Eirikur Eiriksson
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15400 Visits: 18614
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.
Cool
Silverfox
Silverfox
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3554 Visits: 1161
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
twin.devil
twin.devil
SSCrazy
SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)SSCrazy (2.4K reputation)

Group: General Forum Members
Points: 2413 Visits: 2675
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.
dan-572483
dan-572483
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1347 Visits: 1999
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.
Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)SSCrazy Eights (8.7K reputation)

Group: General Forum Members
Points: 8683 Visits: 7660
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
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32972 Visits: 18560
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

sqlsurfing
sqlsurfing
Old Hand
Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)Old Hand (392 reputation)

Group: General Forum Members
Points: 392 Visits: 1185
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 Smile ( "silverfox") sounds like a name that has some ? Smile

--------------------------------------------------
...0.05 points per day since registration... slowly crawl up to 1 pt per day hopefully :-D
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search