Job Title : "Database Developer".

Job Details :

Job Type : Full Time

Experience : 3 to 7 Yrs

Location : Chennai (WFO)

Notice Period : Immediate to 15 days

Skills : Postgresql and Azure are mandatory, no SQL Developer profiles.

Job Description :

1. 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.

2. 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.

3. 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.

4. 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.

5. 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.

- 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.