STATE CLASSIFICATION JOB DESCRIPTION
Salary Group B26
Class No. 0214
Performs advanced and/or supervisory (senior-level) database administration work. Work involves providing direction and guidance in strategic operations and planning; providing for the efficient and effective storage, retrieval, customization, and archiving of data to ensure integrated database systems; planning, developing, and implementing database policies and procedures; and maintaining and verifying data integrity. May assign and/or supervise the work of others. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.
EXAMPLES OF WORK PERFORMED
Oversees the analysis, design, and maintenance of database structures.
Oversees the evaluation of database software packages for potential acquisition.
Oversees logical and physical data modeling, evaluates relational database models, and reviews physical data models created from logical data models.
Oversees and/or coordinates the installation of database software and migrations to new data management system software levels, and ensures that migrations are appropriately tested and validated.
Assesses future information requirements.
Designs, recommends, and implements procedures necessary to save, retrieve, and recover databases from hardware and software failures.
Develops and reviews policies and procedures to guide in the use and acquisition of database software and resources.
Develops goals and objectives for the use and improvement of an efficient and cost-effective database system.
Develops standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.
Develops budgets for database management systems and required support levels.
Evaluates and reviews database performance monitoring and implements efficiency improvements.
Modifies existing databases and database management systems.
Recommends and implements database security standards and controls, and user access levels.
May assign and/or supervise the work of 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 computer programming languages; of data processing flowcharting techniques; of database structures and theories; of current database technologies; and of data analysis, evaluation, and testing techniques and protocols.
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 process information logically, to conduct short-range and long-range project planning studies, to communicate effectively, and to assign and/or supervise the work of others.
State Auditor’s Office