This website uses cookies to ensure you get the best experience on our website. By continuing to use this site, you agree to our cookie  & privacy policy.Accept

checked This is a sample alert

AWS RedShift Database Administrator

  • Full Time
  • Hybrid - Bengaluru
  • 6 months
  • Project posted on: 3/03/2026
add_new View Project Details

AWS RedShift Database Administrator

  • Technology
  • DevOps
  • Cloud Computing
  • AI & Machine Learning

Hybrid - Bengaluru

Full Time

6 months

 3/03/2026

Assignment Details

Our client, a global specialist in energy management, automation and digitalization is looking to engage with a Redshift database administrator

Roles & Responsibilities
 

  • Administer and manage large-scale Amazon Redshift clusters (Provisioned & Serverless) including RA3 architecture, WLM configuration, concurrency scaling, and capacity planning.
  • Drive performance optimization through sort/distribution key strategies, compression tuning (ZSTD/LZO), VACUUM/ANALYZE automation, and query troubleshooting using STL/SVL system tables.
  • Ensure security, governance, and compliance by implementing IAM RBAC, MFA, encryption (at rest/in transit), VPC security controls, SSO integration, and audit readiness (SOC2).
  • Own disaster recovery and resilience planning including automated snapshots, cross-region replication, RTO/RPO definition, DR drills, and high-availability alignment.
  • Implement monitoring, logging, and observability frameworks using CloudWatch, S3, SIEM integrations, and proactive alerting standards.
  • Optimize cost and resource utilization through RA3 migration, managed storage adoption, Reserved Instance planning, tagging governance, and FinOps monitoring.
  • Collaborate with Data Engineering and cross-functional teams to govern ETL/ELT pipelines (Glue, S3, Lambda, Airflow) and ensure ingestion reliability and schema governance.

Skills Required

  • Strong expertise in Amazon Redshift administration, including RA3 architecture, WLM configuration, concurrency scaling, Spectrum, and cluster lifecycle management (Provisioned & Serverless).
  • Advanced performance tuning skills, including sort/distribution key design, compression strategies (ZSTD/LZO), VACUUM/ANALYZE automation, and query diagnostics using STL/SVL system tables.
  • Proficiency in AWS ecosystem services such as S3, Glue, Lambda, IAM, VPC, KMS, CloudWatch, SNS, and SQS, with strong integration knowledge.
  • Security and governance expertise, including IAM RBAC, MFA enforcement, encryption (at rest/in transit), VPC network controls, SSO integration, and compliance alignment (SOC2/CIS/NIST).
  • Disaster recovery and high-availability planning experience, including automated snapshots, cross-region replication, RTO/RPO strategy, and DR testing.
  • Monitoring, observability, and incident management capabilities, including CloudWatch dashboards, logging frameworks, SIEM integration, alerting standards, and L3/L4 escalation handling.
  • Automation and scripting proficiency, particularly in SQL and Python, with working knowledge of ETL/ELT pipelines (Glue, Airflow) and infrastructure tools such as Terraform, Git, and Jenkins.

Industry

Professional Services - Consulting

Experience Required:

2+ years

Additional Skills:

  • RA3
  • Amazon Redshift
  • Data Warehousing
  • Cloud Storage
  • AWS
  • Big Data
  • Information Security Management System

No of open positions:

1

Similar Freelance Projects you can apply to

View More Projects btn btn

How it works

  • 1

    Build your
    skill profile

  • 2

    Strengthen it
    with feedback

  • 3

    Determine your
    optimal fee level

  • 4

    Apply for matching
    projects

  • 5

    Get finalized

  • 6

    Stay Engaged

Build your skill prodile

Project
step1
shape_step

Request feedback from prior projects and/or work stints

shape_step

Determine your optimal fee level

  • starFeeBee helps consultants understand how to price their services.
  • starEnter your skill & location to get ranges for what similar professionals have charged on projects.
  • starUnlock more details e.g., best paying sub-skills, ranges by projects durations, by simply adding a benchmark from a orior projects.
graph_step2
shape_step

Apply for matching projects

shape_step

Get finalized!

Project
step5
shape_step

Stay Engaged!

Project
step6
shape_step

More than 3000 clients rely on Flexing It today

Frequently asked questions.

We host both full-time & part-time projects from top clients for 100+ skill categories. We also help connect experts like you with clients for short consultation calls called Flexperts

You just need to create a ‘boutique firm’ account during the registration process. The rest of the application process remains the same.

Our freelancers fee benchmarking tool, FeeBee helps our freelancers and consultants find out what their peers charged for similar projects. Built on 600K+ verified benchmarks, registered users get unlimited access to it.

As a freelancing platform, we do not provide permanent positions or full-time job to our consultant network.

Flexing It will be involved end to end right from contracts to invoicing. Once you are finalized, your payment details are transparently laid out in your contract terms with your client and our team actively liaises with the client finance team to ensure timely payments.

We do not charge any fee or commission from you. Your fee quote will be paid out to you in full as per your project contract.

planGet alerts for new project opportunities.