Senior PostgreSQL Data Engineer - Zero-Downtime Migrations

HYGO; United States; Remote; USD 120,000 - 140,000; Full time

Job summary

A leading media company in the United States is seeking a Data Engineer to own their complex data layer. The role emphasizes deep expertise in PostgreSQL, schema design, and zero-downtime migrations. Responsibilities include optimizing the database for high volume AI generation tasks and ensuring data integrity. With a competitive salary range of $120,000 to $140,000, this position offers impact and visibility at a significant media firm.

Qualifications

• 4+ years as a database engineer, DBA, or backend engineer with SQL focus.
• Expert knowledge of PostgreSQL features and optimization.
• Experience with production ORM tools and raw SQL.

Responsibilities

• Own the data layer for processing millions of AI generation jobs.
• Design and optimize PostgreSQL schema and migrations.
• Implement data integrity patterns and support complex queries.

Skills

Database engineering

SQL expertise

PostgreSQL knowledge

ORM experience

Connection pooling

Zero-downtime migration

Role-based database security

Tools

PostgreSQL

Prisma

PgBouncer

Job description

A leading media company in the United States is seeking a Data Engineer to own their complex data layer. The role emphasizes deep expertise in PostgreSQL, schema design, and zero-downtime migrations. Responsibilities include optimizing the database for high volume AI generation tasks and ensuring data integrity. With a competitive salary range of $120,000 to $140,000, this position offers impact and visibility at a significant media firm.