ERP & SQL Systems Specialist – IT, Reporting & Compliance

Mindscope

Hauppauge (NY)

On-site

USD 70,000 - 90,000

Full time

2 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

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.