PostgreSQL Expert

At Technoidentity were a Data AI product engineering company delivering scalable modern enterprise solutions. We are seeking a seasoned Senior Database Developer & PostgreSQL Expert with 810 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.

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

• 810 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 internalsquery planner vacuum processes WAL replication logical decoding and high-availability strategies.
  

• Experience designing PostgreSQL architectures including HA replication fault-tolerance and disaster recovery.