車電Senior DBA / Data Engineer(內湖) - TWPR01484
Description
1. Design and maintain database architecture, schemas, and data models, including relationships among image data, sensor data, metadata, annotations, datasets, and physical files.
2. Manage database installation, configuration, upgrades, monitoring, capacity planning, user / role / permission management, and daily operations.
3. Design and maintain database backup / restore, recovery, replication, and high availability mechanisms to ensure database reliability and availability.
4. Perform SQL query optimization, index design, partitioning, and database performance tuning, while planning for scalability as data volume grows.
5. Plan and execute database migration, validation, rollback, and data consistency checks to ensure reliable data migration.
6. Collaborate with Data Pipeline Engineers to define database interfaces and data ingestion patterns, and establish metadata and reference architecture between databases and NAS / file storage.
7. Create and maintain relevant architecture, operation, backup / recovery, and troubleshooting documentation.