DATABASE ASSOCIATE

Recruitment #2301-4897-001

Introduction

Located on the western shore of Lake Michigan, Milwaukee is an urban hub bursting with energy. Milwaukee provides a casual sophistication – big city appeal without the big city hassles. We are accessible and affordable, and our residents are welcoming. Milwaukee has evolved through the years, bringing together its unsurpassed historic charm with a breathtaking Art Museum, top-flight arts and cultural attractions, professional sports, lakefront festivals, recreational opportunities, and great restaurants.

 

The City of Milwaukee is proud to employ a diverse workforce that is committed to providing exemplary service to the City’s residents. If you have a passion for being a part of an inclusive team of public servants, please consider the following opportunity.

Purpose

The Database Associate provides support for the Information and Technology Management Division (ITMD) Microsoft SQL Server database servers, storage, client software, and configuration to support and improve ITMD’s citywide database systems. The Database Associate maintains various mission-critical production databases. Working in a team environment, the person in this position continually employs strategies for improving the City’s database operating efficiency.

Essential Functions

Database Software Maintenance

  • Monitor and maintain database server hardware, virtualized servers, operating systems, and database software.
  • Provide functional support in areas such as user accounts, SQL queries, batch data loads, table and view definitions, and end-user support.
  • Provide general assistance, maintenance, backups, and database administration to City Departments.
  • Perform backup procedures for operating systems and databases to ensure recoverability.
  • Provide general assistance, maintenance, and database administration.
  • Safeguard the integrity of databases, including daily monitoring to ensure high availability of production and carrying out performance tuning and troubleshooting.
  • Recover and restore production, development, and test databases.
  • Perform relational database management system (RDBMS) tasks related to MS SQL Server and Oracle.
  • Create and maintain accurate documentation.
  • Write, edit, and test SQL batch files and use Procedural Language/Structured Query Language (PL/SQL).
  • Provide PeopleSoft application support to City end-users.
  • Schedule and automate database processing and tasks.
  • Stay apprised of changing technology; research and test application and support software and recommend infrastructural changes to improve the operating efficiency of the databases.

System Administration

  • Interact with vendors for efficient implementation/operation of new software products or systems and for resolution of any adaptation issues.
  • Interact with automation management, network administrators, system analysts, and software engineers to assist in resolving problems with software products or departmental software systems.
  • Interact regularly with managers, users, vendors, and agencies to field queries and questions.

We welcome qualified individuals with disabilities who are interested in employment and will make reasonable accommodations during the hiring process in accordance with the Americans with Disabilities Act (ADA) of 1990, as amended by the Americans with Disabilities Act Amendments Act (ADAAA) of 2008.

Conditions of Employment

Please be advised that new employees are required to have received either both doses of the Moderna or Pfizer or one dose of the Johnson & Johnson vaccine prior to their employment start date or have an approved religious or medical accommodation prior to their employment start date. You can find further information relative to the City’s COVID-19 Vaccination Policy here.

 

  • Must be able to respond to emergency call-outs for assistance after normal business hours.
  • Must be able to work for extended hours to respond to emergencies.

Minimum Requirements

  1. Bachelor’s degree in computer science, management information systems (MIS), mathematics, or a closely related field from an accredited college or university.
  2. Two years of professional experience administering, supporting, maintaining, and restoring SQL database applications, performing duties related to the essential functions of this position.

Equivalent combinations of education and experience may be considered. Note: Candidates with a master’s degree must have at least one year of professional experience as listed above.

 

NOTICE: Please do not attach your academic transcripts to your employment application. The hiring department will verify candidates’ education as part of the background screening process prior to extending any job offers.

Desirable Qualifications

  • Experience administering MS SQL Server database(s) and/or being an MS SQL Server Database Administrator (DBA).
  • Experience using MS Windows Server and Linux.
  • Experience managing servers in a storage area network (SAN) and virtual environment.
  • Related certifications, such as Microsoft SQL Server.

Knowledge, Skills, Abilities & Other Characteristics

Technical

  • Knowledge of and skill using SSRS (SQL Server Reporting Services).
  • Ability to administer, support, and maintain MS SQL Server databases.
  • Ability to use MS Windows Server and Linux.
  • Ability to generate database reports and queries.
  • Ability to manage servers in a storage area network (SAN) and virtual environment.
  • Ability to troubleshoot complex database-related issues.
  • Ability to create and maintain system documentation.
  • Ability to create detailed plans for testing and implementation that others can understand and use effectively.

Communication

  • Written communication skills and documentation skills to write general correspondence as well as detailed reports, specifications, and procedures that can be used to create programs and interfaces.
  • Verbal communication skills to be able to train and present technical information to users in a constructive and effective manner.

Interpersonal and Customer Service

  • Ability to interact with and work cohesively with other staff, department heads, officials, outside agencies and vendors.
  • Ability to work well independently and to function as part of a team.

Critical Thinking, Planning, and Judgment

  • Ability to meet strict deadlines to deliver database reports.
  • Ability to take initiative to solve complex problems with minimal supervision.
  • Ability to recognize when a problem must be addressed at a higher level.
  • Ability to remain calm under pressure and when responding to emergency situations.
  • Ability to maintain confidentiality and have high ethical standards.
  • Responsible stewardship of City of Milwaukee resources.

Current Salary

The current salary range (Pay Range 2GX) is $53,548 - $74,974 annually, and the resident incentive salary range for City of Milwaukee residents is $55,154 - $77,223 annually. Appointment above the minimum is possible based upon level of experience and other qualifications and is subject to approval.

 

The City of Milwaukee provides a comprehensive benefit program that includes the following:

  • Defined Benefit Pension Plan
  • 457 Deferred Compensation Plan
  • Health and Dental Insurance
  • Paid Parental Leave
  • Comprehensive Wellness Program
  • Onsite Clinic Services
  • Onsite Employee Assistance Program
  • Alternative Work Schedules
  • Long Term Disability Insurance
  • Group Life Insurance
  • Tuition Benefits
  • Paid Vacation
  • 12 Paid Holidays
  • Paid Sick Leave and other paid leaves
  • Flexible Spending Arrangement
  • Commuter Value Pass

For full details of the benefits offered by the City of Milwaukee, please visit https://city.milwaukee.gov/der/benefits.

Selection Process

THE SELECTION PROCESS will be job related and will consist of one or more of the following: an evaluation of education, experience and/or responses to supplemental questions; a written or performance test, a structured interview or other assessment methods. The Department of Employee Relations reserves the right to call only the most qualified candidates to structured interviews and performance examinations. Structured interviews may include written exercises. Selection process component weights will be determined by further analysis of the job.

 

INITIAL FILING DATE - The selection process will be held as soon as practical after the application deadline listed above. Receipt of applications may be discontinued at any time after this date without prior notice. However, recruitment may continue until the needs of the City have been met. Qualified applicants will be notified of the date, time, and place of the selection process components. Unless otherwise required by law, the City of Milwaukee will not provide alternative selection process dates or times. The applicant is responsible for attending all phases of the job selection process at the time and place designated by the City of Milwaukee.

Additional Information

  • Applications and further information may be accessed by visiting www.jobapscloud.com/MIL.
  • If you would like assistance completing an application, please contact the Department of Employee Relations at (414) 286-3751 or staffinginfo@milwaukee.gov.
  • The Department of Employee Relations is located at City Hall, 200 E Wells St, Room 706, Milwaukee, WI 53202

Conclusion

EEO CODE = 203

The City of Milwaukee values and encourages diversity and is an equal opportunity employer.



Click on a link below to apply for this position:

Fill out the Application NOW using the Internet. Apply Online