SQL Database Administrator – MES

21 hours ago

Chennai, Tamil Nadu, India KONE Full time ₹ 8,00,000 - ₹ 24,00,000 per year

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.

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.

Read more on

  • Ms Sql Database Administrator

    5 days ago

    Chennai, Tamil Nadu, India Computer Age Management Services (CAMS) Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Job Title: MSSQL Server Database Administrator (4+ Years Experience)COMPANY DESCRIPTIONAbout CAMS: Computer Age Management Services (CAMS) is the leading Mutual Fund Transfer Agency to the Indian Asset Management Companies servicing ~70% of the MF Industry AUM. CAMS is also a technology enabled service solutions partner to Private Life Insurance, Private...

  • Microsoft SQL Server Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India Tata Consultancy Services Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Walkin Interview at TCS, Chennai (TCS sholinganallur , Kumaran Nagar, 415/21-24, TNHB Main Rd, Chennai, Tamil Nadu Role- Microsoft SQL Server Database AdministratorYears of Experience - 4 to 10 years Location - ChennaiMicrosoft SQL Server 2000, 2005, 2008 R2 & 2012 Administration3 - 6 years of experience in Microsoft SQL Server Database Administration....

  • SQL Database Administrator

    4 weeks ago

    Chennai, Tamil Nadu, India Sanmina Full time

    Job DescriptionKey Responsibilities:- 5+ years of experience in administration and maintenance of MSSQL, PostgreSQL, and MySQL database engines.- Strong knowledge of DBA administrative tasks and database engine architecture.- Well-versed in implementing robust database security practices.- Experience in cloud-based database hosting, preferably in Google...

  • Sql Database Administrator

    4 weeks ago

    Chennai, Tamil Nadu, India Sanmina Full time

    Job DescriptionRole & Responsibilities:- Administer and maintain MSSQL, PostgreSQL, and MySQL database environments with 3+ years of hands-on experience.- Perform core DBA administrative tasks with a strong grasp of database engine architecture.- Implement and maintain robust database security protocols.- Manage cloud-based database hosting, preferably on...

  • SQL Database Administrator

    4 weeks ago

    Chennai, Tamil Nadu, India Sanmina Full time

    Job DescriptionKey Responsibilities:- Administer and maintain MSSQL, PostgresDB, and MySQL database engines with 5+ years of hands-on experience.- Perform core DBA administrative tasks and understand DB engine architectures in depth.- Establish and maintain strong database security protocols and standards.- Manage cloud-based database hosting, preferably on...

  • Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India MWIDM Staffing Services Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Responsibilities :Install, configure, and maintain PostgreSQL database servers and clusters across different environments (development, testing, production). Implement and maintain database security measures, including user management, access control, and data encryption. Perform database backups and recovery procedures, ensuring data integrity and...

  • Senior Sql Database Administrator

    5 days ago

    Chennai, Tamil Nadu, India Colan Infotech Private Limited Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Greetings from Colan InfotechDesignation - SQL DBAExperience - 7+ YearsJob Location - ChennaiNotice Period - Immediate to 15 DaysKey Responsibilities:Manage and maintain high-performance SQL Server databases supporting critical capital markets applicationsPerform backup, recovery, high availability (HA), and disaster recovery (DR) planning and...

  • Database Administrator

    1 week ago

    Chennai, Tamil Nadu, India MAGELLANIC CLOUD LIMITED Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We are seeking a skilled and experienced Database Administrator (DBA) to manage and support our database environments. The ideal candidate will be responsible for maintaining the performance, integrity, and security of our databases. You will work closely with other IT team members and stakeholders to ensure our data systems operate efficiently and meet...

  • MES Engineer

    1 week ago

    Chennai, Tamil Nadu, India Hsi Automotive Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    MES architecture and production data flows manufacturing processes and on-site communication Experience with Oracle or MS-SQL database management Proficiency in Java or C# development Knowledge of equipment interface protocols (PLC integration)

  • Database Administrator

    2 weeks ago

    Chennai, Tamil Nadu, India PayTabs Global Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Key ResponsibilitiesInstall, configure, upgrade, and patch MySQL database instances across various environments (development, staging, production).Monitor database performance, availability, and capacity, implementing proactive measures to prevent issues.Set up and manage comprehensive database backup, recovery, and disaster recovery strategies, conducting...