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 qualified experience as a Database Engineer or Database Developer focusing primarily on PostgreSQL.
PostgreSQL Expertise: Robust, 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: Robust 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.

📌 Postgresql Database Engineer Bengaluru (India)
🏢 Zarthi
📍 India