IT Systems & ERP/SQL Support Specialist

Mindscope; Hauppauge (NY); On-site; USD 70,000 - 90,000; Full time

Job summary

Mindscope is seeking a motivated IT Systems & ERP/SQL Support Specialist to join our IT team. You will support day-to-day IT operations, develop expertise in Infor Visual ERP and SQL Server, and assist with reporting, Windows infrastructure, and security/compliance in a defense manufacturing environment.

Work under IT leadership, supporting ERP, databases, users, and core IT systems, while documenting procedures and escalating risks when needed.

Qualifications

• 2+ years of IT, database, ERP, helpdesk, or systems support experience.
• Working knowledge of Microsoft SQL Server and relational databases.
• Ability to write basic to intermediate SQL queries, including SELECT statements, JOINs, filtering, grouping, and aggregations.
• Experience supporting business applications, databases, or operational reporting needs.
• Strong troubleshooting, analytical, and problem-solving skills.
• Ability to work independently while following direction, documentation, and escalation procedures.
• Detail-oriented with strong organizational and communication skills.
• Comfortable supporting users in a business or manufacturing environment.

Responsibilities

• Support and maintain the Infor Visual ERP environment, including user support, troubleshooting, reporting, and coordination with internal stakeholders and vendors as needed.
• Write and troubleshoot SQL queries for reporting, data validation, operational support, and management requests.
• Assist with SQL Server maintenance, backups, documentation, and basic performance troubleshooting under IT leadership.
• Generate and maintain reports for operations, finance, quality, production, and leadership.
• Provide Tier 1-2 IT support for users, workstations, printers, software, access requests, and general troubleshooting.
• Assist with Windows Server, Active Directory, Group Policy, file shares, permissions, and system administration tasks.
• Support Microsoft 365 / GCC High administration tasks, including user support, mailbox support, access control, and security-related configuration as directed.
• Support CMMC 2.0 / NIST SP 800-171 compliance activities, including access control, secure configuration, system documentation, audit evidence collection, and protection of CUI.
• Document procedures, troubleshooting steps, system changes, and recurring support issues.
• Escalate risks, recurring problems, security concerns, and system issues to IT leadership promptly.

Skills

SQL queries

IT support

ERP support

Troubleshooting

Documentation

Independent work

Manufacturing environment

Tools

Infor Visual ERP

SQL Server

SSRS/Power BI

Windows Server

Active Directory

Job description

Our client is seeking a motivated and technically capable IT Systems & ERP/SQL Support Specialist to join our IT team. This role supports day-to-day IT operations while developing expertise in our Infor Visual ERP system, Microsoft SQL Server, reporting, Windows infrastructure, Microsoft 365, and security/compliance support in a defense manufacturing environment. Work directly under IT leadership, supporting ERP, databases, users, and core IT systems. Develop working expertise in Infor Visual ERP and Microsoft SQL Server.

Job Function

Key Responsibilities

• Support and maintain the Infor Visual ERP environment, including user support, troubleshooting, reporting, and coordination with internal stakeholders and vendors as needed.
• Write and troubleshoot SQL queries for reporting, data validation, operational support, and management requests.
• Assist with SQL Server maintenance, backups, documentation, and basic performance troubleshooting under IT leadership.
• Generate and maintain reports for operations, finance, quality, production, and leadership.
• Provide Tier 1-2 IT support for users, workstations, printers, software, access requests, and general troubleshooting.
• Assist with Windows Server, Active Directory, Group Policy, file shares, permissions, and system administration tasks.
• Support Microsoft 365 / GCC High administration tasks, including user support, mailbox support, access control, and security-related configuration as directed.
• Support CMMC 2.0 / NIST SP 800-171 compliance activities, including access control, secure configuration, system documentation, audit evidence collection, and protection of CUI.
• Document procedures, troubleshooting steps, system changes, and recurring support issues.
• Escalate risks, recurring problems, security concerns, and system issues to IT leadership promptly.

Job Requirement

Required Qualifications

• 2+ years of IT, database, ERP, helpdesk, or systems support experience.
• Working knowledge of Microsoft SQL Server and relational databases.
• Ability to write basic to intermediate SQL queries, including SELECT statements, JOINs, filtering, grouping, and aggregations.
• Experience supporting business applications, databases, or operational reporting needs.
• Strong troubleshooting, analytical, and problem-solving skills.
• Ability to work independently while following direction, documentation, and escalation procedures.
• Detail-oriented with strong organizational and communication skills.
• Comfortable supporting users in a business or manufacturing environment.

Preferred Qualifications

• Experience with Infor Visual ERP or similar manufacturing/ERP systems.
• Experience with reporting tools such as SSRS, Crystal Reports, Power BI, or similar platforms.
• Experience with Active Directory, Group Policy, Windows Server, and file permissions.
• Experience with Microsoft 365, GCC High, Exchange Online, Intune, Defender, or cloud-based administration.
• Experience with virtualization platforms such as Hyper-V or VMware.
• Familiarity with cybersecurity concepts, endpoint protection, vulnerability management, audit evidence, or compliance documentation.
• Relevant certifications such as CompTIA A+, Network+, Security+, Microsoft, SQL, Cisco, or similar are a plus.

The salary range is $70,000-$90,000.

#IND2