database admin

Database Admin Required to be onsite 2 days a week 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