STATE CLASSIFICATION JOB DESCRIPTION


Salary Group B22

Class No. 0212

DATABASE ADMINISTRATOR III

 GENERAL DESCRIPTION

Performs complex (journey-level) database administration work. Work involves planning, developing, maintaining, and monitoring integrated database systems; evaluating and implementing database policies and procedures; and maintaining data integrity. May train others. Works under general supervision, with moderate latitude for the use of initiative and independent judgment.

EXAMPLES OF WORK PERFORMED

Coordinates and supports the installation of database software and migrations to new data management system software levels, and tests the migrations to ensure data reliability and functionality.

Analyzes, designs, and maintains database structures.

Designs and implements procedures necessary to save, retrieve, and recover databases from hardware and software failures.

Develops goals and objectives for the use and improvement of an efficient and cost-effective database system.

Establishes and implements database security controls and user access levels.

Evaluates and recommends database software packages for potential acquisition.

Maintains data standards.

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

Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models.

Performs database performance monitoring and implements efficiency improvements.

Assists in modifying existing databases and database management systems.

Assists in developing standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.

Assists in developing policies and procedures to guide in the use and acquisition of database software and resources.  

May train others.

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 and evaluation 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 task needs, to conduct short-range and long-range project planning studies, to communicate effectively, and to train others.


State Auditor’s Office

Revised 9-1-15