The Database Administrator is responsible for providing IT management for The Museum System, the Peabody Museum's collections management database system, including day-to-day administrative management and documentation of database, end user training and troubleshooting, creating reports and user-requested customizations, and planning and implementing system upgrades. Reports to the Senior Collections Manager.
Duties and Responsibilities:
Manages collections management system, The Museum System (TMS), and acts as primary contact with software vendor, Gallery Systems.
Manages user accounts, security access, and database configuration.
Creates and maintains reports using Crystal Reports.
Creates and manages user-defined forms, list views, and data views.
Using SQL, runs data updates and data mining queries.
Schedules and performs TMS upgrades, SQL client upgrades, data file restores, and database maintenance routines.
Manages TMS media linking including process quality control.
Trains new users and responds to user requests for TMS assistance.
Assists with planning for future development of TMS database including systems analysis, research, and testing.
Documents, communicates, and expedites TMS issues/bugs resolution and user requests for new feature.
Working with Systems Administrator, schedules and monitors database backups and sets retention policy; communicates with HUIT contacts as required.
Researches and implements all data migration projects; works closely with Senior Collections Manager on data mapping.
Attends collections-based IT meetings, workshops, and conferences as representative of the Peabody Museum.
Serves as liaison to other collections-based IT departments on the Harvard campus.
Serves on the Peabody's internal IT working group.
Provides database management services for the Harvard Semitic Museum per M.O.U. terms.
All formal offers will be made by FAS Human Resources
Unfortunately the Peabody is not able to pay for travel expenses for applicants who are not local
Salary Grade: 055
Union: 55 - Hvd Union Cler & Tech Workers
A BA degree and a minimum of two years' experience managing TMS (The Museum System).
At least two years related experience.
Experience managing relational databases and training end users.
Knowledge of SQL, XML, XSLT, and Crystal Report required.
Knowledge of collections management procedures and standards preferred.
Experience with PC and Apple operating systems required.
Strong customer service orientation required.
Ability to manage multiple tasks simultaneously essential.
Ability to work occasional off-house during system upgrades or maintenance.
EQUAL OPPORTUNITY EMPLOYER: We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.
About Harvard University Faculty of Arts and Sciences
At the Harvard Library, our work is enriched by our diverse campus community. Our unique and wide-ranging abilities, experiences, and perspectives are integral to achieving Harvard University’s mission of excellence in research, teaching, and learning for our patrons, our collections, and our workplace. We believe that an inclusive environment that cultivates and promotes understanding, respect, a...nd collaboration across our diverse workforce enables our success.
We encourage individuals with diverse backgrounds, experiences and abilities to apply to be a part of our community of over 700 staff members. Our work with faculty, students and researchers to explore answers to intellectual questions, enduring and new, and to seek solutions to the world’s most consequential problems, requires that we not only reflect, but also champion our diverse society.
Harvard Library inspires collaboration, reflection, experimentation, and discovery. Serving as an information hub, the Library connects users to related disciplines and to University-wide teaching resources. The Library engages users through curated discovery, digital collections, reimagined physical space, specialized research support, and delivers exceptional experiences to its user communities. Today, Harvard Library’s holdings range from traditional print collections to rapidly expanding access to digital resources. Harvard Library provides the University's faculty, students, and researchers—now and in the future—with comprehensive access to these materials.
Learn more about our contributions to the academic enterprise by visiting us at http://lib.harvard.edu/about-us and about the Harvard University community at http://hr.harvard.edu/why-harvard .
The Harvard Library is a proud member of the ACRL Diversity Alliance.