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.
51 comentarios:
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
Thanks for your comments :),
Regards,
Victor.
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/
Thanks, what a good post and informative blog.
thanks buddy...nice article....really found useful....keep posting like this other topics also....
Very nice useful article thank you for sharing this information. Know more about Oracle DBA Training
useful informative we have to sharing
Informatica Online Training
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ẻ
Thanks for the excellent information and facts, this was a very good piece of writing.
Microsoft Server 2016 Installation
Server 2016
nice post
SQL Server DBA Online Training india
thank you for sharing.it is a nice information
SQL Server DBA Online Training
1it's a Nice blog, very helpful for usSql Server dba online training
very useful article thank you for sharing Sql Server dba Online Training Bangalore
Really Good blog thank you keep updating Sql Server dba Online Training
Nice Blog Thank You For Sharing Sql Server dba Online Training
Hyderabad
Nice blog it is very useful thank you for sharing Sql Server dba Online Training hyderabad
Wow! That's really great information guys.I know lot of new things here. Really great contribution.Thank you ...
Oracle Weblogic Server Training
It is very good blog and useful for students and developer ,
Sql server DBA Online Training Banaglore
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
It 's an amazing article and useful for developers
Sql server DBA Online Training
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.
Thanks for sharing this post. Your post is really very helpful its students.
SQL server dba Online Training
Nice blog thank you so much
SQL DBA Training in Hyderabad
This Blog Provides Very Useful and great Information. United States Medical Licensing Examination Thanks for sharing.
A very useful blog, Thank you so much. For more info:
SQL DBA Training in Hyderabad
good information provided in the blog thanks for sharing for more visit SQL DBA Training in Texas
Thanks for sharing this informative blog post. Nice video. easy to understandable, really helpful for learning. For more info:
Linux Administration Training in Hyderabad
thank you for sharing useful information. visit us at
SQL DBA Training in Austin
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
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
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
Awesome post. You Post is very informative. Thanks for Sharing.
Oracle DBA Training in Noida
Appreciating the persistence you put into your blog and detailed information you provide.
Oracle dba training chennai | oracle dba training course chennai
Thanks for sharing the information.
Azure Development Online Training
I like your post very much. It is very much useful for my research. I hope you to share more info about this. Keep posting sql server DBA online training
Thanks for sharing the valuable information.
Azure Development Online Training
Your blog is in a convincing manner, thanks for sharing such an information with lots of your effort and time sql dba training training
This is really an awesome blog! Keep us updated with more such blogs.thanks a lot guys.
C and C++ Training Institute in chennai | C and C++ Training Institute in anna nagar | C and C++ Training Institute in omr | C and C++ Training Institute in porur | C and C++ Training Institute in tambaram | C and C++ Training Institute in velachery
Superb information.Keep going. Java training in Chennai | Certification | Online Course Training | Java training in Bangalore | Certification | Online Course Training | Java training in Hyderabad | Certification | Online Course Training | Java training in Coimbatore | Certification | Online Course Training | Java training in Online | Certification | Online Course Training
Really Thanks For Posting Such a Useful and informative article. oracle training in chennai
Money Gadget
Money Gadget
Money Gadget
Money Gadget
Money Gadget
Money Gadget
Money Gadget
Money Gadget
Nice post.
Spark training
splunk admin online training
splunk admin training
splunk development online training
splunk development training
splunk online training
splunk training
sql azure online training
sql azure training
sql plsql online training
sql plsql training
sql server dba online training
sql server dba training
sql server developer online training
sql server developer training
Infycle Technologies offers the Best Data training in chennai and is widely known for its excellence in giving the best Data Science Certification course in Chennai. Providing quality software programming training with 100% placement & to build a solid career for every young professional in the software industry is the ultimate aim of Infycle Technologies. Apart from all, the students love the 100% practical training, which is the specialty of Infycle Technologies. To proceed with your
career with a solid base, reach Infycle Technologies through 7502633633.
Nice post. Please check out our website SQL Certifications For Beginners to learn more about SQL. Thanks in advance.
nice post.splunk training
splunk online training
splunk online course
Infycle Technologies, the best software training institute in Chennai offers the leading Python course in Chennai for tech professionals, freshers, and students at the best offers. In addition to the Python course, other in-demand courses such as Data Science, Cyber Security, Selenium, Oracle, Java, Power BI, Digital Marketing also will be trained with 100% practical classes. After the completion of training, the trainees will be sent for placement interviews in the top MNC's. Call 7504633633 to get more info and a free demo.
Thanks for making this blog helpful for me! I am doing online SQL Server SQL Server DBA Roles and Responsibilities: What Should You Know. Thanks for sharing.
Great Article. I really liked it.
SQL Course in Pune
Publicar un comentario