PostgreSQL Database Engineer - Performance & Reliability

Lucid Compliances LLC; Chicago (IL); On-site; USD 110,000 - 160,000; Full time

Job summary

Lucid Compliances LLC is seeking a Database Engineer to shape data storage, movement, and protection across products. You’ll design PostgreSQL schemas, implement backup/restore and replication, and tune slow queries in collaboration with product engineering and CloudOps teams.

You will also help document naming standards, retention policies, and secure access controls, while evaluating columnar warehouses and data patterns to support analytics and multi-tenant patterns.

Qualifications

• 4+ years hands-on with PostgreSQL (or comparable enterprise RDBMS) in production environments.
• Deep SQL expertise including performance tuning, locking, and transaction isolation tradeoffs.
• Experience with migration tooling, zero-downtime deploy patterns, and schema evolution at scale.
• Understanding of encryption, auditing, role-based access, and least-privilege database users.
• Strong collaboration skills with backend engineers and CloudOps/SRE peers.

Responsibilities

• Design and maintain PostgreSQL schemas, indexing strategies, partitioning, and migration plans in partnership with product engineering.
• Own backup, restore, replication, and failover practices; validate RPO/RTO targets with operations.
• Analyze slow queries and workload patterns; recommend schema and application-level improvements.
• Support analytics and reporting use cases with governed views, ETL patterns, or data warehouse handoffs as needed.
• Document standards for naming, retention, PII handling, and access—aligned to security and compliance expectations.

Skills

PostgreSQL

SQL performance tuning

Migration tooling

Encryption & RBAC

Collaborating with backend engineers

Tools

Snowflake

BigQuery

Redshift

dbt

Job description

Lucid Compliances LLC is seeking a Database Engineer to shape data storage, movement, and protection across products. You’ll design PostgreSQL schemas, implement backup/restore and replication, and tune slow queries in collaboration with product engineering and CloudOps teams.

You will also help document naming standards, retention policies, and secure access controls, while evaluating columnar warehouses and data patterns to support analytics and multi-tenant patterns.