Lead Database Administrator AWS Redshift

Impetus

Hyderabad

On-site

INR 900,000 - 1,300,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Impetus is seeking a skilled Database Administrator to manage and optimize our data infrastructure in Hyderabad. You will oversee Amazon Redshift and Amazon RDS PostgreSQL, ensuring uptime, scalability, and data integrity.

You will implement high-availability configurations, perform performance tuning, and drive cost optimization while maintaining strong security controls across in-transit and at-rest data.

Qualifications

  • Proven experience administering AWS Redshift and RDS PostgreSQL.
  • Strong SQL, indexing, vacuum/analyze and performance tuning expertise.
  • Ability to design backup, PITR, and DR strategies with RPO/RTO targets.
  • Hands-on IaC with Terraform to provision and manage data infra.

Responsibilities

  • Provision, configure, and maintain high-availability RDS PostgreSQL and Redshift clusters.
  • Tune queries, distribution keys, sort keys, and storage for OLTP/OLAP workloads.
  • Design robust backup, PITR, and multi-region DR solutions with automated snapshots.
  • Enforce security via IAM, RBAC, SSL/TLS, and KMS key management.
  • Set up monitoring, logging and alerts with CloudWatch and Performance Insights.
  • Plan capacity and optimize costs with Redshift serverless and autoscaling.
  • Automate provisioning and config with Terraform and related tooling.

Skills

Database administration
Performance tuning
Security & compliance
Disaster recovery
Automation with IaC
Cost optimization

Tools

Amazon Redshift
Amazon RDS PostgreSQL
Terraform
CloudWatch
Performance Insights
KMS

Job description

We are seeking a skilled Database Administrator to manage, optimize, and secure our data infrastructure. In this role, you will oversee both our high-performance analytical data warehouse (Amazon Redshift) and our transactional relational databases (Amazon RDS PostgreSQL). You will balance day-to-day operational support with strategic performance tuning to ensure maximum uptime, scalability, and data integrity.

  • Database Provisioning & Infrastructure: Deploy, configure, and maintain high-availability Amazon RDS PostgreSQL instances and Amazon Redshift clusters utilizing AWS best practices and Infrastructure as Code (IaC) tools like Terraform.
  • Performance Tuning & Optimization: Analyze and optimize query performance, indexing strategies, vacuum/analyze operations, distribution keys, and sort keys to ensure sub-second response times for both OLTP and OLAP workloads.
  • Backup, Recovery & Disaster Recovery: Design, implement, and test robust backup and recovery strategies, including automated snapshots, point-in-time recovery (PITR), and multi-region replication to guarantee strict RPO and RTO targets.
  • Security & Access Management: Enforce data security at rest and in transit by managing IAM roles, database-level permissions (RBAC), security groups, SSL/TLS configurations, and KMS encryption keys.
  • Monitoring & Alerting: Set up proactive monitoring, logging, and alerting systems using Amazon CloudWatch, Enhanced Monitoring, and Performance Insights to detect and resolve performance bottlenecks or anomalies before they impact production.
  • Capacity Planning & Cost Optimization: Forecast storage and compute requirements while actively managing costs through the implementation of Redshift serverless/concurrency scaling, RDS storage auto-scaling, and optimal instance sizing.

Redshift,Redshift AWS,Database Administrator,Database Administration,Aws Aurora,Amazon Rds,Redshift Db,Postgresql,DBA

  • Database Administration: Manage, configure, maintain and upgrade Amazon RDS PostgreSQL databases and Amazon Redshift clusters across production and non-production environments.
  • Performance Optimisation: Monitor and tune database performance, including SQL queries, execution plans, indexing, VACUUM/ANALYZE, Redshift distribution keys, sort keys and workload configurations.
  • High Availability & Disaster Recovery: Implement and maintain HA, automated backups, snapshots, Point-in-Time Recovery (PITR) and disaster recovery solutions aligned with defined RPO/RTO requirements.
  • Database Security: Manage IAM integration, RBAC, database permissions, security groups, SSL/TLS and AWS KMS encryption to ensure secure access and data protection.
  • Monitoring & Alerting: Implement proactive database monitoring and alerting using Amazon CloudWatch, RDS Performance Insights, Enhanced Monitoring and native database monitoring capabilities.
  • Production Support: Provide L2/L3 support for database incidents, performance issues, connectivity failures, locking, capacity constraints and other production database problems.
  • Capacity & Cost Optimisation: Monitor and forecast compute, storage and workload requirements, and optimise RDS/Redshift sizing, storage auto-scaling, Redshift Serverless and concurrency scaling.
  • Infrastructure Automation: Automate database provisioning and configuration using Terraform/IaC and scripting to improve deployment consistency and reduce manual effort.
  • Database Maintenance & Upgrades: Plan and execute database patching, PostgreSQL/Redshift upgrades, parameter changes and scheduled maintenance with minimal business disruption.
  • Troubleshooting & RCA: Perform root-cause analysis for database incidents and recurring performance issues, and implement corrective and preventive actions.
  • Operational Governance: Maintain database standards, SOPs, operational runbooks, backup/recovery procedures, security controls and technical documentation.
  • Cross-Team Collaboration: Work closely with Application, Data Engineering, DevOps, Cloud, Security and Architecture teams on database design, releases, migrations, scalability and performance improvements.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead DBA
Lead DBA

Apptware Solutions LLP • Pune District

On-site
INR 1,500,000 - 2,000,000
Systems Integration Specialist Advisor
Systems Integration Specialist Advisor

NTT DATA Group • Bengaluru

On-site
INR 3,000,000 - 4,200,000
Lead Database Engineer
Lead Database Engineer

Hapag Lloyd • Chennai

On-site
INR 1,200,000 - 1,800,000
AWS Cloud Database Administrator Specialist
AWS Cloud Database Administrator Specialist

NTT DATA Global Delivery Services Ltd • Bengaluru

On-site
INR 2,500,000 - 4,000,000
Systems Integration Specialist Advisor
Systems Integration Specialist Advisor

NTT America, Inc. • Bengaluru

On-site
INR 2,500,000 - 4,500,000
Database Administrator
Database Administrator

True Tech Professionals • Bengaluru

On-site
INR 1,000,000 - 1,500,000
Database Administrator
Database Administrator

Astek Group • Ernakulam

Remote
INR 2,000,000 - 3,600,000
AWS Redshift Data Engineer
AWS Redshift Data Engineer

Vouchagram India • New Delhi

On-site
INR 900,000 - 1,400,000
AWS Redshift Data Engineer
AWS Redshift Data Engineer

Mployee.me • Delhi

On-site
INR 180,000 - 300,000
Senior Team Lead | Engineering - Database Management
Senior Team Lead | Engineering - Database Management

Deloitte Shared Services India • Bengaluru

On-site
INR 2,400,000 - 4,200,000