<div><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><font size="4"><font style="box-sizing:border-box; text-shadow:none; font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:bolder">108211- Programmer Analyst 6 - IT - DTMB - Agency Services - MDOT - state of MI </span></span></span> </font></font></span></span></span></div> <p style="margin-bottom:16px"><span style="font-size:13px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="color:#000000"><span style="font-family:sans-serif, Arial, Verdana, "Trebuchet MS", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol""><span style="font-size:16px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal">Position: Senior Oracle DBA</span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:16px"><span style="font-size:13px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="color:#000000"><span style="font-family:sans-serif, Arial, Verdana, "Trebuchet MS", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol""><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:700"><span style="font-size:16px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal">Location: Lansing, MI</span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:16px"><span style="font-size:13px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="color:#000000"><span style="font-family:sans-serif, Arial, Verdana, "Trebuchet MS", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol""><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:700"><span style="font-size:16px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal">Direct client: </span></span></span></span></span></span></span><span style="font-size:small"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="color:#1f1f1f"><span style="font-family:"Google Sans", Roboto, RobotoDraft, Helvetica, Arial, sans-serif"><span style="font-variant-ligatures:no-contextual">IT - DTMB - Agency Services - MDOT</span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:16px"><span style="font-size:13px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="color:#000000"><span style="font-family:sans-serif, Arial, Verdana, "Trebuchet MS", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol""><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:700"><span style="font-size:16px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal">Experience: 12+</span></span></span></span></span></span></span></span></span></span></span></span></span></p> <p style="margin-bottom:16px"><span style="font-size:13px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="color:#000000"><span style="font-family:sans-serif, Arial, Verdana, "Trebuchet MS", "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol""> Interview Process: MS Teams Video with integrated audio and camera ON.<br style="box-sizing:border-box; text-shadow:none; font-weight:normal" /> Duration: 1 year with likely extension.</span></span></span></span></span></span></p> <div><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal">Remote or On-site? LOCAL PREFERRED. Local candidates or able to relocate to MI immediately for a 2-day a week on-site presence. Please have the candidate SIGN hybrid work agreement. NO REMOTE ONLY. (<br style="box-sizing:border-box; text-shadow:none; font-weight:normal" /> <br style="box-sizing:border-box; text-shadow:none; font-weight:normal" /> <span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:bolder">Top Skills & Years of Experience:</span></span></span><br style="box-sizing:border-box; text-shadow:none; font-weight:normal" /> • Programming in Oracle PL/SQL and Toad., Required 8 years<br style="box-sizing:border-box; text-shadow:none; font-weight:normal" /> • Writing Oracle packages, procedures, and functions Required 8 years<br style="box-sizing:border-box; text-shadow:none; font-weight:normal" /> • Experience in developing and using web services, Required 8 years<br style="box-sizing:border-box; text-shadow:none; font-weight:normal" /> <br style="box-sizing:border-box; text-shadow:none; font-weight:normal" /> <span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:bolder">Job Description:</span></span></span></span></span></span> <p style="text-align:justify; margin-bottom:11px"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-size:11pt"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="line-height:15.6933px"><span style="font-family:Calibri, sans-serif"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial, sans-serif"><span style="background-image:initial"><span style="background-position:initial"><span style="background-size:initial"><span style="background-repeat:initial"><span style="background-origin:initial"><span style="background-clip:initial">Data developer within Oracle 19c database environment </span></span></span></span></span></span></span></span></span></span>This requisition is for an application data development expert with 8 or more years of experience. The position functions as a database developer within a team of technology professionals and is responsible for providing data management in support of all applications and services assigned to our team. Responsibilities include project and maintenance participation with expertise leading database development projects for tasks such as data design, writing procedures, packages, and functions associated with application data and services within an Oracle 19c database environment. This individual will work in coordination with Data Architects and the Database Administrators to create, test, and integrate agency specific data. This position is responsible for considerable knowledge of data development platforms and data development tools listed within the skills section. This position may report directly to a project lead, project manager, or manager. A wide degree of creativity and latitude is expected.</span></span></span></span></span></span></span></span></span></p> <span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"> </span></span></span></div> <div><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:bolder">Client Skill matrix</span></span></span></span></span></span></div> <div> <table style="box-sizing:border-box; text-shadow:none; font-weight:normal; border-collapse:collapse; width:919px" width="919"> <colgroup style="box-sizing:border-box; text-shadow:none; font-weight:normal"> <col style="box-sizing:border-box; text-shadow:none; font-weight:normal; width:540pt" width="720" /> <col style="box-sizing:border-box; text-shadow:none; font-weight:normal; width:149pt" width="199" /> </colgroup> <tbody style="box-sizing:border-box; text-shadow:none; font-weight:normal"> <tr> <td style="border-bottom:1px solid black; height:20px; width:720px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:1px solid black; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black">Skills</span></span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; width:199px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:1px solid black; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black">Candidate years of experience</span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial,sans-serif">Programming in Oracle PL/SQL and Toad, Required 8+ years</span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial,sans-serif">- Writing Oracle packages, procedures, and functions, Required 8+ years</span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial,sans-serif">- Experience in developing and using web services, Required 8+ years</span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial,sans-serif">- Designing, creating and maintenance of oracle database objects, Required 8+ years</span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial,sans-serif">- Normalizing database., Required 8+ years</span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial,sans-serif">- Designing logical and physical database model, Required 8+ years</span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial,sans-serif">- Data analysis and management, Required 8+ years</span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial,sans-serif">- Database programming experience in data migration and conversion practices, Required 8+ years</span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></td> </tr> <tr> <td style="border-bottom:1px solid black; height:21px; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:1px solid black"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Arial,sans-serif">- Experience in developing using ETL software such as DataStage or SAFE FME, Desired 4+ years</span></span></span></span></span></span></span></td> <td style="border-bottom:1px solid black; padding-top:1px; padding-right:1px; padding-left:1px; vertical-align:bottom; white-space:nowrap; border-top:none; border-right:1px solid black; border-left:none"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="box-sizing:border-box"><span style="text-shadow:none"><span style="font-weight:normal"><span style="font-family:Calibri,sans-serif"><span style="color:black"> </span></span></span></span></span></span></span></span></td> </tr> </tbody> </table> </div> <div> </div> <div> </div> <p style="margin-bottom:16px"> </p>