AWS Redshift DBA

Job Description

United Airlines is seeking for an AWS Redshift DBA who will help with our dataware house workload migration into AWS Redshift. This individual will have extensive, hands-on experience with database administration along with Query Tuning.

Responsibilities

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

Must have excellent Redshift experience along with DBA knowledge

Optimizing and tuning the Redshift environment including Cluster, Database & 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)

Redshift and Aurora Cluster & Database Administration support

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

Good to have - AWS Certified Solution Architect

Experience

Database administration: 8 years

Performance tuning: 5 years

AWS Redshift & RDS Experience: 2-3 years

Python: 1 year

Scripting: 1 year

Education

Bachelor's degree required