Work Location: Required to be onsite 2 days a week

Length: 12-month contract

Our client is seeking an AWS Redshift DBA who will help with their Data-warehouse 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

Years of 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 : AWS Cloud, AWS Redshift, AWS RDS 8-10 Years of DBA experience
Basic Qualification :
Additional Skills :
Background Check :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
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 :Development/Engineering
Master Job Title :DBA: Oracle
Branch Code :Chicago