Senior PostgreSQL Developer / Database Engineer

Sequoia Applied Technologies; Chennai District; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

A technology solutions firm is seeking a Senior PostgreSQL Developer in Chennai. The successful candidate will design and maintain scalable database solutions, optimize SQL queries, and ensure high performance of PostgreSQL systems. They should possess 6–8 years of experience, with expertise in database design and performance tuning. Familiarity with cloud platforms and scripting is preferred, along with strong analytical and collaboration skills.

Qualifications

• 6–8 years of hands-on experience with PostgreSQL.
• Strong expertise in database design, normalization, and data modeling.
• Advanced knowledge of SQL and query optimization techniques.

Responsibilities

• Design, develop, and maintain PostgreSQL database schemas.
• Write and optimize complex SQL queries.
• Perform query tuning and manage database performance.

Skills

PostgreSQL expertise

Database design

SQL optimization

Performance tuning

Scripting (Python, Bash)

Transaction management

Tools

Prometheus

Grafana

pgAdmin

Job description

Role Overview

We are looking for an experienced Senior PostgreSQL Developer with strong expertise in database design, query optimization, and performance tuning. The ideal candidate will be responsible for designing scalable database solutions, writing efficient queries, and ensuring high availability and performance of PostgreSQL systems.

Key Responsibilities

• Design, develop, and maintain robust and scalable PostgreSQL database schemas.
• Write, optimize, and troubleshoot complex SQL queries for high-performance applications.
• Perform query tuning, indexing strategies, and execution plan analysis.
• Manage database performance, identify bottlenecks, and implement improvements.
• Develop and maintain stored procedures and functions.
• Handle database migrations, upgrades, and version control.
• Ensure data integrity, security, and compliance standards are maintained.
• Work closely with application developers to design efficient data models.
• Monitor database health, backups, replication, and disaster recovery processes.
• Implement and manage high availability solutions (replication, clustering).
• Troubleshoot production issues and provide timely resolutions.
• Contribute to CI/CD pipelines for database deployments.

Required Skills & Qualifications

• 6–8 years of hands‑on experience with PostgreSQL.
• Strong expertise in database design, normalization, and data modeling.
• Advanced knowledge of SQL and query optimization techniques.
• Experience with performance tuning, indexing, and query planning.
• Familiarity with PostgreSQL internals (vacuuming, indexing, WAL, etc.).
• Experience in backup and recovery strategies.
• Knowledge of replication techniques (streaming, logical replication).
• Proficiency in scripting languages (e.g., Python, Bash) for automation.
• Understanding of transaction management and concurrency control.

Good to Have

• Experience with cloud platforms (AWS RDS, Azure Database for PostgreSQL, GCP).
• Knowledge of partitioning and sharding strategies.
• Exposure to NoSQL databases is a plus.
• Experience working in Linux/Unix environments.
• Experience with monitoring tools (Prometheus, Grafana, pgAdmin, etc.).
• Familiarity with DevOps practices and CI/CD pipelines.
• Understanding of microservices architecture.

Soft Skills

• Strong analytical and problem‑solving skills.
• Excellent communication and collaboration abilities.
• Ability to mentor junior team members.
• Proactive approach to identifying and solving performance issues.