Salary : $79,210.30 - $93,996.50 Annually
Location : City County Building 210 Martin Luther King Jr. Blvd., Madison, WI
Job Type: PERMANENT FULL TIME
Remote Employment: Flexible/Hybrid
Job Number:Department: Information Technology
Opening Date: 10/26/2026
Closing Date: 11/3/2026 11:59 PM Central
Comp. Group/Range: 18/08
General DescriptionAre you looking for a full-time IT job that works less than 40 hours per week?
Do you have technical experience with database administration? The City of Madison Information Technology Department is looking to hire a Database Administrator to provide database administrator duties for SQL databases, SQL Server Reporting Services, and SQL Server Integration Services, along with providing implementation and support services for third party applications. This is objective level professional work in the support of automated management information systems. The work is characterized by the independent application of professional skills in providing standardized developmental or support activities, and/or serving as a contributing member on more diverse team efforts. Work is performed under the general supervision of a senior level professional or supervisor.
Please note: interviews will be held in person for this position.
The City of Madison is a qualified employer for the .
Examples of Duties and Responsibilities Database Administration:- Assist primary database administrator in all database administrator functions.
- Establish processes to ensure databases are backed up, and test backups, in accordance with application needs.
- Work with appropriate staff to develop architecture to ensure high availability of systems according to application needs.
- Troubleshoot database outages as they occur, including after hours and weekends.
- As new databases and system are brought online, work with development team to set up appropriate backup and availability requirements.
- Install and configure new database servers.
- Deploy database change scripts provided by third party vendors.
- As performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
- Manage database accounts and permissions following the City's policies.
- Assist developers in troubleshooting database coding and design issues.
- Document the City's database environment.
- Maintain Database Policies and Guidelines, updating as needed.
- Perform continuous upgrade of database environment to stay current with supported versions of SQL.
Implementation and Support of Third Party Applications:- Perform basic business analysis to document customer requirements.
- Write, test, and implement software code.
- Adhere to standards to ensure proper controls and security within code modules.
- Prepare documentation for users.
- Document customizations.
- Configure application interfaces and workflows.
- Test customizations and new functionality.
- Prepare and conduct data conversion tasks.
- Create digital reports for end users.
- Conduct administrative functions - setting up users, groups, permissions, etc.
- Facilitate remote vendor support and manage on-premise application architecture documentation.
- Troubleshoot user and system issues and coordinate with vendor to resolve.
Serve as Project Manager and/or Technical Specialists on smaller projects- Perform basic business analysis to document customer requirements.
- Write specifications to be used by other staff.
- Provide technical consultation and training to lower level staff.
- Communicate with vendors; evaluate products; and participate in Requests For Proposals (RFPs).
- Coordinate staff time within IT and in other City agencies for quality assurance testing, meetings, and review of software applications.
- Develop and maintain management and operation analytic support tools (ex. dashboard).
Internal Administrative Tasks:- Include racial equity and social justice considerations in projects and initiatives.
- Attend training on technologies and other required job skills as needed.
- Attend Team Meetings - prepare and follow up, participate in meetings.
- Perform recordkeeping such as time spent on various tasks, tracking progress on tasks and recording new assignments.
- Communicate with customers by participating in analysis meetings, following up for information via email or phone, keeping customers apprised of status, all by following protocols that may be particular to a customer or project.
- Participate in on-call rotation.
Perform related work as assigned.
Minimum Qualifications - Four (4) years of familiarity with the following:
- RDBMS systems, such as Microsoft SQL Server:
- Client/server and n-tier applications and issues related to them.
- Database design concepts and SQL skills;
- Current Microsoft Windows desktop operating systems and database server.
- SQL Server Reporting Services and SQL Server Integration Services.
- Microsoft Windows Servers, VMWare, and Microsoft Azure.
- Familiarity with the following:
- Scripting languages such as T-SQL, or .NET (VB or C#), or Javascript, or Python.
- Windows Server operating systems and server hardening practices.
- Secure coding practices.
- Microsoft Office Suite of products.
OR- Two (2) years of professional programming, software support and database administrator experience comparable to that gained as anat the City of Madison. and
- Degree in computer science or a related field,.
The City of Madison strives to provide exceptional customer service to all its residents and visitors. Therefore successful candidates will have demonstrated ability to effectively work with multicultural communities, and have the ability to do the following:- Determine customer needs and define the scope of projects.
- Develop realistic estimates, establish realistic schedules and meet deadlines on a consistent basis.
- Facilitate projects, recommend change and communicate methods.
- Work independently, manage multiple projects on an ongoing basis.
- Work with both users and project team members to resolve problems in a timely and effective manner.
- Communicate and work effectively with users, department staff, vendors, and consultants.
- Work well under pressure.
For a complete list of the Knowledge, Skills, and Abilities, please see the class specification for .
Special RequirementsAbility to meet the transportation requirements of the position.
Please note: The City of Madison does not sponsor visas. Applicants must have proof of a legal right to work in the U.S. to be considered for this position.
Physical Requirements:
Work is primarily sedentary in nature and performed in an office environment. Employees will be expected to use standard office equipment such as a telephone, computer, calculator, and copier. Must have the ability to view and interpret a map online.
* The payroll title is IT Specialist 2.
The City of Madison offers excellent pay and benefits for employees. City Ordinances, handbooks, and labor contracts provide specifics; the description here is not to be considered a binding statement but offers an informal summary.
CompensationThe City of Madison strives to pay competitive wages. View the current for pay for all classifications. Employees receive increases based on tenure with the City.
Benefits The City offers a competitive benefits package, including a generous leave package, a variety of insurance options, and non-traditional benefits such as optional pet insurance, a bus pass for all employees, and the possibility of flexible work schedules. A brief summary of benefits is listed below. Please visit our for more information.
LeaveVacation is earned upon starting employment and can be used after completion of probation. The general vacation schedule is below.
0-3 years 10 work days of vacation
After 3 years 12-1/2 days
After 7 years 15 days
After 11 years 17-1/2 days
After 15 years 20 days
After 19 years 25 days
After 27 years 27 days
Employees earn 3.5 personal days in addition to vacation.
Employees receive eight official paid holidays (New Year's Day, Martin Luther King, Jr. Holiday, Memorial Day, Juneteenth, Independence Day, Labor Day, Thanksgiving, Christmas Day), as well as 3 paid leave days (the Friday after Thanksgiving, Christmas Eve, New Year's Eve).
Employees also earn 13 sick days annually that may accrue to a total of 150 days.
RetirementThe City of Madison participates in the Wisconsin Retirement System through the State of Wisconsin Department of Employee Trust Funds.
InsuranceThe City of Madison offers a variety of optional insurance programs including:
- Health Insurance
- Dental Insurance
- Vision Insurance
- Pet Insurance
- Life Insurance
- Income Continuation Insurance (for short and long-term disability)
- Long Term Care Insurance
Other Benefits The City offers numerous other benefits and programs for employees, including:
• 457(b) deferred compensation plans
• Employee Assistance Program
• Bus Pass on Madison Metro
• Flexible Work Schedules
• Employer-paid Training
01
How much experience do you have managing Microsoft SQL Server databases? This includes backups, keeping systems running, fixing outages, tuning performance, managing user access, and upgrades.
- No experience
- Some experience, but less than 2 years
- 2 to 4 years of experience
- More than 4 years of experience
02
What is the newest version of SQL Server you have worked with hands-on?
- SQL Server 2022 or newer
- SQL Server 2019
- SQL Server 2017 or 2016
- SQL Server 2014 or older
03
Which statement best describes how you keep your technical skills up to date?
- I prefer to keep using the proven tools and methods I already know.
- I learn new technologies when my job needs them.
- I look for new technologies to learn on my own.
- I'm not sure.
04
Indicate your experience supporting vendor-made software applications. This includes setting them up, working with the vendor to fix problems, loading data into them, and building reports from them.
- No experience
- Some experience, but less than 2 years
- 2 to 4 years of experience
- More than 4 years of experience
05
Which best describes how you manage your project work?
- I keep my own to-do list or calendar.
- I use a shared project or ticket tool and a set method, like Agile or Waterfall.
- I use a shared project or ticket tool, without a set method.
- I don't use tools or methods.
06
Experience with relational database systems (e.g., Microsoft SQL Server).
- No experience
- Some experience, but less than 2 years
- 2 years of experience, but less than 4
- 4 or more years of experience
07
Experience working with client/server or n-tier applications
- No experience
- Some experience, but less than 2 years
- 2 to 4 years of experience
- More than 4 years of experience
08
Experience with database design concepts
- No experience
- Less than 2 years of experience
- 2 to 4 years of experience
- More than 4 years of experience
09
Experience with current Microsoft Windows desktop operating systems and database server?
10
Experience with SQL Server Reporting Services and SQL Server Integration Services.
- No experience
- Some experience, but less than 2 years
- 2 years of experience, but less than 4
- 4 or more years of experience
11
Experience with Microsoft Windows Servers, VMWare, and Microsoft Azure.
- No experience
- Some experience, but less than 2 years
- 2 to 4 years of experience
- More than 4years of experience
12
Experience with scripting languages such as T-SQL, or .NET (VB or C#), or Javascript, or Python?
13
Experience with Windows Server operating systems and server hardening practices?
14
Experience with secure coding practices?
15
Experience using the Microsoft Office Suite of products?
Required Question
