SQL SERVER – DBA Types (Logical DBA Vs Physical DBA)

Days ago I was talking with some colleagues about the existing DBA types, so we were discussing about Logical DBA and Physical DBA. Hence I am going to show some DBA types according two authors.

According to Craig S. Mullins (Book: Database Administration: The Complete Guide to Practices and Procedures) (
http://www.CraigSMullins.com), (http://media.techtarget.com/digitalguide/images/Misc/DBA_types.pdf)

There are DBAs who focus on logical design and DBAs who focus on physical design;
DBAs who specialize in building systems and DBAs who specialize in maintaining and
tuning systems; specialty DBAs and general-purpose DBAs.

System DBA: A system DBA focuses on technical rather than business issues, primarily in the system administration area. Typical tasks center on the physical installation and performance of the DBMS software. System DBAs are rarely involved with actual implementation of databases and applications. They might get involved in application tuning when operating system parameters or complex DBMS parameters need to be altered.

Database Architect: The database architect is involved in new design and development work only; he is not involved in maintenance, administration, or tuning of established databases and applications. The database architect designs new databases for new or existing applications. The rationale for creating a separate position is that the skills required for designing new databases are different from the skills required to keep an existing database implementation up and running. A database architect is more likely than a general purpose DBA to have data administration and modeling expertise.

Database Analyst: Sometimes junior DBAs are referred to as database analysts. Sometimes a database analyst performs a role similar to that of the database architect. Sometimes the data administrator is referred to as the database analyst or perhaps as the data analyst. And sometimes a database analyst is just another term used by some companies instead of database administrator.

Data Modeler: A data modeler is usually responsible for a subset of the DA’s responsibilities.

Application DBA: In direct contrast to the system DBA is the application DBA. The application DBA focuses on database design and the ongoing support and administration of databases for a specific application or applications. The application DBA is likely to be an expert at writing and debugging complex SQL and understands the best ways to incorporate database requests into application programs. The application DBA must also be capable of performing database change management, performance tuning, and most of the other roles of the DBA.

Performance Analyst: Performance analysts are a specific type of task-oriented DBA. The performance analyst, more common than other task-oriented DBAs, focuses solely on the performance of database applications.

Data Warehouse Administrator: Organizations that implement data warehouses for performing in-depth data analysis often staff DBAs specifically to monitor and support the data warehouse environment. Data warehouse administrators must be capable DBAs, but with a thorough understanding of the differences between a database that supports OLTP and a data warehouse.

According to Brad McGhee. He defines the following classification for DBA:

  • DBA System Administrator
  • DBA Database Designer
  • DBA Developer
  • DBA High Availability Specialist
  • DBA Business Intelligence Specialist
  • DBA Report Writer

For details of each type, please check the ebook. (Book: How to become an exceptional DBA)

As we can see, both authors have the same idea, in the following table I put the DBA classification for each author and the equivalent between each other. From my point of view I did a classification of DBA Logical or Physical as well.





Conclusion.

The Logical DBA is the person in charge of developing, design, debugging, etc, the Logical stuff for the database and the Physical DBA is the person in charge of the configuration, maintenance, physical design, etc. From my perspective exist some DBA types that is necessary to perform both activities Logical and Physical.

48 comentarios:

Anónimo dijo...

Thanks for great information you write it very clean. I am very lucky to get this tips from you


You can also visit my page its valuable: Oracle managed service

Anónimo dijo...

Thanks for your comments :),
Regards,
Victor.

sqlservermasters dijo...

Resources like the one you mentioned here will be very useful to me! I will post a link to this page on my blog. I am sure my visitors will find that very useful.
I can see that you are are genuinely passionate about this! I am trying to build my own website and youve helped me with some great information.
http://www.sqlservermasters.com/

Anónimo dijo...

Hey very nice blog!!
Hi there,I enjoy reading through your article post, I wanted to write a little comment to support you and wish you a good continuationAll the best for all your blogging efforts.
Appreciate the recommendation! Let me try it out.
Keep working ,great job!
http://www.mindqonline.com/

sqlservermasters dijo...

My partner and i actually enjoy this post and the internet site all in all! Your piece of writing is really plainly composed as well as simply understandable. Your current Blog design is awesome as well! Would be awesome to know where I are able obtain it. Please maintain up the very good job. We all require far more such website owners like you on the net and much fewer spammers. Fantastic mate!
http://sqlservermasters.com/

