Database Administrator*

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 (permitted within a 2-hour drive of the City-County Building, 210 Martin Luther King Jr. Blvd., Madison, WI 53703).  View a complete listing of benefits.  Consider joining our team! 

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.

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

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

• 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).

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

• 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 an IT Specialist 1 at the City of Madison. and

• Degree in computer science or a related field,. 

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

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, and copier. Must have the ability to view and interpret a map online.