Lead Database Administrator AWS Redshift

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