Ignition - SQL Developer

Long Description

Job Title: Ignition/MS SQL Developer 
Location: Asheville, NC
Job Summary
We are seeking a highly skilled Ignition/MS SQL Developer to join our dynamic team. The ideal candidate will have a deep understanding of Ignition SCADA development and proficiency in Microsoft SQL Server, with experience in database design, scripting, and troubleshooting. This role involves creating, deploying, and managing data-driven applications in a manufacturing or industrial environment.
Responsibilities
Ignition Development:
1.    Design, develop, and maintain Ignition applications, dashboards, and HMIs.
2.    Configure and manage Ignition Gateways, projects, and tags.
3.    Integrate Ignition with PLCs, OPC servers, and other industrial devices.
4.    Implement scripting and automation using Python in Ignition.
SQL Server Development:
1.    Design and optimize database schemas, tables, views, and indexes.
2.    Develop, test, and maintain complex SQL queries, stored procedures, and triggers.
3.    Analyze and troubleshoot database performance issues.
4.    Implement data integration solutions, including ETL processes.
Integration & Data Analytics:
1.    Integrate data from Ignition applications with Microsoft SQL Server.
2.    Create real-time data analytics and reporting solutions.
3.    Work with APIs and third-party integrations to enhance system functionality.
Collaboration:
1.    Work closely with cross-functional teams, including engineers, IT, and operations.
2.    Provide training and technical support for Ignition and SQL-based solutions.
3.    Ensure documentation of all development activities and system configurations.
Maintenance & Optimization:
1.    Monitor system performance and implement improvements as needed.
2.    Perform regular system updates and ensure data security compliance.
3.    Troubleshoot issues and provide timely resolutions.

Long Description

Qualifications:
1.    Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent experience).
2.    Proven experience with Ignition SCADA platform (Ignition 8.1 preferred).
3.    Strong knowledge of MS SQL Server (database design, T-SQL scripting, and optimization).
4.    Experience in Python scripting, especially within Ignition.
5.    Familiarity with industrial protocols (e.g., OPC UA, Modbus, BACnet).
Preferred:
1.    Experience in manufacturing, process control, or industrial automation environments.
2.    Knowledge of Ignition Perspective and Vision modules.
3.    Understanding of network architecture and IT/OT convergence.
4.    Certifications in Ignition or Microsoft SQL Server.
Skills & Competencies:
1.    Excellent problem-solving and analytical skills.
2.    Strong communication and interpersonal abilities.
3.    Ability to work independently and in team settings.
4.    Attention to detail and commitment to delivering high-quality solutions.
 Responsibilities for Health, Safety and Environment include:
1.    Work in compliance with divisional health, safety, and environmental procedures
2.    Refrain from removing or altering safety devices or guarding unless hazardous energies are controlled through lockout-tagout methods
3.    Report any unsafe conditions or unsafe acts 
4.    Report defect in any equipment or protective device
5.    Ensure that the required protective equipment is used for the assigned tasks
6.    Attend all required health, safety, and environmental training
7.    Report any accidents/incidents to supervisor
8.    Assist in investigating accidents/incidents
9.    Refrain from engaging in any prank, contest, feat of strength, unnecessary running, or rough and boisterous conduct