DB2/SQL Analyst - Information Systems Technician I jobs in United States
cer-icon
Apply on Employer Site
company-logo

Illinois Secretary of State · 1 month ago

DB2/SQL Analyst - Information Systems Technician I

The Illinois Secretary of State is seeking an Information Systems Technician I – DB2/SQL Analyst to serve as a technical expert in database design and programming. The role involves creating and maintaining data files, developing database structures, and coordinating with other personnel to implement database changes.

GovernmentNon ProfitOffice Administration
badNo H1BnoteU.S. Citizen Onlynote

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

Qualification

DB2SQLInformation TechnologyData AnalysisTechnical SupportCommunication SkillsTeam Collaboration

Required

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

Company

Illinois Secretary of State

twittertwittertwitter
company-logo
Illinois Secretary of State provides services for driver licensing, vehicle registration, business filings, and state records management.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Chad Leonard
Chief Information Security Officer
linkedin
leader-logo
Martín Burciaga
DIGITAL MEDIA + CREATIVE DIRECTOR | COMMUNICATIONS
linkedin
Company data provided by crunchbase