Database Administrator

Madison, City of • Madison, WI

13h

About The Position

The City of Madison Information Technology Department is hiring a Database Administrator to perform database administration for SQL databases, SQL Server Reporting Services, and SQL Server Integration Services, and to provide implementation and support for third-party applications. This is objective-level professional work supporting automated management information systems. The work involves independently applying professional skills to standardized development or support activities and contributing to more diverse team efforts. The position works under the general supervision of a senior-level professional or supervisor.

The role includes assisting the primary database administrator, maintaining database availability and performance, and supporting database infrastructure and related policies. It also involves configuring and supporting third-party applications, working with users and vendors, and contributing to smaller projects. The employee participates in an on-call rotation and may troubleshoot database outages after hours and on weekends. Work is primarily sedentary in an office environment. Interviews will be held in person. Telecommuting options are permitted within a two-hour drive of the City-County Building.

Requirements

• Four years of familiarity with RDBMS systems such as Microsoft SQL Server; client/server and n-tier applications and related issues; database design concepts and SQL; current Microsoft Windows desktop operating systems and database servers; SQL Server Reporting Services and SQL Server Integration Services; and Microsoft Windows Servers, VMWare, and Microsoft Azure.
• Familiarity with scripting languages such as T-SQL, .NET (VB or C#), JavaScript, or Python; Windows Server operating systems and server hardening practices; secure coding practices; and Microsoft Office Suite products.
• Alternatively, two 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 a degree in computer science or a related field.
• Ability to meet the transportation requirements of the position.
• Ability to work effectively with multicultural communities.
• Ability to determine customer needs and define project scope.
• Ability to develop realistic estimates, establish realistic schedules, and consistently meet deadlines.
• Ability to facilitate projects, recommend change, and communicate methods.
• Ability to work independently and manage multiple ongoing projects.
• Ability to work with users and project team members to resolve problems in a timely and effective manner.
• Ability to communicate and work effectively with users, department staff, vendors, and consultants.
• Ability to work well under pressure.
• Applicants must have proof of legal authorization to work in the United States; the City of Madison does not sponsor visas.

Responsibilities

• Assist the primary database administrator with database administration functions.
• Establish database backup processes and test backups in accordance with application needs.
• Work with staff to develop architectures that provide system availability according to application needs.
• Troubleshoot database outages, including after-hours and weekend incidents.
• Establish backup and availability requirements for new databases and systems with development teams.
• Install and configure new database servers.
• Deploy database change scripts supplied by third-party vendors.
• Investigate database performance issues and identify effective improvements, including hardware purchases, server configuration changes, or index and query changes.
• Manage database accounts and permissions according to City policies.
• Assist developers with database coding and design troubleshooting.
• Document the City's database environment and maintain and update database policies and guidelines.
• Upgrade the database environment to remain current with supported SQL versions.
• Document customer requirements through basic business analysis.
• Write, test, and implement software code while following standards for controls and security.
• Prepare user documentation and document application customizations.
• Configure application interfaces and workflows; test customizations and new functionality.
• Prepare and conduct data conversion tasks.
• Create digital reports for end users.
• Perform application administration, including setting up users, groups, and permissions.
• Facilitate remote vendor support and maintain documentation of on-premise application architecture.
• Troubleshoot user and system issues and coordinate resolutions with vendors.
• Serve as project manager and/or technical specialist on smaller projects.
• Write specifications for other staff and provide technical consultation and training to lower-level staff.
• Communicate with vendors, evaluate products, and participate in Requests for Proposals.
• Coordinate staff time within IT and City agencies for quality assurance testing, meetings, and application reviews.
• Develop and maintain management and operational analytic support tools, such as dashboards.
• Include racial equity and social justice considerations in projects and initiatives.
• Attend training and team meetings; prepare for and follow up on meetings.
• Maintain records of time spent, task progress, and new assignments.
• Communicate with customers, participate in analysis meetings, follow up for information, and keep customers informed of status according to applicable protocols.
• Participate in the on-call rotation.
• Perform related work as assigned.

Benefits

• Competitive benefits package
• Generous leave package
• Variety of insurance options at a low cost to employees
• Free bus pass
• Flexible work schedules
• Telecommuting options within a two-hour drive of the City-County Building
• The City of Madison is a qualified employer for the Public Service Loan Forgiveness Program

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level