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.