Database Systems Specialist

3 weeks 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 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,...


  • 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 Government Jobs Full time

    Job Summary: We are seeking a skilled Mechanical Systems Specialist to join our team at Government Jobs. In this role, you will be responsible for maintaining and repairing existing building mechanical systems.Key Responsibilities:Set up programming and occupancy schedules of buildingsAssist on new system designsPerform routine maintenance and repairs on...


  • 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 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 Contact Government Services, LLC Full time

    Job Title: Senior Systems AnalystWe are seeking a highly skilled Senior Systems Analyst to join our team at Contact Government Services, LLC. As a key member of our IT team, you will be responsible for designing, implementing, and maintaining complex systems to support our government clients.Key Responsibilities:Develop and manage workflow processes to...


  • Peoria, Illinois, United States Natural Fiber Welding Full time

    About NFWNFW is a pioneering company that's revolutionizing the way materials are developed and used. Our mission is to create a world where all materials are nutrient-based and can be easily recycled, reducing plastic waste and promoting a circular economy.Our PlatformWe've developed a multi-material platform that serves a wide range of industries, from...


  • Peoria, Illinois, United States Elite Mente LLC Full time

    Job DescriptionJob Title: Digital Technical SpecialistLocation: Peoria, ILVisa: AnyDuration: 12+ Months ContractPrimary Skills:Snowflake, Grafana, AWS Cloud Formation, API, Technical SupportDescription:The Digital Technical Specialist is responsible for monitoring overall performance of assigned digital products and handling customer issues through...


  • Peoria, Illinois, United States Caterpillar Full time

    Career Opportunity: As a Data Governance Specialist at Caterpillar Inc., you will play a critical role in shaping the company's data management strategy. You will work closely with developers, customers, and digital architects to bring data to the platform through ETL or SQL development. Your focus will be on developing and maintaining the governance frame...


  • Peoria, Illinois, United States Goli Tech Full time

    Job OverviewWe are seeking a highly skilled Digital Technical Support Specialist to join our team at Goli Tech. The successful candidate will be responsible for monitoring the performance of assigned digital products and resolving customer issues in a timely and efficient manner.Key Responsibilities:Triage and resolve support tickets in accordance with our...


  • Peoria, Illinois, United States City of Peoria Full time

    Job SummaryThe City of Peoria is seeking a skilled Mechanical Maintenance Technician to join our team. As a key member of our Public Works department, you will be responsible for maintaining and repairing existing building mechanical systems.Key ResponsibilitiesPerform routine maintenance and repairs on HVAC systems, including setting up and executing...


  • Peoria, Illinois, United States Peoria Public Schools Full time

    Job SummaryWe are seeking a highly skilled and detail-oriented Clerical Support Specialist to join our team as a substitute clerk. The ideal candidate will possess excellent communication and organizational skills, with the ability to work independently and as part of a team.ResponsibilitiesProvide administrative support to various departments and staff...


  • Peoria, Illinois, United States Iron Systems Full time

    Job Title: Desktop SupportJob Summary:We are seeking a highly skilled Desktop Support professional to join our team at Iron Systems. The successful candidate will be responsible for providing technical support and maintenance for desktop devices, including hardware and software issues.Responsibilities:Manage desktop devices incidents through to resolution,...


  • Peoria, Illinois, United States Pace® Analytical Services Full time

    About UsPace Analytical Services is a leading provider of quality assurance solutions. Our mission is to advance the science of quality and provide exceptional service to our customers.Job DescriptionSummaryWe are seeking a highly skilled Quality Assurance Specialist to join our team. The successful candidate will be responsible for administering and...


  • Peoria, Illinois, United States ENTEC Services, Inc. Full time

    Job SummaryAs a key leader on the Entec Operations Team, you will guide and support our Project Management and System Specialist teams, driving success across a diverse portfolio of building automation projects. These include HVAC, access, and lighting control, energy management, and large-scale upgrades such as mechanical system retrofits and redesigns. In...


  • Peoria, Illinois, United States CAILEAN CPA & BUSINESS CONSULTANT, PLLC Full time

    Job SummaryOur firm is seeking a highly skilled and detail-oriented Senior Accountant and Tax Specialist to join our team. The ideal candidate will have a strong background in accounting and tax preparation, with a focus on providing exceptional customer service and upholding the highest standards of accuracy and efficiency.Key Responsibilities: Prepare and...


  • Peoria, Illinois, United States Caterpillar Full time

    Job Title: IT Analyst III-ApplicationsCaterpillar Inc. is seeking a highly skilled IT Analyst III-Applications to join its team. As a key member of the data analytics group, you will work closely with developers, customers, and digital architects to bring data to the platform through ETL or SQL development.Key Responsibilities:Develop and maintain the...


  • Peoria, Illinois, United States Bleeding & Clotting Disorders Institute Full time

    Billing Specialist OpportunityWe are seeking a skilled Billing Specialist to join our team at the Bleeding & Clotting Disorders Institute. As a Billing Specialist, you will play a critical role in verifying healthcare charges and maintaining patient accounts through our automated billing system. You will also be responsible for submitting claims to various...


  • Peoria, Illinois, United States Terra Engineering Full time

    Job SummaryWe are seeking a skilled Documentation Specialist to join our team at Terra Engineering. As a key member of our Construction Services Department, you will be responsible for planning, directing, and coordinating the preparation of project documentation, ensuring customer contract requirements are met.Key ResponsibilitiesPlan and coordinate the...