Postgresql Database Engineer

Key Responsibilities

• Database Automation & Logic:

  Design and implement automated database workflows, event-driven processes, and server-side automation using PL/pgSQL functions, procedures, and triggers.

• Schema Design & Management:

  Lead entity-relationship modeling, database schema creation, table optimization, indexing strategies, and data normalization efforts.

• Database Development:

  Write, debug, and maintain complex SQL queries, advanced functions, and views to support high-throughput backend applications.

• Ownership & Delivery:

  Independently manage assigned database tasks from design to deployment, ensuring timely delivery and clean, maintainable code.

• ETL & Data Pipeline Support:

  Build and support automated ETL processes for smooth data movement, integration, and aggregation.

• Performance Tuning & Optimization:

  Identify slow-running queries using execution plans (EXPLAIN ANALYZE), implement indexing strategies, and optimize schema logic for scalability.

• Collaboration:

  Partner with backend engineers, system leads, and product stakeholders to transform business rules into scalable database contracts and production-ready solutions.

Required Skills & Qualifications

• Experience:

  Minimum

  1.5+ years

  of hands-on professional experience as a Database Engineer or Database Developer focusing primarily on

  PostgreSQL

  .

• PostgreSQL Expertise:

  Strong, direct experience with PostgreSQL schema architecture, row-level security concepts, and database administration basics.

• Advanced Function & Automation Skills:

  Proven ability to build business logic and automated routines directly inside the database using

  PL/pgSQL functions

  , procedures, and triggers.

• Schema Design Mastery:

  Deep understanding of relational database design, data modeling, ER diagrams, normalization, and constraint configurations (Foreign Keys, Unique Checks, Indexes).

• Advanced SQL Proficiency:

  Strong hands-on ability with complex SQL, including window functions, common table expressions (CTEs), dynamic SQL, and subqueries.

• Self-Driven & Adaptive:

  Strong problem-solving mindset with the ability to take full ownership of tasks with minimal supervision.