Details
Job Description:
- 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 with 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 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.