Database Architect
Database Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Title/Role: IDOPL Database Architect 4.
Worksite Address: Boise, ID
Agency Interview Type: In-Person
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.
Experience using database modeling and extraction tools and technologies.
Required 8 Years
Experience in coding data extract jobs.
Required 8 Years
Experience in coding data cleansing jobs and merging data from multiple databases
Required 8 Years
Experience with data migration processes and methodologies
Required 8 Years
SQL Server 2005, 2008 R2 & 2012
Required 5 Years
SQL Server Integration Services (SSIS)
Required 4 Years
Skills :
Employment Type
Full Time
