I am very keen to move into the database sector. What are the typical day-to-day tasks of a DBA?
Sid Adelman’s Answer: The database administrator (DBA) is responsible for the physical aspect of the data warehouse. This includes physical design, performance, backup and recovery. Before starting, the DBA must understand the users’ basic requirements and how the data warehouse databases will be accessed. Some changes to the design and configuration of the system are more easily made than others. The more that is known initially, the less disruptive and costly the changes will be.
Data warehouse DBAs are usually more closely involved with the users than are the DBAs responsible for operational (OLTP) systems. Data warehouse DBAs are constantly monitoring and tuning the data warehouse databases, adding indexes and summary tables. They monitor the SQL generated from the queries to help improve individual query performance.
The database administrator will typically use a modeling CASE tool to create the physical database design. The same CASE tool should be used for the physical database design that was used for the logical data model. The advantage in that case is that the mapping between the logical and physical data models can be done on the CASE tool and exported to the central repository without having to write additional programs.
Database administrators will then create the data definition language or use the CASE tool to create the data definition language to build the database. Database administrators always have an eye for performance. Performance will dictate designs and the creation of keys and indexes.
Database Administration is sometimes responsible for capacity planning, always responsible for physical design for good performance, for monitoring response time and resources used (CPU, disk I/O), for evaluating performance problems, for tuning the databases and for reviewing the complicated SQL statements written by both application developers and power users.
The description of the DBA is taken from Data Warehouse Project Management by Sid Adelman and Larissa Moss, Addison Wesley, 2000
Chuck Kelley’s Answer: This can be considered as a list of starting points for any DBA:
Again, this is a beginning of a list.
Other tasks that are required for either type of DBA include:
Backup and Recovery
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access