SQL Database Administrator – MES

KONE.com

Office

Chennai ITEC/KBS, India

Full Time

Job Title: SQL Database Administrator – MES

Location: Preferably Chennai India or Pune
Experience: 5+ Years (SQL Administration)

Role Overview

We are looking for an experienced SQL Database Administrator to manage, maintain, and continuously improve the performance and reliability of our MES (Apriso) databases across multiple factory sites. The ideal candidate will have strong SQL Server expertise, a proactive mindset for optimization, and hands-on experience in troubleshooting and performance tuning.

Key Responsibilities

Database Maintenance & Optimization
Perform monthly index analysis and creation for all MES factory sites.
Identify and optimize expensive queries for improved system performance.
Monitor deadlocks and expensive queries using Extended Events.
Apply best practices for SQL Server performance tuning and query optimization.
Data Management & Archival
Manage orphan record deletions to maintain database integrity.
Update and maintain archival scripts:
Identify missing tables, copy data to archival server, and extend deletion coverage.
Automation & Monitoring
Develop and manage SQL jobs for MES failed alert handling.
Ensure monitoring scripts are in place and effective across environments.
Continuous Improvement & Support
Proactively analyze database health and propose optimization strategies.
Work closely with MES operations teams, application owners, and infra teams to ensure reliable DB operations.
Contribute to incident RCA (Root Cause Analysis) and implement corrective/preventive actions.
Perform monthly index analysis and creation for all MES factory sites.
Identify and optimize expensive queries for improved system performance.
Monitor deadlocks and expensive queries using Extended Events.
Apply best practices for SQL Server performance tuning and query optimization.
Manage orphan record deletions to maintain database integrity.
Update and maintain archival scripts:
Identify missing tables, copy data to archival server, and extend deletion coverage.
Identify missing tables, copy data to archival server, and extend deletion coverage.
Develop and manage SQL jobs for MES failed alert handling.
Ensure monitoring scripts are in place and effective across environments.
Proactively analyze database health and propose optimization strategies.
Work closely with MES operations teams, application owners, and infra teams to ensure reliable DB operations.
Contribute to incident RCA (Root Cause Analysis) and implement corrective/preventive actions.

Required Skills & Experience

5+ years of hands-on experience as a SQL Server DBA.
Strong knowledge of Apriso MES database structures and integration.
Proven expertise in:
Index analysis and creation.
Query tuning & performance optimization.
Extended Events and deadlock troubleshooting.
SQL job setup and automation.
Experience in database archival strategies.
Ability to work in a global, multi-site environment with multiple stakeholders.
Index analysis and creation.
Query tuning & performance optimization.
Extended Events and deadlock troubleshooting.
SQL job setup and automation.

Soft Skills & Values

Collaboration: Able to work effectively with IT, business, and partner teams across regions.
Customer focus: Proactive in ensuring systems meet factory operational needs with minimal downtime.
Courage: Takes ownership, challenges the status quo, and drives improvements even in complex environments.
Care: Ensures reliability and integrity of data that directly impacts manufacturing operations.
Strong problem-solving and analytical thinking.
Excellent communication skills, both written and verbal.

Nice-To-Have Skills

Experience in manufacturing IT / MES domain.
Familiarity with ITIL processes (incident, problem, change management).
Knowledge of cloud migration or hybrid DB setups.

At KONE, we are focused on creating an innovative and collaborative working culture where we value the contribution of each individual. Employee engagement is a key focus area for us and we encourage participation and the sharing of information and ideas. Sustainability is an integral part of our culture and the daily practice. We follow ethical business practices and we seek to develop a culture of working together where co-workers trust and respect each other and good performance is recognized. In being a great place to work, we are proud to offer a range of experiences and opportunities that will help you to achieve your career and personal goals and enable you to live a healthy and balanced life.