Lead Database Administrator AWS Redshift

Name: Jobpe
Address: T-Hub, Plot No 1/C, Sy No 83/1, Raidurgam panmaktha, Knowledge City Rd, Hyderabad, Telangana, 500081, IN
Telephone: +91-83339-09630
Price range: Free

Impetus Technologies

8 - 10 years

Bengaluru

Posted:9 hours ago

Apply

Job Description

Qualification:

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.

Skills Required:

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

Role:

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.

Experience:

8 to 10 years

Job Reference Number:

14261

Skills Required

AWS Data Warehouse Amazon Redshift Relational Databases Amazon RDS Postgresql Operational Support Performance Tuning Data Integrity High Availability Terraform Disaster Recovery

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now

Impetus Technologies

RecommendedJobs for You

Lead Database Administrator AWS Redshift

Impetus Technologies

Bengaluru

Lead Database Administrator AWS Redshift

Impetus Technologies

Bengaluru

Login to

Please Verify Your Phone or Email

Confirm Action

Search

Profile

Upskill and Grow with AI

Lead Database Administrator AWS Redshift