Description

You will own the design, development, and maintenance of mission-critical data layers.

Responsibilities

• Write performant SQL and PL/pgSQL functions; optimize ORM-generated queries and enforce data integrity via constraints and triggers.
• Implement table partitioning (range/list/hash) and manage data lifecycle policies including archiving.
• Build data access layers/APIs using Java, .NET, Node.js, or Python, ensuring proper connection pooling, transaction handling, and retry logic.
• Own database migrations (Liquibase/Flyway), versioning, and rollback strategies while enforcing security via roles, privileges, and RLS.
• Diagnose and resolve performance bottlenecks using tools like EXPLAIN/ANALYZE and pg_stat_statements, tuning parameters as needed.

Required Skills

• 10+ years of experience in database engineering.
• Expertise with PostgreSQL.
• Proficiency in writing and optimizing SQL and PL/pgSQL.
• Experience building data access layers with Node.js, .NET, or Python.
• Familiarity with containerization using Docker and Kubernetes.
• Experience with CI/CD pipelines, including GitHub Actions and ArgoCD.
• Knowledge of Infrastructure as Code using Terraform.
• Understanding of database replication, failover, and point-in-time recovery (WAL archiving).

Key Skills

Education

Any Gradute