Virtusa - Database Architect - PostgreSQL

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.