Redshift Database Administrator (DBA)

Redshift Database Administrator (DBA)

Posted 2 days ago by 1751353992

Apply
Negotiable
Outside
Remote
USA
Apply
Airflow Amazon Athena Amazon Redshift Amazon S3 Amazon Web Services (AWS) Apache Airflow Automation AWS Identity And Access Management (IAM) AWS Lambda Business Continuity And Disaster Recovery Database Administration Database Design Database Security Data Governance Data Ingestion Data Processing Data Retention Disaster Recovery External Tables Extract Transform Load (ETL) IBM Workload Manager For Z/OS (WLM/SRM) Management Oracle Database Administration (DBA) Performance Tuning Python (Programming Language) Query Performance Virtual Private Cloud Workflows

Summary: The Redshift Database Administrator (DBA) role involves managing and optimizing Amazon Redshift databases, ensuring security and compliance, and automating DBA tasks. The position requires extensive experience with AWS and Redshift, including backup processes, performance monitoring, and data ingestion workflows. The DBA will also work with various AWS services to enhance data processing and management. This is a remote position based in the USA, classified as outside IR35.

Key Responsibilities:

  • Manage user access and permissions.
  • Monitor database performance and optimize queries.
  • Ensure database security and compliance.
  • Handle cluster resizing and scaling operations.
  • Understand database design and schema management in Redshift.
  • Monitor queries and analyze workload management (WLM) to optimize cluster performance.
  • Implement data distribution strategies and tune table designs for performance.
  • Troubleshoot ETL/ELT processes and optimize data ingestion workflows.
  • Integrate Amazon S3 and utilize external tables in Redshift Spectrum and Athena.
  • Automate DBA tasks using Python.
  • Design and manage AWS accounts.
  • Utilize AWS services like Lambda, Glue, and Airflow for data processing and orchestration.
  • Monitor Redshift clusters using CloudWatch and set up alarms.
  • Integrate Data Lake architecture with Redshift.
  • Configure Redshift security settings, including IAM roles and VPC security.
  • Debug and resolve Redshift query performance bottlenecks.
  • Implement 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 (e.g., GDPR, HIPAA) in Redshift environments.

Key Skills:

  • 6+ years of experience as a DBA, with at least 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 performance tuning.
  • Proficient in troubleshooting ETL/ELT processes.
  • Knowledge of Amazon S3 integration and external table usage.
  • Experience automating tasks using Python.
  • Familiarity with AWS services such as Lambda, Glue, and Airflow.
  • Hands-on experience with CloudWatch for monitoring Redshift clusters.
  • Understanding of Redshift security configurations.
  • Ability to debug query performance issues.
  • Knowledge of cross-region disaster recovery strategies.
  • Familiarity with data retention policies and partition management.
  • Experience with data governance frameworks (e.g., GDPR, HIPAA).

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job Role: Redshift Database Administrator (DBA)

Location:- Remote

Duration:- 6+ Months

Required Skills and Experience:

  • Overall 6-plus year of experience as a 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:

o Managing user access and permissions.

o Monitoring database performance and optimizing queries.

o Ensuring database security and compliance.

o Handling cluster resizing and scaling operations.

o Strong understanding of database design and schema management in Redshift.

o Experience with query monitoring and analyzing workload management (WLM) to optimize cluster performance.

o Familiarity with data distribution strategies and tuning table designs for performance.

o Proficient in troubleshooting ETL/ELT processes and optimizing data ingestion workflows.

o 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 AWS services like:

o Lambda: For serverless data processing.

o Glue: For ETL workflows and data cataloging.

o Airflow: For orchestration and automation of data workflows.

o Knowledge of Redshift Serverless design and best practices.

o Hands-on experience with CloudWatch for monitoring and setting up alarms for Redshift clusters.

o Exposure to Data Lake architecture and integration with Redshift.

o Understanding of Redshift security configurations, including IAM roles and VPC security.

o 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 maintenance tasks, such as vacuuming and analyzing tables.
  • Exposure to data governance and compliance frameworks (e.g., GDPR, HIPAA) in Redshift environments.
Apply
Similar Jobs
Loading data...