SQL Developer - DBA

Wisconsin Foundation & Alumni Association

(Madison, Wisconsin)

Full Time

Job Posting Details

About Wisconsin Foundation & Alumni Association

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

Responsibilities

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

Ideal Candidate

- 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

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