About the Role:
We are looking for an experienced Database Administrator (DBA) with deep, hands-on expertise in AWS RDS Aurora PostgreSQL .
The ideal candidate is not only proficient in general PostgreSQL operations and tuning, but also has a strong command of AWS RDS-specific configurations , monitoring , and performance optimization .
This role is critical in ensuring the stability, performance, and scalability of our production databases that support mission-critical applications in the supply chain and enterprise domain.
Key Responsibilities:
1.
Health Monitoring
- Review and interpret CloudWatch alarms and Performance Insights dashboards.
- Monitor database connections , CPU utilization , and storage I/O metrics.
- Ensure proactive issue detection and alert configuration to maintain database health.
2.
Log Analysis
- Regularly review PostgreSQL error logs for warnings, errors, and abnormal patterns.
- Identify and resolve authentication failures or connection issues .
- Analyze slow query logs to identify and resolve performance bottlenecks.
- Monitor autovacuum activities and manage table/index bloat effectively.
3.
Capacity Planning
- Analyze historical trends in storage growth , compute resource utilization , and connection load .
- Forecast future capacity needs and recommend scaling strategies.
- Review and optimize backup storage plans to balance cost and availability.
4.
Performance Analysis and Optimization
- Conduct deep-dive database performance reviews and tuning exercises.
- Identify and optimize resource-intensive queries and stored procedures.
- Monitor wait events , lock contention , and long-running transactions .
- Assess connection pooling strategies (e.g., PgBouncer, RDS Proxy) for effectiveness.
- Review and fine-tune PostgreSQL parameters for optimal throughput and latency.
- Provide monthly performance reports and recommend improvement actions.
Requirements:
Technical Skills
- 5+ years of experience managing PostgreSQL databases in production.
- 3+ years of hands-on experience specifically with AWS RDS Aurora PostgreSQL .
- Strong understanding of:
- RDS performance tuning and parameter groups
- Read replica and failover configuration
- IAM authentication and encryption (KMS)
- Backup, snapshot, and PITR strategies
- Security, compliance, and maintenance best practices
- Deep expertise in AWS RDS advanced configuration , including parameter groups, option groups, and Aurora-specific features like serverless scaling and global databases.
- Proven experience in PostgreSQL tuning and analyzing execution plans, including query optimization, indexing, and vacuuming.
- Strong proficiency in AWS services : CloudWatch, Performance Insights, IAM for database access, and VPC configurations.
- Excellent problem-solving skills and ability to work in a fast-paced, collaborative environment.
Preferred Qualifications:
- AWS Certified Database – Specialty (or equivalent hands-on experience).
- Experience with Aurora Global Database , multi-AZ deployment, and cross-region replication .
- Knowledge of CI/CD pipelines and infrastructure as code (e.g., Terraform, CloudFormation) for database provisioning.
- Experience supporting databases in high-availability enterprise environments .