Location Country India
Location Region
Location City Chennai
Job Details
Locations: India
Type: Full-time
Experience: 6-8 Years
Functions: Consulting, Finance, Information Technology, Data Governance
Industries: Capital Markets, Investment Banking, Alternative Investments, Financial Services, Management Consulting, Information Technology and Services, Business Travel Healthcare
Job Description
We are looking for an AWS Redshift Admin who carries experience in architecture of Enterprise Data Warehouse on AWS Redshift including cluster and node topology, configuration, and sizing.
Key Responsibilities
- 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 Data Warehouse in AWS Redshift across all environments, including configuration, maintenance, code migration, and incident response.
- Monitor and maintain uptime SLAs for the Data Warehouse
- Identify and execute cost, performance, and uptime optimizations.
- Partner with the Analysts and Business Partners on data extracts as needed.
- Hands on experience on Redshift cluster up & down automations
- Solving complex redshift query performance issues
- Hands on Experience in Redshift Snapshots, Recovery and DR designs
- Supporting the CICD pipeline build for Redshift
- Experience in Redshift users access and data permissions management
Key Responsibilities Hands on experience with Redshift audit logging and security enhancements
Experience on OKTA/MFA integration with Redshift and User management
Knowledge on Redshift Serverless service
Excellent and proven knowledge of AWS Redshift and SQL demonstrate.
Experience partnering with data engineers to optimize ETL processes and helping to deploy them in production.
Experienced in agile methodologies.
Education Level Bachelor's Degree
Experience Level 7 - 9 years
