Postgresql Database Engineer

Zarthi; Dadri, Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

Zarthi in India is seeking a database engineer focused on PostgreSQL to design and automate backend data workflows. You will work on schema creation, performance tuning, and building robust data models to support scalable applications.

The role requires hands-on SQL proficiency, experience with ER modeling, indexing, and advanced SQL features such as window functions and CTEs. You will collaborate with backend teams to translate business rules into reliable database contracts.

Qualifications

• 1.5+ years of hands-on experience with PostgreSQL.
• Strong knowledge of PostgreSQL schema architecture and row-level security.
• Ability to build business logic inside the database using PL/pgSQL.
• Experience in ER modeling, normalization, and constraint configurations.
• Proficient in advanced SQL, including window functions, CTEs, and dynamic SQL.
• Self-driven with good problem-solving and ownership.

Responsibilities

• Design and implement automated database workflows and server-side automation.
• Lead schema design, table optimization, and indexing strategies.
• Develop complex queries, views, and database objects to support applications.
• Own assigned tasks from design to deployment.
• Support ETL processes and data integration.
• Collaborate with backend engineers and product stakeholders.

Skills

PostgreSQL

PL/pgSQL

SQL

ER modeling

Indexing

Performance tuning

ETL

Data pipelines

Window functions

CTEs

Collaboration

Job description

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.