GIS and Database Administrator

Salary : $76,903.32 - $91,258.70 Annually

Location : Madison, WI

Job Type: PERMANENT FULL TIME

Job Number: 4

Department: Information Technology Department

Opening Date: 01/06/2025

Closing Date: 1/21/:59 PM Central

Comp. Group/Range: 18/08

General Description

Are you looking for a full-time IT job that works less than 40 hours per week?

Do you have technical experience with database administration and/or GIS?

The City of Madison Information Technology Department is looking to hire an entry-level GIS and Database Administrator to perform database administration and GIS support work. This is objective level professional work in the support of automated management information systems. This 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 Team Leader (Principal IT Specialist).

This series is structured to provide advancement from an IT Specialist 2 to an IT Specialist 3, as a function of the employee's career development and generally occurs after two years.

The City of Madison offers a competitive benefits package, including a generous leave package, a variety of insurance options at a low cost to employees, and non-traditional benefits such as a free bus pass, flexible work schedules and telecommuting options. View a complete listing of benefits. Consider joining our team.

The City of Madison is a qualified employer for the .

Black, Indigenous, people of color, women, trans, nonbinary, and individuals with disabilities are encouraged to apply. We value the unique blend of lived experiences and diverse perspectives that comes from non-traditional education pathways and the variety of transferrable skills each candidate brings to the table. We value diversity, equity, inclusion, and belonging. Even if every item on the job posting doesn't match your experience perfectly, we encourage you to apply and share how your skills and experience can best serve our community.

Examples of Duties and Responsibilities

Database Administrator:

• Support processes to ensure databases are backed up, and test backups, in accordance with application needs.
• Work with Server Administrators 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.
• Support 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.

GIS Support:

• Support the GIS/ESRI environment:

• Administer licenses
• Set-up permissions
• Manage desktop versions
• Manage back-end versions
• Manage integrations
• Provide documentation
• Perform scripting
• Perform business analysis

• Support by assisting in publishing new data.
• Support Publishing of Maps and Apps.
• Serve as the Main Point of Contact with ESRI.

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 professional information technology experience in two (2) of the following three (3) areas:
  • RDBMS systems, such as Microsoft SQL, TSQL language and database servers.
  • ESRI suite of products.
  • Python and/or FME scripting.

Familiarity with the following:

• Client/server and n-tier applications and issues related to them.
• Windows 10/11 desktop Operating System.
• Microsoft Office Suite of products.

OR

• Two (2) years of professional experience in two (2) of the three (3) areas noted above, 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 Requirements

Ability to meet the transportation requirements of the 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, copier, and fax machine. 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.

Compensation

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

Leave

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

Retirement

The City of Madison participates in the Wisconsin Retirement System through the State of Wisconsin Department of Employee Trust Funds.

Insurance

The 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

For the following questions, please share your experience working with each item.

• My responses are noted below and supported by related descriptions within the Work Experience section of my application.

02

Do you have experience using the Microsoft Office Suite of products?

• Yes
• No

03

Do you have experience with Windows 10/11 desktop operating system?

• Yes
• No

04
. click apply for full job details