Job Location: Information Technology
Reporting to the Manager of Information Technology, the Database Coordinator primarily designs, implements, administers, maintains and evaluates the Walters Art Museum’s databases and provides the primary desktop and software-related technical support for problem resolution. When needed, the Database Coordinator provides technical support to the Head of Imaging and Intellectual Property with regard to ResourceSpace (data asset management system) and to the Assistant Registrar for Data and Images with regard to TMS (the collection management system). The Database Coordinator provides consistent backup support to the Information Technology Manager with server administration, user account maintenance, system documentation, help-desk support functions and participates in planning of future upgrades and technology enhancements.
- Oversees user accounts/groups, recommends and manages security permissions and develops and implements related security policies in partnership with the Information Technology Manager.
- Assists staff in identifying and producing their reporting and querying needs including the creation and revision of specified custom Crystal and SSRS reports and the identification of data entry requirements for staff that are necessary to create reports.
- Implements, maintains, and troubleshoots database system integrations.
- Implements and maintains test environments for database systems where new processes and upgrades can be tested. Maintains the test environments with recent production data.
- Develops and maintains comprehensive disaster recovery and backup plans for database systems and data. Monitors these processes to ensure appropriate coverage.
- Creates and maintains user guides, manuals and documentation for system administration, data entry and data retrieval.
- Performs end-user client maintenance as related to database applications, including installation and troubleshooting.
- Trains staff in database usage and provides end-users with daily support for all database related issues as help desk resource.
- Conducts file transfers, imports, exports and dissemination of data and associated media to web based applications and partner organizations.
- Uses security protocols, database administration protocols, table and metadata management to ensure data integrity, digital preservation of resources and a successful end user experience.
- Keep database applications running in optimum condition by evaluating new version upgrades for all databases and testing and applying upgrades as needed. Maintains database application test environments to safely facilitate both this process and all database processes and development initiatives.
- Anticipates future client and server hardware needs for database applications by developing growth scenarios and end-user needs requirements, and works closely with the Manager of Information technology on budgeting and planning to meet those needs.
- Extends the functionality of applications by developing and maintaining SQL scripts, stored procedures, automated reporting, PHP utilities and other applications that facilitate imaging and information workflows, data sharing, interoperability and data integrity.
- Works with end-users to define needs for customized application interfaces, data views and other user-interface components. Use vendor-provided tools to implement customizations or serve as the technical lead for developing larger-scale, outsourced customizations.
- Automates digital preservation and metadata schema protocols to as great extent as possible by using scripts, utilities and stored procedures.
- Interacts with all necessary departments/divisions to analyze and gather report requirements for generating criteria and output.
- Provides back-up support to the Information Technology Manager in supporting the network and infrastructure of the museum.
Qualifications include BA in Computer Science, Management Information Systems, or related field, three years of experience with various database applications and strong SQL scripting skills, or an equivalent combination of education, training and experience.Experience with Crystal reports, SSRS Reporting and MySQL preferred. Must have good organizational skills, be detail oriented, and communicate effectively.
Salary is commensurate with experience. We offer an attractive benefits package. For consideration, send your resume, cover letter, and salary requirement to firstname.lastname@example.org. Application end date is April 30, 2018.
An Equal Opportunity, Equal Access Employer.
A smoke and drug free workplace
- NO CALLS PLEASE
The Walters Art Museum is an equal opportunity, equal access employer committed to achieving a diverse workforce. Employment at the Walters is contingent on a favorable investigative background check. The museum is a drug and smoke free workplace. The Walters Art Museum is an at will employer.