Work From Anywhere in LATAM and the Philippines

Work Schedule: 9:00 AM – 6:00 PM PST (EasternTime)

An AI-powered recruiting platform is building the database layer behind its operational systems, reporting, and AI features, and is looking for a Database Engineer to design clean schemas, write efficient SQL, and make Postgres do more with less.

The company runs a production Postgres backend powering its applicant tracking system, fed by webhook-driven ingestion from external hiring tools via serverless workers and queues. As it scales, it is investing in the database foundation that will support reporting and AI consumers, and the role pairs closely with the Engineering team (which owns ingestion) and AI Engineering (which consumes datasets).

Day-to-day, the Database Engineer extends and evolves the Postgres schema across recruiting, candidates, and business operations, builds SQL views and derived tables that serve as the standard interface for reporting and AI, and optimizes query performance through indexing, partitioning, and execution-plan analysis.



Success in the first 3–6 months means a completed schema audit with top-priority fixes shipped, measurable p95 gains on key dashboard queries, and column-level PII classification aligned to retention policy.

Requirements

Must-Have
- 3+ years working with production PostgreSQL databases
- Advanced SQL: window functions, CTEs, JSONB, EXPLAIN analysis, and query rewriting for performance
- Relational data modeling for both OLTP and analytical use cases, including materialized views, indexing, and partitioning on OLTP Postgres
- Defining and enforcing PII, data-classification, and retention policies at the database level
- Git-based schema-migration workflows (Flyway, sqitch, or comparable) with PR review
- Basic Python or comparable scripting for one-off data operations and validation
- B2+ English (CEFR) for technical documentation read across teams

Nice-to-Have
- Experience with Supabase (RLS, auth model, Realt

📌 Pearl Talent (Ciudad de México)
🏢 Pearl
📍 Ciudad de México