Job Description :
Role: Database Architect
Location: Madison, WI
Duration: Long Term

Designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Must be able to design, develop and manipulate database management systems, data warehouses and multidimensional databases. Requires a depth and breadth of database knowledge that will help with formal design of relational databases and provides insight into strategic data manipulation. Database Architect capabilities with 8+ years of experience, independently designs and builds relational databases. Develops strategies for data acquisitions, archive recovery, and implementation of a database. Cleans and maintains the database by removing and deleting old data. Familiar with a variety of the field''s concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals. Performs a variety of tasks. A wide degree of creativity and latitude is expected. This contracted resource will provide data and database architect assistance primarily for mortality, morbidity and enhanced state surveillance on opioids data infrustructure development and support efforts. The Office of Health Informatics manages the Enhanced State Surveillance on Opioid Involved Mortality and Morbidty grant and is responsible for reporting mortality and morbidity statistics for public health surveillance. As time and funding permit, this resource will also perform similar functions for other IAS projects, as assigned.


Information Technology - Databases
Create database objects • 6 years
Creating, reviewing and tuning SQL scripting 6 years
Data analysis • 6 years
Data flow diagramming • 6 years
Data structure diagrams • 6 years
SQL Server • 6 years
SQL Server Management Studio • 6 years
Stored procedures and triggers • 6 years
Working knowledge of SQL Server T-SQL • 6 years
Nice to Have
Information Technology - Databases
Data migration and archiving • 4 years
ERwin • 4 years
Knowledge of Oracle PL/SQL • 4 years
Migration tools • 4 years
Oracle 12c • 4 years
Oracle PL/SQL unit testing •4 years