SQL Server Syncade Expert

*Job Title: SQL Server Syncade Expert* *Location: REMOTE* *Key Responsibilities*

• Act as the primary technical SME for *Emerson Syncade MES* applications and underlying architecture.
• Analyze and resolve complex performance issues within Syncade MES applications and associated SQL Server databases.
• Perform SQL Server performance tuning, including query optimization, indexing strategies, execution plan analysis, and database health assessments.
• Support troubleshooting and optimization of *Syncade integrations*, interfaces, and data flows with enterprise systems.
• Conduct root cause analysis of application, database, and integration performance bottlenecks.
• Collaborate with MES, infrastructure, and application teams to improve system stability, scalability, and response times.
• Review application and database architecture and recommend optimization strategies and best practices.
• Support upgrades, enhancements, and ongoing operational excellence initiatives for Syncade MES environments.

*Required Skills & Experience*

• Strong hands-on experience with *Emerson Syncade MES*.
• Expert-level knowledge of *Microsoft SQL Server* administration and development.
• Proven experience in *performance tuning and optimization* of Syncade-based applications.
• Strong expertise in SQL query tuning, stored procedures, indexing, database design, and performance monitoring tools.
• Good understanding of *Syncade integrations*, interfaces, and data exchange mechanisms.
• Experience troubleshooting complex MES production environments.
• Strong analytical, debugging, and problem-solving skills.
• Ability to engage directly with business and technical stakeholders and provide architecture-level recommendations.

Expected hours: 40.0 per week