Database Architect
First seen by Alion on Sep 29, 2026.
About the Role :
We are looking for an experienced PostgreSQL Database Architect with a strong engineering mindset and hands-on expertise in designing, developing, optimizing, and modernizing PostgreSQL environments. The ideal candidate will have experience with database architecture, data modelling, replication, clustering, partitioning, indexing, and AWS PostgreSQL services.
Key Responsibilities :
- Design and define scalable PostgreSQL database architectures aligned with application and business requirements.
- Develop database strategies covering application backend processes, data structures, data models, replication, clustering, partitioning, and indexing.
- Design logical and physical data models to support scalable and high-performance applications.
- Define high availability, disaster recovery, replication, backup, and failover strategies for PostgreSQL environments.
- Lead PostgreSQL performance optimization, including query tuning, indexing, partitioning, execution-plan analysis, and database configuration.
- Design and implement PostgreSQL environments on AWS RDS for PostgreSQL and Amazon Aurora PostgreSQL.
- Drive database migration and modernization initiatives from on-premises or legacy environments to AWS.
- Support migration planning, data replication, cutover, validation, and post-migration optimization.
- Integrate PostgreSQL environments with CI/CD pipelines and automated deployment processes.
- Work closely with Application Development, Cloud, DevOps, Data Engineering, and Architecture teams to ensure effective database integration.
- Establish database development, deployment, monitoring, security, and operational standards.
- Troubleshoot complex database performance, availability, replication, and production issues.
- Conduct database design reviews and provide technical guidance on PostgreSQL architecture and best practices.
- Automate routine database administration, deployment, monitoring, and maintenance activities where appropriate.
- Ensure database solutions meet requirements for scalability, reliability, availability, security, and maintainability.
Required Skills & Experience :
- 5 - 11 years of experience in PostgreSQL development, database engineering, database architecture, or a closely related field.
- Strong hands-on expertise in PostgreSQL database design, development, optimization, and administration.
- Strong understanding of data modelling, database architecture, normalization, schema design, and data structures.
- Hands-on experience with replication, clustering, partitioning, indexing, and high-availability architectures.
- Strong knowledge of PostgreSQL performance tuning and query optimization.
- Hands-on experience with AWS RDS for PostgreSQL and/or Amazon Aurora PostgreSQL.
- Experience with AWS database migration and modernization initiatives.
- Experience integrating database deployment and change management with CI/CD pipelines.
- Strong SQL and database troubleshooting skills.
- Understanding of backup, recovery, disaster recovery, monitoring, and database security practices.
- Strong engineering mindset with the ability to evaluate technical trade-offs and design scalable solutions.
- Experience working with application/backend teams in designing database solutions for enterprise applications.
- Strong analytical, problem-solving, communication, and stakeholder collaboration skills.
Skills
PostgreSQL, Database Architecture, AWS, Data Modeling, Performance Tuning, SQL, Data Architect