Job Description

About the job
Role: AWS Redshift Database administratorExperience: Overall 5 - 8years (4-5 years relevant)Location: Bangalore/IndiaAs a database administrator, you will work with diverse data analytics technologies on the cloud. Technical Responsibilities include deploying, managing, and operating scalable, highly available, and fault-tolerant databases on AWS. Strong verbal and written communication skills with ability to articulate results and issues to internal and client teams. Proven ability to work creatively and analytically in a problem-solving environment.Primary Responsibilities Include

• 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.

• Experienced in core AWS services like EC2, S3, IAM, and VPC.

• Experienced with the AWS console and basic command-line tools (AWS CLI).

• Familiarity with data processing concepts like ETL/ELT pipelines. Basic experience with Python or Scala for data manipulation.

• 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 Lake formation, Glue, AWS data shares, GitHub, PySpark

• AWS Certification is preferred.

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

• Experienced with data sharing mechanisms like S3 Sharing and Redshift Sharing. Sharing using Lake formation. sharing between accounts, regions

• Automating the repeated DBA tasks.

• An interest and ability to learn new technologies.

• Experience with data processing frameworks like Apache Spark or AWS Glue. Understanding of data warehousing concepts and data quality practices.

• Experienced with AWS serverless services like Lambda, Step Functions, AWS Glue and Redshift Serverless.

• Experience with CI/CD pipelines for automating infrastructure and code deployment.

• Experienced with cloud monitoring and logging services like CloudWatch.

Bonuses

• Ability to multi-task, organize, prioritize, research and resolve issues in a timely and effective manner.

• In-depth knowledge of S3 for object storage and data lakes.

• Understanding of data partitioning and file formats like Parquet or good to have knowledge on OTF / Iceberg

• Understanding of data lineage and data quality tools.

Business / Soft Skills:

• Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.

• Ability to communicate effectively, both verbal and written, excellent presentation skills.

• Ability to effectively move forward on tasks even with ambiguous or changing requirements.

• Ability to work in a team-oriented, collaborative environment in a global context.

• Willingness and ability to train and teach others.

• Ability to facilitate meetings and follow up with resulting action items.

• Ability to self-manage, prioritize and execute tasks in a high-pressure environment.

• Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem-solving skills.

• The desire for growth and innovation, to bring rapid solutions to business challenges/opportunities.

• Strong consultancy orientation and experience, with the ability to form collaborative, productive working relationships across diverse teams and cultures is a must.

• The ability to work in a centralized/decentralized operating model, with varying implementation partners and implementation owners.

QualificationsAbout the job
Role: AWS Redshift Database administratorExperience: Overall 5 - 8years (4-5 years relevant)Location: Bangalore/IndiaAs a database administrator, you will work with diverse data analytics technologies on the cloud. Technical Responsibilities include deploying, managing, and operating scalable, highly available, and fault-tolerant databases on AWS. Strong verbal and written communication skills with ability to articulate results and issues to internal and client teams. Proven ability to work creatively and analytically in a problem-solving environment.Primary Responsibilities Include

• 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.

• Experienced in core AWS services like EC2, S3, IAM, and VPC.

• Experienced with the AWS console and basic command-line tools (AWS CLI).

• Familiarity with data processing concepts like ETL/ELT pipelines. Basic experience with Python or Scala for data manipulation.

• 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 Lake formation, Glue, AWS data shares, GitHub, PySpark

• AWS Certification is preferred.

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

• Experienced with data sharing mechanisms like S3 Sharing and Redshift Sharing. Sharing using Lake formation. sharing between accounts, regions

• Automating the repeated DBA tasks.

• An interest and ability to learn new technologies.

• Experience with data processing frameworks like Apache Spark or AWS Glue. Understanding of data warehousing concepts and data quality practices.

• Experienced with AWS serverless services like Lambda, Step Functions, AWS Glue and Redshift Serverless.

• Experience with CI/CD pipelines for automating infrastructure and code deployment.

• Experienced with cloud monitoring and logging services like CloudWatch.

Bonuses

• Ability to multi-task, organize, prioritize, research and resolve issues in a timely and effective manner.

• In-depth knowledge of S3 for object storage and data lakes.

• Understanding of data partitioning and file formats like Parquet or good to have knowledge on OTF / Iceberg

• Understanding of data lineage and data quality tools.

Business / Soft Skills:

• Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.

• Ability to communicate effectively, both verbal and written, excellent presentation skills.

• Ability to effectively move forward on tasks even with ambiguous or changing requirements.

• Ability to work in a team-oriented, collaborative environment in a global context.

• Willingness and ability to train and teach others.

• Ability to facilitate meetings and follow up with resulting action items.

• Ability to self-manage, prioritize and execute tasks in a high-pressure environment.

• Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem-solving skills.

• The desire for growth and innovation, to bring rapid solutions to business challenges/opportunities.

• Strong consultancy orientation and experience, with the ability to form collaborative, productive working relationships across diverse teams and cultures is a must.

• The ability to work in a centralized/decentralized operating model, with varying implementation partners and implementation owners.

Schedule: Full-time
Req: 009077

eQuest