Provide in office technical administration and support for SQL Server databases supporting PLM and MES applications, ensuring availability, performance, data integrity, backup and recovery.
Key Responsibilities :
- Administer and monitor SQL Server databases for PLM and MES.
- Create, schedule and monitor full, differential and transaction-log backups.
- Perform database restore, recovery and point-in-time recovery when required.
- Monitor database health, performance, storage, blocking, deadlocks and growth.
- Perform database maintenance including indexes, statistics, integrity checks and log management.
- Troubleshoot PLM/MES database connectivity, performance and data-related technical issues.