Job Abstract

Reporting to the Director of Information Technology at the Yale University Art Gallery, the Data and Database Specialist develops, implements, and maintains policies and procedures for ensuring the security and integrity of the Gallery’s collection database while actively ensuring adherence to data standards across the Gallery environment. Serves as primary resource for a wide-range of museum staff members and departments that use TMS (The Museum System), the collections management database used by the Gallery.

Reporting to the Director of Information and Digital Services at the Yale University Art Gallery (YUAG), the Data and Database Specialist handles the front-end support and some back-end support for The Museum System (TMS), the art collection management system, as well as Conservation Studio (CS), the database for conservation activities at the museum. The Data and Database Specialist develops, implements, and maintains policies and procedures for ensuring the security and integrity of the Gallery’s collection data and information while actively ensuring adherence to data standards.

Responsibilities include the following: Manages the collection information systems for the Gallery- The Museum System (TMS) and the Conservation Studio system (CS). Responsible for day-to-day administration of TMS and CS and works with Gallery members to understand data needs. Uses SQL skills to assist in data management and answer questions as they arise. Plans, coordinates, and implements activities necessary to the effective operation and maintenance of the database. Uses available report writing software to assist with the creation of reports to support the various museum functions. Assists with the training of museum staff in the basic use of TMS and Conservation Studio. Interacts with vendors to troubleshoot the software and server environments and maintains documentation of processes and workflows. Creates and enforces data standards at the museum while working on a variety of data cleanup and data enrichment projects. All other duties as assigned.

This position allows for remote work, but it must be from one of Yale’s approved states, and work hours are expected to be 9:00 AM- 5:00 PM Eastern Standard Time.
??????Excellent project management, organizational and communication skills. Ability to manage and prioritize multiple projects simultaneously. 1. Manages the collection information system (TMS); day-to-day administration (e.g. basic database management, backup, maintenance, security, etc.)2. Work with Gallery members to understand data needs; use SQL skills to assist in data management needs and answer questions as they arise.3. Plans, coordinates, and implements activities necessary to the effective operation and maintenance of the database.4. Uses available software tools to assist with the creation of reports to support the various museum functions.5. Assists with the training of museum staff in the basic use of the TMS database through individual instruction, classroom sessions, and telephone support.6. Interact with vendors to install and troubleshoot software and server environment; research server and vendor software to ensure compatibility before doing upgrades.7. Create and maintain documentation of YUAG systems and environments. Create and promote data standards and best practices, enforce and train museum in standards. Bachelor's Degree in a related field and two years of related work experience or an equivalent combination of education and experience.