Database Architect – PostgreSQL
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.
- 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.
- 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?