Total Years of Experience 7 to 9 Relevant years of Experience 5 to 6 Mandatory Skills • Overall 6 plus year experience as DBA. AWS 3 years. Minimum 2 years of experience with Amazon Redshift (traditional or serverless). • Proficient in Redshift backup and snapshot recovery processes. • Experience with AWS account design and management. AWS Services such as Lambda, Glue, Airflow Alternate Skills Good to have (Not Mandatory) • Expertise in day-to-day DBA activities • Experience automating DBAtasks using Python. • Ability to create and manage Redshift maintenance tasks, such as vacuuming and analyzing tables. • Exposure to data governance and compliance frameworks (e.g., GDPR, HIPAA) in Redshift environments. Detailed Job Description • Overall 6 plus year experience as DBA. AWS 3 years. Minimum 2 years of experience with Amazon Redshift (traditional or serverless). • Proficient in Redshift backup and snapshot recovery processes. • Expertise in day-to-day DBA activities, including:o Managing user access and permissions. o Monitoring database performance and optimizing queries. o Ensuring database security and compliance. o Handling cluster resizing and scaling operations. o Strong understanding of database design and schema management in Redshift. o Experience with query monitoring and analyzing workload management (WLM) to optimize cluster performance. o Familiarity with data distribution strategies and tuning table designs for performance. o Proficient in troubleshooting ETL/ELT processes and optimizing data ingestion workflows. o Understanding of Amazon S3 integration and external table usage in Redshift Spectrum, Athena. • Experience automating DBA tasks using Python. • Experience with AWS account design and management. • Familiarity with AWS services like: o Lambda: For serverless data processing. o Glue: For ETL workflows and data cataloging. o Airflow: For orchestration and automation of data workflows. o Knowledge of Redshift Serverless design and best practices. o Hands-on experience with CloudWatch for monitoring and setting up alarms for Redshift clusters. o Exposure to Data Lake architecture and integration with Redshift. o Understanding of Redshift security configurations, including IAM roles and VPC security. o Ability to debug and resolve Redshift query performance bottlenecks. • Familiarity with cross-region disaster recovery strategies for Redshift. • Knowledge of data retention policies and partition management. • Ability to create and manage Redshift maintenance tasks, such as vacuuming and analyzing tables. • Exposure to data governance and compliance frameworks (e.g., GDPR, HIPAA) in Redshift environments. Location Any Location RTH- Y - U2XK4M