SQL Server Syncade Expert

Job Overview:

Pay Range: $47.00hr - $52.00hr

Requirement/Must Have:

• 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.

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:

• Emerson Syncade MES.
• Microsoft SQL Server.
• Performance Tuning.
• SQL Query Optimization.
• Database Administration.
• System Integration.
• Root Cause Analysis.