University of Connecticut University of UC Title Fallback Connecticut

Database Administrator I

Payroll Title: UCP VI
Class Code: 0676-9086
Job Family: DPS
FLSA Code: E
Score: 530

JOB SUMMARY

Under the general supervision of a designated administrator or more experienced Data Base Administrator, applies a high degree of expertise and specialized knowledge of data base management techniques which facilitate and expedite the usability, consistency, accuracy, integrity, security, timeliness and availability of academic and administrative data regardless of environment or platform.

CHARACTERISTIC DUTIES AND RESPONSIBILITIES

  1. Creates, loads, reorganizes, alters, deletes, secures, and otherwise maintains files, databases, tables, indexes, and other related objects.
  2. Monitors, manages and tunes DBMS components (catalogs, directories, data dictionaries, buffer-pools, access rules, disk space, etc.).
  3. Assists and reviews the design of logical and physical data models and file structures.
  4. Assists Systems Programmers to install, maintain, enhance, test and migrate DBMS products and supporting software.
  5. Assists with systems integration issues including activities associated with Data Warehouse and operational data technology and client/server technology.
  6. Reviews and evaluates data base administration and application support tools and software.
  7. Reviews application designs for efficiency, integrity, recoverability, security and interface issues.
  8. Enforces naming conventions and standards for data definitions and usage, DBMS structures, program coding techniques, and database utilities.
  9. Manages and monitors the access to resources and data through the appropriate granting of privileges and authorizations.
  10. Assists applications developers with functional prototyping, testing, problem resolution and data-related consulting.
  11. May provide support, assistance, and training to users and technical staff on one or more of the following products; DB2, DBAXPERT, FILEAID/DB2, TSO, CMS, SQL/DS, FOCUS, CICS, SOURCEBANK, AUTODOC, VSAM, DADS, FDR, FAVER, ACF2 and other products and technologies as they become available.
  12. Participates in local and national professional organizations and user groups to keep abreast of new developments and technology.
  13. Performs related duties as required.

MINIMUM ACCEPTABLE QUALIFICATIONS

  1. Bachelor’s degree and three to five years of progressively responsible technical experience or equivalent combination of training and experience
  2. Demonstrated commitment to maintaining state-of-the-art technical knowledge.
  3. Excellent verbal and written communication skills
  4. Ability to provide technical documentation and project plans for technical staff members.
  5. Good interpersonal skills
  6. Ability to work flexible or off-shift hours.

OTHER DESIRABLE QUALIFICATIONS/SKILLS

  1. Good organizational skills
  2. Ability to present technical papers or presentations at professional seminars and workshops.

Date Created: 11/1/98