314e - Product Engineer - SQL Server

Responsibilities :

- Collaborate with backend developers to review, refine, and optimize SQL queries.

- Design and enhance database schemas, indexes, and constraints for performance and scalability.

- Leverage advanced PostgreSQL features such as window functions, CTEs, partial indexes, JSON handling, and query operators.

- Identify and resolve query inefficiencies, deadlocks, and slow-running jobs.

- Establish best practices for query design, schema evolution, and migrations.

- Act as the go-to expert for SQL and relational data modeling questions.

- Educate developers on writing efficient queries without slowing down delivery speed.

- Work with infra/ops teams to monitor and tune query performance at the application level.

Requirements :

- Strong expertise in SQL (PostgreSQL preferred) query design, indexing, performance tuning, and optimization.

- Deep understanding of relational database internals (execution plans, operators, concurrency, isolation levels).

- Proven experience in data modeling and schema design for transactional systems.

- Hands-on experience with backend development (Python, Java, Node, etc. ) and integrating queries into APIs.

- Ability to apply advanced concepts such as window functions, materialized views, and query planner hints.

- Familiarity with database migration/versioning tools (Dbmate, Atlas, Alembic, Flyway, etc. ).

- Strong analytical and problem-solving skills with the curiosity to dig into query execution behavior.

- Experience using profiling tools like EXPLAIN/ANALYZE and pg_stat_statements.

Nice-to-Haves :

- Exposure to scaling strategies (sharding, partitioning, replication).

- Understanding of caching strategies to complement SQL performance.

- Experience working in healthcare or other data-heavy, regulated domains.