· Be responsible for data conversions from legacy grant administration database to a new agency – wide system (DNR eGrants System).
· Develop scripts to convert grant program-specific datasets.
· Test and correct errors, and refine changes to database.
· Work collaboratively with System Architects to make changes to database management system.
· Determine impact of database changes on other system components.
· Modifies database procedures to increase processing performance, referred to as performance tuning.
· Stay up-to-date on business requirements and objectives, particularly as these relate to database architecture issues.
· Work onsite only (at the DNR central office in downtown Madison, WI) to complete tasks and assignments as directed and with moderate supervision with some latitude for independent judgement.
· Maintain excellent communication with Technology Services Section Chief, Project Manager and Business Analyst to ensure: 1) business requirements are met, 2) risks are identified and problem-solved, and 3) status updates are provided in a timely manner.
Qualification – Rating
Information Technology – Database Design
Database Tuning and Maintenance to assure highest level of system availability and performance – 1 (0 – Familiarity) of 5 (Expert) and 5 years
Information Technology – Databases
Data Flow & Structure Modeling - 1 (0 – Familiarity) of 5 (Expert) and 5 years
Entity relationships - 1 (0 – Familiarity) of 5 (Expert) and 5 years
Experience in Data Conversion projects - 1 (0 – Familiarity) of 5 (Expert) and 5 years
Knowledge of Oracle database management systems principles, techniques and capabilities – 5 years
MS SQL Server -1 (0 – Familiarity) of 5 (Expert) and 5 years
SQL server database administration expertise – 5 years
Stored procedures and triggers - 1 (0 – Familiarity) of 5 (Expert) and 5 years
Information Technology – Data Warehouse
Experience with ETL tools or an equivalent combination of training and/or experience with other data - 1 (0 – Familiarity) of 5 (Expert) and 5 years