Job Overview

job responsibilities: -

exp range- 5-8 yrs

hiring location- chennai, kolkata, hyderabad, pune,bangalore

• serve as the subject matter expert (sme) for postgresql database management and optimization.
• manage and maintain the company's postgresql database systems, ensuring high performance, availability, and security.
• implement and manage automation processes using ansible to streamline postgresql database operations.
• hands on experience with ansible
• utilize postgresql tools such as pgadmin, pg_dump, pg_backup, barman, and pg_stat_statements for database management, backup, and performance tuning.
• configure and manage database replication using pg_logical and other relevant postgresql replication tools to ensure data consistency and high availability.
• deploy and manage multi-node postgresql clusters using patroni and other relevant high-availability solutions for scalability and fault tolerance.
• monitor postgresql database systems using monitoring tools such as pg_stat_activity, pgbadger, and prometheus for performance and availability monitoring.
• perform regular postgresql backups and implement recovery strategies to safeguard data integrity.
• optimize postgresql performance through query and index tuning, as well as system parameter adjustments.
• collaborate with cross-functional teams to support application development and deployment processes.
• develop and maintain documentation related to postgresql configurations, ansible automation processes, postgresql tools, and procedures.
• develop and maintain shell scripts, ansible playbooks, and python scripts to automate and optimize database operations and infrastructure management