Job Summary
We are hiring a Technical Lead / Database Architect with deep expertise in AWS RDS Aurora (PostgreSQL-compatible) environments. The role focuses on designing, optimizing, and scaling distributed data systems on AWS for performance, reliability, and cost efficiency. You will collaborate with development, DevOps, and product teams to define database strategy, guide optimization efforts, and ensure operational excellence across production workloads.
Key Responsibilities
- Architect and optimize AWS RDS Aurora clusters for scalability, performance, and high availability.
- Design multi-AZ, read replica, and failover strategies for critical workloads.
- Drive performance tuning, schema optimization, and connection management.
- Implement monitoring, automation, and governance using AWS-native tools.
- Lead database migrations from PostgreSQL to Aurora and ensure cost efficiency.
- Collaborate with cross-functional teams to improve database reliability and performance.
- Mentor engineers on Aurora best practices and performance optimization.
Required Skills & Qualifications
- 10+ years of database experience; 5+ years with AWS RDS Aurora (PostgreSQL).
- Strong knowledge of Aurora architecture, tuning, indexing, and partitioning.
- Hands-on experience with Performance Insights, RDS Proxy, and pgBouncer.
- Proficiency in data modeling, high availability, and automation (CloudWatch, Lambda, CloudFormation).
- Familiarity with AWS DMS or pg_dump/pg_restore for migrations.
Preferred Skills
- Experience with Aurora Global Database and cross-region replication.
- Knowledge of PostgreSQL extensions, scripting (Python/Bash), and microservices data patterns.
- Exposure to AWS Lambda, S3, and Secrets Manager.