Sr. Application Analyst

UNISOFT INFOTECH PTE LTD; Singapore; On-site; SGD 50,000 - 80,000; Full time

Job summary

A technology solutions provider in Singapore is looking for an experienced Application & Database Developer. The role involves designing and building applications and databases for manufacturing operations, integrating systems, and improving workflows. Ideal candidates hold a Bachelor's degree in IT with 3-5 years of relevant experience. Strong skills in Java, Python, and database management are required. Join a cross-functional team to contribute to digital transformation projects.

Qualifications

• 3–5 years of relevant experience in application support.
• Strong understanding of application architecture and databases.
• 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.

Responsibilities

• Design, develop, and maintain software applications and database systems.
• Develop and maintain custom applications for manufacturing operations.
• Design APIs for seamless data exchange.
• Manage database performance tuning and data integrity.
• Provide technical support for deployed applications and databases.

Skills

Java

Python

C#

Node.js

SQL

ETL

REST APIs

Kafka

MQTT

Data Modeling

DevOps

Git

Education

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

Tools

Oracle

PostgreSQL

SQL Server

GCP

Azure

AWS

Job description

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.

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.).
• 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
• Strong understanding of application architecture and databases
• Proficiency in:
  1. Languages: Java, Python, C#, Node.js
  2. Web Frameworks: .NET, Flask, JavaScript
  3. Databases: Oracle, PostgreSQL, ETL, Stored Procedures, SQL Server
  4. Integration: REST APIs, Kafka, MQTT
• 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
• Experience with big data platforms and real‑time data processing
• 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
• Understanding of factory security, safety, and quality standards