Application & Database Support Analyst

About The Role

The Application & Database Support Analyst is responsible for supporting enterprise applications, SQL databases, and Windows server environments within a manufacturing organization. This role focuses on troubleshooting application and data-related issues, maintaining system reliability, supporting operational processes, and assisting with database and infrastructure administration activities.

What You'll Do

• Provide day-to-day support for enterprise applications including TCM (Workwise) and related business systems.
• Troubleshoot applications, integration, and data-related issues.
• Aid with software updates, data corrections, and operational support activities.
• Maintain application functionality and escalate complex issues as needed.
• Resolve application support tickets in a timely manner.
• Support Microsoft SQL Server environments including: SQL Server Management Studio (SSMS), SQL Server Agent Jobs, database permissions and monitoring, backup and restore validation, and creation of SQL scripts for data corrections, insert/update operations, troubleshooting, and operational support.
• Monitor database performance and assist with issue resolution.
• Server & Infrastructure Support>
• Support Windows Server operations including: starting and stopping services, reviewing event logs, monitoring scheduled tasks and services, resource monitoring, and troubleshooting.
• Aid with IIS management and application monitoring.
• Resolve remote access and RDP-related issues.
• Utilize command-line tools for troubleshooting and support activities.
• File & Data Management Support>
• Manage ISAM tables and files using Synergy RMS functionality and related utilities such as Fconvert, ISLOAD, Cache rebuild utilities.
• Aid with key rebuilds and data integrity troubleshooting.

Technical Skills

• Experience supporting Microsoft SQL Server environments.
• Working knowledge of SQL scripting and query development.
• Experience with: SSMS, SQL Server Jobs, Windows Server administration, event log analysis, and command-line utilities.
• Understanding of database backup and restore processes.
• Strong troubleshooting and analytical skills.

Preferred Qualifications

• SQL replication knowledge or experience.
• Experience with SSRS and SSIS.
• Automotive manufacturing IT experience.
• WorkWise software experience.
• Experience with Synergy RMS or ISAM file management.
• Exposure to AI prompting or AI-assisted troubleshooting tools.

Soft Skills

• Strong problem-solving and troubleshooting abilities.
• Ability to prioritize and manage multiple support tasks.
• Good written and verbal communication skills.
• Ability to work independently and within a team environment.
• Detail-oriented with a focus on operational reliability.

Experience

Experience 2–5 years of experience in application support, database support, or IT systems support preferred.

Work Environment

Dexter is committed to attracting, developing, and retaining a highly qualified, dedicated workforce. We hire and promote individuals based on their qualifications, performance, and abilities. It is the policy of the Company to provide equal opportunity to all qualified individuals without discrimination on the basis of race, ethnicity, national origin, gender, age, sexual orientation, disability, religion, veteran status, citizenship status or any other protected characteristic as outlined by applicable U.S. and Canada equal rights legislation protected by federal, state, province or local law.