About this 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.
Update and maintain archival scripts: Identify missing tables, copy data to archival server, and extend deletion coverage.
Develop and manage SQL jobs for MES failed alert handling.
Proactively analyze database health and propose optimization strategies.
Work closely with MES operations teams, application owners, and infra teams to ensure reliable DB operations.

SQL Database Administrator – MES

Key skills