SQL Database Administrator – MES
KONE
full-time
Posted on:
Location Type: Office
Location: Chennai • 🇮🇳 India
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
SQL
About the role
- Manage, maintain, and continuously improve the performance and reliability of MES databases across multiple factory sites
- 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
- Manage orphan record deletions to maintain database integrity
- Develop and manage SQL jobs for MES failed alert handling
- Proactively analyze database health and propose optimization strategies
Requirements
- 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
Benefits
- Employee engagement focus
- Innovative and collaborative working culture
- Opportunities for personal and career growth
- Ethical business practices
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQL Server DBAindex analysisquery tuningperformance optimizationExtended Eventsdeadlock troubleshootingSQL job setupautomationdatabase archival strategiesMES database structures
Soft skills
ability to work in a global environmentstakeholder management