SQL Server Syncade Expert

CYNET SYSTEMS INC.

New Brunswick, NJ, United States

1 day ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$97,760.0 - $108,160.0

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Databases Database Design Software Debugging Electronic Data Interchange (EDI) Microsoft SQL Server Performance Tuning Query Optimization SQL Stored Procedures SQL Databases Data Streaming Systems Integration Enterprise Software Applications

+4 more

Database Optimization Indexer Syncade Performance Monitor

Job description

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.

Requirements

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., * Emerson Syncade MES.
Microsoft SQL Server.
Performance Tuning.
SQL Query Optimization.
Database Administration.
System Integration.
Root Cause Analysis.

Benefits & conditions

Our Benefits Include:

Medical, Dental, and Vision Insurance
401(k) Retirement Plan
Health Savings Account (HSA)
Disability Insurance (Short-Term and Long-Term)
Life and AD&D Insurance
Paid Sick Leave (where required by applicable state or local law)
Supplemental Insurance Plans
Identity Theft Protection
Pet Insurance
Employee Wellness Programs
Employee Assistance Program (EAP)
Career Growth and Professional Development Opportunities

About the company

Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia.