Database Developer

Remote

May 23, 2025

Full Time

Application ends: August 23, 2025

Job Description

About the Role:

We are seeking a Database Developer who thrives in environments where data integrity, performance tuning, and query optimization are critical. You’ll work closely with our backend engineers and data scientists to support real-time data access for millions of transactions per day, while building scalable schemas that align with product evolution.

Key Responsibilities:

Design, implement, and optimize relational and NoSQL database schemas tailored to high-velocity data applications, including time-series, geospatial, and event-sourced data models.
Develop stored procedures, triggers, and user-defined functions to support business logic within the data layer, using PostgreSQL and PL/pgSQL.
Collaborate with DevOps to establish database deployment pipelines using Liquibase and Flyway, ensuring consistent schema changes across dev, staging, and production.
Conduct query performance analysis using tools like pg_stat_statements, EXPLAIN/ANALYZE, and pgBadger, and apply indexing strategies to reduce query times on critical paths.
Support data governance efforts by implementing column-level encryption, row-level security, and user access controls for compliance with SOC 2 and GDPR.
Assist backend engineers in optimizing ORM-generated queries, particularly for complex joins and nested relationships in Prisma and Sequelize.
Design materialized views and data marts to support business intelligence dashboards and ML feature pipelines.
Manage database replication and partitioning strategies to support cross-region failover and high availability in a Kubernetes-native environment.

Must-Have Qualifications:

4+ years of professional experience in database development, preferably in a product-focused tech company.
Deep knowledge of PostgreSQL internals, including vacuum behavior, WAL management, and background workers.
Experience working with at least one cloud-native database service (e.g., Amazon Aurora, Google Cloud Spanner).
Proficiency in SQL query optimization, with demonstrable ability to reduce query runtime from seconds to milliseconds.
Familiarity with data modeling in event-driven architectures and microservices.
Solid experience with CI/CD practices for database code, and rollback strategy design.

Nice-to-Have:

Experience with TimescaleDB or ClickHouse for time-series data use cases.
Previous work with CDC (Change Data Capture) tools like Debezium.
Familiarity with GraphQL data sources and query federation techniques.

Are you interested in this position?

Apply by clicking on the “Apply Now” button below!