Database Specialists


About

Exploring this Job

There are a number of ways to explore your interest in this field while you are still in high school. One good way is to read books. Many books about computer databases are available at bookstores, libraries, and online. One book to check out is Principles of Database Management: The Practical Guide to Storing, Managing and Analyzing Big and Small Data, by Wilfried Lemahieu, Seppe vanden Broucke, and Bart Baesens.

You can also join your high schools computer club to work on computer projects and meet others interested in the field. Learn everything you can about computers by working with them regularly. Online sources can be particularly good for keeping up to date with new developments and learning from people who are actively involved in this work. Learn to use a commercial database program, either by teaching yourself or taking a class in it. 

You may also want to ask your school counselor or a computer teacher to arrange for a database specialist to speak to your class at school or to arrange for a field trip to a company to see database specialists at work. Another option is to ask your school administrators about databases used by the school and try to interview any database specialists working in or for the school system. Similar attempts could be made with charities in your area that make use of computer databases for membership and client records as well as mailing lists.

Look for direct-experience opportunities, such as part-time work, summer internships, and even summer camps that specialize in computers. Visit https://cty.jhu.edu/resources/academic-opportunities/competitions/math.html for a list of summer programs that are offered by colleges and universities. If you cant find such a position, you can still put your skills to work by offering to set up small databases, such as address books, recipe databases, or DVD libraries for friends or family members.

The Job

It may be easiest to think of a database as being the computer version of the old-fashioned file cabinet that is filled with folders containing information. The database is the information, and the database specialist is the person who designs or adjusts programs that determine how the information is stored, how separate pieces of information relate and affect one another, and how the overall system should be organized. For example, a specialist may set up an online retailers customer database to have a separate "record" for each customer, in the same way that the retailer may have had a separate file folder in its file cabinet for each customer. In the retailers sales database, each sale represented by an invoice will have a separate record. Each record contains many "fields" where specific pieces of information are entered. Examples of fields for a customer database might include customer number, customer name, address, city, state, ZIP code, phone, and contact person. Examples of fields in a sales database might include customer number, item purchased, quantity, price, date of purchase, and total. With information organized in separate fields, the retailer can easily sort customer records or invoices, just like filing folders in a file cabinet. In this way, the retailer could print a list of all its customers in Iowa, for example, or total sales for the month of April.

In the same way that records within a database can be sorted, databases themselves can be related to each other. The customer database can be related to the sales database by the common field: customer number. In this way, a business could print out a list of all purchases by a specific customer, for example, or a list of customers who purchased a specific product.

Database specialists are responsible for the flow of computer information within an organization. They make major decisions concerning computer purchases, system designs, and personnel training. Their duties combine general management ability with a detailed knowledge of computer programming and systems analysis.

The specific responsibilities of a database specialist are determined by the size and type of employer. For example, a database specialist for a telecommunications company may develop a system for billing customers, while a database specialist for a large store may develop a system for keeping track of in-stock merchandise. To do this work accurately, database specialists need a thorough knowledge and understanding of the companys computer operations.

There are three main areas of the database specialists work: planning what type of computer system a company needs; implementing and managing the system; and supervising computer room personnel.

To adequately plan a computer system, database specialists must have extensive knowledge of the latest computer technology and the specific needs of their company. They meet with high-ranking company officials and decide how to apply the available technology to the companys needs. Decisions include what type of hardware and software to order and how the data should be stored. Database specialists must be aware of the cost of the proposed computer system as well as the budget within which the company is operating. Long-term planning is also important. Specialists must ensure that the computer system can process not only the existing level of computer information received, but also the anticipated load and type of information the company could receive in the future. Such planning is vitally important since, even for small companies, computer systems can cost several hundred thousand dollars.

Implementing and managing a computer system entails a variety of technical and administrative tasks. Depending on the organizations needs, the specialist may modify a system already in place, develop a whole new system, or tailor a commercial system to meet these needs. To do this type of work, the database specialist must be familiar with accounting principles and mathematical formulas. Scheduling access to the computer is also a key responsibility. Sometimes, database specialists work with representatives from all of a companys departments to create a schedule. The specialist prioritizes needs and monitors usage so that each department can do its work. All computer usage must be documented and stored for future reference.

Safeguarding the computer operations is another important responsibility of database specialists. They must make plans in case a computer system fails or malfunctions so that the information stored in the computer is not lost. A duplication of computer files may be a part of this emergency planning. A backup system must also be employed so that the company can continue to process information. Database specialists must also safeguard a system so that only authorized personnel have access to certain information. Computerized information may be of vital importance to a company, and database specialists ensure that it does not fall into the wrong hands.

Database specialists may also be responsible for supervising the work of personnel in the computer department. They may need to train new computer personnel hires to use the companys database, and they may also need to train all computer personnel when an existing database is modified. At some organizations, specialists are also required to train all employees in the use of an upgraded or a new system. Therefore, specialists need the ability to translate technical concepts into everyday language.

Database specialists may be known by a number of different titles and have a variety of responsibilities, depending on the size and the needs of the organizations that employ them. According to an article at Computerworld.com, the title database designer indicates someone who works on database programming. These workers usually have a math or engineering background. The title database administrator indicates someone who primarily focuses on the performance of the database, making sure everything is running smoothly. They may also do routine jobs, such as adding new users to the system. The title database analyst indicates someone who primarily focuses on the business, its goals, products, and customers. They work on improving the database so that the organization can meet its goals. In large businesses or organizations, the many duties of the database specialist may be strictly divided among a number of specialists. In smaller organizations there may be only one database specialist, designer, manager, administrator, or analyst who is responsible for carrying out all the tasks mentioned above. No matter what their title is, however, all database specialists work with an operation that processes millions of bits of information at a huge cost. This work demands accuracy and efficiency in decision-making and problem-solving abilities.