IT Data Architect

*Data modeling
- Establishment of conceptual/logical/physical data modeling and data modeling direction
- Data modeling changes and process management
- Establish data standards and a data standard management system, including items required for data modeling, terminology dictionary, and domains, and apply the MDM (master data management) and data governance framework to the meta management system.
*DB design and implementation
- Implement database architecture design, database structure design/backup design/security design
- Implement database object design such as tables and procedures
- Create guides for developers, including index design guides for performance, tuning guides, and SQL development guides
PoC/BMT performance for database selection and architecture verification
- Development, testing, establishment of operating environment and data model/database change management
- Support unit/integration testing and perform system testing to ensure system performance, backup/recovery, and availability
- Develop a database optimization and SQL performance tuning plan
*DB operation
- Provides smooth data services and establishes operation management procedures for stable operation and management
- Management and monitoring of DB object changes such as tables and indexes
- DBMS change management and monitoring, including DBMS parameter and storage structure changes
- Operational diagnostics and problem management
- Audit and improve operating processes
* Big data design and implementation
- Identify source data types and storage structures and design logical architecture for target big data storage and data processing
- Select a big data storage solution to implement logical architecture, design and build the architecture.