Metropolitan Water Reclamation District of Greater Chicago

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.

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

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

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