DB2/SQL Analyst - Information Systems Technician I
Company: Illinois Secretary of State
Location: Springfield
Posted on: January 22, 2026
|
|
|
Job Description:
Job Description Job Description Office of the Illinois Secretary
of State Alexi Giannoulias 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: Requires elementary knowledge of Information Technology
concepts and principles, the theories and functions of computer
systems, and the principles and techniques of Information
Technology documentation. Requires elementary knowledge of hardware
and software, languages, and procedures to provide assigned
technical and analytical support services. Requires elementary
knowledge of accounting and statistical theories, methods and
practices. Requires working knowledge of the devices for capturing
data and the means available for receiving and transmitting data
from remote locations to a computer. Requires working knowledge of
the principles and techniques of computer system documentation.
Requires ability to effectively participate in and profit from
formal and in-service training programs. Requires ability to
analyze data logically. Requires ability to maintain satisfactory
working relationships with others. Requires the ability to follow
oral and/or written instructions and to carry out routine
operations, once established, without further instructions.
Requires sufficient oral and written communication skills for
effective engagement with colleagues and internal users/customers.
Requires awareness and adherence to organizational standards for
security, privacy and ethics. Requires willingness to travel and
possession of a valid Illinois driver’s license as required by
individual positions within the class. Required to lift, carry and
push/pull up to 50 lbs. Application Process: Please visit
https://ilsos.applytojob.gov/apply to apply by completing the
online application; you may also upload a resume, or other
attachments as needed. Preference will be given to Illinois
residents in the hiring and selection process, in accordance with
the Illinois Secretary of State Merit Employment Code. Questions
regarding this posting or Illinois Secretary of State employment
practices may be directed to Job Counselors at our Personnel
offices in Chicago (312-793-5515) or Springfield (217-782-4783).
Equal Employment Opportunity Employer. Applicants must be lawfully
authorized to work in the United States. Applicants are considered
for all positions without regard to race, color, religion, sex,
national origin, sexual orientation, age, marital or veteran
status, or the presence of a non-job-related medical condition or
disability. Powered by JazzHR ZHWAtCXKbN
Keywords: Illinois Secretary of State, St. Louis , DB2/SQL Analyst - Information Systems Technician I, IT / Software / Systems , Springfield, Missouri
