SENIOR DATA BASE ANALYST

BID/JOB ANNOUNCEMENT

SENIOR DATABASE ANALYST

Department of Family and Support Services

(Information Technology)

Number of Positions: 1

(Additional vacancies possible pending budget approval)

Starting Salary: $93,708

This 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 AND

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

FAILURE TO FOLLOW THESE INSTRUCTIONS WILL RESULT IN A REJECTED BID APPLICATION

Applications for this position will be accepted until 11:59pm CDT on 12/03/2024

Under general supervision, at the fully functional level, maintains integrated database systems and assists in implementing new database technologies, and performs related duties as required

ESSENTIAL DUTIES

* Reviews designs of new database systems of limited to moderate complexity in order to ensure efficient performance and data integrity.

* Assists the team leader in reviewing database-related activities of vendors to ensure compliance with standards and specifications.

* Designs and maintains database structures, including supporting automated systems, ensuring database accessibility at remote locations, installing software, and maintaining hardware.

* Monitors and evaluates the use and performance of existing database systems to ensure maximum utilization of disk space and modifies access paths and reconfigures as required

* Resolves operational problems between databases and operating systems.

* Designs and ensures the appropriateness of backup and recovery techniques and security

* Architectures to protect systems and data against disk-level failures and unauthorized access.

* Documents database techniques, procedures and standards.

* Assists in performing database administration functions.

* Designs, codes, tests, debugs and documents computer programs.

* Maintains security and update procedures for the Data Dictionary, as required.

* May train entry-level staff in database techniques.

Additional duties may be required for this position

Location: Department of Family and Support Services

Address: 1615 West Chicago Avenue

Days: Monday - Friday

Hours: 9:00 AM - 5:00 PM

THIS POSITION IS IN THE CAREER SERVICE

MINIMUM QUALIFICATIONS

Graduation from an accredited college or university with a Bachelor's degree in Computer Sciences, Information Technology/Systems or a directly related field plus one year of experience in maintaining and designing integrated database systems, or an equivalent combination of education, training and experience

Licensure, Certification, or Other Qualifications

None

NOTE:

SELECTION REQUIREMENTS

This position requires applicants to complete an interview. The interviewed candidate(s) possessing the qualifications best suited to fulfill the responsibilities of the position, based on the oral parts of the interview will be selected.

Preference will be given to candidates possessing the following:

* Previous experience in the administration of databases

* Previous experience in SQL server, HTML and basic coding languages

* Previous experience in project management and business requirements development

* Previous experience in developing data models and analyzing data for performance measurement

* Previous experience working with data warehouses and data lake environments using Microsoft Azure cloud platform services

* Microsoft Azure Certification preferred in the following or related cloud applications:

1. Data Bricks

2. Data Factory

3. SQL server

4. Power BI

* Previous experience in salesforce systems administration and report writing will be preferred for this position

APPLICATION EVALUATION: Initial evaluation will be based on information provided on the application and the documents submitted. Department of Human Resource staff will review applications after the final posting date. Staff will follow any and all required Employment/Hiring Plan provisions, federal, state and local laws, and Collective Bargaining Agreements when applicable. Staff will apply hiring preferences as required by the municipal code. Placement on an eligibility list is not an offer or guarantee of an interview nor employment with the City of Chicago.

COMMITMENT TO DIVERSITY: To further our commitment to hiring applicants with diverse experience the City of Chicago has adopted the following ordinances 2-74-020 and 2-74-075. The ordinances provide a preference to applicants who meet minimum qualifications and who are veterans of the Armed Forces, and/or residents of Socio-Economically Disadvantaged Areas (SEDA) and/or Chicago Public School (CPS) high school graduates to be referred to departments for consideration. These hiring preferences do not apply to bidders, as Collective Bargaining Agreements define the hiring process for bidders. For positions covered by a collective bargaining agreement, bidders will be considered before external candidates. To learn more about our hiring practices click here.

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

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

The City of Chicago is committed to providing fair chance hiring and welcomes applicants with past convictions, recognizing the value of a diverse workforce and the potential for growth and positive change.

City of Chicago

Brandon Johnson, Mayor