REQUIRED SKILLS: (Need Majority; 8+ Years)

• Advanced knowledge of Microsoft SQL Server (e.g., installation, configuration, support, and troubleshooting)
• SQL database administration (e.g., database security, SQL and/or PL/SQL tuning, report writing, scripting, and task automation)
• Effective and professional communication and interpersonal skills when dealing with a variety of customers, including executives
• Highly self-motivated with the ability to effectively prioritize and execute tasks with strong attention to detail

NICE TO HAVE SKILLS:

• Microsoft SQL Server certification or similar
• ITIL 4 Foundation certification or similar
• CompTIA A+ certification or similar
• PMP certification or similar

INTERVIEW PROCESS:

• Microsoft Teams interview with the camera on

DESCRIPTION OF ROLE:

Under the general guidance of the IT Operations Manager, this position is responsible for growing and operating the Information Technology program at the Wisconsin Department of Financial Institutions (DFI). This position serves as an expert resource and relies on extensive experience and judgment to plan and accomplish goals.

This role coordinates physical changes to computer databases; codes, tests, and implements them, applying knowledge of database management systems. It involves designing logical and physical databases, reviewing database design changes to understand impacts on data storage (location, space, access method), and establishing database parameters.

The role includes:

• Coding database descriptions and identifiers,
• Calculating optimal values for parameters (e.g., memory usage),
• Specifying user access permissions (e.g., insert, replace, retrieve, delete),
• Testing and correcting errors,
• Creating production databases,
• Monitoring database performance (e.g., distribution of records, memory usage),
• Directing developers and analysts on changes to DBMS,
• Reviewing and correcting code,
• Answering user questions,
• Coordinating with co-workers on cross-system impacts and cost estimates,
• Performance tuning, and
• Possibly training users.

The incumbent is expected to be familiar with a wide variety of IT concepts, practices, and technologies. This position may lead and direct the work of others. This position is headquartered at the Hill Farms State Office building in Madison, WI.