IT Systems & ERP/SQL Support Specialist

Executive Alliance; Hauppauge (NY); On-site; USD 85,000 - 120,000; Full time

Job summary

Executive Alliance seeks an IT Systems & ERP/SQL Support Specialist to join its IT team in a defense manufacturing environment. You will support the Infor Visual ERP, SQL Server and Windows infrastructure, while developing expertise across reporting, 365 services, and security/compliance.

You will work under IT leadership to support ERP, databases, users, and core IT systems, and to ensure secure, well-documented operations with ongoing reporting and data validation.

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 (SELECT, JOIN, filters, groupings).
• Experience supporting business applications, databases, or reporting needs.
• Strong troubleshooting, analytical, and problem-solving skills.
• Ability to work independently with documentation and escalation procedures.
• Detail-oriented with strong organizational and communication skills.
• Comfortable supporting users in a business/manufacturing environment.

Responsibilities

• Support and maintain Infor Visual ERP environment including user support and reporting.
• Write and troubleshoot SQL queries for reporting and data validation.
• Assist with SQL Server maintenance, backups, and documentation.
• Generate reports for operations, finance, quality, production and leadership.
• Provide Tier 1-2 IT support for users, devices, and software.
• Assist with Windows Server, AD, GPO, file shares and permissions.
• Support Microsoft 365/GCC High administration tasks and security configurations.
• Support CMMC 2.0 / NIST SP 800-171 compliance activities and documentation.
• Document procedures, troubleshooting steps, and system changes.
• Escalate risks and issues to IT leadership promptly.

Skills

IT support

SQL queries

ERP systems

Windows administration

Reporting

Manufacturing IT

Tools

Infor Visual ERP

Microsoft SQL Server

SSRS/Crystal/Power BI

Active Directory

Windows Server

Microsoft 365

GCC High

Hyper-V/VMware

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