Redshift AWS Administrator

Description : Job Summary :

We are seeking an experienced Redshift AWS Administrator to manage, optimize, and support our Redshift data warehouse and related AWS services. The ideal candidate will have hands-on expertise in Redshift administration, data backup and recovery, user access management, Kafka operations, Linux systems administration, and automation using shell scripting. This role will collaborate closely with engineering, data, and support teams to ensure high availability, secure access, and efficient performance across environments.

Key Responsibilities :

Redshift Administration :

• Configure, manage, and optimize Amazon Redshift clusters across production and non-production environments.
• Manage user access, roles, and permissions for Prod & Non-Prod environments.
• Create and manage snapshots for backup, retention, and disaster recovery.
• Monitor Redshift cluster performance and query workloads; identify and resolve bottlenecks.
• Configure and monitor CloudWatch alarms for cluster performance, storage, and system health.
• Perform data load / unload activities between Redshift and S3 based on user and project requirements.
• Create and manage Redshift Data Shares for secure inter-account and inter-cluster data distribution.
• Build and maintain external schemas and external tables using AWS Glue and Athena.
• Manage AWS MDC tasks across QA, Stage, and Prod environments.
• Participate in production deployments and release activities.

Kafka Administration :

Additional Responsibilities :

Qualifications & Requirements :

(ref : hirist.tech)