
Redshift Database Administrator (DBA)
* Overall 6 plus years 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:
* Managing user access and permissions.
* Monitoring database performance and optimizing queries.
* Ensuring database security and compliance.
Handling cluster resizing and cooling
Glue: For ETL workflows and data cataloging.
* Airflow: For orchestration and automation of data workflows.
* Knowledge of Redshift Serverless design and best practices.
* Hands-on experience with CloudWatch for monitoring and setting up alarms for Redshift clusters.
* Exposure to Data Lake architecture and integration with Redshift.
* Understanding of Redshift security configurations, including IAM roles and VPC security.
* 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 main GO TO THE LATEST analyzing and
* Exposure to data governance and
* Handling cluster resizing and scaling operations.
* Strong understanding of database design and schema management in Redshift.
* Experience with query monitoring and analyzing workload management (WLM) to optimize cluster performance.
* Familiarity with data distribution strategies and tuning table designs for performance.
* Proficient in troubleshooting ETL/ELT processes and optimizing data ingestion workflows.
* 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 NC combine like: GO TO THE LATEST processing