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
Hace más de 30 días
Tipo de contrato
  • A tiempo completo
Descripción del trabajo

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.
Crear una alerta de empleo para esta búsqueda

Database Analyst • Chicago, IL, USA

Ofertas similares

Client Advisory Analyst - SQL

Convey Health SolutionsChicago, Illinois, US
A tiempo completo

All potential candidates should read through the following details of this job with care before making an application.Pareto Intelligence™ is a bold and innovative healthcare analytics organization...Mostrar más

 • Oferta promocionada • Nueva oferta

Database Administrator

KonnectITChicago, Illinois, US
A tiempo completo
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...Mostrar más

Senior Database Administrator (Remote Opportunity)

Hyatt CorporationChicago, IL, United States
Teletrabajo
A tiempo completo

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 ...Mostrar más

 • Oferta promocionada

CuramBusiness Analyst - Chicago

RedMane TechnologyChicago, IL, United States
A tiempo completo

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...Mostrar más

 • Oferta promocionada

Analyst II: Business Intake

Mayer Brown LLPChicago, IL, United States
A tiempo completo

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...Mostrar más

 • Oferta promocionada

Remote Econometric Data Analyst (Stata SE)

Micro1Zion, Illinois, US
Teletrabajo
A tiempo completo

Econometric Data Analyst (Stata SE).AI labs train foundational models and enterprises build AI agents.We provide frontier evaluations and reinforcement learning environments used to improve LLM cap...Mostrar más

 • Oferta promocionada

Business Analyst - REMOTE

Georgia IT, Inc.Chicago, IL, United States
Teletrabajo
A tiempo completo

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 ...Mostrar más

 • Oferta promocionada

Senior Analyst, Commerce

Publicis Groupe ANZChicago, IL, United States
A tiempo completo

Spark Foundry is a global media agency that exists to bring HEAT – Higher Engagement, Affinity, and Transactions – to brands.By combining flawless media fundamentals with aggressive innovation, Spa...Mostrar más

 • Oferta promocionada

Business Analyst (Level II)

LHHChicago, IL, United States
A tiempo completo

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...Mostrar más

 • Oferta promocionada

Implementation Solutions Group Senior Analyst

CallanChicago, IL, United States
A tiempo completo

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 ...Mostrar más

 • Oferta promocionada

Title Analyst

GenStoneChicago, IL, United States
A tiempo completo

Title Clearing & Escrow, LLC (TC&E) is a national title and escrow provider specializing in institutional real estate transactions.Based in Tulsa and part of The Fay Group, TC&E delivers comprehens...Mostrar más

 • Oferta promocionada

SAS Analyst

Inizio Partners CorpChicago, IL, United States
A tiempo completo

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...Mostrar más

 • Oferta promocionada

Data Integrity Gift Analyst

Loyola University ChicagoChicago, IL, United States
A tiempo completo

Loyola University Chicago's Advancement division is seeking a detail-oriented team member committed to the highest quality of gift maintenance, management, and standards to join its team.In partner...Mostrar más

 • Oferta promocionada

Database Development

TradeJobsWorkForce60546 Riverside, IL, US
A tiempo completo

Database Development Job Duties: Database Developers are responsible for data gathering before development of a database.They design, develop, test, implement and maintain new and existing database...Mostrar más

 • Oferta promocionada

SP&A Analyst

BoxChicago, IL, United States
A tiempo completo

Chicago, Illinois, United States, San Francisco, CA, United States.Box is the leader in Intelligent Content Management.Our platform enables organizations to fuel collaboration, manage the entire co...Mostrar más

 • Oferta promocionada

BPI Analyst

1872 ConsultingChicago, IL, United States
A tiempo completo

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...Mostrar más

 • Oferta promocionada

QA Data Compliance Analyst

MINIAT HOLDINGS LLCSouth Holland, IL, United States
A tiempo completo

The QA Data Compliance Analyst is responsible for collecting, compiling, and reviewing product-related quality and food safety data to ensure compliance with internal requirements and customer spec...Mostrar más

 • Oferta promocionada

Support Analyst (IT-Client Services)

InsideHigherEdPalos Hills, Illinois, United States
A tiempo completo

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...Mostrar más