Collection Systems (Database) Specialist

Overview

Hybrid
$115,000 - $130,000
Full Time
No Travel Required

Skills

Qualifications: Bachelor's degree in computer science preferred
Minimum three years of experience managing cultural heritage databases preferred
Database administrator experience with MS SQL server required
Knowledge of working with packages in SQL Server Management Studio (SSMS)
SSIS/SSDT preferred
Proficiency in writing SQL statements required
Familiarity with Crystal Report and SQL Server Reporting

Job Details

The Morgan Library & Museum invites applications for the position of Collection Systems Specialist. Reporting to the Network Administrator in Management Information Systems, the Collection Systems Specialist is responsible for the optimum operation and development of the Morgan's ecosystem of databases supporting collection information, collection management, collection imaging, and the dissemination of collection data. Day-to-day responsibilities will also include documenting system administration processes, custom configurations, workflows and processes, and training super-users for each system.

Responsibilities: 

  • Manage the Morgan's core collection systems, including: The Museum System (TMS), its related application Conservation Studio (implementation in process), Voyager ILS, and Resource Space DAMs
  • Manage the Morgan's core collection database custom solutions (e.g. an Access-based Imaging & Rights database and its Photo Studio extension); conceptualize and implement long-term strategies for data management
  • Manage the Morgan's ancillary custom collection management solutions (e.g. reader tracking, call slip and label printing, offsite storage management, etc.) with an eye to moving them to updated platforms as needed
  • Design and maintain custom reports for each system and across systems in order to meet user needs and supply institutional statistics (e.g. Crystal Reports, SSRS, SQL queries, dashboards, etc.); field and respond to user feedback on these reports
  • Model, implement, and manage data processes and integrations among the collection systems, including timed data refreshes; spearhead movement towards improved interoperability between the various collection systems
  • Write and maintain custom code to support the extraction and transformation of collection data to other platforms (e.g. website, union catalogs, specialized portals, etc.)
  • Contribute to strategic planning as it regards to system upgrades, migration, and integration
  • Advise on integration approaches to other types of data (ie. CRM)
Qualifications: 
  • Bachelor's degree in computer science preferred
  • Minimum three years of experience managing cultural heritage databases preferred
  • Database administrator experience with MS SQL server required
  • Knowledge of working with packages in SQL Server Management Studio (SSMS), SSIS/SSDT preferred
  • Proficiency in writing SQL statements required
  • Familiarity with Crystal Report and SQL Server Reporting Service (SSRS) preferred
  • Knowledge of one or more high-level programming languages required; additionally, familiarity with Visual Basic (VB) preferred
  • Understanding of metadata standards, data models, and data encoding related to cultural heritage information, such as JSON, MARC, MARCXML, IIIF, RDF/Linked Data preferred
  • Diplomatic and clear verbal and written communication skills Strong organization skills to effectively manage multiple projects
  • Ability to establish excellent working relationships with stakeholders and end users Ability to lift 40 lbs. of computer equipment.
  • Able to climb, kneel, and crawl through narrow spaces for hardware installs and network cabling
Compensation: 

$115,000–$130,000 annually, commensurate with experience; excellent benefits.

The Morgan Library & Museum receives many applications and inquiries for employment. Unfortunately, we are not able to respond to all of them. Due to the high volume of applicants, we can contact only those candidates whose skills and background best fit our needs.

Important to note:

Vaccination Requirement
To ensure the overall health and safety of the Morgan Library & Museum campus, all staff of the Morgan are required to be vaccinated against the virus that causes COVID-19, absent qualifying exemptions for medical, religious, or other reasons in accordance with applicable laws.

EEO Statement
The Morgan is an Equal Opportunity Employer and is committed to complying with all federal, state, and local equal employment opportunity laws. The Morgan provides equal employment opportunities to all employees and applicants for employment without regard to race or color, religion or creed, alienage or citizenship status, sex (including pregnancy), national origin, age, sexual orientation, gender identity or expression, sexual and reproductive health decisions or decision making (of covered persons or their dependents), disability, height, weight, marital status, familial status, domestic partnership status, caregiver status, genetic information or predisposing genetic characteristics, military status, domestic violence, sexual violence, or stalking victim status, pre-employment arrest record, or any other characteristic protected by law.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.