Database Architect – PostgreSQL

PineQ Lab; Bengaluru; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

PineQ Lab is seeking an experienced Database Architect specializing in PostgreSQL to design scalable, secure, high-performing databases. You will lead architecture decisions, optimization efforts, and HA/DR implementations while coordinating with DevOps and application teams.

Responsibilities include configuring schemas and partitioning, tuning queries, managing backups and upgrades, and ensuring security and access controls. Strong Linux experience required; cloud exposure is a plus.

Qualifications

• Proficient in PostgreSQL architecture and administration.
• Strong skills in SQL, query optimization and performance tuning.
• Experience with PostgreSQL replication, high availability, failover and disaster recovery.
• Proficient in backup and recovery strategies and tooling.
• Knowledge of database security, roles and access management.
• Experience with database migrations and version upgrades.
• Understanding of database scalability and capacity planning.
• Experience in Linux environments.
• Familiarity with PostgreSQL tooling and cloud platforms is a plus.

Responsibilities

• Design scalable, secure PostgreSQL databases with high performance.
• Define schemas, tables, indexes, partitioning and standards.
• Tune SQL queries and optimize performance.
• Implement HA, replication, failover, and DR solutions.
• Manage backups, recovery, upgrades, and migrations.
• Implement security, access controls, and user privileges.
• Monitor health, performance, capacity and availability.
• Troubleshoot complex database incidents.
• Collaborate with app, infra and DevOps teams on DB needs.

Skills

PostgreSQL Architecture & Admin

SQL & Query optimization

Replication & HA/Failover/DR

Backup & Recovery

Security & Access mgmt

Migration & upgrades

Scalability & capacity planning

Linux experience

Database performance tuning

Tools

Patroni

Pgpool-II

PgBouncer

repmgr

Job description

Role: Database Architect PostgreSQL

Role Overview

We are looking for an experienced Database Architect with strong expertise in PostgreSQL database architecture, design, performance, scalability, high availability, and security. This is a purely database-focused role and not a Data Architect role.

Key Responsibilities

• Design and architect scalable, secure, and high-performing PostgreSQL databases.
• Define database schemas, tables, indexes, partitioning, and database standards.
• Perform SQL query and database performance tuning.
• Design and implement High Availability, replication, failover, and Disaster Recovery solutions.
• Manage PostgreSQL backup, recovery, upgrades, and migrations.
• Implement database security, user access, roles, and privileges.
• Monitor database health, performance, capacity, and availability.
• Troubleshoot complex database issues and production incidents.
• Work with application, infrastructure, and DevOps teams on database requirements and solutions.

Required Skills

• Strong hands-on experience with PostgreSQL Database Architecture and Administration.
• Expertise in SQL, Query Optimization, Performance Tuning, Indexing, and Partitioning.
• Experience with PostgreSQL Replication, High Availability, Failover, and Disaster Recovery.
• Strong knowledge of Backup and Recovery.
• Experience with database security and access management.
• Experience with database migration and version upgrades.
• Strong understanding of database scalability and capacity planning.
• Experience working in Linux environments.

Preferred Skills

• PostgreSQL tools: Patroni, Pgpool-II, PgBouncer, repmgr.
• Backup tools: pgBackRest, Barman.
• Cloud PostgreSQL experience on AWS, Azure, or GCP.
• Docker and Kubernetes exposure.