Subscribe

SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
DBA - Database Architect - Data Architect - What’s the difference ?

18 March,2013 by Jack Vamvas

DBA , Database Architect, Data Architect : I was asked to differentiate between these three job functions.

1) The different job functions are : Part of the same workflow, but serve different functions.

 2) A Data Architect looks at the wider use of data , independent of RDBMS.

A Database Architect focuses performance,optimisation, capacity planning, data storage techniques and so forth (more details below)

DBA works with the Database Architect to develop the relevant knowledge in being able to support the database systems.

3) How the skills are implemented depends on the organisation. In large organisations it is not unusual to see all three jobs represented by different people. Other organisations integrate all three skillsets into onto one job.

4) It depends on a number of factors such as skill level of staff  and service agreements .

 Some sample skills to differentiate Data Architect versus Database Architect

Database Architect

Database Engine in-depth

Database Design and Usage Patterns – OLTP ,DSS

Database Optimization Techniques such as Partitioned Tables, Queues,sql programming, Exceution Plans, Data File management to support different usage ,full range of Backup and Restore  strategies, Indexes, XML optimization

Performance Tuning – Strategies for improved performance

Disaster Recovery and High Availability -  Techniques such as Linux Clustering,Tivoli Storage Automation,HADR, SAN Replication,Database Mirroring planning on SQL server 2005

Security Architecture

Capacity Planning

Data Storage Techniques. Defining database server IO profiles  and mapping to storage methods such as DAS, SAN, SSD, RAID levels ,PCIe attached .

 

Data Architect

Database Design – Structured methods for design

Data Architecture – Conceptual Model methods

Data Analysis

Data Migration Tools

Data Modeling – Enterprise Data Modeling with an emphasis on transactional enterprise data models meeting normalization rules

Data Integration -  disparate source systems and disparate data formats.

Read More

SQL Server DBA Top 10 automation tasks

DBA and the end of time management

SQL Server – DBA productivity and less is more



Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer