SQL Database Administrator – MES
5 days ago
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
-
Senior Sql Database Administrator
7 days ago
Pune, Maharashtra, India Vastika Inc Full time ₹ 12,00,000 - ₹ 24,00,000 per yearRequired Skills and Experience:5+ years hands-on experience with Microsoft SQL Server 2016–2019/2022 administration and development.Proven track record in cloud database migrations , especially Azure → GCP or on-prem → Cloud .Strong expertise in:T-SQL scripting, stored procedures, views, triggersPerformance tuning, indexing, query plan...
-
Ms Sql Database Administrator
1 week ago
Pune, Maharashtra, India The Digital Group Infotech Full time US$ 90,000 - US$ 1,20,000 per yearThe Job Description is as below -- Minimum 6 years experience MS SQL Database Administration- Atleast 2 years experience in Snowflake is mandatory.- Experience Replication, Performance Tuning etc is mandatory.- Candidate shoould be flexible working 24*7 shift.- Experience in Azure SQL is preferred.
-
Pune, Maharashtra, India VOIS Full time ₹ 15,00,000 - ₹ 25,00,000 per yearA Database Administrator (DBA) is responsible for ensuring the performance, security, availability, and reliability of Oracle databases. The role blends technical expertise with operational efficiency to support business-critical applications.5+ years of expAdvanced knowledge of Oracle Database ArchitecturePerform advanced SQL tuning, indexing, partitioning,...
-
MES Consultant
2 weeks ago
Pune, Maharashtra, India Enhanced Information Solutions Full time ₹ 12,00,000 - ₹ 36,00,000 per yearThe full-time Manufacturing Execution Systems (MES) Consultant will focus on providing consulting services for our clients in the biotech and pharmaceutical industries.The MES consultant will work on project teams to assist with the implementation or support of MES and is expected to perform various roles in the software development life cycle, including...
-
MES Developer
1 day ago
Pune, Maharashtra, India Peoplefy Full time ₹ 9,00,000 - ₹ 12,00,000 per yearWe're Hiring: MES Developer – Pune, IndiaAre you a passionate developer with experience in building and supporting Manufacturing Execution Systems (MES)? We're looking for someone who thrives in a dynamic environment and loves solving real-world industrial challenges through technology. Key Skills We're Looking For: Strong experience in C#, .NET, and...
-
Database Administrator
2 weeks ago
Pune, Maharashtra, India Programming Full time ₹ 2,00,000 - ₹ 6,00,000 per yearJob Description : We are looking for a junior database administrator (DBA) to join our IT team and help us manage and maintain our databases. You will be responsible for ensuring the security, availability, performance, and integrity of our data. You will also assist in database design, development, backup, recovery, and troubleshooting. You will work as...
-
Mes Developer
5 days ago
Pune, Maharashtra, India Peoplefy Infosolutions Full time ₹ 9,00,000 - ₹ 12,00,000 per yearWe're Hiring: MES Developer Pune, India Are you a passionate developer with experience in building and supporting Manufacturing Execution Systems (MES)? We're looking for someone who thrives in a dynamic environment and loves solving real-world industrial challenges through technology. Key Skills We're Looking For:Strong experience in C#, .NET, and...
-
Database Administrator
2 weeks ago
Pune, Maharashtra, India Systems Plus Full time ₹ 15,00,000 - ₹ 25,00,000 per yearLocation: PuneEmployment Type: full-timeDesignation: Database AdministratorJob DetailsJob Description:SQL Server installation, configuration, and database maintenanceDatabase design, index strategies, and stored procedures. Skills in writing, debugging and optimizing T-SQL queries and scriptsKnowledge of database backup strategies, recovery models, disaster...
-
Database Administrator
2 weeks ago
Pune, Maharashtra, India Cummins Full time ₹ 12,00,000 - ₹ 24,00,000 per yearDescriptionJob Summary:Responsible for the installation, creation, monitoring, support, maintenance and optimization of databases; participates in design; ensures secure database access, data integrity and security, as well as manages performance and capacity.Key Responsibilities:Analyzes data on existing databases and makes process improvement and...
-
Database Administrator
2 days ago
Pune, Maharashtra, India Cummins Full time ₹ 10,00,000 - ₹ 25,00,000 per yearDESCRIPTIONJob Summary:Responsible for the installation, creation, monitoring, support, maintenance and optimization of databases; participates in design; ensures secure database access, data integrity and security, as well as manages performance and capacity.Key Responsibilities:Analyzes data on existing databases and makes process improvement and...
