What are the responsibilities and job description for the AWS Redshift DBA position at Lorien?
Job Description
AWS Redshift DBA
Work Location: Required to be onsite 2 days a week
AWS Redshift DBA who will help with our datawarehouse 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
