Database Administrator

This position provides planning, development, implementation, upgrade, support, reporting, and access control for databases managed by the Division of State Patrol (DSP). In addition, this position serves as an administrator for SharePoint intranet and public facing web content. This position acts as the DOT Security Officer for the DSP and as part of a team of IT professionals who provide IT support of the sworn officers, dispatchers, and civilian staff of the Division of State Patrol.

This position works with a significant amount of independence and is responsible for making decisions regarding the direction of database support, security, maintenance, and reporting for the Division. In addition to the DOT Security Officer duties of user management, additional security responsibilities of this position include Active Directory Administration duties and SharePoint user permissions oversight.

This position is also part of a team that regularly conducts IT problem solving, testing, and planning. This position is called upon to provide remote and onsite support for critical IT functions during planned events and unplanned incidents.

Qualified candidates must meet all the following:

• Experience with administration of databases.

• Experience may include configuration of database servers/instances, troubleshooting technical database issues, database optimization, managing database backup jobs, and other related activities.

• Experience managing data from multiple sources.

• Experience may include facilitating collection of data, coordinating/troubleshooting data entry, auditing data input and results, and other related activities.

• Experience producing reports from multiple data sources.

• Experience may include identifying reporting needs, developing queries, extracting data, managing a data marketplace and other related activities.

In addition to all the above, well-qualified candidates must meet one or more of the following:

• Experience with Transact-SQL (T-SQL) scripting or stored procedure development including extract-transform-load (ETL) processes.
• Experience in the software development lifecycle.
• Experience optimizing reports through SQL indexing or query tuning.

WisDOT is a great place to work! In addition to meaningful and rewarding work, we offer a competitive benefits package featuring:

• Substantial leave time including at least 3.5 weeks of paid leave time to start, 9 paid holidays, and 130 hours of sick time that roll over each year.
• Excellent and affordable health, vision, and dental benefits (health plan options start at just $49/month for single plans and $122/month for family plans after two months of employment)
• A casual office atmosphere, flexible work schedules, and telework options depending on the position's requirements
• An exceptional pension plan with employer match and lifetime retirement payment, plus an optional tax advantaged 457 retirement savings plan
• Well Wisconsin Wellness Program
• A free and confidential employee assistance program that offers employees and their immediate family dependents a variety of tools, resources, and professional consultation services to support their health, goals, and overall well-being
• Use this Total Rewards Calculator to see the total value of our competitive benefits package!

In addition to our generous employee benefits, we strive for inclusivity and celebrate different religious holidays and cultural observances and provide flexibility for utilizing paid time off for such celebrations. For more information on WisDOT you can visit our website by clicking here., This position is in schedule-range (07-34) with an annual salary of $70,012-$99,257, plus excellent benefits. A twelve month probationary period is required. Pay for current state employees will be set in accordance with the Wisconsin State Compensation Plan.

Use your analytical skills and join the Department of Transportation's Division of State Patrol as a Database Administrator (IS Data Services Senior)! This position develops, supports, and upgrades databases managed by the Division of State Patrol. This position offers a hybridized work schedule. The position will be headquartered at and required to work from the Hill Farms State Office Building at 4822 Madison Yards Way, Madison, WI at least 1-2 days per week once fully trained. All employees working a hybrid work schedule are generally expected to telework from within the State of Wisconsin. This topic will be discussed more at the time of the interview.