AWS Redshift SME

  • Aligarh
  • System Soft Technologies

Job Summary: Enterprise Data Platform (EDP) has multiple AWS Redshift environments for data analytics development and running production workloads. The work defined is to perform in-depth analysis of the Redshift cluster configuration and workloads and optimize them. Required Skills and Experience: Analyze EDP production cluster and identify top workloads and queries Define optimization steps for workloads and run them Review table structures, keys and joins Run vacuum analyze on table Adjust join criteria as required Identify cluster parameters that need to be updated Run workload on different configurations Design parameters to reduce cost and query run times