Senior Database Architect

Vyntrapro Innovations; India; On-site; INR 2,400,000 - 4,800,000; Full time

Job summary

Vyntrapro Innovations is seeking a senior PostgreSQL Database Engineer to design and optimize large-scale PostgreSQL deployments. You will lead schema design, performance tuning, and security practices across cloud environments, while mentoring a team of engineers and shaping governance standards.

The role emphasizes advanced indexing, partitioning, and PITR familiarity, with strong emphasis on CI/CD integration and reliable database operations.

Qualifications

• 15+ years of PostgreSQL database design and management.
• Strong expertise in PostgreSQL architecture, performance tuning, query optimization, and PL/pgSQL development.
• Experience with advanced indexing, partitioning, and storage/memory management.
• Hands-on experience with cloud-based PostgreSQL deployments, database security, and CI/CD integration.
• Strong leadership, problem-solving, and mentoring capabilities.

Responsibilities

• Design complex database schemas, normalization strategies, partitioning, and advanced indexing to support high-performance systems.
• Drive database performance tuning, query optimization, and server-level configuration management.
• Design and manage PostgreSQL deployments on cloud platforms.
• Establish database development standards, coding practices, and governance policies.
• Implement and enforce database security controls, including IAM, RLS, encryption, and auditing.
• Integrate database changes into CI/CD pipelines and support automated deployments.
• Mentor and guide database engineers, ensuring high-quality architecture and development practices.

Skills

PostgreSQL design

Performance tuning

PL/pgSQL development

Cloud PostgreSQL

Database security

CI/CD integration

Mentoring

Leadership

Tools

pgBackRest

Barman

WAL-G

Job description

Key Responsibilities

• Design complex database schemas, normalization strategies, partitioning, and advanced indexing to support high-performance systems.
• Drive database performance tuning, query optimization, and server-level configuration management.
• Design and manage PostgreSQL deployments on cloud platforms.
• Establish database development standards, coding practices, and governance policies.
• Implement and enforce database security controls, including IAM, RLS, encryption, and auditing.
• Integrate database changes into CI/CD pipelines and support automated deployments.
• Mentor and guide database engineers, ensuring high-quality architecture and development practices.

Required Skills & Experience

• 15+ years of experience in PostgreSQL database design and management of large-scale databases.
• Strong expertise in PostgreSQL architecture, performance tuning, query optimization, and PL/pgSQL development.
• Experience with advanced indexing, database partitioning, and storage/memory management.
• Proficiency in backup and recovery solutions including pgBackRest, Barman, WAL-G, and Point-in-Time Recovery (PITR).
• Hands-on experience with cloud-based PostgreSQL deployments, database security, and CI/CD integration.
• Strong leadership, problem-solving, and mentoring capabilities.