Senior Database Consultant – PostgreSQL

November 17, 2026

Job Description

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

About the Role

Octave is seeking an experienced PostgreSQL Architect to design, migrate, and optimize enterprise databases from Oracle and SQL Server to PostgreSQL. This role focuses on designing high-transaction, multi-tenant PostgreSQL environments and leading complex database migrations with minimal downtime, requiring 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) while establishing 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.
  • Partner with Cloud Operations and Security teams on monitoring, patching, access control, auditing, and incident response.

Requirements & Qualifications

  • 6 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, embracing differences, and ensuring equal opportunities.

At Octave, we believe that diverse and inclusive teams are critical to the success of our people and our business. Here, everyone is welcome. As an inclusive workplace, we don’t discriminate. In fact, we embrace differences and are fully committed to creating equal opportunities, an inclusive environment, and fairness for all.