IDOPL Database Architect 4

Working with existing databases and contractors to prepare for Data Migration, cleansing, and validation in a new system,

The Idaho Division of Occupational and Professional licenses (DOPL) is an organization that has combined 11 former agencies into one new Division.

DOPL has 11 licensing systems and a handful of content management systems used to store historical documentation. We will be moving to one consolidated licensing system. DOPL is in the final phases of a contract award for a new consolidated licensing system.

This position will assist with identifying appropriate data fields in existing databases to be used for data migration to a new database, working with contractors of existing systems to ensure all data is captured, working with DOPL's new system contractor to ensure data is extracted, provided to the new contractor in an agreed upon format, assist with data cleansing, and validation that the data has been imported into the new system correctly.

This position will work with a team at DOPL that includes a project manager, business analysts, quality assurance testers, subject matter experts and database staff from the State of Idaho's Information and Technology Services agency.



RELEVANT WORK EXPERIENCE: 9 or more yrs.
Required/Desired Skills
SkillRequired /DesiredAmountof ExperienceExperience using database modeling and extraction tools and technologies. Required8YearsExperience in coding data extract jobs.Required8YearsExperience in coding data cleansing jobs and merging data from multiple databasesRequired8YearsExperience with data migration processes and methodologiesRequired8YearsSQL Server 2005, 2008 R2 & 2012 Required5YearsSQL Server Integration Services (SSIS) Required4Years
Questions
No.QuestionQuestion1Please list candidate's email address.Question2NA not to exceed NA. Do you accept this requirement? Question3This position is required to be on-site, 5 days a week between 8 am and 5 pm mtn time. Do you accept this requirement?