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. The role is available on a hybrid work schedule with a requirement to work from the Hill Farms State Office Building 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.

• 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.

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

The 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. It also includes active-directory administration duties, SharePoint user-permissions oversight, and remote or onsite support during planned events and unplanned incidents.

• Experience with administration of databases: 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: facilitating collection of data, coordinating or troubleshooting data entry, auditing data input and results.
• Experience producing reports from multiple data sources: identifying reporting needs, developing queries, extracting data, and managing a data marketplace.
• Experience (preferred):
  • Transact-SQL (T-SQL) scripting or stored-procedure development, including extract-transform-load (ETL) processes.
  • Software development lifecycle experience.
  • Optimizing reports through SQL indexing or query tuning.

Annual salary range: $70, (depending on experience).

This state agency does not sponsor work visas and is not enrolled in USCIS E-Verify. Any appointment is contingent on proof of valid status to work in the United States.