Virtusa - Database Architect - PostgreSQL in Bangalore, भारत

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 https://jobeax.com/link/v8qrFLRTZgSSorDg 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 https://jobeax.com/link/pUSKeqov1v4pOSK0 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. (ref:hirist.tech)