Logo
Saxon Global

Database Administrator V - AWS Redshift

Saxon Global, Chicago, Illinois, United States, 60290


Job Title: AWS Redshift DBA

Work Location: Required to be onsite 2 days a week

Travel Expenses: Can't Pay Travel Expenses at this time

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

Required Skills : Hybrid - onsite 2 days a week! (Address: 233 S Wacker Dr Chicago, IL 60606 United States) • Database administration: 8 years • Performance tuning: 5 years • AWS Redshift & RDS Experience: 2-3 years • Python: 1 year • Scripting: 1 yearBasic Qualification :Additional Skills :Background Check :YesDrug Screen :YesNotes :Selling points for candidate :Project Verification Info :Candidate must be your W2 Employee :YesExclusive to Apex :NoFace to face interview required :NoCandidate must be local :YesCandidate must be authorized to work without sponsorship ::NoInterview times set : :NoType of project :Administration/SupportMaster Job Title :DBA: OtherBranch Code :Chicago