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