Database Administrator

Metropolitan Water Reclamation District of Greater Chicago Database Administrator (#)

Under direction, designs, implements, administers, and maintains the District’s relational database systems that support the functional requirements of the application systems used by the operating departments; and develops, implements, and oversees database policies and procedures to ensure the integrity and availability of databases and their accompanying software.

Notify Me when a Job Opens for the above position(s)

• Evaluates user requests for development of new databases or modifications to existing databases; determines scope of work and timeline for projects; serves as the technical lead on more complex projects.
• Assesses and develops long‑term strategic goals for production databases in conjunction with data owners and department managers.
• Leads the design and development of new databases; assists with 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.
• Provides technical support to other analysts and technical staff related to database design and administration; troubleshoots more complex database issues.
• Works with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Designs and implements redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• Performs database transaction and security audits.
• Creates, or supports creation of, required reports in response to business user needs.
• Provides support for standard business analysis tools such as Microsoft Power BI.
• Provides support to analysts in day‑to‑day activities including the review of work products for accuracy.

• Performs other duties as assigned.

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

• Thorough knowledge of the principles, procedures and methodologies relating to database design, control, administration and usage in support of application systems.
• Thorough knowledge of data processing flowcharting techniques and entity relationship diagrams.
• Knowledge of the operating characteristics and limitations of common computer hardware and software utilized by the District.
• Knowledge of applicable data privacy practices and laws.
• Knowledge of data analytics practices and concepts.
• Skill in writing SQL scripts.
• Ability to troubleshoot and resolve operational issues related to databases.
• Ability to communicate effectively, orally and in writing.

Graduation from a four‑year accredited college or university majoring in information technology, computer science or a closely related field and two years of experience in database development and/or administration.

Graduate study in computer science or a closely related field may be substituted for the required experience on a year‑for‑year basis to a maximum of two years. Additional professional 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 or experience.

• Two years of service with the District as a Database Analyst or an IT Support Coordinator, or four years of such service as an IT Support Analyst II.
• Civil service status in one of the foregoing classifications.