Description

Define and maintain standards for Postgres database environments, focusing on performance tuning and automation.

This role is on-site.

Responsibilities

• Design, deploy, and maintain EDB Postgres, PGD, and AWS RDS clusters for large-scale applications.
• Create and manage functional database clusters across development, QA, and production environments.
• Plan and execute Postgres database upgrades, patches, and data migrations to new platforms.
• Provide day-to-day administrative support and production on-call rotation for Postgres and AWS Aurora databases.
• Drive automation and lead best practices for cloud-managed Postgres systems.

Required Skills

• 10+ years of experience in database design, maintenance, and administration.
• Deep experience with EDB Postgres, Postgres Distributed, and AWS RDS.
• Proficiency in PostgreSQL installation, configuration, and internals, including advanced server features.
• Strong skills in collecting diagnostics and tuning PostgreSQL and SQL performance.
• Proficiency in Linux environments, specifically Oracle Linux Enterprise.
• Experience setting up and monitoring PostgreSQL binary and logical replication.
• Proficiency in scripting languages such as Bash, KSH, and Perl.
• Experience with PostgreSQL procedural languages (PL/pgSQL, PL/Tcl, PL/Perl, PL/Python).
• Familiarity with monitoring tools like Splunk and Dynatrace.

Referral Bonus: ₹50,000

Key Skills

Education

Any Graduate