Provision, configure, and maintain Amazon Redshift clusters
Monitor cluster health, storage, CPU, and query performance
Manage snapshot schedules, backups, and restore operations
Perform routine maintenance including VACUUM, ANALYZE, and table distribution optimizations
Optimize Redshift schema design (distribution keys, sort keys, compression)
Tune complex SQL queries and optimize workload management (WLM) queues
Analyze system logs and STL tables to diagnose slow-running queries and bottlenecks
Assist data engineers with efficient data ingestion using COPY commands, Glue, Lambda, Step Functions, or external ETL tools
Manage Spectrum, external schemas, and integration with S3
Implement IAM-based access controls and manage users, groups, and roles
Configure data encryption (KMS), network security, and auditing
Ensure compliance with enterprise data governance and security policies
Automate cluster scaling, monitoring, auditing, and tuning tasks using scripts (Python, Bash) or AWS services
Create automated alerts using CloudWatch, SNS, and Lambda
Integrate Redshift admin tasks with CI/CD pipelines (CodeBuild, Jenkins, Azure DevOps, etc.)
Monitor cluster logs, disk usage, queue performance, and query throughput
Troubleshoot connectivity, query failures, and cluster performance degradation
Provide on-call support for production Redshift environments
Work closely with data engineering, analytics, and business intelligence teams
Document schema changes, cluster configurations, operational procedures, and best practices
Provide guidance to teams on Redshift best practices and cost optimization

Requirements

5+ years of experience as a DBA (preferably in cloud data warehouse environments)
Strong hands-on experience with Amazon Redshift, Redshift Serverless, and Redshift Spectrum
Expert-level SQL skills, including query tuning
Strong understanding of data warehousing concepts: star/snowflake schemas, OLAP design
Experience with Python or Bash scripting
Familiarity with AWS services such as S3, IAM, CloudWatch, Glue, Lambda, KMS, VPC
Familiarity with ETL tools (Informatica, Talend, Matillion, Glue, etc.)
Strong analytical, troubleshooting, and performance tuning skills
Preferred Qualifications
AWS Certified Database - Specialty or AWS Data Analytics certification
Knowledge of Redshift RA3 nodes, AQUA, concurrency scaling, and materialized views
Familiarity with SQL-on-S3 engines (Athena)
Experience with DevOps or Infrastructure-as-Code (Terraform, CloudFormation)

Benefits

Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade
Company paid holidays
Personal Days
Sick Leave
Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs
Other benefits as provided by local policy and eligibility

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

Amazon RedshiftSQLPythonBashETLdata warehousingquery tuningdata encryptionperformance tuningcloud data warehouse

Soft Skills

analytical skillstroubleshootingperformance optimizationcollaborationdocumentation

Certifications

AWS Certified Database - SpecialtyAWS Data Analytics certification