What are the responsibilities and job description for the GIS and Database Administrator position at City of Madison, WI?
Salary : $76,903.32 - $91,258.70 Annually
Location : Madison, WI
Job Type : PERMANENT FULL TIME
Job Number : 2024-00454
Department : Information Technology Department
Opening Date : 01 / 06 / 2025
Closing Date : 1 / 21 / 2025 11 : 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 :
Internal Administrative Tasks :
Perform related work as assigned.
Minimum Qualifications
RDBMS systems, such as Microsoft SQL, TSQL language and database servers.
Client / server and n-tier applications and issues related to them.
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 :
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 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 :
Other Benefits
The City offers numerous other benefits and programs for employees, including :
For the following questions, please share your experience working with each item.
Do you have experience using the Microsoft Office Suite of products?
Do you have experience with Windows 10 / 11 desktop operating system?
Experience working with client / server or n-tier applications
Experience with relational database systems (e.g., Microsoft SQL Server)
Experience writing queries or scripts using T-SQL
Experience with ESRI suite of products
If you answered Yes to the previous question, what products or modules have you used and for how many years?
Experience with Python scripting
Experience using FME scripting in your projects
Experience integrating SQL Server data, ESRI maps, and web-based applications
Required Question
Salary : $76,903 - $91,259
