SQL Developer - DBA

The Wisconsin Alumni Association is Where Badgers Belong. Because you’re not just any alumni. You’re Wisconsin alumni.

- 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, hardware purchases - Review, audit and maintain permissions and security settings on WFAA databases

- Four year degree, or equivalent work experience - 2 or more years of experience as a Database Programmer. - Experience with Microsoft SQL Server Management Studio (SSMS), TSQL and Stored Procedures - Experience producing reports, vendor exports and other data related tasks. - Experience working with non-technical users. - Ability to manage multiple projects and tasks simultaneously - Dedicated to completing assigned tasks on time - Strong oral and written communication skills - Strong trouble shooting and problem-solving skills - Strong analytical skills - Strong leadership and decision making skills - Experience in a DBA role - Familiarity with SQL Server Profiler and server side tracing - Familiarity with SQL Server dynamic management views - Experience working with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) Cubes - 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