PostgreSQL Expert

Job 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   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, fault-tolerance, and disaster recovery.