Responsibilities
- Create and maintain the Redshift user account and their group privileges.
- Migrate/Sync the views from Redshift PROD to Other Redshift environments.
- Must have hands on experience of Amazon Redshift architecture.
- Optimize Redshift data warehouse by implementing WLM.
- Must have hands on experience in copying the data to sync for testing from one account to another account.
- Monitor the ETL(Matillion) server and databases and ensure the optimal performance.
- Monitor all the Redshift environments/accounts and resolve all the performance issues.
- Must have DWH admin responsibilities to maintain and improve the database performances.
- Data copy from one redshift to another
- Matillion administration is good to have
- Work with database admins to understand new schema creation