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, 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.
- Collaborate with developers on data access patterns, ORM configuration, and query design, while mentoring DBAs and engineers.
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)
- Commitment to a supportive and inclusive environment where diverse teams are valued.
At Octave, we believe that diverse and inclusive teams are critical to the success of our people and our business. Here, everyone is welcome.