IT Systems & ERP/SQL Support Specialist

Gse Dynamics Inc; Hauppauge (NY); On-site; USD 70,000 - 90,000; Full time

Benefits offered by this job

Paid Time Off

Medical Insurance

401k with company match

Job summary

Gse Dynamics Inc is searching for an IT Systems & ERP/SQL Support Specialist based in Hauppauge, NY. This position focuses on supporting IT operations and developing expertise in Infor Visual ERP, Microsoft SQL Server, and security compliance in a defense manufacturing environment.

The ideal candidate will have at least 2 years of experience in IT support and knowledge of SQL queries. You'll engage with users, assist with ERP systems, and ensure compliance with industry standards.

This full-time role offers a salary range of $70,000 to $90,000 and a comprehensive benefits package including medical, dental, and paid time off.

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.

Responsibilities

• Support and maintain the Infor Visual ERP environment.
• Write and troubleshoot SQL queries for reporting.
• Provide Tier 1-2 IT support for users.

Skills

SQL queries

Troubleshooting

Analytical skills

Problem-solving

Education

2+ years in IT support

Tools

Microsoft SQL Server

Infor Visual ERP

Microsoft 365

Job description

GSE Dynamics, Inc. 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.

Position Summary

• Work directly under IT leadership supporting ERP, databases, users, and core IT systems.
• Develop working expertise in Infor Visual ERP and Microsoft SQL Server.
• Support a CMMC 2.0 / NIST SP 800-171-aligned DoD contractor environment.
• Assist with helpdesk, systems administration, documentation, reporting, and security/compliance activities.
• Gain hands‑on exposure to ERP systems, SQL Server, Microsoft 365, Windows infrastructure, cybersecurity, and compliance in a manufacturing environment.
• This role provides hands‑on exposure to ERP systems, SQL Server, Microsoft 365, Windows infrastructure, cybersecurity, and compliance.
• Opportunity to grow into stronger ERP, database, systems administration, or cybersecurity responsibilities as business needs and candidate capability develop.
• Training and skill development will be aligned with GSE’s IT, manufacturing, and compliance needs.

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.

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.

Security and Compliance Requirements

• U.S. citizenship is required due to the nature of GSE’s defense‑related work, potential access to CUI, ITAR/EAR‑controlled information, and possible future security‑clearance requirements.
• Must be able to work in a DoD contractor environment and comply with company security policies and procedures.
• Must comply with CMMC 2.0, NIST SP 800‑171, CUI handling, access control, and information security requirements.
• Background check will be required.
• Eligibility for future security clearance may be required depending on business needs.
• Reliable, professional, and accountable.
• Detail‑oriented and process‑driven.
• Security‑minded and careful with sensitive information.
• Self‑starter able to work independently while knowing when to escalate.
• Strong problem‑solving mindset and willingness to learn.
• Patient and effective when supporting end users.
• Comfortable working in a fast‑paced manufacturing and defense contractor environment.
• Effective communication and teamwork skills.

Salary Range: $70,000‑$90,000 annually

This is an estimated salary range with any actual compensation offers to be dependent upon factors including experience, skill set, qualifications, and other factors allowed by law.

Job Type: Full‑time

FLSA Classification: Exempt

Benefits Include: Paid Time Off, Medical Insurance, FSA (Flexible Spending Account), Dental Benefit, Aflac Supplemental Insurance, Life Insurance, 401k with company match.