Database Administrator

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.

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 rollover each year.
• 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
• 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

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.

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.

This state agency does not sponsor work visas. This state agency is not enrolled in USCIS E-Verify and is not eligible to employ international F-1 students seeking STEM-OPT extension. Any appointment made will be contingent on the applicant being able to prove valid status to work in the United States.

A comprehensive background investigation will be conducted as part of the recruitment process for top candidates. The background investigation will seek and obtain information and records pertaining to your background as it relates to the job, whether such information is public, private, favorable, unfavorable, or confidential in nature. Background investigations may include but are not limited to: FBI fingerprinting and criminal history, driving/motor vehicle history, present and former employers, military service, and any private citizen who may be able to speak to your qualifications.

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.