Database Systems Specialist
3 weeks ago
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
-
Database Analyst/Programmer
1 month ago
Peoria, Illinois, United States TriOptus LLC Full timeJob 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,...
-
Snowflake Database Administrator
3 weeks ago
Peoria, Illinois, United States Caterpillar Full timeAbout 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,...
-
Software Development Specialist
4 weeks ago
Peoria, Illinois, United States Saxon Global Full timeJob 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...
-
Mechanical Systems Specialist
7 days ago
Peoria, Illinois, United States Government Jobs Full timeJob 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...
-
Software Development Specialist
4 weeks ago
Peoria, Illinois, United States Saxon Global Full timeJob 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...
-
Automotive Mobility Systems Specialist
4 weeks ago
Peoria, Illinois, United States Personal Mobility Full timeJob 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...
-
Senior Systems Analyst
4 weeks ago
Peoria, Illinois, United States Contact Government Services, LLC Full timeJob 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...
-
Electrical Systems Specialist
4 weeks ago
Peoria, Illinois, United States Natural Fiber Welding Full timeAbout 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...
-
Digital Technical Specialist
4 weeks ago
Peoria, Illinois, United States Elite Mente LLC Full timeJob 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...
-
Data Governance Specialist
4 weeks ago
Peoria, Illinois, United States Caterpillar Full timeCareer 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...
-
Digital Technical Support Specialist
4 weeks ago
Peoria, Illinois, United States Goli Tech Full timeJob 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...
-
Mechanical Systems Specialist
4 weeks ago
Peoria, Illinois, United States City of Peoria Full timeJob 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...
-
Clerical Support Specialist
4 weeks ago
Peoria, Illinois, United States Peoria Public Schools Full timeJob 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...
-
Desktop Support Specialist
4 weeks ago
Peoria, Illinois, United States Iron Systems Full timeJob 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,...
-
Quality Assurance Specialist
4 weeks ago
Peoria, Illinois, United States Pace® Analytical Services Full timeAbout 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...
-
Senior Project Manager
4 weeks ago
Peoria, Illinois, United States ENTEC Services, Inc. Full timeJob 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...
-
Senior Accountant and Tax Specialist
4 weeks ago
Peoria, Illinois, United States CAILEAN CPA & BUSINESS CONSULTANT, PLLC Full timeJob 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...
-
Data Governance Specialist
1 month ago
Peoria, Illinois, United States Caterpillar Full timeJob 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...
-
Medical Billing Specialist
4 weeks ago
Peoria, Illinois, United States Bleeding & Clotting Disorders Institute Full timeBilling 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...
-
Documentation Specialist
4 weeks ago
Peoria, Illinois, United States Terra Engineering Full timeJob 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...