Skip to main content

Database Architect – PostgreSQL

Technology
PineQ Lab Technology
Bengaluru, India2 months ago
Full time

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.

Keywords
ScalabilityPartitionLinuxDevOpsPostgresqlSqlReplicationDisk partitioningAWSDockerKubernetes

Interested in this role?