Database Administrator

Senior Redshift Database Administrator

We are seeking an experienced Senior Redshift Database Administrator to join an Enterprise Data Warehouse (EDW) team. This role is responsible for the administration, performance optimization, and operational support of a large-scale AWS Redshift environment spanning multiple business units. The ideal candidate brings deep, hands-on Redshift experience, strong data warehousing fundamentals, and a proven background in performance tuning, automation, and managing mission-critical analytics platforms at scale.

Key Responsibilities

• Administer and support 40+ AWS Redshift clusters across multiple business domains and environments.
• Own SQL performance tuning initiatives, including query rewrites, workload analysis, and table optimization.
• Lead cluster performance optimization, including Workload Management (WLM) configuration, distribution key and sort key strategies, and capacity planning.
• Execute DDL migrations and manage schema changes across development, test, and production environments.
• Manage security, access control, auditing, and compliance for Redshift environments.
• Monitor system health and performance using Redshift system tables and metrics (e.g., STL/SVL tables).
• Troubleshoot and resolve performance, concurrency, and availability issues.
• Support and integrate with CI/CD pipelines for automated database deployments and schema changes.
• Partner closely with data engineers, analytics teams, and business stakeholders to ensure stable and performant data platforms.

Required Qualifications

• 5+ years of hands-on experience as an AWS Redshift Database Administrator, including experience supporting complex, multi-cluster Redshift architectures.
• 10+ years of overall data warehousing experience.
• Strong, practical understanding of AWS Redshift architecture, internals, and operational behavior.
• Proficiency with Redshift system tables and query performance diagnostics.
• Knowledge of advanced SQL tuning and optimization techniques.
• Understanding of workload management (WLM) and concurrency tuning.
• Familiarity with database deployment automation and CI/CD concepts.
• Proven experience supporting enterprise-scale, mission-critical data warehouse platforms.

Preferred Qualifications

• Experience working with Databricks or other cloud-based big data platforms.
• Familiarity with modern data lake or lakehouse architectures.
• Experience operating Redshift in multi-account or cross-domain environments.

The pay rate for this position is between $90.00/hour and $95.00/hour. A benefits package may be available to eligible employees.

This employer is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.