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.

📌 Lead Database Administrator AWS Redshift (Hyderabad)
🏢 Impetus
📍 Hyderabad