Type: 12 month contract to start

Location: Chicago, IL

Schedule: Hybrid, 2 days onsite work

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 : MUST already be in Chicago, Illinois. DBA Skills: AWS Redshift, SQL, Python scripting
Basic Qualification : MUST already be in Chicago, Illinois. DBA Skills: AWS Redshift, SQL, Python scripting
Additional Skills : MUST already be in Chicago, Illinois. DBA Skills: AWS Redshift, SQL, Python scripting
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :Yes
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Administration/Support
Master Job Title :DBA: Other
Branch Code :Chicago