IT Systems & ERP/SQL Support Specialist (Hauppauge)

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.
• Familiarity 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.