System Analyst (SQL / Oracle / ASP.Net / C# / AWS+VB)

at  Trust Recruit Pte Ltd

REQUIREMENTS:

• Bachelor Degree in Information Technology and Computer Science
• SQL; Oracle PL/SQL; MS SQL Server Transact-SQL
• Object-oriented analysis and design

• Develop, support and enhance the Data Download Centre (including Engineering Portal) and iSCM websites.
• Develop, support and enhance Excel productivity enhancement tools (VBA macros).
• Support end-users in usage of Plasma and ACCPAC and help to resolve any operational issues, including working together with vendor (YHQ or Databit) if necessary.
• Develop and enhance data extraction and transformation mechanisms on source systems (e.g. Plasma, YEOS, NYQT, Oracle BI, SAP RFC, PTS etc.) and store the results into Plasma Info Server Monitor the space consumption of Plasma Info so that Server database so that potential problems (e.g. disproportionate consumption of disk space by a particular table, depletion of data tablespace, excessive consumption of temp tablespace) are detected and resolved early to avoid unscheduled database downtime.
• Perform ad-hoc retrieval of order/production/sales data to support incident
• investigation, reporting or other requests.
• Support Migration Activities of Existing Plasma Info Server to SAP.Support & ensure successful implementation of Company-wide Automation (ERP) Projects.