Alloy DB Postgres SQL Developer

Design, develop, and optimize Alloy DB PostgreSQL components supporting high-volume document metadata ingestion, retrieval, migration, retention, and audit requirements. Central to the platforms data layer, working closely with API, data engineering, DevOps, and architecture teams.

KEY RESPONSIBILITIES:

• Design schemas, indexes, partitions, functions, and queries for high-volume metadata storage.
• Build scalable metadata storage and retrieval solutions in AlloyDB.
• Support metadata migration from MongoDB JSON sources with batching, idempotency, and reconciliation.
• Implement source-to-target mappings, data cleansing, validation, and exception handling.
• Optimize query performance and implement row-level security, auditability, and retention controls.

MANDATORY SKILLS:

• Strong hands-on PostgreSQL development and advanced SQL, AlloyDB.
• Schema design, indexing, partitioning, query tuning, stored functions, and transaction management.
• High-volume dataset handling and performance optimization.
• Data migration, source-to-target mapping, reconciliation, and data quality validation.
• JSON processing, database security, RLS access controls, audit, and root cause analysis.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.