- 6 active jobs (view)
Description
Overview
The Wisconsin Foundation and Alumni Association (WFAA)*, the private fundraising and alumni relations organization for UW-Madison, is recruiting for a SQL Developer / Database Administrator (DBA). In this role, you will be responsible for database and data warehouse development, query development, management reporting and database maintenance and optimization. This position is a hybrid role and will require you to work in our Madison, WI office location at least two days weekly.
Who is WFAA?
The Wisconsin Foundation and Alumni Association is a private, nonprofit corporation that encourages individuals and organizations to make gifts to the university and to connect with the UW. In 2014, the UW Foundation merged with the Wisconsin Alumni Association® to better serve a growing population of UW alumni and donors. We believe that private support grows out of good relationships between campus leaders, faculty and program staff who need support, and the alumni and friends who want to invest in UW–Madison. We provide important engagement opportunities to link UW–Madison alumni to each other and to their alma mater, building a strong community of Badgers.
Diversity and Inclusion:
Just as the university community benefits from differing viewpoints, perspectives, and experiences, inclusion and diversity are imperative for the success of our mission. WFAA values people and the differences that they bring to the organization, and creates an environment in which all staff members and constituents feel respected and have opportunities to thrive.
Essential Functions
- Develop, maintain and enhance reports, queries and data exports.
- Develop and test stored procedures, views and functions.
- Perform quality checks on reports and exports to ensure exceptional quality.
- Provide business users the data required for metrics and analysis.
- Develop new SQL Server Integration Services (SSIS) packages to meet business needs.
- Design and develop SQL databases and write applications to interface with SQL databases.
- Identify WFAA specific needs regarding database configuration and monitoring and work with third party DBAs from planning through implementation.
- Determine and implement effective ways to improve performance including index and/or query changes, database and/or server configuration changes, and hardware purchases.
- Review, audit and maintain permissions and security settings on WFAA databases.
Qualifications
Required Qualifications:
- Bachelor’s degree or equivalent work experience.
- 5+ years’ experience as a Database Programmer.
- 5+ years’ experience with Microsoft SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), TSQL, Stored Procedures, and SQL Server Integration Services (SSIS).
- Experience producing reports, vendor exports and other data related tasks.
- Experience working with non-technical users.
Other Qualifications:
- Experience in a DBA role.
- Familiarity with SQL Server Profiler and server side tracing.
- Familiarity with SQL Server dynamic management views.
- Experience in relational data modeling principles and techniques.
- Experience with XML, XSLT, and schema files.
- Experience in creation of automated unit test cases.
- Experience in automated builds.
- Familiarity in a fundraising or not for profit environment.
- Experience with CRM, ERP and/or Financial Reporting systems.
WFAA is committed to providing our employees with an environment that is inspiring, creative and respectful. We offer competitive pay and an excellent benefits program, which includes a 10% 401k contribution after 1 year of service!
The Wisconsin Foundation and Alumni Association is an Equal Opportunity Employer *The Wisconsin Foundation and Alumni Association (advanceuw.org) is the “doing business as” name of the merged organization comprising the University of Wisconsin Foundation (supportuw.org) and the Wisconsin Alumni Association (uwalumni.com). Its legal corporate name is registered as the University of Wisconsin Foundation.