Senior PostgreSQL Developer / Database Engineer

<div><strong>Role Overview</strong></div><div>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.</div><div align="center" style="text-align:center;"><hr align="center"></div><div><strong>Key Responsibilities</strong></div><ul style="margin-top:0cm;" type="disc"><li>Design, develop, and maintain robust and scalable <strong>PostgreSQL</strong> database schemas.</li><li>Write, optimize, and troubleshoot complex SQL queries for high-performance applications.</li><li>Perform <strong>query tuning</strong>, indexing strategies, and execution plan analysis.</li><li>Manage database performance, identify bottlenecks, and implement improvements.</li><li>Develop and maintain stored procedures and functions.</li><li>Handle database migrations, upgrades, and version control.</li><li>Ensure <strong>data integrity, security, and compliance</strong> standards are maintained.</li><li>Work closely with application developers to design efficient data models.</li><li>Monitor database health, backups, replication, and disaster recovery processes.</li><li>Implement and manage <strong>high availability solutions</strong> (replication, clustering).</li><li>Troubleshoot production issues and provide timely resolutions.</li><li>Contribute to CI/CD pipelines for database deployments.</li></ul><div align="center" style="text-align:center;"><hr align="center"></div><div><strong>Required Skills & Qualifications</strong></div><ul style="margin-top:0cm;" type="disc"><li>6–8 years of hands-on experience with PostgreSQL.</li><li>Strong expertise in <strong>database design</strong>, normalization, and data modeling.</li><li>Advanced knowledge of <strong>SQL</strong> and query optimization techniques.</li><li>Experience with <strong>performance tuning</strong>, indexing, and query planning.</li><li>Familiarity with <strong>PostgreSQL internals</strong> (vacuuming, indexing, WAL, etc.).</li><li>Experience in <strong>backup and recovery strategies</strong>.</li><li>Knowledge of <strong>replication techniques</strong> (streaming, logical replication).</li><li>Proficiency in scripting languages (e.g., Python, Bash) for automation.</li><li>Understanding of <strong>transaction management</strong> and concurrency control.</li></ul><div align="center" style="text-align:center;"><hr align="center"></div><div><strong>Good to Have</strong></div><ul style="margin-top:0cm;" type="disc"><li>Experience with cloud platforms (AWS RDS, Azure Database for PostgreSQL, GCP).</li><li>Knowledge of <strong>partitioning and sharding strategies</strong>.</li><li>Exposure to <strong>NoSQL databases</strong> is a plus.</li><li>Experience working in <strong>Linux/Unix environments</strong>.</li><li>Experience with monitoring tools (Prometheus, Grafana, pgAdmin, etc.).</li><li>Familiarity with DevOps practices and CI/CD pipelines.</li><li>Understanding of microservices architecture.</li></ul><div align="center" style="text-align:center;"><hr align="center"></div><div><strong>Soft Skills</strong></div><ul style="margin-top:0cm;" type="disc"><li>Strong analytical and problem-solving skills.</li><li>Excellent communication and collaboration abilities.</li><li>Ability to mentor junior team members.</li><li>Proactive approach to identifying and solving performance issues.</li></ul>