Talent.com
DB2 / SQL Analyst - Information Systems Technician I

DB2 / SQL Analyst - Information Systems Technician I

Illinois Secretary of StateSpringfield, IL, US
30+ days ago
Job type
  • Full-time
  • Quick Apply
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
  • Create a job alert for this search

    System Analyst • Springfield, IL, US

    Related jobs
    • Promoted
    Licensed Clinical Psychologist - Raymond, IL

    Licensed Clinical Psychologist - Raymond, IL

    LifeStance HealthRaymond, IL, US
    Full-time
    At LifeStance Health, we believe in a truly healthy society where mental and physical healthcare are unified to make lives better. Our mission is to help people lead healthier, more fulfilling lives...Show moreLast updated: 30+ days ago
    • Promoted
    Licensed Clinical Psychologist - Middletown, IL

    Licensed Clinical Psychologist - Middletown, IL

    LifeStance HealthMiddletown, IL, US
    Full-time
    At LifeStance Health, we believe in a truly healthy society where mental and physical healthcare are unified to make lives better. Our mission is to help people lead healthier, more fulfilling lives...Show moreLast updated: 30+ days ago
    • Promoted
    Travel Nurse RN - Med / Surg in Carlinville, IL

    Travel Nurse RN - Med / Surg in Carlinville, IL

    TravelNurseSourceCarlinville, IL, US
    Full-time
    TravelNurseSource is working with Titan Medical Group to find a qualified Med / Surg RN in Carlinville, Illinois, 62626!. Carlinville, IL, United States.Titan Medical is looking for travelers to fill ...Show moreLast updated: 18 days ago
    • Promoted
    PMHNP Nurse Practitioner - Illiopolis, IL

    PMHNP Nurse Practitioner - Illiopolis, IL

    LifeStance HealthIlliopolis, IL, US
    Full-time +1
    At LifeStance Health, we believe in a truly healthy society where mental and physical healthcare are unified to make lives better. Our mission is to help people lead healthier, more fulfilling lives...Show moreLast updated: 26 days ago
    • Promoted
    Digital Imaging Analyst - Information Systems Technician I

    Digital Imaging Analyst - Information Systems Technician I

    Illinois Secretary of StateSpringfield, IL, US
    Full-time
    Office of the Illinois Secretary of State.Job Title : .Digital Imaging Analyst – Information Systems Tech...Show moreLast updated: 30+ days ago
    Server Support - Information Systems Specialist I

    Server Support - Information Systems Specialist I

    Illinois Secretary of StateSpringfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Server Support ​​​​– Information Systems Specialist I Division : ...Show moreLast updated: 30+ days ago
    • Promoted
    Licensed Clinical Psychologist - Illiopolis, IL

    Licensed Clinical Psychologist - Illiopolis, IL

    LifeStance HealthIlliopolis, IL, US
    Full-time
    At LifeStance Health, we believe in a truly healthy society where mental and physical healthcare are unified to make lives better. Our mission is to help people lead healthier, more fulfilling lives...Show moreLast updated: 30+ days ago
    • Promoted
    Travel Nurse RN - Med Surg - $2,450 per week

    Travel Nurse RN - Med Surg - $2,450 per week

    ProKatchersCarlinville, IL, United States
    Full-time
    ProKatchers is seeking a travel nurse RN Med Surg for a travel nursing job in Carlinville, Illinois.Job Description & Requirements. Under general supervision, provides nursing care in a hospital to ...Show moreLast updated: 2 days ago
    • Promoted
    Travel Nurse RN - Med / Surg - $1,934 to $2,057 per week in Carlinville, IL

    Travel Nurse RN - Med / Surg - $1,934 to $2,057 per week in Carlinville, IL

    TravelNurseSourceCarlinville, IL, US
    Full-time
    TravelNurseSource is working with Fusion Medical Staffing to find a qualified Med / Surg RN in Carlinville, Illinois, 62626!. Facility in Carlinville, Illinois.Fusion Medical Staffing is seeking a Med...Show moreLast updated: 18 days ago
    • Promoted
    PMHNP Nurse Practitioner - Waverly, IL

    PMHNP Nurse Practitioner - Waverly, IL

    LifeStance HealthWaverly, IL, US
    Full-time +1
    At LifeStance Health, we believe in a truly healthy society where mental and physical healthcare are unified to make lives better. Our mission is to help people lead healthier, more fulfilling lives...Show moreLast updated: 26 days ago
    • Promoted
    Licensed Clinical Psychologist - New Berlin, IL

    Licensed Clinical Psychologist - New Berlin, IL

    LifeStance HealthNew Berlin, IL, US
    Full-time
    At LifeStance Health, we believe in a truly healthy society where mental and physical healthcare are unified to make lives better. Our mission is to help people lead healthier, more fulfilling lives...Show moreLast updated: 30+ days ago
    • Promoted
    Licensed Clinical Psychologist - Sherman, IL

    Licensed Clinical Psychologist - Sherman, IL

    LifeStance HealthSherman, IL, US
    Full-time
    At LifeStance Health, we believe in a truly healthy society where mental and physical healthcare are unified to make lives better. Our mission is to help people lead healthier, more fulfilling lives...Show moreLast updated: 30+ days ago
    • Promoted
    Travel Nurse RN - Med / Surg - $1,906 per week in Carlinville, IL

    Travel Nurse RN - Med / Surg - $1,906 per week in Carlinville, IL

    TravelNurseSourceCarlinville, IL, US
    Full-time +1
    TravelNurseSource is working with Infojini Healthcare to find a qualified Med / Surg RN in Carlinville, Illinois, 62626!. Self Assessment (Skills Checklist).At Infojini Healthcare, We tell it like it ...Show moreLast updated: 18 days ago
    • Promoted
    Telemedicine Physician

    Telemedicine Physician

    QuickMDSherman, IL, US
    Full-time
    QuickMD is a leading telemedicine provider, delivering high-quality virtual care across 44 states.Since our founding in 2019, we have helped more than 100,000 patients access essential medical trea...Show moreLast updated: 30+ days ago
    • Promoted
    Information Systems Technician

    Information Systems Technician

    NavySouthern View, IL, United States
    Full-time
    ABOUT Effective, secure communication in the cyber domain is essential to the everyday operations of military intelligence in America’s Navy. Information Professionals who oversee the seamless opera...Show moreLast updated: 4 days ago
    Web Services - Information Systems Technician I

    Web Services - Information Systems Technician I

    Illinois Secretary of StateSpringfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Web Services – Information Systems Technician I Division : Systems & Programming Unio...Show moreLast updated: 30+ days ago
    • Promoted
    Diesel Fleet Technician - Earn $27.64 / Hour + $7,500 Sign On Bonus

    Diesel Fleet Technician - Earn $27.64 / Hour + $7,500 Sign On Bonus

    SyscoLitchfield, IL, US
    Full-time
    Sysco is Now Hiring Diesel Fleet Technicians in St.Hour • Plus a $600 Annual Boot & Tool Allowance.Up To $7,500 Sign-On Bonus - Career Growth Opportunities. We offer our colleagues the opportunit...Show moreLast updated: 12 days ago
    • Promoted
    Licensed Clinical Psychologist - Waverly, IL

    Licensed Clinical Psychologist - Waverly, IL

    LifeStance HealthWaverly, IL, US
    Full-time
    At LifeStance Health, we believe in a truly healthy society where mental and physical healthcare are unified to make lives better. Our mission is to help people lead healthier, more fulfilling lives...Show moreLast updated: 30+ days ago
    • Promoted
    DB2 / SQL Analyst - Information Systems Technician I

    DB2 / SQL Analyst - Information Systems Technician I

    Illinois Secretary of StateSpringfield, IL, US
    Full-time
    Office of the Illinois Secretary of State.Information Systems Technician I – DB2 / SQL Analyst.Union : .S Second St, Springfield, IL – Sangamon County...Show moreLast updated: 30+ days ago
    • Promoted
    Travel Nurse RN - Med / Surg - $2,164 per week in Carlinville, IL

    Travel Nurse RN - Med / Surg - $2,164 per week in Carlinville, IL

    TravelNurseSourceCarlinville, IL, US
    Full-time
    TravelNurseSource is working with Magnet Medical to find a qualified Med / Surg RN in Carlinville, Illinois, 62626!.The Registered Nurse (RN) in the Med-Surg unit is responsible for providing direct ...Show moreLast updated: 18 days ago