SQL Database Administrator – MES

Kone México; Chennai District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A leading global technology company is looking for an experienced SQL Database Administrator to manage and optimize MES database performance. Based in Chennai or Pune, the role involves overseeing database maintenance, automation, and collaboration with cross-functional teams. Ideal candidates will have over 5 years of experience, strong knowledge of SQL Server, and skills in troubleshooting and optimization. This position offers a chance to work in a dynamic environment with a focus on continuous improvement and collaboration.

Qualifications

• 5+ years of hands-on experience as a SQL Server DBA.
• Strong knowledge of Apriso MES database structures and integration.
• Experience in database archival strategies.

Responsibilities

• Manage, maintain, and improve MES database performance.
• Identify and optimize expensive queries for system performance.
• Monitor deadlocks and expensive queries using Extended Events.

Skills

Strong SQL Server expertise

Index analysis and creation

Query tuning & performance optimization

Extended Events and deadlock troubleshooting

Automation of SQL jobs

Job description

SQL Database Administrator – MES page is loaded## SQL Database Administrator – MESlocations: Chennai ITEC/KBS: Punetime type: Temps pleinposted on: Offre publiée aujourd'huijob requisition id: R0653332**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.**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.**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.Chez KONE, nous nous attachons à créer une culture de travail innovante et collaborative, dans laquelle nous valorisons la contribution de chaque individu. L’engagement de chacun de nos salariés est au cœur de notre démarche collaborative et nous encourageons la participation de chacun ainsi que le partage d’informations et d’idées. Nous nous engageons au quotidien dans une démarche durable et responsable, s’appuyant sur des pratiques commerciales éthiques. Nous développons une culture basée sur la confiance, le respect et le travail en équipe ainsi que sur la reconnaissance de la performance individuelle. Rejoindre KONE, c’est rejoindre une entreprise ou il fait bon vivre, respectueuse de la qualité de vie de chacun de ses collaborateurs. Nous sommes fiers de proposer des parcours de carrières riches en expériences et opportunités qui vous aideront à atteindre vos objectifs professionnels et personnels.En savoir plus sur