Length of engagement: Full time. At least 1 year. Possibly 2-3.

Start: Immediate need. Looking to interview and start ASAP or by May 22, 2023.

Location: ~ 1 or 2 weeks on site to start onboarding, etc. at Milwaukee Police Department District 3 (2333 N 49th St, Milwaukee, WI 53210). Then can transition to remote if that is preferred. A typical remote day would start off with a kickoff call with the team lead.

Experience: Mid - Senior

Must have skills: SQL, XML, SSIS

Must be able to code to SQL Server 2000 thru SQL Server 2019
Must be able to write efficient SQL Queries (SQL Server and Oracle)
Must be able to monitor, Start, Stop, setup SQL Server Replication
Must be able to create and maintain SQL Server Agent Jobs
Must be able to write XML queries
Must be able to extract data from XML data types
Must be able to create and maintain SSIS packages

Nice to know how to use Toad for SQL, TOAD (For Oracle)
Nice to know Data Modeling (logical and Physical)
Nice to know how to setup and use Service Broker
Nice to know PowerShell scripting