Application Database Developer

Consulguru Pte. Ltd.; Singapore; On-site; SGD 90,000 - 130,000; Full time

Job summary

Consulguru Pte. Ltd. seeks an Application & Database Developer to design, develop, and maintain software applications and database systems for manufacturing operations.

You will work across full-stack development, database design, and performance tuning, collaborating with IT and OT teams to deliver scalable, secure solutions. The role involves building APIs for IT-OT data exchange, optimizing relational databases, and supporting digital transformation projects such as predictive maintenance and

Qualifications

• Bachelor's degree in computer science, IT, or related field.
• 3–5 years of relevant experience in application support; strong understanding of application architecture and databases.

Responsibilities

• Develop and maintain custom web, desktop, or mobile applications for manufacturing operations (e.g., MES, SPC, Equipment Tracking, Quality Management).
• Integrate applications with factory systems such as ERP, MES, SCADA, PLCs, and data historians.
• Design APIs and interfaces for seamless data exchange between IT and OT systems.
• Support the automation of manufacturing workflows, reporting, and analytics dashboards.
• Design, build, and optimize relational databases (Oracle, PostgreSQL, SQL Server, etc.).
• Develop complex SQL queries, stored procedures, triggers, and ETL scripts.
• Manage database performance tuning, backup/recovery, and data integrity.
• Collaborate with data engineers to structure data for analytics and reporting.
• Work closely with manufacturing engineers, process owners, and IT infrastructure teams to gather requirements and deliver scalable solutions.
• Provide technical support for deployed applications and databases, including troubleshooting and enhancements.
• Ensure compliance with cybersecurity, audit, and change management standards.
• Contribute to digital transformation projects such as predictive maintenance, AI/ML model integration, and factory data lakes.
• Identify automation opportunities and propose system improvements.
• Document system architecture, workflows, and procedures.

Skills

Analytical thinking

Problem solving

Communication skills

English proficiency

Education

Bachelor's degree in computer science, IT, or related field

Tools

Oracle

PostgreSQL

SQL Server

REST APIs

Kafka

MQTT

Git

Azure

AWS

GCP

Job description

Job Summary

The Application & Database Developer is responsible for designing, developing, and maintaining software applications and database systems that support business operations. This role involves full stack development, database design, performance tuning, and close collaboration with cross-functional teams to ensure high-quality, scalable, and secure solutions.

Key Responsibilities

Application Development

• Develop and maintain custom web, desktop, or mobile applications for manufacturing operations (e.g., MES, SPC, Equipment Tracking, Quality Management).
• Integrate applications with factory systems such as ERP, MES, SCADA, PLCs, and data historians.
• Design APIs and interfaces for seamless data exchange between IT and OT systems.
• Support the automation of manufacturing workflows, reporting, and analytics dashboards.

Database Development

• Design, build, and optimize relational databases (Oracle, PostgreSQL, SQL Server, etc.). o Develop complex SQL queries, stored procedures, triggers, and ETL scripts.
• Manage database performance tuning, backup/recovery, and data integrity.
• Collaborate with data engineers to structure data for analytics and reporting.

Operations & Support

• Work closely with manufacturing engineers, process owners, and IT infrastructure teams to gather requirements and deliver scalable solutions.
• Provide technical support for deployed applications and databases, including troubleshooting and enhancements.
• Ensure compliance with cybersecurity, audit, and change management standards.

Continuous Improvement

• Contribute to digital transformation projects such as predictive maintenance, AI/ML model integration, and factory data lakes.
• Identify automation opportunities and propose system improvements.
• Document system architecture, workflows, and procedures.

Required Skills & Qualifications

Must Have

• Bachelor's degree in computer science, IT, or related field
• 3–5 years of relevant experience in application support o Strong understanding of application architecture and databases

Proficiency in

• Languages: Java, Python, C#, Node.js
• Web Frameworks: .NET, Flask, JavaScript
• Databases: Oracle, PostgreSQL, ETL, Stored Procedures, SQL Server
• Integration: REST APIs, Kafka, MQTT o Excellent problem-solving and communication skills
• Ability to communicate effectively in English (verbal and written)
• Experience with data modeling, performance tuning, and version control (Git).
• Familiarity with cloud and on-prem hybrid environments (GCP,Azure, AWS, etc.).

Good to Have

• Experience with Rest API, Web backend, SQL and No-SQL databases o Experience with big data platforms and real-time data processing o Familiarity with DevOps tools and CI/CD pipelines
• Experience working with cross-functional teams (e.g., manufacturing, engineering)
• Ability to create user guides and training materials o Understanding of factory security, safety, and quality standards

Nice to Have

• Knowledge of ITIL processes (Incident, Problem, Change Management) o Familiarity with cloud platforms (AWS, Azure) o Experience with monitoring tools (e.g., Zabbix)
• Understanding of information security best practices and compliance standards
• Experience in automation and process improvement initiatives