Job Description

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: 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 Experience working with client/server or n-tier applications No experience Some experience, but less than 1 year 1 to 3 years of experience More than 3 years of experience 05 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 06 Experience writing queries or scripts using T-SQL Novice: Basic understanding of T-SQL; still learning and may need guidance for complex queries. Professional: Fluent and proficient; regularly writes and optimizes queries as part of daily tasks. Expert: Deep expertise; often consulted by others for solving complex problems or designing advanced queries. 07 Experience with ESRI suite of products No experience Experience as a user of ESRI tools Experience as an administrator of ESRI tools Expert experience as an administrator of ESRI tools, often consulted by others for solving complex problems 08 If you answered Yes to the previous question, what products or modules have you used and for how many years? 09 Experience with Python scripting No experience Some experience, but less than 2 years 2 years of experience, but less than 4 4 or more years of experience 10 Experience using FME scripting in your projects 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 integrating SQL Server data, ESRI maps, and web-based applications No experience Some experience, but less than 1 year 1 to 3 years of experience More than 3 years of experience Required Question City of Madison, WI

Job Tags

Holiday work, Permanent employment, Full time, Temporary work, Work experience placement, Self employment, Christmas work, New year, Remote job, Trial period, Flexible hours,

Similar Jobs