PostgreSQL Expert

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

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


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
PostgreSQL/AlloyDB preferred).
• 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.
• Experience designing PostgreSQL architectures including HA, replication, faulttolerance,
and disaster recovery.