STATE CLASSIFICATION JOB DESCRIPTION


Salary Group B18

Class No. 0210

DATABASE ADMINISTRATOR I

 GENERAL DESCRIPTION

Performs entry-level to routine (journey-level) database administration work. Work involves providing assistance in the planning, development, maintenance, and monitoring of integrated database systems; assisting with the development of database policies and procedures; and maintaining data integrity. Works under moderate supervision, with limited latitude for the use of initiative and independent judgment.

EXAMPLES OF WORK PERFORMED

Creates test database environment for applications section, including the creation of necessary libraries and procedures.

Executes the procedures necessary to save, retrieve, and recover databases from hardware and software failures.

Loads databases, reorganizes as necessary, and assists in monitoring database performance.

Maintains data standards.

Prepares and develops database documentation, procedures, and definitions for data dictionaries.

Performs data modeling and prototyping and implements efficiency improvements.

Assists with the installation of database software.

Assists with analyzing, designing, and developing databases.

Assists with the design and maintenance of database structures.

Assists with establishing and implementing database security controls and user access levels.

Performs related work as assigned.

GENERAL QUALIFICATION GUIDELINES

Experience and Education

Experience in computer systems, data analysis, or database development and maintenance work. Graduation from an accredited four-year college or university with major coursework in computer science, management information systems, or a related field is generally preferred. Education and experience may be substituted for one another.

Knowledge, Skills, and Abilities

Knowledge of the principles, practices, and techniques of computer databases, programming, and systems design; of computer operations, systems, and procedures; of project control and cost estimating techniques; of computer database application systems; of data processing flowcharting techniques; of database structures and theories; of current database technologies; and of data analysis techniques.

Skill in complex problem solving and critical thinking, and in the use of a computer and applicable software.

Ability to identify and define user functional and technical database needs, to process information logically, to conduct short-range and long-range project planning studies, and to communicate effectively.


State Auditor’s Office

Revised 9-1-15