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

- Robust 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.

📌 Database Architect – PostgreSQL (Bengaluru)
🏢 PineQ Lab Technology
📍 Bengaluru