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
chance 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
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.

📌 PostgreSQL Expert (Hyderabad)
🏢 TechnoIdentity
📍 Hyderabad