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

Job Description

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

Experience: 35 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.