Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Technoidentity

PostgreSQL Expert

Posted Updated

Description

At Technoidentity, we’re a Data + AI product engineering company delivering scalable, modern enterprise solutions.


We are seeking a seasoned Senior Database Developer & PostgreSQL Expert with 8–10 years of experience across multiple database systems, with deep hands-on expertise in PostgreSQL internals, performance tuning, advanced indexing, and enterprise data architecture.

With a strong preference for Oracle to AlloyDB (PostgreSQL) migration expertise, this role blends modernization, advanced PostgreSQL engineering, and cloud-native architecture on Google Cloud Platform (GCP). If you thrive in transforming complex data logic, optimizing performance, and architecting enterprise-grade PostgreSQL systems, this opportunity is built for you.



Requirements

Key Responsibilities

Database Migration & Development

  • Lead database migrations from Oracle to PostgreSQL-based platforms like AlloyDB, applying both manual and automated strategies.
  • Re-engineer stored procedures, triggers, and packages from PL/SQL to PL/pgSQL.
  • Recreate and optimize DB objects (schemas, constraints, views, indexes) across target platforms.
  • Design PostgreSQL-specific architecture including partitioning strategies, indexing plans (GIN, GiST, BRIN), and query optimization paths.
  • Leverage PostgreSQL internals such as vacuum tuning, WAL configuration, and connection management for optimal system performance.


Performance Optimization

  • Implement indexing strategies, query plans, and table partitioning to enhance database performance.
  • Use tools like EXPLAIN ANALYZE, pg_stat_statements, and GCP-native monitoring dashboards for tuning.
  • Collaborate with DevOps for deployment pipelines and infrastructure-as-code (IaC) best practices.
  • Perform deep-dive PostgreSQL performance fine-tuning including buffer cache analysis, autovacuum configuration, and planner optimization.
  • Optimize PostgreSQL workloads for high concurrency and large datasets, ensuring stable and predictable performance.

Data Integrity & Validation

  • Build and execute validation scripts for source-to-target comparison.
  • Ensure row-level data accuracy, transformation logic fidelity, and zero data loss post-migration.
  • Manage large-scale datasets for archival and bulk processing tasks.
  • Implement PostgreSQL-native data integrity strategies like constraint management, row-level security (RLS), and trigger-based validations.

Collaboration & Documentation

  • Work with cross-functional teams to translate business logic and legacy workflows to scalable, modern database systems.
  • Maintain clear documentation on schema conversions, validation methods, rollback strategies, and change history.
  • Create PostgreSQL architecture documents, optimization playbooks, and database best-practice guidelines for engineering teams.

Ideal Candidate Profile

Experience & Skills

  • 4–10 years of database development experience across Oracle, PostgreSQL, and similar RDBMS platforms.
  • Strong expertise in PL/SQL and PL/pgSQL for procedural logic, error handling, and performance tuning.
  • Proven track record of large-scale database migration projects (Oracle to PostgreSQL/AlloyDB preferred).
  • Proficient in query optimization, indexing, partitioning, and schema normalization.


Skills:- PostgreSQL

Skills

Apply

See also