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

Database Administrator

KonnectITChicago, Illinois, US
Full-time
Quick Apply

The ideal candidate will have extensive expertise in.This role is critical in ensuring data integrity, availability, and security across the organization’s systems.Administer, monitor, and optimize...Show more

Senior Database Administrator (Remote Opportunity)

Hyatt CorporationChicago, IL, United States
Remote
Full-time

The OpportunityHyatt seeks an enthusiastic Senior Database Administrator to join our Corporate Information Technology department, where you will join a team of six professionals who love what they ...Show more

 • Promoted

Business System Analyst

The Judge GroupChicago, IL, United States
Full-time

A financial services organization is seeking a Senior Business Systems Analyst to partner with business and technology teams to deliver high‑impact solutions.This role is responsible for discoverin...Show more

 • Promoted

CuramBusiness Analyst - Chicago

RedMane TechnologyChicago, IL, United States
Full-time

RedMane Technology LLC is an application software consulting and systems integration company based in Chicago.We deliver software solutions for our clients throughout the United States and Canada b...Show more

 • Promoted

Analyst II: Business Intake

Mayer Brown LLPChicago, IL, United States
Full-time

Mayer Brown is an international law firm positioned to represent the world's major corporations, funds, and financial institutions in their most important and complex transactions and disputes.We a...Show more

 • Promoted

Analyst

Vizient, Inc.Chicago, Illinois, United States
Full-time

When you're the best, we're the best.We instill an environment where employees feel engaged, satisfied and able to contribute their unique skills and talents while living and working as their authe...Show more

 • Promoted

Business Analyst - REMOTE

Georgia IT, Inc.Chicago, IL, United States
Remote
Full-time

Location: Chicago, IL or REMOTE.Serve as an Infor M3 subject matter expert.Gather business requirements through interviews with business area subject matter experts.Identify business needs, create ...Show more

 • Promoted

Business Analyst (Level II)

LHHChicago, IL, United States
Full-time

LHH Recruitment Solutions is seeking a Change Analyst at our top tier banking client in Chicago, Illinois.This role is an ideal entry opportunity for a team player who has worked in Financial Servi...Show more

 • Promoted

Implementation Solutions Group Senior Analyst

CallanChicago, IL, United States
Full-time

Callan is looking for a new addition to our Implementation Solutions Group.In the role of Senior Analyst, you'll support the team in various areas, including conducting trust/custody due diligence ...Show more

 • Promoted

SAS Analyst

Inizio Partners CorpChicago, IL, United States
Full-time

Develop, test, and implement SAS programs using SAS EG, SAS Studio, and SAS Macros, SQL.Manage and analyze large datasets on SAS Unix platforms.Collaborate with cross-functional teams to design and...Show more

 • Promoted

Lead Business Systems Analyst

S&C Electric CompanyChicago, Illinois, United States
Full-time

As an S&C Electric team member, you'll work on projects that have real-world impact.You'll help transform the grid for resilient and reliable power worldwide.S&C has more than a 100-year history of...Show more

 • Promoted

Business Analyst- Chicago, IL

StaffingChicago, IL, United States
Full-time

The ideal candidate must have a finance background.The IT Senior Business Analyst will identify and document functional and technical requirements for various financial applications and reports.The...Show more

 • Promoted

Data Architect

SIDRAM TECHNOLOGIESChicago, IL, United States
Full-time

Location: New York / Chicago / Dallas.Mandatory: Snowflake, DOMO - Analytics and Reporting is a must.We are looking for a Database Lead with strong GCP, database, and ETL experience to support a cl...Show more

 • Promoted

Healthcare Analyst - Strong Release management experience Required - Remote

Arthur Grand Technologies IncChicago, IL, United States
Remote
Full-time

Job DescriptionArthur Grand Technologies is currently seeking a highly motivated and skilled Healthcare Business Analyst -Long Term Contract - Chicago, IL Remote for one of our clients.Role- System...Show more

 • Promoted

BPI Analyst

1872 ConsultingChicago, IL, United States
Full-time

Sr Business Process Improvement Analyst.Chicago, IL (Loop) Hybrid 3-4 days/week.The Business Process Improvement (BPI) team serves as dedicated project resources to drive change, identify and imple...Show more

 • Promoted

Business Analyst (Data Background)

Cloudious LLCChicago, IL, United States
Full-time
Quick Apply

Role: Business Analyst (Data Background) Location: Chicago, IL (Hybrid) Show more

Support Analyst (IT-Client Services)

InsideHigherEdPalos Hills, Illinois, United States
Full-time

Support Analyst (IT-Client Services).Under direction, the Support Analyst is responsible for troubleshooting, diagnosing, and repairing of computing-related problems.As part of the USS Technical Te...Show more

 • Promoted

Business Analyst

Baker TillyChicago, IL, United States
Full-time

Baker Tilly Healthcare Consulting providers management and technology consulting services to healthcare insurance companies and health systems.Join a talented, collegial team in our fast past growi...Show more