Database Administrator

University of Washington Shoreline, WA

The University of Washington (UW) is proud to be one of the nation’s premier educational and research institutions. Our people are the most important asset in our pursuit of achieving excellence in education, research, and community service. Our staff not only enjoys outstanding benefits and professional growth opportunities, but also an environment noted for diversity, community involvement, intellectual excitement, artistic pursuits, and natural beauty.

The Meany Center enjoys an international reputation as one of the Northwest’s premier centers for performing arts presentations and arts education. Located at Meany Hall on the University of Washington campus, Meany Center embraces the boundless power of the arts to inspire and connect us, and to create positive change in the world.

Meany Center has an outstanding opportunity for a 50% FTE Database Administrator. We are seeking an individual with a strong SQL database administration and application support skills preferably in the performing arts with Tessitura software experience as well as desktop support experience.

Tessitura is multifaceted SQL database software for ticketing, fundraising, memberships, marketing, reporting, customer relationship management, web transactions, and custom capabilities.

This position is a member of a collaborative IT department that also includes a 50% FTE IT Administrator. Together, these two positions provide IT Services and Database Administration/Application in support of Meany Center. Working under the general supervision of the Managing Director, this individual is responsible for the Tessitura database system and its applications and supporting the Finance, Fundraising, Marketing & ticketing departments in the use of Tessitura. Also secondary support for desktop support; other duties as assigned.

Tessitura (ticketing software) Database Administration/Application Support (85%)

• Provide Tessitura software client-server application support and database administration

• Develop and maintain complex reports using Microsoft SQL Server Reporting Services

• Create and maintain custom stored procedures, views, tables, etc. as necessary for client support

• Create, maintain and modify reports in SSRS for use in Tessitura. (Limited number of reports in Infomaker)

• Create, modify and maintain processes that export/import data to and from external sources

• Develop test plans for upgrades and project manage upgrade process

• Provide Tessitura and associated application training assistance for the staff

• Collaborate with users to develop processes, reports and data analysis tools that maximize Tessitura’s capabilities

• Document Tessitura customizations

• Enroll users in and maintain the Tessitura system security

• Participate in Tessitura application development processes to facilitate good database design and access

• Liaison to Tessitura Network for reporting and resolving Tessitura software bugs

• Participate in Seattle Tessitura community to stay current on Seattle arts community business practices

Working with the IT Administrator (10%)

• Install Tessitura software and upgrades

• Troubleshoot and maintain Microsoft SQL 2008 databases

• Plan, prepare and test backup and recovery procedures for all production databases

• Monitor production databases for efficiency

Desktop Support (secondary support) (5%)

• Installations, upgrades, troubleshooting and ongoing support of desktop computers, printers and peripherals.

• Maintain and enhance as required all PCs and Macs; administer machines to provide reliable campus network access, internet access and current application installations.

• Upgrade and enhance applications and operating systems software as required by departmental and campus requirements.

REQUIREMENTS:

• BS in computer science or equivalent experience in computer science or related field.

• Two or more years of database experience.

• Demonstrated experience with Microsoft SQL Server 2008 and T-SQL – including the creation and maintenance of stored procedures, views and tables

• Experience in SQL based reporting tools such as SSRS/ Visual Studio

• Possesses high level of initiative, strong leadership and project management skills.

• Superior interpersonal communication skills supporting staff of various levels of technical expertise and background

• Demonstrated ability to work independently and with minimal supervision.

• Experience in help desk or direct desktop support

Equivalent education/experience will substitute for all minimum qualifications except when there are legal requirements, such as a license/certification/registration.

DESIRED:

• Experience with Tessitura or other SQL based ticketing systems

• Working knowledge PCI Data Security Standard and application in a web environment

• Experience programming in Microsoft .NET and ASP, AJAX and HTML

CONDITION OF EMPLOYMENT:

Work Schedule:

• Daily schedule to be discussed; during normal business hours which includes overlap hours with IT Administrator.

• Must occasionally be available to work off-hours to deal with serious service outages, and have the ability to monitor services during evenings and weekends, as well as meet deadlines and accomplish projects that require greater than normal working hours.

Appointment to this position is contingent upon obtaining satisfactory results from a criminal background check

Application Process:

The application process for UW positions may include completion of a variety of online assessments to obtain additional information that will be used in the evaluation process. These assessments may include Work Authorization, Criminal Conviction History, Cover Letter and/or others. Any assessments that you need to complete will appear on your screen as soon as you select “Apply to this position”. Once you begin an assessment, it must be completed at that time; if you do not complete the assessment you will be prompted to do so the next time you access your “My Jobs” page. If you select to take it later, it will appear on your "My Jobs" page to take when you are ready. Please note that your application will not be reviewed, and you will not be considered for this position until all required assessments have been completed.

The University of Washington is a leader in environmental stewardship & sustainability, and committed to becoming climate neutral.

The University of Washington is an equal opportunity, affirmative action employer.

To request disability accommodation in the application process, contact the Disability Services Office at 206-543-6450 / 206-543-6452 (tty) or dso@uw.edu.

Apply for this job

var _gaq = _gaq

Similar jobs you might like