Database Administrator

Overview

On Site
$90,000 - $110,000
Full Time
No Travel Required

Skills

MSSQL
TMS
Ability to write SQL statements.

Job Details

The Morgan Library & Museum invites applications for the position of Database Administrator. Reporting to the Network Administrator, the Database Administrator is responsible for maintaining a range of databases used for museum and library functions while also evolving them towards greater interoperability with one another. Database systems at the Morgan include The Museum System (TMS) and Voyager (our OPAC) as well as a digital asset management system and databases used by paper and book conservators, the reading room for scholars, and the management of image rights and the sale of collection images, among others. The context for this work is the Morgan’s constellation of collections encompassing materials traditionally managed in both museum and library systems and a wide range of associated activities. Stakeholders include colleagues in curatorial departments and multiple supporting areas; a primary relationship is with the manager of the Morgan’s OPAC database.

Responsibilities: 
  • Managing The Museum System (TMS) at the Morgan, including:
    • Maintaining database integrity and function, working with vendors when necessary to troubleshoot database problems and perform upgrades
    • Configuring fields and user permissions
    • Creating new user accounts and helping to train and support database users
    • Documenting procedures
    • Working with other IT staff to ensure database integrity
    • Working with librarians and curators to maintain data quality
  • Completing implementation and ongoing management of Gallery System’s Conservation Studio module for TMS
  • Working with the manager of the Morgan’s OPAC database, CORSAIR, running Voyager, to maintain integration of the TMS and CORSAIR databases - unifying collection data across both museum and library
  • Adopting a middleware database to act as a hub for integrating the Morgan’s collection data and facilitate future further data integration
  • Working to develop a sales/CRM system for the Imaging and Rights department to replace their aging Access database
  • Identify legacy datasets that should be incorporated into a supported system; model and migrate the data
  • Working to develop a framework and method for tying in other Morgan databases where feasible and sensible.  Opportunities may involve a) the database of Readers used by the Reading Room and b) connecting the front desk ticketing system to donor management software
  • Assisting with other database projects in an advisory role (e.g., implementation of a new HRIS).
Qualifications: 
  • BA or BS in Computer Science preferred or comparable skills and experience
  • A minimum of three to five years of relevant experience, particularly MSSQL and SQL databases, cultural institution experience – museum and/or library experience preferred
  • Ability to write SQL statements
  • Knowledge of and ability to work with packages in SQL Server Management Studio (SSMS), SSIS/SSDT is important.
  • Ability to understand and work with data integration among multiple databases
  • Familiarity with developing reports using Crystal Reports, SQL Server Reporting Services (SSRS), or similar tools
  • Understanding of metadata standards, data models, and data encodings that relate to art and library collections (Dublin Core, MARC, IIIF, RDF/Linked Data)
  • Diplomatic and clear communication skills with the ability to build strong relationships with end users
Compensation: 

$90,000 - $110,000 commensurate with experience; Excellent Benefits.

To apply: 

Interested applicants should email a cover letter, resume, and three references to Human Resources at: