Job Purpose The Database Administrator (DBA) manages enterprise database systems used by the PSO; the primary database is Tessitura. The DBA serve as the Tessitura expert, supports the work of the PSO staff by ensuring accurate, timely, and comprehensive data management through system implementation, systems training, supervision of processes, reporting, and data analysis. This position reports to the VP & Technology Officer. Essential Duties and Responsibilities • Technical lead for Tessitura Database • Provide first line database technical support for PSO staff • Primary point of contact and database liaison for PSO users and Pittsburgh Culture Trust • Monitor/analyze databases identifying inefficiencies, redundancy, and threats to data integrity • Design and implement solutions to identified issues and threats • Support data analysis projects for multiple PSO departments • Create organizational reports as requested • Support strategies and create procedures for streamlining processes and improving efficiency • Lead monthly interdepartmental meetings to identify needs, provide updates, and ensure ongoing communication. • Handle specialized data output requests using SQL queries/procedures and customized SQL Server Reporting Services (SSRS) reports where necessary. • Perform database audits to identify and troubleshoot errors • Assist with financial audits and accessing reports • Assist in generating leads and lists for tele funding, solicitation mailings, benefit fulfillment or acknowledgements. • Provide regular and ongoing training of staff including new system features, processes, reports, and new user onboarding. • Implement Tessitura Business Intelligence reporting, by creating and maintaining Analytic dashboards for the organization • Manage Donate2 and provide Prospect2 support for development and marketing and research ways to use these platforms to reduce staff workload. • Support Archivist with database management and provide input and assistance with maintenance of data and digital assets. • Assist with Active Directory management and other network controls. • All other duties as assigned
