SQL Database Administrator – MES

3 weeks 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



  • 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. -...


  • Chennai, India Infotel UK Full time

    Role: SQL Database Administrator Location: Tata Ramanujan Intellion Park, Chennai. Full-time permanent role. Smurk IT is the Indian branch of Infotel group. Founded more than 40 years ago, the Infotel group is a European key player in digital transformation and IT Consultancy. We are proud to be an innovation leader, specializing in bespoke software...


  • India Bloom Consulting Services Full time

    **MES Camstar Administrator ( Job ID : 000000489 )**: NA Experience **8 - 10 years** Offered Salary Notice Period **Not Disclosed** - MES Camstar Administrator position - Should have Good understanding of MES-Camstar tool - Should have at least 2 years of experience in Modeling, Configurations and Testing Camstar MES systems - Should have Good...


  • 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, Tamil Nadu, India Infotel UK Full time

    Role: SQL Database Administrator Location: Tata Ramanujan Intellion Park, Chennai. Full-time permanent role. Infotel India is a prominent player in digital transformation and IT Consultancy, specializing in tailor-made software solutions for various industries such as automotive, banking, aerospace, and public sectors. We pride ourselves on our ability to...


  • Kolkata, India Tata Consultancy Services Full time

    Job Description We await your innovation at TCS: Hiring | MS SQL Server DBA| Greetings from TCS!! We are Hiring for MS SQL Server DBA Required Experience: 9-15 years Work location: Kolkata Must-Have - Experience in SQL Server database administration (SQL Server 2012 through 2022). - Strong proficiency in installation, configuration, upgrades, and patching. -...


  • India Accolite Digitial Full time

    **About This Role**: We 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. If you want to contribute to exciting...


  • 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...


  • Chennai, India Jobs for Humanity Full time

    Company Description Jobs for Humanity is dedicated to building an inclusive and just employment ecosystem. Therefore, we have dedicated this job posting to individuals coming from the following communities: Refugee, Neurodivergent, Single Parent, Blind or Low Vision, Deaf or hard of hearding, Black, Hispanic, Asian, Military Veterans, the Elderly, the...


  • Chennai, Tamil Nadu, India Virtusa Full time

    We are looking for an experienced SQL Database Administrator/Developer to support the project team from a database perspective. This role will be responsible for setting up the SQL database environment, creating tables, views, and stored procedures, and ensuring database performance, security, and integrity. This dedicated resource will provide the required...