Collections Systems Database Specialist

Description:

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-date 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 ResourceSpace 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)

Requirements:

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, EAD, 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.

To apply:

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

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 fully 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, color, creed, religion, sex, pregnancy, sexual orientation, gender identity or expression, national origin, age, dis ability, marital status, military or veteran status, domestic violence victim status or any other basis prohibited by applicable federal, state, and/or local laws.

Compensation details: Yearly Salary

PIb0eee1990bb1-37483-37650546