SQL Database Administrator – MES

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

Job summary

A global technology company is seeking an experienced SQL Database Administrator to manage and optimize MES databases across multiple sites in Chennai and Pune. The ideal candidate will have over 5 years of experience in SQL Server, specializing in performance tuning and query optimization. Responsibilities include monitoring database performance, developing SQL jobs, and ensuring data integrity. Candidates should have strong problem-solving abilities and excellent communication skills. Join a collaborative culture focused on innovation and employee engagement.

Qualifications

• 5+ years of hands-on experience as a SQL Server DBA.
• Strong knowledge of Apriso MES database structures.
• Proven expertise in index analysis and query optimization.
• Experience in managing SQL jobs and automation.

Responsibilities

• Manage and optimize MES databases across multiple sites.
• Monitor deadlocks and optimize expensive queries.
• Develop SQL jobs for alert handling.
• Propose optimization strategies based on database health.

Skills

SQL Server expertise

Performance tuning

Query optimization

Database archival strategies

Job description

SQL Database Administrator – MES page is loaded## SQL Database Administrator – MESlocations: Chennai ITEC/KBS: Punetime type: Na pełny etatposted on: Opublikowano dzisiajjob 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.W firmie KONE koncentrujemy się na budowaniu innowacyjnej kultury współpracy, w której cenimy wkład każdej osoby. Zaangażowanie pracowników jest dla nas kluczowym obszarem zainteresowania. Zachęcamy do uczestnictwa i dzielenia się informacjami oraz pomysłami. Zrównoważony rozwój stanowi integralną część naszej kultury i codzienności. Stosujemy etyczne praktyki biznesowe oraz dążymy do rozwoju kultury współpracy, w której współpracownicy ufają sobie wzajemnie i darzą się szacunkiem, a dobre wyniki znajdują uznanie wśród współpracowników. Jako doskonałe miejsce pracy z dumą oferujemy szeroki zakres możliwości, które ułatwią osiągnięcie celów zawodowych i osobistych oraz umożliwią zdrowe, zrównoważone życie.Więcej informacji można znaleźć na stronie