Talent.com
This job offer is not available in your country.
PostgreSQL Developer

PostgreSQL Developer

NUSTAR TECHNOLOGIES INDIA PRIVATE LIMITEDHyderabad
8 days ago
Job description

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 :

  • 5 to 10 years of hands-on experience with PostgreSQL database administration, including installation, configuration, and monitoring.
  • Strong expertise in managing PostgreSQL users, permissions, and security best practices.
  • Proven experience with backup, restore processes, and disaster recovery procedures using third-party tools and custom scripts.
  • Experience upgrading PostgreSQL databases and applying patches with minimal downtime.
  • In-depth knowledge of database refresh processes in non-production environments.
  • Demonstrated skills in performance tuning and troubleshooting PostgreSQL database and application performance issues.
  • Familiarity with PostgreSQL tools such as pgAdmin, pgBench, Pgpool, and Pg_rewind.
  • Hands-on experience setting up and managing high availability (HA) and replication strategies (streaming and logical replication).
  • Strong scripting skills, preferably with shell scripting, for automation of DBA tasks.
  • Experience working closely with developers and cross-functional teams to resolve database issues and implement enhancements.
  • Good understanding of incident, problem, and change management processes.
  • Excellent communication and interpersonal skills to coordinate with customers and internal teams effectively.

    • ref : hirist.tech)

    Create a job alert for this search

    Developer Postgresql • Hyderabad