PostgreSQL Expert

Technoidentity; Hyderabad; On-site; INR 400,000 - 650,000; Full time

Job summary

Technoidentity, a Data & AI product engineering company, seeks a PostgreSQL Expert with 8–10 years of experience. You will lead migrations from Oracle to PostgreSQL-based platforms (AlloyDB), re-engineer PL/SQL to PL/pgSQL, and design PostgreSQL architectures with partitioning and advanced indexing.

You will optimize queries, tuning, and data integrity in a cloud-native Google Cloud Platform environment. Ideal candidates have deep PostgreSQL internals knowledge, experience with high-concurrency

Qualifications

• 8–10 years of database development experience with 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).
• Proficient in query optimization, indexing, partitioning, and schema normalization.

Responsibilities

• Lead database migrations from Oracle to PostgreSQL-based platforms like AlloyDB.
• Re-engineer PL/SQL to PL/pgSQL logic and optimize DB objects across platforms.
• Design PostgreSQL architecture including partitioning and indexing strategies.
• Tune performance using EXPLAIN ANALYZE, VACUUM tuning, and WAL/connection management.

Skills

PostgreSQL

PL/SQL

PL/pgSQL

Query optimization

Partitioning

Oracle to PostgreSQL migration

GCP

Migration architecture

CI/CD

Agile

Tools

AlloyDB

PostgreSQL

Google Cloud Platform (GCP)

Job description

Supercharge Your Career as a PostgreSQL Expert at Technoidentity!

At Technoidentity, we're a Data & AI product engineering company with over 15 years of expertise in building durable digital products, intelligent enterprise solutions, and scalable Data & AI platforms. As we continue expanding globally, it's the perfect time to join our team of tech innovators and make a lasting impact.

What’s in it for You?

We are seeking a seasoned PostgreSQL Expert with 8–10 years of experience across multiple database systems, with deep hands 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

What Will You Be Doing?

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.
• 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 postmigration.
• 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.
• Work with cross-functional teams to translate business logic and legacy workflows to.
• 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.

What Makes You the Perfect Fit?

• 8–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
• Proficient in query optimization, indexing, partitioning, and schema normalization.
• Familiar with Agile practices, Git-based version control, and CI/CD workflows.
• Hands‑on experience with Google Cloud Platform (GCP) for database hosting, monitoring, and scaling.
• Deep expertise in PostgreSQL internals—query planner, vacuum processes, WAL, replication, logical decoding, and high-availability strategies.