Role Overview
We are looking for an experienced Senior PostgreSQL Developer with robust 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

📌 Senior PostgreSQL Developer (Chennai)
🏢 Sequoia Applied Technologies
📍 Chennai