See more Collapse

Principal Database Analyst

3 months ago


Chicago, United States National Guard Employment Network Full time
Job Description

Under direction, functions as a technical team leader for the design, implementation, and management of database systems and new database technologies, and performs related duties as required

As a technical expert OR team leader, assignments at this level typically require considerable knowledge of database design and analysis, or specialized knowledge of a subject matter, discipline, or function. Positions in this class title are allocated across various City departments and perform a wide range of functions that are specific to the operational needs of the department. Common specialty titles of functional roles for positions in this class title include but are not limited to: Lead/Supervising System Database Analyst, Lead/Supervising Application Database Analyst, and Lead/Supervising Database Developer.

ESSENTIAL DUTIES
  • Query and report on various transportation related data
  • Maintain CDOT's Advanced Traffic Management System
  • Identify system maintenance issues
  • Coordinate with consultants and internal users
  • Monitor data flow through API's
  • Check operation of field devices supplying or publishing traffic data
  • Monitor server patching and upgrade activities, coordination with other CDOT departments and external partners
  • Act as IT and data liaison for CDOT's Intelligent Transportation System projects
Additional duties may be required for this position.

Certificates/Security Clearances/Other

THIS POSITION IS IN THE CAREER SERVICE

LOCATION:
2 N LaSalle, Suite 950, Chicago, IL 60602

ALL REFERENCES TO POLITICAL SPONSORSHIP OR RECOMMENDATION MUST BE OMITTED FROM ALL APPLICATION MATERIALS SUBMITTED FOR CITY EMPLOYMENT.

The City of Chicago is an Equal Employment Opportunity and Military Friendly Employer.

Additional Qualifications/Responsibilities

Qualifications

MINIMUM QUALIFICATIONS:
Graduation from an accredited college or university with a Bachelor's Degree in Computer Science, Information Technology/Systems, or a directly related field, plus two years of experience in maintaining and designing integrated database systems, or an equivalent combination of education, training and experience

"Accredited" means any nationally or regionally accredited college, university, or law school where the applicant is enrolled in or has completed an Associates, Bachelors, Masters, or Juris Doctorate degree program.

Preference will be given to candidates possessing the following:
  • Previous experience with Geographical Information Systems (GIS), large transportation databases and/or systems
  • Previous experience in Database Administration of Oracle or Postgres or a similar relational database, SQL Programming, or scripting languages

We have other current jobs related to this field that you can find below

  • Database Analyst

    3 weeks ago


    Chicago, United States Global Channel Management Full time

    About the job Database Analyst Database Analyst needs two years of professional work experience in financial operations, banking, database management, gift processing or similar field Database Analyst requires: Experience analyzing, investigating and solving database issues. Experience using Business Objects or other database reporting software. Ability to...

  • Database Analyst

    4 months ago


    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

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


  • Chicago, United States Solving IT Full time

    One of the largest health insurers in the nation is focused on continuously building an industry-defining, world-class IT capability. Healthcare is forever evolving, especially due to emerging technologies, making this a great experience to add to your resume. Come join their winning team!This Contract role as a Hybrid Database Analyst in Chicago, IL will...

  • Database Administrator

    4 months ago


    Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement 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...


  • Chicago, United States Options Clearing Corporation Full time

    What You'll Do:This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.Primary Duties and Responsibilities:To perform this job...


  • Chicago, United States Options Clearing Corporation Full time

    What You'll Do:This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.Primary Duties and Responsibilities:To perform this job...


  • Chicago, United States Options Clearing Corporation Full time

    What You'll Do:This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.Primary Duties and Responsibilities:To perform this job...


  • Chicago, United States Options Clearing Corporation Full time

    What You'll Do:This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.Primary Duties and Responsibilities:To perform this job...


  • Chicago, United States Options Clearing Corporation Full time

    What You'll Do:This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.Primary Duties and Responsibilities:To perform this job...


  • Chicago, United States Options Clearing Corporation Full time

    What You'll Do:This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.Primary Duties and Responsibilities:To perform this job...


  • Chicago, United States Chicago Public Schools Full time

    Chicago Public Schools (CPS) is the third-largest school district in the United States, serving over 330,000 students in 600+ schools and employing nearly 36,000 people, most of them teachers. CPS has set ambitious goals to ensure that every student, in every school and every neighborhood, has access to a world-class learning experience that prepares each...


  • Chicago, United States Metropolitan Water Reclamation District of Greater Chicago Full time

    General Statement Under direction, leads the design, implementation, administration and maintenance of the District’s relational database systems that support the functional requirements of application systems used by the operating departments. This classification is also responsible for developing, implementing, and overseeing database policies and...

  • Database Developer

    2 months ago


    Chicago, United States Ardmore Roderick Full time

    Job DescriptionJob DescriptionArdmore Roderick is a full-service civil engineering firm providing infrastructure design, construction services and program management to a variety of agencies. Headquartered in Chicago, we have offices in Champaign, IL, Orlando, FL, and Philadelphia, PA. Ardmore Roderick was recently named by Crain’s Chicago as one of the...

  • Database Developer

    17 hours ago


    Chicago, Illinois, United States Ardmore Roderick Full time

    Ardmore Roderick is a full-service civil engineering firm providing infrastructure design, construction services and program management to a variety of agencies. Headquartered in Chicago, we have offices in Champaign, IL, Orlando, FL, and Philadelphia, PA. Ardmore Roderick was recently named by Crain's Chicago as one of the fastest growing companies in the...

  • Marketing Specialist

    2 months ago


    Chicago, United States William Blair Full time

    The Marketing Specialist - Database will build knowledge of William Blair institutional investment strategies and products. Obtain information on investment philosophy, features, and performance of specific investment products. Complete and maintain information on Investment Management division in third-party databases and provide analytical support to IM...


  • Chicago, United States Request Technology, LLC Full time

    ***Hybrid, 3 days onsite, 2 days remote******We are unable to sponsor as this is a permanent full-time role***A prestigious company is looking for an Associate Principal, Database Administrator. This DBA will focus on production support, performance back up, and DBMS. This company needs someone with 7+ years of working with db2 LUW on Red Hat and PostgreSQL....


  • Chicago, IL, United States Options Clearing Corporation Full time

    What You'll Do:This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.Primary Duties and Responsibilities:To perform this job...


  • Chicago, IL, United States Options Clearing Corporation Full time

    What You'll Do:This role will design and maintain databases and database solutions that operate within prescribed resource limits and meet company standards. Participate in and contribute to all phases of systems development projects. Monitor and tune database and database application performance.Primary Duties and Responsibilities:To perform this job...

  • Research Analyst

    2 months ago


    Chicago, United States First Trust Capital Management L.P. Full time

    SummaryThe Research Analyst role at First Trust Alternative Investment Research (“FT AIR”) is focused on supporting all aspects of the investment due diligence efforts with respect to the firm’s hedge fund, private equity, venture capital, real estate, private credit, and liquid alternatives investments. The Research Analyst will be involved in all...

  • Research Analyst

    3 months ago


    Chicago, United States First Trust Capital Management L.P. Full time

    SummaryThe Research Analyst role at First Trust Alternative Investment Research (“FT AIR”) is focused on supporting all aspects of the investment due diligence efforts with respect to the firm’s hedge fund, private equity, venture capital, real estate, private credit, and liquid alternatives investments. The Research Analyst will be involved in all...