Database Administrators and Architects

Database Administrators and Architects typically perform the following tasks: • Modify existing databases and database management systems or direct programmers and analysts to make changes. • Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. • Plan and install upgrades of database management system software to enhance database performance. • Specify users and user access levels for each segment of database. • Test changes to database applications or systems. • Test programs or databases, correct errors, and make necessary modifications. • Train users and answer questions. • Provide technical support to junior staff or clients. • Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases. • Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information. • Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions. • Develop data models describing data elements and how they are used, following procedures and using pen, template, or computer software. • Select and enter codes to monitor database performance and to create production databases. • Identify, evaluate and recommend hardware or software technologies to achieve desired database performance. • Review procedures in database management system manuals to make changes to database. • Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management. • Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records. • Revise company definition of data as defined in data dictionary.