PLM Enovia LCA Support Engineer
The current Product Data Management system is based on ENOVIA LCA and manages all CAD 3D data from Concepts through to Design Release. They have built a data exchange mechanism based upon Siemens TeamCentre to ensure platform data availability for all projects. They use the DELMIA toolset for virtual build assurance and process planning.
Responsibilities will include:
-The continued availability of ENOVIA LCA solution which includes the development of critical enhancements and fixes. Start the planning for the replacement of ENOVIA LCA
-Maintain and enhance as required the bi-directional data exchange mechanism between ENOVIA LCA and CONNECT which facilitates the design process using platforms from other brands
-The continued availability of the DELMIA solution which includes the development of critical enhancements and fixes.
-Provide input into future system landscape assessment based on previous experience and industry exposure
-Perform database administration and configuration management functions such as installing and upgrading the Oracle architecture and all its associated products and application tools.
-Plan for future database system storage requirements.
-Create, manage and optimize primary database storage structures and objects (data files, tables, table spaces, indexes, procedures, triggers, etc.).
-Ensure sufficient system resources are in place to support the operations, growth, resiliency, synchronization, and backup/recovery of all production databases.
-Monitor and maintain the security of databases and database software on corporate, application, database, role, program, and when applicable, table, view; and column levels in cooperation with security experts and systems programmers.
-Conduct database testing when integrating new production releases in support of changes, enhancements, and the integration of new systems/functions.
-Execute data translation, data integration, data reconciliation, data administration, data storage, data warehousing, data mining, and data analysis and reporting as required.
-Maintain data quality through the translation, integration and reconciliation of enterprise data structures and values.
Experience with Oracle
Experience with PL/SQL
Experience with Microsoft SQL Server/ Oracle Enterprise Manager a plus
Experience of Aix and Linux
Working knowledge of Solaris 10 and/or Red Hat Linux 6.0