Principal Data Base Analyst

Description:BID/JOB ANNOUNCEMENTPRINCIPAL DATABASE ANALYSTDEPARTMENT OF TRANSPORTATIONNumber of Positions: 1(Additional vacancies possible pending budget approval)Salary: $112,404; G-10This position is open to the public and all current city employees covered under the City’s Collective Bargaining Agreement with AMERICAN FEDERATION OF STATE, COUNTY, AND MUNICIPAL EMPLOYEES (AFSCME) – BARGAINING UNIT 1, 3, 4 & 5. Only employees in City job titles in this bargaining unit are eligible to bid.BID INSTRUCTIONS: Apply on the bid site: https://chicago.taleo.net/careersection/103/jobsearch.ftl?lang=en AND1. Check the box on your profile titled “Currently employed by the City of Chicago”2. Enter your employee ID (located on your pay stub labeled ‘payee/employee number’)3. Select your correct bargaining unitFAILURE TO FOLLOW THESE INSTRUCTIONS WILL RESULT IN A REJECTED BID APPLICATIONUnder 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 requiredAs 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 projectsAdditional duties may be required for this position.LOCATION: 2 N LaSalle, Suite 950, Chicago, IL 60602DAYS/HOURS: Monday – Friday, 8:30 am – 4:30 pmTHIS POSITION IS IN THE CAREER SERVICE.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 experienceDisclaimer - "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.NOTE: You must provide your transcripts or diploma at the time of processing, if applicable.SELECTION REQUIREMENTSThis position requires an applicant to successfully complete an interview. The interviewed candidate(s) possessing the qualifications best suited to fulfill the responsibilities of the position based on the oral interview, will be selected according to the collective bargaining agreement.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 languagesALL 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.City of ChicagoBrandon Johnson, MayorApplications for this position will be accepted until 11:59 pm CDT on Monday, June 24, 2024.