8 to 10 years as a dba that include database and query performance tuning
- must have excellent redshift experience along with dba knowledge
- optimizing and tuning the redshift environment, including cluster, databases, and sql queries
- good knowledge of analyzing explain plan and tune workloads to improve runtime
- good knowledge of workload management within redshift along with queue mgmt.
- excellent understanding of the aws architecture (rds, s3, virtual machine)
- cluster & database administration support (linux os)
- knowledge of data replication, data sharing & data modelling including logical and physical data source
- hands on experience with python scripting & automation
- knowledge of adfs and user access management
- knowledge of setting up cloud monitoring and alert metrics management
- good to have apache airflow experience
- excellent communications and a team player
- must have - cloud computing certification aws ( foundation/practitioner).