best gadget reviews dijo...

Thanks, what a good post and informative blog.

magnifictraining dijo...

Resources like the one you mentioned here will be very useful to me! I will post a link to this page on my blog. I am sure my visitors will find that very useful.
Hadoop training

rehan dijo...

thanks buddy...nice article....really found useful....keep posting like this other topics also....

Pradeep Reddy dijo...

Very nice useful article thank you for sharing this information. Know more about Oracle DBA Training

Informatica Training dijo...

useful informative we have to sharing

Informatica Online Training

Đẩu Anh dijo...

Công ty nhận nhập khẩu hàng từ hàn quốc về việt nam chi phí thấp
Đơn vị chuyên lấy hàng từ hàn quốc về việt nam giá thấp
Đơn vị nhận order phụ kiện quảng châu giá rẻ

Abdur Rahim dijo...

Thanks for the excellent information and facts, this was a very good piece of writing.

Microsoft Server 2016 Installation
Server 2016

Sirisha Rao dijo...

nice post
SQL Server DBA Online Training india

Sirisha Rao dijo...

nice blog
SQL Server DBA Online Training

SINDUJA SINDHU dijo...

thank you for sharing.it is a nice information
SQL Server DBA Online Training

SINDUJA SINDHU dijo...

thank you for sharing
SQL Server DBA Online Training

Priya angel dijo...

1it's a Nice blog, very helpful for usSql Server dba online training

Sneha rathod dijo...

very useful article thank you for sharing Sql Server dba Online Training Bangalore

Zeniya Nurbanu dijo...


Nice post, This is really great and informative post..

Office 365 migration
Office 365 setup

Sneha rathod dijo...

Really Good blog thank you keep updating Sql Server dba Online Training

Priya angel dijo...

Nice Blog Thank You For Sharing Sql Server dba Online Training
Hyderabad

Priya angel dijo...

Nice blog it is very useful thank you for sharing Sql Server dba Online Training hyderabad

Anónimo dijo...

Wow! That's really great information guys.I know lot of new things here. Really great contribution.Thank you ...


Oracle Weblogic Server Training

Unknown dijo...


It is very good blog and useful for students and developer ,

Sql server DBA Online Training Banaglore

Peter Johnson dijo...

I Just Love to read Your Articles Because they are very easy to understand.Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Restaurant Equipment Parts Through Out US At Very Affordable Prices And Also We Offer Same Day Shipping In US.We Offer Only Genuine Products.Thanks For Posting.HAve a Nice Day!

alltop dijo...


Hi Your Blog is very nice!!

Get All Top Interview Questions and answers PHP, Magento, laravel,Java, Dot Net, Database, Sql, Mysql, Oracle, Angularjs, Vue Js, Express js, React Js,
Hadoop, Apache spark, Apache Scala, Tensorflow.

Mysql Interview Questions for Experienced
php interview questions for freshers
php interview questions for experienced
python interview questions for freshers
tally interview questions and answers



mounika dijo...

It 's an amazing article and useful for developers
Sql server DBA Online Training

Lathika Honey dijo...

Thankful for the Informative Post The Best article, Bala Guntipalli

seo dijo...

Whatever We Are Gathering the information from the blogs,we have to keep on updating it,Chicago Immediate care in Chicago.By getting them into one place.Really thanks for posting.Very Thankful for the Informative Post.Really Thanks For Posting Such an Informative Content.

Unknown dijo...

Thanks for sharing this post. Your post is really very helpful its students.
SQL server dba Online Training

calfre143 cal dijo...

Nice blog thank you so much
SQL DBA Training in Hyderabad

Unknown dijo...

It's so nice article thank you for sharing a valuable content. SQL server dba Online Training Bangalore

Lathika Honey dijo...

This Blog Provides Very Useful and great Information. United States Medical Licensing Examination Thanks for sharing.

meena resma dijo...

Thanks for sharing this post. Your post is really very helpful its students.
SQL server dba Online Training Hyderabad

calfre143 cal dijo...

A very useful blog, Thank you so much. For more info:
SQL DBA Training in Hyderabad

meena resma dijo...

Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on. SQL server dba Online Training

srcalfre009 dijo...

good information provided in the blog thanks for sharing for more visit SQL DBA Training in Texas

