On-site
BANGALORE
India
3-6 months
Time and material
$ 18-20/Hr
Description
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 
Skills:
Query performance optimization,AWS,Data governance and compliance frameworks,Redshift backup and snapshot recovery,AWS account design and management,Python,Amazon Redshift,Database security and compliance

Interested in this project and numerous others like it?

Register on WorkWall now and get started