FAQs about Database administrator

1. FAQs about Database administrator What is DBA (Database Administrator)? Database administrator uses specialized software to store and organize data. Database administrators (DBAs) use specialized software to store and organize data. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery. What are the types of Database administrator? 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. Few types of database administrator are: System DBA: A system DBA focuses on technical rather than business issues, primarily in the system administration area. 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. Database Analyst: Another common staff position is the database analyst. There is really no set definition for this position. Data Modeler: The application DBA focuses on database design and the ongoing support and administration of databases for a specific application or subset of applications. Application DBA: The application DBA focuses on database design and the ongoing support and administration of databases for a specific application or subset of applications. consultgeek.com

2. Task-Orientated DBA: Larger organizations sometimes create very specialized DBAs that focus on a specific DBA task. Performance Analyst: Performance analysts are a specific type of task-oriented DBA. The performance analyst, more common than another task-oriented Database administrator, focuses solely on the performance of database applications. Data Warehouse Administrator: Data warehouse administrators must be capable DBAs, but with a thorough understanding of the differences between databases that support OLTP and a data warehouse. What are the types of database users? Database users are the one who really uses and takes the benefits of a database. There will be different types of users depending on their need and way of accessing the database: Sophisticated Users - They are database developers, who write SQL queries to select/insert/delete/update data. Application Programmers - They are the developers who interact with the database by means of DML queries. These DML queries are written in the application programs like C, C++, JAVA, Pascal etc. Specialized Users - These are also sophisticated users, but they write special database application programs. They are the developers who develop the complex programs to the requirement. Stand-alone Database Administrator Users - These users will have stand –alone database for their personal use. These kinds of the database will have readymade database packages which will have menus and graphical interfaces. Specialized Users - These are also sophisticated users, but they write special database application programs. They are the developers who develop the complex programs to the requirement. consultgeek.com