SQL Database Administrator – MES

3 days ago


Chennai India KONE Full time

Job Description 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. Read more on



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

    Job Title: SQL Database Administrator – MESLocation: Preferably Chennai India or PuneExperience: 5+ Years (SQL Administration)Role OverviewWe 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...


  • Chennai, Tamil Nadu, India Kone Full time

    **Job Title**:SQL Database Administrator - MES **Location**:Preferably Chennai India or Pune **Experience**:5+ Years (SQL Administration) **Role Overview** **Key Responsibilities** - **Database Maintenance & Optimization** - Perform monthly index analysis and creation for all MES factory sites. - Identify and optimize expensive queries for improved system...


  • India Lister Digital Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    About This RoleWe are seeking a skilled and experienced Database Administrator (DBA) to join our growing team. This DBA role is a ninja role; We need a detailed oriented person who can dig into a variety of system backends and help find areas of performance and reliability risks in our database infrastructure.The ideal candidate will be responsible for...


  • India Cyanous Software Private Limited Full time

    Job Description Job Title : SQL Database Administrator (DBA) - Support Experience : 5 - 15 Years Location : Greater Noida Employment Type : Responsibilities : - Provide day-to-day support, monitoring, and troubleshooting of Microsoft SQL Server databases. - Install, configure, and maintain SQL Server instances in production and non-production environments. -...


  • india Tanla Platforms Limited Full time

    Job Scope: Responsible for creating, monitoring and maintaining various databases - MySQL, Postgres, Oracle, ClickHouse including NoSQL databases like Cassandra, Mongo DB, Scylla DB etc. Automating routine Database Administration, monitoring and alerting activities using shell scripting, python, Perl etc. Providing DB design solutions, hands-on expert using...


  • India Datacore Technologies Full time

    Role : Database Administrator Job Location : Bangalore/Hyderabad Job Type : Contract Job Description: · 5 years previous experience in a complex corporate IT infrastructure role is essential. · 5 years previous experience in a Senior Database Administrator role is essential. · 2 years previous experience of supporting failover clustering, SAN...


  • india Tata Consultancy Services Full time

    Required Experience & Skillset: For E3- level -- More than 8 years of Experience in IT with a minimum 5 years in SQL administration Expert knowledge of: Installation, configuration and troubleshooting of current and previous MS SQL server versions dating back to 2016 SQL server maintenance tasks SQL server high availability / disaster recovery solutions...


  • Chennai, India NCS SoftSolutions Full time

    Our Team - We take pride in our employee culture, which represents the diverse range of thought we provide to our clients. Be part of our team We're looking for passionate people to join us on our mission. We value flat hierarchies, clear communication and full responsibility. **Database Administrator (SQL)**: Build and Maintain database systems of SQL...


  • Chennai, Tamil Nadu, India GM Infotech Full time

    Professional Qualifications & Skills: - Degree in Computer Science or Information Technology. - 6+ years of experience as a SQL Server Database Administrator in a complex, enterprise-level environment. - Expert-level proficiency in SQL Server database administration, including installation, configuration, monitoring, and troubleshooting. - Demonstrated...


  • Chennai, India SRM Technologies Full time

    SRM Technologies is a global IT services provider offering Cloud and Infrastructure, Digital Transformation, Data and AI, Application Lifecycle, Technology Consulting, Quality Assurance, eCommerce and Product Engineering services. The key industries that benefit from our offerings include Automotive, Manufacturing and Consumer Goods. We offer our customers...