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: 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)
🏢 Zarthi
📍 Bengaluru