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

    Information Analyst • Springfield, IL, US

    Related jobs
    • Promoted
    Information Systems Technician

    Information Systems Technician

    U.S. NavyRochester, 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: 17 days ago
    Information Systems Technician I - General Services

    Information Systems Technician I - General Services

    Illinois Secretary of StateSpringfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Information Systems Technician I – General Services Division : Systems & Programming Unio...Show moreLast updated: 30+ days ago
    • Promoted
    Clinical Psychologist - Litchfield IL

    Clinical Psychologist - Litchfield IL

    MRG ExamsWaggoner, IL, US
    Part-time
    Clinical Psychologist – Veteran Disability Assessments .We are seeking a dedicated Clinical Psychologist to join our team in performing medical assessments for U.Veterans as part of the ...Show moreLast updated: 30+ days ago
    • Promoted
    General Dentist - Litchfield, Illinois

    General Dentist - Litchfield, Illinois

    Litchfield Family DentistryLitchfield, IL, US
    Full-time
    General Dentist Opportunity in Litchfield, Illinois - $200,000 total compensation package! .Our commitment to exceptional patient care, cutting-edge technology, and professional growth makes u...Show moreLast updated: 30+ days ago
    • Promoted
    Clinical Psychologist

    Clinical Psychologist

    MRG ExamsCarlinville, Illinois, US
    Part-time
    Clinical Psychologist - Veteran Disability Assessments We are seeking a dedicated Clinical Psychologist to join our team in performing medical assessments for U. Veterans as part of the VA's disabil...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Software Developer (1417)- Springfield, Illinois, Hybrid

    Senior Software Developer (1417)- Springfield, Illinois, Hybrid

    ConfidentialSpringfield, Illinois, United States
    Full-time
    The DCFS Server Modernization Project aims to migrate legacy applications from outdated hardware and software (Microsoft Server 2008 and later, IIS, SQL Server, ASP, ASP. This project involves revie...Show moreLast updated: 30+ days ago
    • Promoted
    Work from Home

    Work from Home

    HomeJobFinderPalmyra, IL
    Remote
    Full-time
    Remote Opportunity : Link Posting Marketing Rep (No Experience Needed!) Are you self-driven, reliable, and ready to earn from anywhere? We’re looking for motivated individuals to jo...Show moreLast updated: 30+ 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
    Information Systems Specialist I - ServiceNow

    Information Systems Specialist I - ServiceNow

    Illinois Secretary of StateSpringfield, IL, US
    Full-time
    Quick Apply
    Office of the Illinois Secretary of State Alexi Giannoulias Job Title : .Information Systems Specialist I – ServiceNow Division : Governance & Business Management...Show moreLast updated: 30+ days ago
    • Promoted
    Diesel Fleet Techs III - Earn $35-$42.21 / Hr - $7.5k Sign-On + Benefits

    Diesel Fleet Techs III - Earn $35-$42.21 / Hr - $7.5k Sign-On + Benefits

    SyscoLitchfield, IL, US
    Full-time
    Sysco is Now Hiring Diesel Fleet Technicians in St.Hour • - Up to $7,500 Sign-On Bonus for New Hires.Annual Tool Allowance -Comprehensive Benefits. We offer our colleagues the opportunity to grow per...Show moreLast updated: 8 days ago
    • Promoted
    Optometrist - Litchfield IL

    Optometrist - Litchfield IL

    MRG ExamsCarlinville, Illinois, US
    Full-time +1
    Are you an Optometrist looking for a meaningful, flexible part-time opportunity? Join MRG Exams to conduct comprehensive eye exams for U. Veterans as part of the VA's SHA process.This is a rewarding...Show moreLast updated: 17 days ago
    • Promoted
    Diesel Fleet Techs - Earn Up to $27.64-$34.38 / Hr + Up to $7.5k Sign-On

    Diesel Fleet Techs - Earn Up to $27.64-$34.38 / Hr + Up to $7.5k Sign-On

    SyscoLitchfield, IL, US
    Full-time
    Sysco is Now Hiring Diesel Fleet Technicians Lvl II in St.Hour • Plus a $600 Annual Tool Allowance.Up To $7,500 Sign-On Bonus for New Hires. We offer our colleagues the opportunity to grow personally...Show moreLast updated: 30+ days ago
    • Promoted
    Work From Home

    Work From Home

    Remote JobsFranklin, IL
    Remote
    Full-time
    Remote Jobs are now available in your area.This position is a work from home position.You will not need to come into the office. Benefits : Health Insurance, 401K, Vacation& PTO.Apply now! Work f...Show moreLast updated: 19 days ago
    • Promoted
    Picker Packer

    Picker Packer

    WalmartFranklin, IL
    Full-time
    As a Picker / Packer at Walmart, you will play a critical role in the fulfillment process by accurately selecting and packing merchandise for shipping to customers or Walmart stores.Working in a fast...Show moreLast updated: 19 days ago
    • Promoted
    Business Analyst

    Business Analyst

    Krasan Consulting ServicesSpringfield, Illinois Metropolitan Area, United States
    Full-time
    Springfield, Illinois (Local Candidates Only).We’re looking for a skilled IT Business Analyst with 5+ years of experience gathering requirements, mapping workflows, and translating business needs i...Show moreLast updated: 2 days ago
    • Promoted
    Work From Home

    Work From Home

    AmazonFranklin, IL
    Remote
    Full-time
    Job Title : Work From Home Customer Service Representative.As a Work From Home Customer Service Representative at Amazon, you will be the first point of contact for customers seeking assistance.You ...Show moreLast updated: 19 days ago
    • Promoted
    Accounting System-Senior Business Analyst (Senior Public Service Administrator)

    Accounting System-Senior Business Analyst (Senior Public Service Administrator)

    State of IllinoisSpringfield, IL, United States
    Full-time +1
    Job Requisition ID : 51728 Closing Date : 12 / 05 / 2025 ​Agency : Illinois Office of Comptroller Class Title : SENIOR PUBLIC SERVICE ADMINISTR - 92220 Salary : $90,000 - $120,000 / year Job Type : Salaried Ca...Show moreLast updated: 1 day ago
    • Promoted
    Home Health RN $10,000 Bonus

    Home Health RN $10,000 Bonus

    Residential Home Health and HospiceWaverly, IL, US
    Full-time
    At Residential Home Health and Hospice ('Residential'), we're looking to add to our extraordinary care team.Grounded by our belief that outstanding care is best delivered in a team-based environmen...Show moreLast updated: 30+ days ago