Talent.com
Database Analyst
Database AnalystMetropolitan Water Reclamation District of Greater Chicago • Chicago, IL, USA
Database Analyst

Database Analyst

Metropolitan Water Reclamation District of Greater Chicago • Chicago, IL, USA
30+ days ago
Job type
  • Full-time
Job description

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 with an associate's degree from an 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.

Substitution

Graduation from a four-year accredited college or university majoring in information technology, computer science or a closely related field may be substituted for the minimum qualifications in their entirety. 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.

Promotional Requirement

  • One year of service with the District as an IT Support Analyst II; or possession of an associate's degree in information technology, computer science or a closely related field and one year of service with the District as an IT Support Analyst I, Administrative Assistant, Administrative Specialist, Secretary or Senior Administrative Specialist.
  • Civil service status in one of the foregoing classifications.
Create a job alert for this search

Database Analyst • Chicago, IL, USA

Similar jobs

Business Analyst

ReleadyChicago, IL, United States
Temporary

This role is focused on turning data into clear, actionable insights through dashboards and reporting.You'll work closely with business stakeholders to understand what questions need to be answered...Show more

 • Promoted

Principal Data Analyst

Capital One Financial CorpChicago, IL, United States
Full-time +1

At Capital One, data is at the center of everything we do.When we launched as a startup we disrupted the credit card industry by individually personalizing every credit card offer using statistical...Show more

 • Promoted

Data Analyst

The Hiring Method LLCChicago, IL, United States
Full-time

Chicago, IL (preferred) or Oakville, ON (Canada).Hybrid (2 days onsite / 3 days remote).Medical, Dental, Vision, HSA, Medical & Dependent Care FSAs, company-paid Short- & Long-Term Disability and L...Show more

 • Promoted

IBM MDM Database Analyst/Developer

NavtechChicago, IL, United States
Full-time

IBM MDM Database Analyst/Developer.Immediately if you are interested reply me with your updated resume or consultant's contact details and if you could refer someone i really appreciate it.IBM MDM ...Show more

 • Promoted

Database Administrator II - Remote/Nationwide

Signature PerformanceChicago, IL, United States
Full-time

This is a remote based position.Applicants can be located nationwide.Back Database Administrator II #2679 United States Apply X Facebook LinkedIn Email Copy Position Description.You are a person wh...Show more

 • Promoted

Data Analyst

Kasmo GlobalNorthbrook, IL, United States
Full-time

We are seeking a highly analytical and detail-oriented.The ideal candidate will have a strong foundation in SQL, demonstrated project experience, and the ability to communicate complex technical in...Show more

 • Promoted

Oracle EBS Analyst

Apollo ITSChicago, IL, United States
Full-time

Location: Chicago, IL (REMOTE).Duration: 2 months (might get extend).We are looking for an ERP Analyst to provide technical expertise and high-level support during our client's Oracle E-Business Su...Show more

 • Promoted

Business Data Analyst

DexianChicago, IL, United States
Full-time

Job Title: Business Analyst Expert (Sr.Business Data Analyst/PowerBI).Working Location: Chicago Illinois 60606.Possibility of conversion to FTE: Yes.Working hours: Standard 9 to 5.This role is abou...Show more

 • Promoted

Database Analyst

United IT SolutionsChicago, IL, United States
Full-time

Develop, maintain, and enhance complex databases used for a variety of areas and functions using SQL, VB, VBA, Access, Excel and other software as applicable.Work with users to capture and analyze ...Show more

 • Promoted

Senior Business (Systems) Analyst: Fulltime: Chicago, IL

NextRowChicago, IL, United States
Full-time

Title: Senior Business (Systems) Analyst.Skills: Business Analysis, Adobe Analytics, Stakeholder Management, Project Management.We are looking for a Senior Business Analyst to join our Adobe Experi...Show more

 • Promoted

Senior Data Analyst - Card

Capital OneChicago, IL, United States
Full-time +1

At Capital One, data is at the center of everything we do.When we launched as a startup we disrupted the credit card industry by individually personalizing every credit card offer using statistical...Show more

 • Promoted

Business Analyst III

Voluble Systems LLCChicago, IL, United States
Full-time

We are seeking a Business Analyst with strong Oracle E Business Suite (EBS) functional expertise who can also help shape the next generation of intelligent solutions across the enterprise.This role...Show more

 • Promoted

SAS Programmer

Avani Technology SolutionsChicago, IL, United States
Full-time

SAS Data Management Advanced suite, specifically Data Integration Studio.Bachelor's degree or higher in Computer Science, Statistics, Mathematics, or a similar quantitative field, such as Economics...Show more

 • Promoted

ServiceNow IRM Business Analyst Chicago, IL (Onsite) Contract

AceStack LLCChicago, IL, United States
Full-time

Job Title: ServiceNow IRM Business Analyst.Location: Chicago Downtown, IL (Onsite).Job Type: Contract (W2 or C2C).Duration: 6-12 Months (Possible Extension).We are seeking a proactive and detail-or...Show more

 • Promoted

Senior Oracle Database Administrator

WabtecChicago, IL, United States
Full-time

You will join Wabtec's Digital Technology team in one of our hub locations, reporting to Vice President of DI, Database & Enterprise Tools.This team is responsible for delivering mission-critical d...Show more

 • Promoted

Senior, Business Systems Analyst

Publicis Groupe Holdings B.VChicago, IL, United States
Full-time

As a pioneer in outcome-based marketing, Epsilon is dedicated to transforming data into actionable insights.Demonstrating our advanced Epsilon PeopleCloud platform, we deliver personalized marketin...Show more

 • Promoted

Mainframe Database Manager 4 (Mainframe Db2 & IMS database)

U.S. BankChicago, IL, United States
Full-time

Bank, we're on a journey to do our best.Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed.We b...Show more

 • Promoted

Database Coordinator, 2-1-1

United WayChicago, IL, United States
Full-time

Director, Data & Technology, 2-1-1.United Way of Metro Chicago is seeking a 2-1-1 Database Coordinator for Chicago and Cook County, an exciting initiative that connects community members with easil...Show more