AWS Redshift DBA

Responsibilities

This individual will have extensive, hands-on experience with database administration along with Query Tuning.

Optimizing and tuning the Redshift environment including Cluster, Database & SQL queries.

Hands on experience with Python scripting & Automation

Redshift and Aurora Cluster & Database Administration support

Remote conditions

Hybrid (Mostly Remote but will required to be onsite on needed basis)

Experience required

Experience: 8 to 10 years as a DBA that include Database & Query Performance Tuning.

Must have excellent Redshift experience along with DBA knowledge

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)

Knowledge of Data Replication, Data Sharing & Data Modelling including Logical and Physical data source

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

Good to have - AWS Certified Solution Architect

Skills : RedShift,AWS,S3