Job Details

ID #8302079
State Wisconsin
City Madison
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source MARS IT
Showed 2021-01-18
Date 2021-01-15
Deadline 2021-03-16
Category Et cetera
Create resume

Database Architect

Wisconsin, Madison, 53701 Madison USA

Vacancy expired!

Project Description:
  • The application database architect will work closely with an application development team and project manager to design, code, test, and migrate existing DB2 data into SQL Server as new web applications are developed and released.
  • Primary duties will be to work on two different databases (DB2 and SQL Server) including CDC and SSIS packages. Create SSIS packages to support CDC and perform ETL from CDC tables to History tables without losing any data. Depending on the candidate’s experience she/he may assist developing core backend .NET code using C#.
  • This candidate is required to analyze the current production database (DB2) and the new database (SQL Server), and work with the business unit to create requirements for data migration.
  • The candidate is also responsible for data migration leadership including: planning and migration execution of high-profile modernization projects, documenting database and migration processes, .NET and SSIS package development and creating data flow diagrams, developing strategies for data acquisitions, archive recovery, and cleaning and maintaining the database by removing and deleting old data.
  • The candidate will adhere to consistent data migration processes and must have experience in versatile software data ETL approaches. Project duties include SSIS, CDC, dry-runs, testing, quality reports, exception reports and production deployment processes.
  • Expert communication skills are required for ensuring requirements are understood by business units and the project team.

Candidates Must:
  • Have experience and expertise in leading large and complex data migration projects
  • Have In depth experience in SQL Server, T-SQL, Visual Studio, and C#
  • CDC and SSIS experience
  • Possess excellent communication skills and be a team player
  • Be self-organizing and proficient executing data migration activities independently, demonstrate extensive experience and judgment to plan and accomplish goals.

Vacancy expired!

Subscribe Report job