srcalfre009 dijo...
Este comentario ha sido eliminado por el autor.
calfre143 cal dijo...

Thanks for sharing this informative blog post. Nice video. easy to understandable, really helpful for learning. For more info:
Linux Administration Training in Hyderabad

calfre cal dijo...

thank you for sharing useful information. visit us at
SQL DBA Training in Austin

narayana p dijo...

Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog on. SQL server dba Online Training

Raj Kumar dijo...

Fantastic Article ! Thanks for sharing this Lovely Post !!

Oracle DBA Training
Sybase DBA Training
Mysql DBA Training

harikasri.blogspot.com dijo...

technically your blog is very useful oracle online training

Ananth Academy dijo...

nice post..ms office training in chennai
ms office training institute in chennai
ms sql server training in chennai
best sql server training institute
mysql dba training institute
mysql dba training in chennai
java training in chennai
best java training institute in chennai

Ananth Academy dijo...

nice post..advanced .net training in chennai
advanced dot net training in chennai
ms office training in chennai
ms office training institute in chennai
ms sql server training in chennai
best sql server training institute
mysql dba training institute
mysql dba training in chennai
java training in chennai
best java training institute in chennai

Sukana Murtaja dijo...


We take the frustration out of parking management for Apartments, Home Owners Associations, Condominiums, Townhouses Co-ops, and other parking areas.Webparkingsoftware.com has reinvented how parking management should be done.

Parking Management Software
online parking software
Cloud based parking solutions

Sadhana Rathore dijo...

Excellent post. I learned a lot from this blog and I suggest my friends to visit your blog to learn new concept about technology.
Blue Prism Training in Chennai
Blue Prism Training Institute in Chennai
UiPath Training in Chennai
Robotics Process Automation Training in Chennai
RPA Training in Chennai
Data Science Course in Chennai
Blue Prism Training in OMR
Blue Prism Training in Porur

Parking Software dijo...


Parking Management Software
online parking software
Cloud based parking solutions
New Parking Software for Condominiums and Apartments:
WEBPARKINGSOFTWARE.COM has a new product on the internet nowadays that can provide maximum satisfaction to all businessmen and vehicle owners who want to find the perfect parking area for their vehicles in a very convenient way especially while in the city. This powerful parking software is something that vehicle owners and businessmen can use in condominiums, apartments and other business establishments that were designed to accommodate several consumers or clients every day. It’s already available in the official website of the online company that has been stated.
The software can be used by vehicle owners for free for a limited period of time only. It has been reinvented by the company to show to the world the most systematic and effective way of organizing and managing all parking areas that are available in licensed condominiums and apartments all over the country nowadays. People can easily use it with the use of their smart phones. Therefore, it was designed to make the process of providing a vehicle with an excellent parking area in outdoor places more convenient and much easier to accomplish. This product can help businessmen to experience all benefits that an excellent parking management method can provide.
The new parking software for condominiums and apartments at WEBPARKINGSOFTWARE.COM will be very useful in the daily business operations of all businessmen who want to make sure that the parking areas in their business establishments will be managed perfectly every day even if their time for their additional tasks and relaxation is very limited. The product comes with a set of innovative features that can make parking management more convenient and full of satisfying results for all businessmen every day. This software can also assist a vehicle owner in securing an excellent parking area for a vehicle in one of the most popular condominiums or apartments in the country.
The product is equipped with an advanced parking management system that’s highly compatible for all types of building sizes that can be found in the different parts of the country nowadays. It provides professional parking permit to all vehicle owners who will never hesitate to use it regularly. In addition to that, this software has an amazing ability to assign parking spaces for tenants. This software possesses everything that can make parking management more enjoyable and free from stressful moments every day. One of the things that people will surely appreciate in the design of this product is its amazing ability to detect ticket violators.
The new parking software of WEBPARKINGSOFTWARE.COM will always be an excellent choice for all businessmen and vehicle owners who can’t afford to be victimized by the negative effects of stress and misunderstandings while aiming to have a better understanding of the idea of parking management. The product embodies an internet-based cloud model that makes it far better than any other brand of parking software that can be downloaded on the internet nowadays. One of its best advantages is the fact that it’s compatible for all brands of smart phones and modern electronic gadgets. This app has been created to make parking management a paperless procedure that can be accomplished in just few seconds.


Publicar un comentario