The Oregon Shakespeare Festival is seeking a Database Administrator. The primary focus of this position is to facilitate the development, implementation and support of the Tessitura CRM/Ticketing System, HRIS, Financial, and Data Systems across all OSF functions, and provide back-up assistance to the OSF Information Technology Systems Administrator and support Marketings Tessitura Admin. This individual is responsible for data cleanliness and standards, analyzing and mining data and developing customized reports and queries. Deliver exceptional patron service experience by recommending and implementing continuous process improvements, identifying gaps in current processes and bringing resolution to known issues.
This is a full-time, year-round, exempt position.
All Oregon Shakespeare Festival employees are expected to understand and embrace our mission statement, in particular how it is reflected in our commitment to respect and represent diverse ideas, races, genders, sexualities, abilities, cultures, religions, and traditions- on stage and off. OSF company members work in a manner that is consistent with this commitment and work to interrupt behaviors that hinder our diversity and inclusion efforts.
Principal Duties and Responsibilities (Essential Functions**):
Attends Equity, Diversity, and Inclusion, (ED&I) sexual harassment, and any other anti-bias training and workshops as scheduled by the institution.
Model and support the mission and values.
Improve procedures and processes relating to database management that will ensure data integrity is maintained and reports are generated accurately
Test, Install, and Upgrade Server Software
Design back up processes for server and associated data
Create accounts for users and assign security levels
Schedule and perform regular server maintenance
Monitor and maintain system health and security
Participate in 24x7 on-call support rotating schedule
Provide decision-making support for management utilizing Tessitura; supply reports and analysis of patron, donor and participation trends as requested by colleagues.
Provide Tessitura functionality expertise and support to application users in the design and execution of Lists, Extractions, Output Sets, CSIs, data imports/exports, and Tessitura Dashboard analytics.
Work with Web Team and Festival staff as needed to support and maintain transactional integrations between the Festivals website/Web API and the Tessitura database.
Window Server Environment (IIS, Server, MSSQL)
Other Duties and Responsibilities: Other duties as assigned.
Education: Bachelors degree in computer science
Work Experience: 3 years work experience in a similar role
Working knowledge and hands on experience with Microsoft SQL Server, SSRS, and IIS
Database management and reporting/analysis
Virtual Server Administration Experience
NGNIX Web Server Experience
Data Security, Vulnerability Management and OS updates and patching skills
Knowledge and experience with PCI DSS
Project management and severing as a liaison between departments
Other Skills, Ability and/or Knowledge:
Tessitura, Sisense, InfoMaker
Web programming, development, management and e-commerce
Mobile Device experience of Ticket Scanners
Active Directory , Office 365
Must be able to do repetitive hand and wrist work using the computer
Must be able to function competently within situations of high-stress and demand
Special Position Requirements: Must pass a background check
Special Hours Requirements: Position will participate in on 24 hour available for call back rotation
Sick & Vacation Time
Relocation support for eligible employees
Health & Wellness Plan
Flexible Spending Account
Retirement Plan & Company Match
Employee Assistance Program
Long Term Disability
Complimentary Tickets to OSF productions and other select events
Discounts at select local businesses
About the Oregon Shakespeare Festival
Located in the beautiful Rogue Valley of Southern Oregon, our Tony Award-Winning company of extraordinary artists present seasons of ten to twelve plays in rotating repertory between the months of February/March and October. A robust and highly dedicated staff of over 500 employees produces these performances each season across three venues: the Allen Elizabethan, Thomas, and Bowmer Theatres. Inspired by Shakespeare's work and the cultural richness of the United States, the productions on our stages reveal our collective humanity through illuminating interpretations of new and classic plays, deepened by the kaleidoscope of rotating repertory and guided by our values of Excellence, Inclusion, Company, and Stewardship. We are also excited to usher in a new creative era this season as recently announced Artistic Director Nataki Garrett takes the helm!
In addition to our main stage plays, we offer an eclectic array of enrichment programs for audiences and staff alike including backstage tours, educational workshops, prefaces, prologues, a lecture series and the Green Show. We also partner with local organizations and community members on a number of immersive events and celebrations including an annual Martin Luther King, Jr Day Celebration, Juneteenth Celebration, OSF Out Weekend, and Daedalus Project.
Why Should I Apply:
Be a part of an industry-leading professional non-profit regional theatre in its 84th season with a rich history and values arts, excellence, and inclusion. OSF is nestled in a scenic mountain valley near the Oregon-California border where the weather is idyllic with mild winters and hot, dry summers. We are one of the only regional theatres of our size and caliber that is not located in a major metropolitan area! Southern Oregonians love the outdoors, and because of our non-urban setting, an abundance of stunning rivers and lakes, nearby state and national parks, hiking trails, outdoor music venues, white-water rafting and hang gliding excursions are just outside the front door. Southern Oregon also offers robust culinary experiences with dozens of top-notch restaurants, local breweries, charming cafes, and award-winning wineries. We care about community, and our regions dedication to supporting local businesses and agriculture is notable. Our employee benefits are first-rate, too!
At OSF we believe that diverse ideas, cultures and traditions reflect the broad diversity of the nation and enrich our insights into the work we present on stage. We are committed to diversity in all areas of our work, including play selection, casting, marketing and public relation efforts, education programs, strategic recruitment of staff and volunteers, and the composition of the Board of Directors. People of color and members of other underrepresented groups are encouraged to apply.
If you wish to apply for this position please be prepared to provide:
3 work references (name, email and phone number)
A cover letter is requested but not required.
Only complete applications will be considered.