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
- 4–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.
Skills:- PostgreSQL
