AWS Redshift Database Administrator - Only Bangalore Location

Own the architecture for the AWS Redshift clusters across all environments.

Own the database administration of the Enterprise Data Warehouse on AWS Redshift.

Own the architecture for our Enterprise Data Warehouse on AWS Redshift including cluster and node topology, configuration, and sizing.

Automate provisioning, operation, monitoring and troubleshooting of the database and data lake infrastructure.

Determine, enforce and document database policies, procedures and standards.

Keep up to date with emerging cloud technology trends on AWS Redshift.

Define design standards for AWS Redshift for use by development and support teams. Partner with the Data Architect to define data modeling standards.

Partner with data engineers on query design during projects and while performing analytics, and to analyze, troubleshoot and optimize application and ad-hoc queries in production.

Provide operational management for our Enterprise Data Warehouse (EDW) in AWS Redshift across all environments, including configuration, maintenance, code migration, and incident response.

Identify and execute cost, performance, and uptime optimizations.

Partner with the Analysts and Business Partners on data extracts as needed.

Technical Essentials

Expertise in Redshift Administration for managing databases, user tables, indexes, statistics, managing permissions addressing the user issues.

Excellent and proven knowledge of AWS Redshift and SQL demonstrated through 4+ years in a Redshift DBA role.

Excellent knowledge of related AWS technologies included Aurora, Redshift Spectrum, S3, EMR, DynamoDB and Athena.

AWS Certification is preferred.

Experience with generating various DB health statistics, utilization and right sizing.

Automating the repeated DBA tasks.

An interest and ability to learn new technologies.