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.
Skills Required
- 8-10 years database development experience across Oracle and PostgreSQL
- Deep expertise in PostgreSQL internals, performance tuning, and enterprise data architecture
- Experience with PL/SQL and PL/pgSQL for procedural logic and migration
- Proven track record of large-scale Oracle to PostgreSQL/AlloyDB migration projects
- Design and implement partitioning strategies and advanced indexing (GIN, GiST, BRIN)
- Experience tuning vacuum, autovacuum, WAL configuration, connection management, and planner optimization
- Use of tools like EXPLAIN ANALYZE and pg_stat_statements and GCP monitoring dashboards for performance tuning
- Ability to build and execute source-to-target validation scripts and ensure zero data loss post-migration
- Experience collaborating with DevOps and applying Infrastructure-as-Code best practices
- Implement PostgreSQL-native data integrity strategies such as constraints, row-level security, and trigger validations
What We Do
Founded a decade ago, a group of seasoned professionals came together to ask ‘How might we use technology to bring the world closer to social justice?’ A small team was put together to create incredible solutions for organizations working towards delivering large scale impact. Today, we’re a global organization providing disruptive software solutions to our customers who are solving important problems in their industry and also the world we live in. At TechnoIdentity, we challenge our team of passionate technologists to create forward-looking solutions for our customers that improve operational efficiency and bolster their bottom line. We empower them with the tools, methodologies and decision-making to make real impact, fast. We invite creative minds and businesses to TechnoIdentity, let’s collaborate to transform lives through technology.
