Application & Database Development - Application Analyst / Engineer

Decimal Business Solutions Pte Ltd; Singapore; On-site; SGD 70,000 - 90,000; Full time

Job summary

A technology solutions provider in Singapore seeks an Application Analyst/Engineer to develop and maintain applications tailored for manufacturing operations. The role involves integrating these applications with factory systems, designing APIs, and managing databases. Candidates should have a strong background in web application development and database management, with a focus on automation and data analytics. This position offers a chance to contribute to digital transformation projects and support manufacturing efficiency.

Responsibilities

• Develop and maintain custom web, desktop, or mobile applications for manufacturing operations.
• Integrate applications with factory systems such as ERP, MES, and PLCs.
• Design APIs and interfaces for data exchange between IT and OT systems.
• Support the automation of manufacturing workflows and analytics dashboards.
• Design, build, and optimize relational databases (Oracle, PostgreSQL, SQL Server).
• Manage database performance tuning, backup/recovery, and data integrity.

Skills

Web application development

Database management

API design

SQL query development

Automation

Generative AI

Tools

Oracle

PostgreSQL

SQL Server

Job description

Role: Application & Database Development - Application Analyst / Engineer

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, 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.
• Generative AI for code development
• Design, build, and optimize relational databases (Oracle, PostgreSQL, SQL Server, etc.).
• Develop complex SQL queries, stored procedures, triggers, and ETL s.
• 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, Agentic AI and BigData.
• Identify automation opportunities and propose system improvements.
• Document system architecture, workflows, and procedures.