Illinois Secretary of State
DB2/SQL Database Analyst (IST I)
Illinois Secretary of State, Springfield, Illinois, us, 62777
Office of the Illinois Secretary of State
Alexi Giannoulias Job Title:
DB2/SQL Database Analyst - Information Systems Technician I Division:
Data Center Services Union:
IFT Location:
2701 S. Dirksen Pkwy, IL - Sangamon County Salary:
Starting salary $4,865.00 monthly - commensurate with experience
Overview:
Serves as a technical expert in an assigned area of data base design and 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 data base 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 data base changes from a test environment into a production environment. Utilizing vendor supplied data base tools, monitor 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. 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.
Alexi Giannoulias Job Title:
DB2/SQL Database Analyst - Information Systems Technician I Division:
Data Center Services Union:
IFT Location:
2701 S. Dirksen Pkwy, IL - Sangamon County Salary:
Starting salary $4,865.00 monthly - commensurate with experience
Overview:
Serves as a technical expert in an assigned area of data base design and 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 data base 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 data base changes from a test environment into a production environment. Utilizing vendor supplied data base tools, monitor 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. 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.