Database Designer / Developer (Product Database Owner – PostgreSQL, Azure)

Job Description Database Designer / Developer (Product Database Owner – PostgreSQL, 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, new 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 performance, scalability, and data growth behavior.

Perform data validation and sanity checks to ensure data quality and correctness. Cloud & Platform Collaboration Own and manage Azure Database for PostgreSQL from a product perspective, including configuration and scaling decisions. Monitor database performance using pg_stat_statements and Azure-native monitoring as needed.

Work on backup, restore, security, and DR best practices. Collaboration & Ways of Working Collaborate closely with application developers to influence schema design, access patterns, and resolve performance bottlenecks. Use modern AI-assisted development tools to improve productivity and optimization workflows.

Required Skills Strong hands-on experience with PostgreSQL and pgAdmin 4. Expertise in query optimization, indexing, and database performance tuning. Deep understanding of execution plans, partitioning strategies, and cost-based optimization.

Experience with Azure Database for PostgreSQL including setup, scaling, and performance optimization. Strong SQL query design and troubleshooting skills. Experience with schema migrations and version control using Git.

Nice to Have Understanding of connection pooling concepts such as PgBouncer. Exposure to ETL processes or data pipelines. Experience working with high-volume, rapidly growing datasets.

Key Characteristics Strong ownership mindset and accountability. Product-first thinking with a performance-driven approach. Ability to anticipate future data and usage growth.

Comfortable influencing design decisions across engineering teams.