UNM Logo

Position Classification Description

Position Class Code/Title: E1005 / Database Administrator
Recruitment Tier: Tier 1
FLSA: Exempt
Grade: 13

This is a description of a Staff Position Classification. It is not an announcement of a position opening. To view descriptions of current openings, please go to UNMJobs and Search Postings to view positions that are currently accepting applications.

The following statements are intended to describe, in broad terms, the general functions and responsibility levels characteristic of positions assigned to this classification. They should not be viewed as an exhaustive list of the specific duties and prerequisites applicable to individual positions that have been so classified.

Summary

Provides technical expertise in the design, implementation, and maintenance of relational database management systems (RDBMSs) that support institutional business applications. Ensures logical data models are mapped effectively and efficiently into physical data models that take advantage of the characteristics of the specific database management system used. Responsible for technically supporting multiple databases that run university-wide business applications which are accessed by multiple departments.

Duties and Responsibilities

  1. Reviews, develops, and designs data models using standard diagramming techniques, in conjunction with application development teams; creates logical data models and translates into physical database structures that integrate with existing or proposed database structures.
  2. Monitors relational databases to optimize database performance, resource use, and physical implementations of databases; addresses a variety of database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
  3. Maintains development, test, and production RDBMS environments.
  4. Monitors and maintains database security and database software, in cooperation with data security administrators.
  5. Provides advice to applications programmers in the effective use of database languages; advises on troubleshooting, exception processing needs, and other data management issues.
  6. Maintains availability and integrity of databases through multiple access schemes; facilitates sharing of common data by overseeing proper key and index management and data dictionary maintenance.
  7. May evaluate and recommend testing and evaluation of new procedures, software, and hardware.
  8. Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required.
  9. Creates, procures and maintains various database related documents such as manuals and programmers handbooks.
  10. May provide 24 hour on-call support.
  11. Maintains currency of knowledge with respect to relevant state-of-the-art technology, equipment, and/or systems.
  12. Performs miscellaneous job-related duties as assigned.

Minimum Job Requirements

  • Completed degree(s) from an accredited institution that are above the minimum education requirement may be substituted for experience on a year for year basis. Bachelor's degree; at least 2 years of experience that is directly related to the duties and responsibilities specified.ORSuccessful completion of at least 60 college-level credit hours; at least 4 years of experience that is directly related to the duties and responsibilities specified.ORHigh school diploma or GED; at least 6 years of experience that is directly related to the duties and responsibilities specified.

Knowledge, Skills and Abilities Required

  • Ability to interpret data models and to develop database structures.
  • Ability to provide technical guidance and leadership to professional personnel in area of expertise.
  • Knowledge of current technological developments/trends in area of expertise.
  • Ability to use standard diagramming techniques to design and develop computer data models.
  • Ability to implement and troubleshoot programming changes and modifications.
  • Ability to program, configure, manage, and maintain the operation of complex relational databases.
  • Ability to develop and manipulate large, complex data sets.
  • Ability to operate on a scheduled 24-hour on-call basis.
  • Knowledge of data integrity methods and techniques.
  • Technical writing skills.
  • Ability to install, maintain, modify, and upgrade database software.
  • Ability to perform acceptance testing on computer systems, applications, and hardware.
  • Knowledge of computer and/or network security systems, applications, procedures, and techniques.

Distinguishing Characteristics

  • Position requires: a) Creating, maintaining, and monitoring relational databases; b) creating and maintaining documents such as manuals and programmer handbooks; c) installing and upgrading database software; and d) testing and evaluating systems to optimize database performance.

Working Conditions and Physical Effort

  • No or very limited exposure to physical risk.
  • No or very limited physical effort required.
  • Work is normally performed in a typical interior/office work environment.

The University of New Mexico provides all training required by OSHA to ensure employee safety.

Revised Date: 05/12/2014