ATS Company: PA Solutions Requisition ID: 13806 Location: Asheville, NC, US, . Date: Dec 6, 2024 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 J oin the Winning Team at PA Solutions, Inc. (a global division of ATS Automation) . We help exceptional customers automate their manufacturing asTooling System Integrators. We work with Global OEM's/Tier suppliers supporting transportation and aerospace industries. Take your place among the best in the business and grow your career with PA Solutions, Inc. Join an environment where a passion for innovation is combined with an uncompromised commitment to quality. PA Solutions, Inc. offers a superior benefits package designed with you in mind! If you would like to automate your future, check us out and be a part of our unprecedented growth! All qualified applicants will receive consideration for employment without regard to race, color, religion or belief, national, social or ethnic origin, sex (including pregnancy), age, physical, mental or sensory disability, HIV status, sexual orientation, gender identity and/or expression, marital, civil union or domestic partnership status, past or present military service, family medical history or genetic information, family or parental status, or any other status protected by the laws or regulations.