PostgreSQL Developer

About the Role :

We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage and maintain our PostgreSQL database environments across multiple versions (9.x to 15.x). The ideal candidate will have extensive hands-on experience in database installation, configuration, performance tuning, backup, recovery, replication, and automation to ensure high availability, security, and optimal performance of critical applications.

Key Responsibilities :

• Install, configure, and monitor PostgreSQL database instances across various versions (9, 10, 11, 12, 13, 15).
• Manage database users, roles, and permissions to ensure secure access control.
• Perform database backups and restores using third-party tools and custom scripts, ensuring data integrity and availability.
• Plan and execute PostgreSQL upgrades and apply patches without affecting application uptime.
• Perform database refreshes in non-production environments for development and testing purposes.
• Monitor and tune database performance; troubleshoot application and database performance bottlenecks proactively.
• Utilize third-party database administration and monitoring tools such as pgAdmin and pgBench for effective database management.
• Implement and maintain high availability solutions using PostgreSQL streaming replication and logical replication.
• Manage Pgpool for load balancing and Pg_rewind for disaster recovery scenarios.
• Automate routine database administration and maintenance tasks using shell scripting and other automation tools.
• Collaborate with development teams to own, track, and resolve database-related incidents and requests promptly.
• Manage database configurations and properties for applications in both development and production environments.
• Handle incidents, problems, and change requests, and conduct root cause analysis (RCA) for database-related issues.
• Conduct disaster recovery drills as per organizational and customer policies to ensure preparedness.
• Maintain clear and effective communication with stakeholders, including customers and internal teams, to ensure alignment on database management activities.

Required Skills and Qualifications :

ref : hirist.tech)