[Remote] SQL Server Consultant

Note: The job is a remote job and is open to candidates in USA. Yochana is seeking a SQL Server Syncade MES Expert to provide technical expertise for Emerson Syncade MES applications and their underlying architecture. The role focuses on resolving application and database performance issues, optimizing SQL Server environments, supporting integrations, and recommending architecture and operational improvements.

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

Skills

• 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

Benefits

• Remote work arrangement
• Contract mode

Company Overview

Yochana IT Solutions | Founded in Michigan, 2009 Headquartered at 23000 Commerce Drive, Farmington Hills, MI 48335. It was founded in 2009, and is headquartered in Farmington Hills, Michigan, USA, with a workforce of 201-500 employees. Its website is http://yochana.com/.

Company H1B Sponsorship

Yochana has a track record of offering H1B sponsorships, with 8 in 2026, 21 in 2025, 11 in 2024, 3 in 2023. Please note that this does not guarantee sponsorship for this specific role.