Database Manager

The Database Manager's primary responsibility is to coordinate the organization's database systems, keep the data clean, the system up to date, and to use a variety of tools to compile and present data for tracking and analysis. The Database Manager utilizes Tessitura products (Tessitura, TNEW, Analytics) to build Education offerings, streamline organization processes and procedures, maintain clean records, create and manage custom reports for other departments, prepare analytics dashboards, and support daily processes including updating and importing data and records.

The Database Manager reports directly to the Director of Administration.

• Provide database support to assure that the Tessitura database fulfills the transactional and informational needs of the organization.
• Monitor daily actions in the database and provide any daily database cleanup that is needed (updating addresses, merging records, etc.).
• Supervise the Registrar who oversees student enrollment and student data collection and management.
• Establish and maintain organizational protocols for all data entry and configurations.
• Work with the Education Department to gather information and build out class and camp offerings within Tessitura.
• Oversee annual season build and package creation.
• Monitor and manage the performance of the database to assure efficient operation. Keep all database users up-to-date, informed, and confident of data issues and processes.
• Provide foundational Tessitura setup and training for new users across the organization and higher level Tessitura training for power users in Registration, Marketing, Education, Patron Services, and Development.
• Responsible for managing all aspects of Tessitura and related hardware - TNEW, Hosting Services Management, Ticket Scanners, BOCA Printers, Credit Card Readers, and tablets.
• Provide support for Tessitura integrated partners such as Wordfly, Wordpress, Camp Docs, Queue-It and Go Fund Me Pro .
• Document standard procedures for Tessitura best processes and provide support for other internal users.
• Stay up to date and keep users informed about Tessitura developments including patches, outages, updates, and upgrades.
• Serve as the Tessitura knowledge expert on staff by providing advice and instruction on best practices for colleagues as well as troubleshooting small technical issues as they arise.
• Work with Tesitura Network to coordinate upgrades and seek resolutions for errors or answers for questions on behalf of the organization through Tessitura Support.
• Create Campaigns, Funds, Appeals and Sources for the Development Department.
• Oversee and implement new Fiscal Year turnovers including new defaults, campaigns, seasons, batch periods, etc.
• Provide backend support in System Tables, References, Ticketing Setup, Facility Manager, and occasionally SQL Server Management Studio.
• Prepare End-Of-Year Audit Reports and data for Finance and Accounting teams upon request.
• Prepare reports and dashboards for the annual report, grants, and other external reporting.
• Assist other departments in gathering and analyzing information from the database to further department goals.
• Pull lists and extractions for Education, Marketing, and Development departments as needed
• Maintain security and integrity of the database.
• Oversee data imports of mass contribution entries and data from NCOA updates.
• Serve as a technical liaison for outside contractors such as website developers, finance representatives, and fundraising consultants to provide insight and recommendations based on Tessitura configuration.

Bachelor's Degree in relevant field OR equivalent experience in database support.
One to three years relevant work experience in database management…