Redshift Database Administrator

Must-haves :

- Overall exp. Of 7 to 10 yrs.

- Redshift administration (key role,5 years experience with redshift)

- Data Migration / Sync specifically DATA UNLOAD, COPY

- Deployments

- Tuning / Optimization

Key Result Areas and Activities :

- Design and Development : Design, implement, and manage Redshift clusters for high availability, performance, and security.

- Performance Optimization : Monitor and optimize database performance, including query tuning and resource management.

- Backup and Recovery : Develop and maintain database backup and recovery strategies.

- Security Enforcement : Implement and enforce database security policies and procedures.

- Cost-Performance Balance : Ensure an optimal balance between cost and performance.

- Collaboration with Development Teams : Work with development teams to design and optimize database schemas and queries.

- Perform database migrations, upgrades, and patching.

- Issue Resolution : Troubleshoot and resolve database-related issues, providing support to development and operations teams.

- Automate routine database tasks using scripting languages and tools.

Must-Have :

- Strong understanding of database design, performance tuning, and optimization techniques

- Proficiency in SQL and experience with database scripting languages (e.g., Python, Shell)

- Experience with database backup and recovery, security, and high availability solutions

- Familiarity with AWS services and tools, including S3, EC2, IAM, and CloudWatch

- Operating System - Any flavor of Linux, Windows

- Core Redshift Administration Skills - Cluster Management, Performance Optimization, workload management (WLM), vacuuming/analyzing tables for optimal performance, IAM policies, role based access control, Backup & Recovery, automated backups, and restoration strategies.

- SQL Query Optimization, distribution keys, sort keys, and compression encoding

- Knowledge of COPY and UNLOAD commands, S3 integration, and best practices for bulk data loading

- Scripting & Automation for automating routine DBA tasks

- Expertise in debugging slow queries, troubleshooting system tables