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 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, Agentic AI and BigData.
- Identify automation opportunities and propose system improvements.
- Document system architecture, workflows, and procedures.