Redshift Database Administrator

Summary: The Redshift Database Administrator role requires a seasoned professional with over six years of experience in database administration, including three years specifically with AWS and two years with Amazon Redshift. The position focuses on managing database performance, security, and compliance, while also automating DBA tasks and optimizing data workflows. The role is remote and classified as outside IR35, indicating a flexible working arrangement and independent contractor status.

Key Responsibilities:

• Manage user access and permissions.
• Monitor database performance and optimize queries.
• Ensure database security and compliance.
• Handle cluster resizing and scaling operations.
• Oversee day-to-day DBA activities.
• Implement Redshift backup and snapshot recovery processes.
• Analyze workload management (WLM) to optimize cluster performance.
• Troubleshoot ETL/ELT processes and optimize data ingestion workflows.
• Integrate Amazon S3 and manage external tables in Redshift Spectrum and Athena.
• Automate DBA tasks using Python.
• Design and manage AWS accounts.
• Utilize AWS services such as Lambda, Glue, and Airflow for data processing and orchestration.
• Monitor Redshift clusters using CloudWatch and set up alarms.
• Implement data lake architecture and integration with Redshift.
• Configure Redshift security settings, including IAM roles and VPC security.
• Debug and resolve query performance bottlenecks.
• Develop cross-region disaster recovery strategies for Redshift.
• Manage data retention policies and partition management.
• Create and manage Redshift maintenance tasks, such as vacuuming and analyzing tables.
• Ensure compliance with data governance frameworks like GDPR and HIPAA.

Key Skills:

• 6+ years of experience as a DBA, with 3 years in AWS and 2 years in Amazon Redshift.
• Proficient in Redshift backup and snapshot recovery processes.
• Strong understanding of database design and schema management in Redshift.
• Experience with query monitoring and workload management (WLM).
• Familiarity with data distribution strategies and tuning table designs.
• Proficient in troubleshooting ETL/ELT processes.
• Understanding of Amazon S3 integration and external table usage.
• Experience automating DBA tasks using Python.
• Familiarity with AWS services like Lambda, Glue, and Airflow.
• Hands-on experience with CloudWatch for monitoring Redshift clusters.
• Knowledge of Redshift Serverless design and best practices.
• Understanding of Redshift security configurations, including IAM roles and VPC security.
• Ability to debug and resolve query performance bottlenecks.
• Exposure to data governance and compliance frameworks (e.g., GDPR, HIPAA).

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT