Candidates MUST be WI residents or willing to relocate to WI at their own expense prior to starting. This position can work 100% remotely (within the state of WI).

HIGH PREFERENCE GIVEN TO CANDIDATES ALREADY IN WISCONSIN, RELO CANDIDATES DONT GET INTERVEIWS

ALL REMOTE WORK MUST BE DONE IN WISCONSIN, NO EXCEPTIONS

THE FOLLOWING ARE REQUIRED TO SUB. IF I DONT HAVE THEM I WILL REJECT:

• Coversheet
• R2R with VMS ID (SAVED PDF SHOWING DATE AND TIME)
• Clean Formatted Resume (No more than 5 pages)
• Screenshot of candidate email acknowledging review the following 3 attachments to this req: Technical Requirements for Internet Connection, IRS 1075 Exhibit 7, and Contractor Norms Best Practices

Job description:

The recruitment is seeking an experienced application database architect who will work closely with an application development team and project manager in the Enterprise section to design, code, test, and migrate existing DB2 data into SQL Server as new web applications are developed and released. The individual in this position will:

• Work on and analyze two different database, DB2 and SQL Server
• Create SSIS packages to support CDC
• Perform ETL from CDC tables to history tables without loss of data
• Collaborate with business analyst, project manager, and program area stakeholders to define requirements for data migration
• Plan and execute migration of high-profile modernization projects
• Document database and migration processes
• Develop .NET and SSIS packages
• Create data flow diagrams
• Develop strategies for data acquisitions and archive recovery
• Clean and maintain database by removing and deleting old data
• Adhere to consistent data migration processes
• Develop, implement, and optimize in-application SQL statements, stored procedures and functions
• Have strong proficiency with SQL and experience with Visual Studio, C#, CDC and SSIS
• Create database triggers for use in automation
• Have experience and expertise in leading large and complex data migration projects

The database architect is expected to work with minimal supervision, have strong communication and leadership skills, and be a team player. They are expected to demonstrate exceptional judgement based on experience to plan and accomplish data migration goals. Hands on technical expertise and development is required.

Prior experience building and supporting Collection-focused web applications, such as Benefits Recovery Investigation Tracking System (BRITS), and experience with the referral/investigation lifecycle and claims processing is required.

Top 3-4 desired skills required for the position:

• Strong technical mastery of creating SSIS packages to support CDC.
• Experience analyzing and loading with both DB2 and SQL Server.
• Experience building and supporting Collection-focused web applications and experience with the State of Wisconsin referral/investigation lifecycle and claims processing.

Additional Details :

Projected Start Date : 2024-07-01T00:00:00

Projected End Date : 2025-06-30T00:00:00

Client Company : State Of Wisconsin

Vendor Pay Rate : 47

Selling points for candidate :

Face to face interview required : No

Candidate must be authorized to work without sponsorship : No

Background Check : No

Drug Screen : No