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.
Required Skill/ability 1: Excellent interpersonal skills. Ability to build strong relationships with internal clients, effectively resolve problems and communicate creative resolutions to multiple constituents within the museums.
Required Skill/ability 2: Ability to work independently as well as with a team.
Required Skill/ability 3: Advanced knowledge and proven ability in database management (Microsoft SQL and SQL based tools.) SQL preferred.
Required Skill/ability 4: Excellent project management, organizational and communication skills. Ability to manage and prioritize multiple projects simultaneously.
Preferred Education: Experience working with relational databases and linked data principals within a museum setting. Experience with TMS and Conservation Studio (products from Gallery Systems). Knowledge of JSON or XML. Crystal Reports, SSRS or similar.
Work Week: Standard (M-F equal number of hours per day)
Posting Position Title: Database Administrator, YAG
University Job Title: Data and Database Specialist
Preferred Education, Experience and Skills: Experience working with relational databases and linked data principals within a museum setting. Experience with TMS and Conservation Studio (products from Gallery Systems). Knowledge of JSON or XML. Crystal Reports, SSRS or similar. Bachelor's Degree in a related field and two years of related work experience or an equivalent combination of education and experience. About Yale University
Yale University is an American private Ivy League research university located in New Haven, Connecticut. Founded in 1701 in the Colony of Connecticut, the university is the third-oldest institution of higher education in the United States.
Connections working at Yale University
