Perform SQL Server performance tuning, including query optimization, indexing strategies, execution plan analysis, and database health assessments. Strong expertise in SQL query tuning, stored procedures, indexing, database design, and performance monitoring tools.
Numbers & Facts
Location
Pheonix, AZ (Remote)
Industry
Computer Software
Company Size
20 to 49 employees
Year Founded
2014
Website
http://www.tekfortune.com/
Description
Job Title: SQL Server Syncade Expert Location: REMOTE Mode : Contract (6+ Months) Onsite Rate - $65/hr. USC/GC only
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.
About Company
Tekfortune is a software solutions company providing project development and staff augmentation services to companies in various industries including Healthcare, Banking, Finance, Telecommunication and Aviation.
Tekfortune Inc delivers solutions to a wide variety of organizations of various sizes and industries. Our clients include mid-market to Fortune 1000 companies spanning across industries such as: Insurance, Financial, Pharmaceutical, Manufacturing, Retail and many others.
In Tekfortune Inc, we are offering selection of services and solutions at very reasonable rates. With years of experience in the placement and recruitment Industry and over time we have acquired the knowledge essential to comprehend the exact need and dependence on customers. Therefore we provide the customers the best and also the brightest candidates for vacancies. Moreover, by understanding the working interest of customers who is able to place them within the companies where they are able to get maximum opportunity for professional growth.
Tekfortune Inc has a strong emphasis on quality. Its goal would be to achieve client satisfaction by looking into making deliveries satisfaction of customer's business needs. Our ability to quickly identify and effectively employ proven fundamental principles, techniques and resources yields highly desirable results for our clients.
We understand that each industry and organization share a level of uniqueness that requires a tailored approach in order to deliver specific solutions. Such factors as client culture, industry regulations, organizational maturity, financial health and many more items may impact our approach to delivering client solutions.
Having served a wide variety of clients has provided Tekfortune the ability to build subject matter expertise across numerous industries. Our industry expertise combined with our specialized knowledge of Business Process Improvement, Requirements Management and Program & Project Management provides a powerful combination and a tremendous value to our clients.
We are run by a group of industry experts who have decades of experience in delivering custom solutions to our clients.