Tessitura Database Administrator

Full-time - Mid Level

Becket, MA

About the position

The Tessitura Database Administrator provides leadership for the organization in its use of the Tessitura CRM software. This position ensures the effective utilization of Tessitura across departments, spearheads data-driven initiatives, and provides system support to enhance operations and meet organizational goals. The role requires collaboration with all departments, offering guidance on best practices, troubleshooting, and staff training to optimize the use of Tessitura and its integrated applications.

Responsibilities

• Provides management and support for all Tessitura operations across departments.
• Researches, plans, manages projects, and troubleshoots Tessitura upgrades, including leading planning for the use of new features, creating testing plans, and conducting staff training as needed.
• Coordinates implementation and maintains documentation of third-party application integrations with Tessitura and ongoing maintenance and support.
• Supports Marketing Staff in the administration of TN Express Web application and all web customizations.
• Maintains awareness of industry trends and practices in the use of Tessitura and advises the organization regarding changes and enhancements.
• Interfaces with external and internal user groups to facilitate implementation of best practices and user training.
• Works with Tessitura Support staff and consultants to troubleshoot database issues and maintain and update customizations.
• Creates custom reports and modifies existing reports according to business needs.
• Coordinates planning, scheduling, and implementation of third-party data imports.
• Consults with all departments, gathering user requirements for new initiatives and business processes.
• Oversees data entry and tracking, reports, list management, extractions, and other tasks as assigned.
• Assists staff with the generation of lists, advanced data extractions, custom reports, and ad hoc queries.
• Develops training programs for optimization in all departments.
• Investigates and addresses support issues concerning the Tessitura RAMP application.
• Supervises NSCAN installation, maintenance, and support.
• Updates system tables as needed.
• Manages users and security, enhancing security groups and assigning access rights.
• Performs regular data integrity checks and promotes activities, including duplicate reduction.
• Helps departments enrich data through routine quality assurance and data imports.
• Provides regular functional supervision and training to Tessitura users in each department.
• Regularly convenes staff with primary use responsibilities in all departments.
• Manages Google Shared Drive database implementation.
• Creates and maintains documentation concerning system configuration, best practices, and data entry.

Requirements

• Minimum 4 years experience working in enterprise database administration and/or development, preferably with the SQL Server platform.
• Prior experience with major CRM fundraising databases and major ticketing databases.
• Prior experience in Tessitura administration.
• Knowledge of business process analysis.
• Knowledge of SQL Server, SQL Server Reporting Services, or other related tools.
• Knowledge of Agile and Scrum project management methodologies.
• Demonstrated prioritization and project management skills.
• Excellent oral and written communication skills.
• Demonstrated ability to write clear technical documentation.
• Demonstrated ability to achieve goals through influencing and coordinating inter-departmental work.
• Ability to manage multiple projects simultaneously.

Nice-to-haves

• Experience with third-party applications integrated with Tessitura.
• Knowledge of TN Express Web (TNEW).

Benefits

• Health, dental, and vision insurance
• FSA
• 403B contribution
• Paid time off
• Life insurance
• Short- and long-term disability
• Employee Assistance Program
• Three meals a day (summer only)
• Free access to classes, performances, talks, and studio usage (summer only)