Job Description
Database Designer / Developer (Product Database Owner – Postgre SQL, Azure)
Experience: 3–5 Years
Location: Chennai
Shift Time – General Shift (10:00 AM to 7:00 PM)
Work Mode – 5 days' work from office.
Mandatory Skillset:
We need a person who could understand the Structure of Source data and design the DDL of database, Schema, and its tables.
Role Summary
We are are looking for a Database Designer / Developer who will own the database layer end-to-end. This role is responsible for data model design, current dataset onboarding, indexing strategy, query performance, and database evolution as the product scales. The ideal candidate is a hands-on product database engineer who understands application access patterns and makes proactive design decisions to ensure performance, scalability, and reliability.
Key Responsibilities
Product Database Ownership
Own database design decisions across the product lifecycle, including schema modeling, evolution, and backward compatibility.
Design and manage new datasets aligned with product features and analytics needs.




Define and own indexing strategies to support evolving query patterns and data growth.
Ensure long-term data scalability, consistency, and performance.
Query & Performance Engineering
Build, optimize, and troubleshoot complex SQL queries.
Analyze query execution plans using EXPLAIN and EXPLAIN ANALYZE.
Perform query rewrite and cost optimization based on access patterns.
Tune database performance through index optimization, vacuum, analyze, and autovacuum tuning.
Proactively identify performance risks as data volume and usage grow.
Schema & Database Development
Design efficient schemas, partitioning strategies, and relational data models.
Develop and maintain database objects including functions, stored procedures, and materialized views.
Manage schema versioning and database migrations using Git-based workflows.
Data Handling & Validation
Design and manage production-like datasets to validate query perform

📌 Database designer (Chennai)
🏢 GreatHR Solutions
📍 Chennai