Data Integration & Historian Specialist (Pharma, Contract)

12 Months Contract

Location: Tuas

Up to $8,000 depending on experience

Industry: Pharmaceutical

Our client aims at creating a new manufacturing concept consisting of a new generation of evolutive multi-product facilities, modular, adaptable, and agile, leveraging new disruptive technologies, to better address vaccine business challenges

Responsibilities:

• Define and support equipment interfacing to enable contextualized data acquisition (APRM), including Alarm & Event and Audit Trail data.
• Develop and optimize SQL queries to extract and manage relevant data.
• Collaborate on Plug & Produce (P&P) investigations and design efforts for seamless integration between MES and Historian systems.
• Review and approve technical specifications for system interfaces.
• Provide support for test case execution and perform teat case activities as required, ensuring system readiness and compliance with defined requirements.
• Act as a liaison between Digital and other cross function team (Automation, MES and MSAT) as well as Global Teams to support and troubleshoot for application-related incidents, ensuring timely resolution and effective communication.
• Diagnose and resolve issues related to data acquisition and interface connectivity between MES, PLC, DCS, and Historian systems.
• Monitor application performance and availability to ensure continuous operation of the Historian system.
• Conduct routine maintenance tasks including log reviews, job monitoring, and system health checks.
• Ensure robust backup and recovery procedures are in place and regularly tested.
• Participate in Historian upgrade activities, including impact assessments to evaluate risks, dependencies, and validation requirements.

Requirements:

• Proficient in both Waterfall and Agile project methodologies
• Deep expertise in deploying and configuring Aspen Historian Suite, including Aspen IP.21, Aspen Production Record Manager (APRM), Event21, CIM-IO, Batch Extractor and Aspen SQL +
• Skilled in configuring Kepware, including driver setup for protocol transaction and data aggregation
• Experienced working in pharmaceutical manufacturing environments
• Proven experience integrating with a wide range of automation and control systems:

1. DCS systems such as Emerson DeltaV
2. SCADA platforms including WinCC and Wonderware
3. PLCs, benchtop instruments, and other lab/manufacturing equipment

• Technical Proficiencies

1. Database: MySQL, Microsoft SQL Server, Oracle
2. Data and Industrial Protocols: ODBC, FTP, MQTT, OPC-UA, OPC-DA, Modbus
3. Scripting & Automation: PowerShell scripting for automation and data handling

• Infrastructure Knowledge: In-depth understanding of networking principles and operating systems (Windows/Linux)

Lim Pey Chyi - Apple.lim@manpower.com.sg

Recruitment Consultant (R2090579)

Manpower Staffing Services (S) Pte Ltd

EA Licence: 02C3423