Database Systems Specialist

6 days ago


Peoria, Illinois, United States Illinois Mutual Life Insurance Company Full time
Job Description

At Illinois Mutual Life Insurance Company, we are seeking a highly skilled Database Administrator to join our team. The successful candidate will be responsible for providing technical support for our database environments, organizing our databases, and implementing new technologies to improve our data management capabilities.

Key Responsibilities:

  • Monitor, test, troubleshoot, optimize, prevent, and resolve database-related issues
  • Assist in the development of standards and guidelines to optimize the management, documentation, access, usage, migration, consolidation, and safeguarding of our Company data
  • Patch management research and installation of Microsoft SQL Server patches, services packs, and updates
  • Maintain a superior level of technology-related knowledge by staying abreast of database-technology-related changes and advancements
  • Assist with maintaining disaster recovery policies and procedures and in disaster recovery
  • Assist software developers to create, evaluate, and optimize the performance of database queries
  • Implement database-related software, utilities, and/or improvements to computer systems that may affect or improve our ability to access and/or use data
  • Work with Senior Database Administration to plan, coordinate, and implement security measures to safeguard data from accidental or unauthorized usage or modification
  • Perform additional duties as assigned by company management

Requirements:

  • Bachelor's Degree in Computer Science or Information Technology, or Associate Degree in Computer Science or Information Technology with equivalent of 4 years practical experience
  • Preferred Experience: Minimum 4 years practical experience
  • Recommended Certifications: Microsoft Certifications (Azure Database Administrator)
  • Proficient in Database Administration using Microsoft SQL Server
  • Knowledge of troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues
  • Knowledge in Performance Tuning, Query Optimization, using industry standard tools such as Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools
  • Knowledgeable in backups, restores, recovery models, maintenance plans, database shrink operations, DBCC commands, clustering, database mirroring, replication
  • Knowledgeable with indexes and index management, integrity checks, configuration, patching
  • Knowledgeable of SQL Server tools (Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs)
  • Capable of writing and troubleshooting SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints, link servers)
  • Working knowledge of Microsoft Windows Servers, security delegation, SPNs, storage components
  • Excellent documentation and communication skills for processes and procedures
  • Must be available, if required, to periodically assist on a 24-hour on-call basis
  • Some travel may be required


  • Peoria, Illinois, United States Illinois Mutual Life Insurance Company Full time

    Job SummaryWe are seeking a highly skilled and experienced Senior Database Administrator to join our team at Illinois Mutual Life Insurance Company. The successful candidate will be responsible for designing, implementing, and maintaining our database systems to ensure optimal performance, security, and scalability.Key ResponsibilitiesDesign, implement, and...


  • Peoria, Illinois, United States TriOptus LLC Full time

    Job Title & ID #Database Analyst/ProgrammerDuration:12 monthsLocation:IL-Peoria-Building LC OfficeSummary:The primary function of a database analyst/programmer is to oversee changes to computer databases, test, and implement the database utilizing knowledge of database management systems. A typical database analyst/programmer is responsible for planning,...


  • East Peoria, Illinois, United States United Facilities, Inc. Full time

    Job Title: Programmer / DBAUnited Facilities, Inc. is seeking a skilled Programmer / DBA to join our growing IT Department.Job Summary:We are looking for a highly motivated and experienced Programmer / DBA to develop and debug application programs, execute system and integration tests, and support production applications. The ideal candidate will have a...


  • Peoria, Illinois, United States CATERPILLAR INC Full time

    About the RoleCaterpillar Inc. is seeking a skilled Vector Database Engineer to join our team. As a Vector Database Engineer, you will play a critical role in designing, implementing, and optimizing vector databases that enable high-performance, large-scale data processing and retrieval.Key ResponsibilitiesDesign and implement vector databases to support...


  • Peoria, Illinois, United States Greater Peoria Sanitary District Full time

    Job Title: Information Systems SpecialistWe are seeking a highly skilled Information Systems Specialist to join our team at the Greater Peoria Sanitary District. The successful candidate will be responsible for developing and managing the District's information technology and systems, including the Geographic Information System (GIS), Asset Management (AM)...


  • Peoria, Illinois, United States Caterpillar Full time

    About the RoleCaterpillar is seeking a highly skilled Snowflake Database Administrator to join our team. As a key member of our data platform team, you will be responsible for ensuring the integrity, security, and performance of our data platform.Key ResponsibilitiesManage and monitor the Snowflake platform, including data ingestion, data transformation,...


  • Peoria, Illinois, United States Saxon Global Full time

    Job Summary:The Software Development Specialist will apply computer science and mathematical analysis principles to design, develop, test, and evaluate software and systems that make computers work.This role involves researching, designing, developing, and testing operating systems-level software, compilers, and network distribution software for various...


  • Peoria, Illinois, United States Contact Government Services, LLC Full time

    Job Title: Senior SQL Engineer Secure Release IICGS is seeking a highly skilled Senior SQL Engineer Secure Release to join our team supporting a wide-ranging technical support initiative for a large Federal agency.About the Role:We are looking for a seasoned SQL engineer with expertise in Microsoft SQL Server and experience in web development on the...


  • Peoria, Illinois, United States Saxon Global Full time

    Job Summary:The Software Development Specialist will apply the principles of computer science and mathematical analysis to design, develop, test, and evaluate software and systems that make computers work.This role involves researching, designing, developing, and testing operating systems-level software, compilers, and network distribution software for...


  • Peoria, Illinois, United States Iron Systems Full time

    Job Title: Desktop SupportAbout the Role:We are seeking a highly skilled Desktop Support professional to join our team at Iron Systems. As a Desktop Support specialist, you will be responsible for providing top-notch technical support for our desktop devices, ensuring that our users have a seamless and productive experience.Key Responsibilities:Manage...


  • Peoria, Illinois, United States PremiStar Full time

    Job Title: Control System TechnicianWe are seeking a highly skilled Control System Technician to join our team at PremiStar. As a Control System Technician, you will be responsible for completing tasks assigned by your supervisor and project manager, including programming, start-up, troubleshooting, commissioning, and servicing of Building Automation Systems...


  • Peoria, Illinois, United States ARi Full time

    Job Title: System Integration SpecialistARi is a fast-growing global engineering firm headquartered in the United States. Our team is accountable for integrating multiple systems together and performing validation for autonomous truck programs within our organization.Key Responsibilities:Analyzing system and software requirements to create test cases that...


  • Peoria, Illinois, United States Iron Systems Full time

    Desktop Support Job DescriptionJob Summary:We are seeking a skilled Desktop Support Specialist to join our team at Iron Systems. The successful candidate will be responsible for providing top-notch support for our desktop devices, ensuring they are running smoothly and efficiently.Responsibilities:Manage desktop devices, including hardware, software, and...


  • Peoria, Illinois, United States Tata Technologies Full time

    Job SummaryWe are seeking a highly skilled Automation Systems Specialist to join our team at Tata Technologies. The ideal candidate will have a strong background in PLC programming, machine tool connectivity, and data analytics.Key ResponsibilitiesDesign and implement automation systems for manufacturing processesDevelop and maintain PLC programs for machine...


  • Peoria, Illinois, United States Iron Systems Full time

    Job Summary:We are seeking a highly skilled Desktop Support Specialist to join our team at Iron Systems. As a key member of our IT department, you will be responsible for providing top-notch technical support for our desktop devices, ensuring seamless operation and minimizing downtime.Key Responsibilities:Manage and resolve desktop device incidents,...

  • Data Specialist

    1 month ago


    Peoria, Illinois, United States Caterpillar Full time

    Career Opportunity at Caterpillar Inc.Caterpillar Inc. is seeking a highly skilled Data Specialist to join its team. As a Data Specialist, you will play a critical role in ensuring the quality, design, and governance of Caterpillar's digital offerings.Key Responsibilities:Perform data-related tasks, including data design, quality, metadata management, and...


  • Peoria, Illinois, United States Personal Mobility Full time

    Job OverviewAt Personal Mobility, we're seeking a skilled Automotive Mobility Systems Specialist to join our team. As a key member of our service center, you'll be responsible for diagnosing, repairing, and installing automotive mobility and standard automotive systems.Key ResponsibilitiesInvestigate and diagnose malfunction codes in vehicle systems using...


  • Peoria, Illinois, United States United States Air Force Full time

    Missile and Space Systems Maintenance Job DescriptionFORTIFYING OUR DEFENSESMissiles and rockets are critical components of our national defense strategy. As a Missile and Space Systems Maintenance specialist, you will ensure these assets are fully operational at all times.From missile launchers to space lift boosters, you will plan, organize, and perform...


  • Peoria, Illinois, United States United States Air Force Full time

    Missile and Space Systems Maintenance Job DescriptionFORTIFYING OUR DEFENSESMissiles and rockets are critical components of our national defense strategy. As a Missile and Space Systems Maintenance specialist, you will ensure these assets are fully operational at all times.From missile launchers to space lift boosters, you will plan, organize, and perform...


  • Peoria, Illinois, United States United States Air Force Full time

    Missile and Space Systems Maintenance Job DescriptionFORTIFYING OUR DEFENSESMissiles and rockets are critical components of our national defense strategy. As a Missile and Space Systems Maintenance specialist, you will ensure these assets are fully operational at all times.From missile launchers to space lift boosters, you will plan, organize, and perform...