Design and maintain interfaces for contextualized data acquisition (APRM), including alarms, events, and audit trail information.
Build and refine SQL queries to extract, transform, and manage production and system data.
Contribute to investigations and design activities related to Plug & Produce (P&P) for smooth integration between MES and Historian platforms.
Review and validate technical documentation for system interfaces.
Support validation activities by executing and documenting test cases to ensure system readiness and compliance.
Collaborate with Digital, Automation, MES, MSAT, and Global teams to analyze and resolve application incidents, ensuring timely follow-up and resolution.
Troubleshoot and resolve connectivity and data flow issues across MES, PLC, DCS, and Historian systems.
Monitor performance and availability of Historian platforms to ensure stability and reliability.
Perform regular maintenance tasks such as log reviews, job monitoring, and health checks.
Ensure robust backup and recovery processes are in place and validated.
Participate in upgrade projects, performing impact analysis and ensuring alignment with compliance and validation requirements.
ABOUT YOU
Proficiency in both Waterfall and Agile project methodologies.
Solid expertise in deploying and configuring Aspen Historian Suite (Aspen IP.21, Aspen Production Record Manager, Event21, CIM-IO, Batch Extractor, Aspen SQL+).
Experience with Kepware configuration, including driver setup for protocol transactions and data aggregation.
Background in pharmaceutical manufacturing environments.
Proven track record of integrating automation and control systems such as:DCS (e.g., Emerson DeltaV) SCADA platforms (WinCC, Wonderware) PLCs, benchtop instruments, and lab/manufacturing equipment
Databases: MySQL, Microsoft SQL Server, Oracle Data and industrial protocols: ODBC, FTP, MQTT, OPC-UA, OPC-DA, Modbus Scripting and automation: PowerShell scripting for automation and data management
Knowledge of IT infrastructure, networking principles, and operating systems (Windows/Linux).
