PostgreSQL Architect

November 17, 2026

Job Description

Company: Octave
Location: Hyderabad, India
Workplace Type: Hybrid
Employment Type: Full-time

About the Role

We are seeking an experienced PostgreSQL Architect to design, migrate, and optimize enterprise databases from Oracle and SQL Server to PostgreSQL. The ideal candidate will lead complex database migrations with minimal downtime, maintaining a cloud-agnostic mindset.

What You’ll Do / Key Responsibilities

  • Design scalable and reliable PostgreSQL architectures for high-volume transactional workloads, defining strategies for indexing, partitioning, connection pooling, replication, and query optimization.
  • Lead end-to-end migrations from Oracle and/or SQL Server to PostgreSQL, including schema conversion, data migration, validation, and cutover.
  • Design PostgreSQL solutions using appropriate tenant isolation models (e.g., database-per-tenant, schema-per-tenant) and establish tenant-aware monitoring, capacity planning, backup, and recovery practices.
  • Architect PostgreSQL deployments on any cloud platform, defining high availability, backup, point-in-time recovery, and disaster recovery strategies.

Requirements & Qualifications

  • 8 or more years of experience in database engineering, with at least 4 years of substantial hands-on PostgreSQL experience.
  • Proven experience designing and supporting PostgreSQL databases for high-volume transactional workloads.
  • Hands-on experience migrating databases from Oracle and/or SQL Server to PostgreSQL.
  • Strong proficiency in PostgreSQL SQL and PL/pgSQL, with experience reading and converting PL/SQL or T-SQL.
  • Deep understanding of query planning, indexing, partitioning, vacuum and autovacuum, locking, concurrency, and connection management.
  • Experience designing and supporting replication, high availability, backup, restore, and point-in-time recovery.
  • Strong scripting or automation skills using SQL, Bash, or Python.

Preferred / Bonus Qualifications (if applicable)

  • Experience with migration tools such as AWS Schema Conversion Tool, AWS DMS, ora2pg, pgloader, or Azure Database Migration Service.
  • Experience with managed PostgreSQL services such as Amazon Aurora PostgreSQL or RDS for PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL for PostgreSQL.
  • Familiarity with connection poolers such as PgBouncer and monitoring tools such as pg_stat_statements, Prometheus, or Grafana.

Benefits & Perks (if applicable)

  • Octave is committed to creating an inclusive environment where everyone is welcome.

At Octave, we believe that diverse and inclusive teams are critical to the success of our people and our business. Respect is the cornerstone of how we operate, so speak up and be yourself.