PostgreSQL Developer

<p><p><b>Key Responsibilities :</b></p><p><p><b><br/></b></p>- Design, develop, and maintain PostgreSQL databases to support application needs.<br/><br/></p><p>- Perform database tuning and optimization for performance improvements.<br/><br/></p><p>- Write complex SQL queries, stored procedures, triggers, and functions.<br/><br/></p><p>- Manage database backup, recovery, and disaster recovery processes.<br/><br/></p><p>- Monitor database health, troubleshoot issues, and provide timely resolution.<br/><br/></p><p>- Collaborate with development teams to design efficient database schemas and optimize </p><p>queries.<br/><br/></p><p>- Implement and maintain database security best practices.<br/><br/></p><p>- Automate routine database tasks using scripting languages.<br/><br/></p><p>- Ensure data integrity and consistency across distributed environments.<br/><br/></p><p>- Support database migration and upgrades as required.<br/><br/></p><p>- Document database configurations, policies, and Skills & Qualifications : </b></p><p><br/></p>- Minimum 3 years of hands-on experience working with PostgreSQL databases.<br/><br/></p><p>- Strong SQL skills with experience writing complex queries, functions, and triggers.<br/><br/></p><p>- Experience with PostgreSQL performance tuning and optimization.<br/><br/></p><p>- Familiarity with database backup, restore, and disaster recovery strategies.<br/><br/></p><p>- Knowledge of database security and user access management.<br/><br/></p><p>- Experience with monitoring tools and performance metrics analysis.<br/><br/></p><p>- Ability to write automation scripts using Bash, Python, or similar scripting languages.<br/><br/></p><p>- Familiarity with cloud database services (AWS RDS, Azure Database for PostgreSQL, GCP Cloud SQL) is a plus.</p><p><br/></p><p>- Good understanding of database replication and clustering.<br/><br/></p><p>- Experience working in Agile teams and remote environments.<br/><br/></p><p>- Strong communication skills and ability to work independently</p><br/></p> (ref:hirist.tech)