Career Opportunities



Refer Job: Send to a Friend
  • Share this on Facebook
  • Share this on LinkedIn

Add Add to Saved Jobs

Back
           

Database Administrator

Position Type: Full-time, Salaried

Department: Information Management Services Division (633 W. Wisconsin Ave.)

Compensation Range: $86,072.42 - $105,363.89
Closing Date: Open until filled, or upon recent of a sufficient pool of qualified applicants

Job Summary: Provide day-to-day support and related enhancements for Milwaukee County’s enterprise applications, technology, and related system integrations. Additional responsibilities include development of in-house knowledge and intellectual property for key business processes, data, and supporting applications and providing project support as required. 

 

Job Responsibilities:

  • Designs database for software solutions by studying information needs; conferring with project team; studying systems flow, data usage, and work processes; investigating problem areas. Creates technical database design documents.  Determines operational feasibility.    

  • Improves operations by conducting systems analysis Partners with user agencies to make government process more efficient through data processing re-engineering, data workflow automation, data integration, and enhanced business intelligence.

  • Prepares and writes integrations, store procedure, views, triggers, ETLs, Reports and utilities. Responsible to work with Software Engineers in supporting full stack software engineering and development. Oversees database aspects of vendor created custom software.

  • Researches and recommends the use of new database technologies and techniques. Keeps informed on changes in technology.

  • Works with the and acts as Technical DBA in database tuning, deployment, and scheduling. Reviews user requests for service. Analyzes integration, reporting and database malfunctions.

  • Protects operations by adhering to Security Best Practices. Designs and implements database solutions, reports, and integrations, which will maintain the integrity of Milwaukee County data. Maintains SDLC on database systems.

  • Documents ELT test procedures and participate in software development process to perform all tests on database designs, and ETLs. Coordinates database and ETL testing and assists Business Analyst with user acceptance testing

  • Provides end user, Business Annalists, and Project Managers, with technical information and advise on database systems. Serves as a database technical resource on various project committees and meetings. Mentors and trains team members.

  • Supports system during non-business hours, both by being reachable, and by participating in an n call process Completes all administrative tasks required for the position.

  • Completes other duties as asigned.

Minimum Qualifications

Associate degree or higher in IT related field or at least 60 credits in an IT related degree program. Bachelor’s degree in Computer Science, MIS, or Business strongly preferred.

  • Within a Microsoft environment knowledge of full stack development

    • At least three years of practical experience working with applications systems and solutions

    • At least three years of practical experience working with Microsoft SQL Server Integrated Services (SSIS)

    • At least three years of practical experience working with Microsoft SQL Server Reporting Services (SSRS) 

  • At least three years of practical work experience in Microsoft SQL Server Database Administration, five or more years preferred.

  • Possession of a valid Wisconsin driver’s license required at time of application and maintained during incumbency.

Knowledge, Skills and Abilities:

  • Ability to administer a variety of database systems including DB2, Microsoft SQL Server. Ensure databases are tuned and maintained for optimal performance.

  • Thorough knowledge of the principles and practices of data processing, office automation, and computer programming

  • Use of Structured Query Language (SQL)

  • Thorough knowledge of the principles and practices of systems analysis.

  • Organizing work to meet deadlines; Establishing and maintaining effective working relationships. 

 

Special Instructions: The Original Examination is open to all applicants authorized to work in the United States. Upon hire, candidate will have six months to reside in the state of Wisconsin.  In accordance with Rule III Section 11 of the Civil Service Rules a non-competitive examination will be held for this position. The non-competitive examination will consist of a review of candidate materials, education and related experience.

Milwaukee County offers a comprehensive blend of benefits designed to make your life better both inside and outside of the workplace. Milwaukee County conducts criminal background checks and pre-employment drug testing.

A. Nixon Org. 1160


     
Milwaukee County is an Equal Opportunity/E-verify employer committed to diversity and all qualified applicants will receive consideration for employment and will not be discriminated against based on age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability genetic information or protected veteran status. We maintain a drug-free workplace and perform pre-employment substance abuse testing, background checks and pre-employment physicals subject to job requirements. If special accommodations are needed, please contact 414-278-3936.