Database Admin - Amazon Redshift

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 Cloud Watch
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[1]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