What are the types of DBA ????? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

What are the types of DBA ?????

22nd Dec 2016, 2:19 AM
Damodar Joshi
Damodar Joshi - avatar
3 Answers
0
Types of DBA There are different kinds of DBA depending on the responsibility that he owns. Administrative DBA - This DBA is mainly concerned with installing, and maintaining DBMS servers. His prime tasks are installing, backups, recovery, security, replications, memory management, configurations and tuning. He is mainly responsible for all administrative tasks of a database. Development DBA - He is responsible for creating queries and procedure for the requirement. Basically his task is similar to any database developer. Database Architect - Database architect is responsible for creating and maintaining the users, roles, access rights, tables, views, constraints and indexes. He is mainly responsible for designing the structure of the database depending on the requirement. These structures will be used by developers and development DBA to code. Data Warehouse DBA -DBA should be able to maintain the data and procedures from various sources in the datawarehouse. These sources can be files, COBOL, or any other programs. Here data and programs will be from different sources. A good DBA should be able to keep the performance and function levels from these sources at same pace to make the datawarehouse to work. Application DBA -He acts like a bridge between the application program and the database. He makes sure all the application program is optimized to interact with the database. He ensures all the activities from installing, upgrading, and patching, maintaining, backup, recovery to executing the records works without any issues. OLAP DBA - He is responsible for installing and maintaining the database in OLAP systems. He maintains only OLAP databases.
22nd Dec 2016, 2:27 AM
Sandeep
Sandeep - avatar
0
Thanks but OLAB means????
22nd Dec 2016, 4:05 AM
Damodar Joshi
Damodar Joshi - avatar
0
Online analytical processing, or OLAP, is an approach to answering multi-dimensional analytical (MDA) queries swiftly in computing, . OLAP is part of the broader category of business intelligence, which also encompasses relational database, report writing and data mining. Typical applications of OLAP include business reporting for sales, marketing, management reporting, business process management (BPM), budgeting and forecasting, financial reporting and similar areas, with new applications coming up, such as agriculture.
22nd Dec 2016, 4:10 AM
Sandeep
Sandeep - avatar