Will “Database Design Analyst” be Automated?

Core Skills & Abilities

• Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.

• Train users and answer questions.

• Write and code logical and physical database descriptions and specify identifiers of database to management system, or direct others in coding descriptions.

• Specify users and user access levels for each segment of database.

• Test changes to database applications or systems.

• Revise company definition of data as defined in data dictionary.

• Test programs or databases, correct errors, and make necessary modifications.

• Review workflow charts developed by programmer analyst to understand tasks computer will perform, such as updating records.

• Plan, coordinate, and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.

• Review procedures in database management system manuals to make changes to database.

• Identify, evaluate and recommend hardware or software technologies to achieve desired database performance.

• Provide technical support to junior staff or clients.

• Select and enter codes to monitor database performance and to create production databases.

• Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.

• Modify existing databases and database management systems or direct programmers and analysts to make changes.

• Develop data models describing data elements and how they are used, following procedures and using pen, template, or computer software.

• Plan and install upgrades of database management system software to enhance database performance.

• Develop standards and guidelines for the use and acquisition of software and to protect vulnerable information.