DB2 / SQL Analyst - Information Systems Technician I

Office of the Illinois Secretary of State

Job Title : Information Systems Technician I –DB2 / SQL Analyst

Division : Data Center Services

Union : IFT

Location : 501 S Second St, Springfield, IL – Sangamon County

Salary : Range $4,962 to $9,512 monthly, commensurate with experience

Benefits : https : / / cms.illinois.gov / benefits / stateemployee.html

Attention : Applicants must be authorized to work in the United States; the Office of the Secretary of State will not complete certification and / or sponsorship requests.

Overview :

Serves as a technical expert in an assigned area of database design, participates in the utilization of advanced programming languages and systems and programming techniques.

Duties and Responsibilities :

• Under direction of senior staff creates and maintains the necessary data files to support both production and test environments when developing projects such for areas such as, but not limited to, Driver Services, Vehicle Services, Business Services, etc.
• Under direction of senior staff, develops, designs and implements database structures to support user departments such as, but not limited to Driver Services, Vehicle Services, Business Services, etc.
• Prepares and maintains documentation for the data file structures / design.
• Under direction of senior staff, assures the adherence for the standardization of data names within data files that correspond with data names defined in the Data Dictionary / Data Directory.
• Under direction of senior staff, coordinates with personnel from Systems & Programming, transaction processing specialist and Production Assurance the implementation of new database changes from a test environment into a production environment.
• Utilizing vendor supplied database tools, monitors the status of data files for changes, growth, etc.
• Maintains user contact by attending meetings to gain better understanding of user requirements in areas such as, but not limited to, Vehicles Services, Drivers Services, etc.
• Performs other duties as required or assigned.

Education and Experience :

Requires knowledge, skill, and mental development equivalent to completion of one year of college, with coursework in the computer science field OR 1.5 years of technical systems and programming experience OR any equivalent combination of education and experience.

Knowledge, Skills and Abilities :

Application Process :

Equal Employment Opportunity Employer. Applicants must be lawfully authorized to work in the United States.

J-18808-Ljbffr