Metropolitan Water Reclamation District of Greater Chicago

Database Analyst (#20004210)

General Statement

Under supervision, directs, evaluates, reviews, and manages database resources and services across the District while ensuring high levels of data quality; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Essential Job Functions

Essential job functions are fundamental, core functions common to positions in a classification. They are not intended to be an exhaustive list of all job duties for any one position in the class. Since class specifications are designed to be descriptive and not restrictive, incumbents may complete one or all of the job duties listed or tasks of similar kind not specifically listed here.

  • Participates in the design and development of new databases; assists with the installation and testing of new databases.
  • Modifies existing databases and database management systems; tests programs or databases and corrects errors; performs system upgrades as needed.
  • Develops, tests and implements SQL program code and application code for use with databases.
  • Defines, reviews and implements database backup and recovery strategies.
  • Plans, coordinates and implements appropriate security, indexes, access controls, constraints, triggers and other database-related features to safeguard database against accidental or unauthorized damage, modification or disclosure.
  • Monitors performance of application programs with respect to associated databases and performs required performance tuning actions to ensure database stability and efficiency; recommends changes to data storage practices to optimize efficient use of space and prevent unnecessary database growth.
  • Works with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
  • Develops long-term goals for production databases in conjunction with data owners and department managers.
  • Conducts research and makes recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
  • Analyzes user requirements for reports, forms, queries, and data extraction.
  • Develops and deploys end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes.
  • Creates and documents models for new database development and/or changes to existing ones through data flowcharting and entity relationship diagrams.

Other Job Functions

  • Provides after hours and weekend support when required.
  • Performs other duties as assigned.

Environmental Conditions

Work is performed in a typical office environment and requires the use of standard office equipment including computers.

Desirable Knowledge, Skills and Abilities

  • Knowledge of the principles, procedures and methodologies relating to database design, control, administration and usage in support of application systems.
  • Knowledge of the operating characteristics and limitations of common computer hardware and software utilized by the District.
  • Skill in writing SQL scripts for queries.
  • Ability to troubleshoot and resolve operational issues related to databases.
  • Ability to work in a team-oriented, collaborative environment.
  • Ability to communicate effectively, orally and in writing.

Minimum Qualification Requirements

Graduation from a four-year accredited college or university majoring in information technology, computer science or a closely related field.


Full-time paid experience in database development and/or administration may be substituted for the required education on a year-for-year basis. A Microsoft MCITP SQL Server certification may be substituted for one year of the required education.

Promotional Requirement

  • Possession of a bachelor’s degree in information technology, computer science or a closely related field.
  • One year of service with the District as an IT Support Analyst II, IT Support Analyst I, Systems Support Specialist II, Administrative Assistant, Administrative Specialist, Human Resources Assistant, Secretary or Senior Administrative Specialist.
  • Civil service status in one of the foregoing classifications.

CLASS: 20004210; EST: 1/1/2016; REV: 1/1/2019;