Metro Marketers, Inc., wants to build a data warehouse for storing customer information that will be used for data marketing purposes. Building the data warehouse will require much more capacity and processing power than it has previously needed. It is considering Oracle and Red Brick as its database and data warehousing products. As part of its implementation plan, Metro has decided to organize a data administration function. It's four major candidates for the data administrator position:
a. Monica Lopez, a senior database administrator with five years of experience as an Oracle database administrator managing a global banking firm's financial database, but no data warehousing experience.
b. Gerald Brewster, a senior database administrator with six years of experience as an Informix database administrator managing a marketing-oriented database for a Fortune 1000 food products firm. Gerald has been to several data warehousing seminars over the past 12 months and is interested in being involved with a data warehouse.
c. Jim Reedy, currently the project manager for Metro Marketers. Jim is incredibly aware of Metro’s current systems environment and is well respected by his coworkers. He has been involved with Metro’s current database system but does not have any data warehousing experience.
d. Marie Weber, a data warehouse administrator with two years of experience using a Red Brick–based application that tracks accident information for an automobile insurance company.
Based on this limited information, rank the four candidates for the data administration position. Support your rankings by indicating your reasoning.
The solution to the Problem
Data Administrator
The data administrator process is treated as a high-level function, which is responsible for managing the whole data resources of an organization. The data administrator has the responsibility to create the logical design of the data. The data administrator maintains general data like audio, video, files, documents, etc., utilized in the organization. Also, they sustain the corporate-wide characterization and standards of the organization.
Rank 1: Jim Reedy
Jim Reddy is the most preferred candidate for the position of data administrator. Reasons: His professional background illustrates the managerial and technical skills suitable for the data administrator position. He has the capacity to communicate well with the customers. Also, he is well-known with Metro’s current systems environment, so he can able to manage the technical staff and technical issues.
Rank 2: Gerald Brewster
Gerald Bruester is the next preferred candidate for the position of data administrator. Reasons: He is a senior database administrator and has knowledge about data warehousing, so he knows how to handle data. Also, he has managed a marketing-oriented database. This experience is more suitable for storing customer information in a warehouse for promotion purposes.
Rank 3: Marie Weber
Marie Weber is the next preferred candidate for the position of data administrator. Reasons: She is having experience in storing customer information in a data warehouse.
Rank 4: Monica Lopez
Monica Lopez is the least preferred candidate for the position of data administrator. Reasons: She has five years' experience in a financial database for a global banking firm. Also, she is having experience as a senior database administrator. Monica Lopez has experience in different businesses; it depreciates her preference when comparing with others.
See Also: MDM Chapter 11 Problem and Excercise 6
Post a Comment