PostgreSQL Database Engineer

Overview

Experience: 6+yrs
Location: Pune

About the Role:

We are looking for an experienced PostgreSQL Lead with deep technical expertise in managing and scaling PostgreSQL databases. The ideal candidate will have strong hands-on experience with performance tuning, optimization for non-functional requirements (NFRs), and advanced PostgreSQL architecture design. Experience with containerized database environments and complex migrations, especially from Oracle to PostgreSQL, is critical.
Key Responsibilities:

•  Architect, deploy, and manage large-scale PostgreSQL databases in production environments.
•  Lead and execute performance tuning, query optimization, and high availability strategies.
•  Design and implement solutions for key NFRs (security, scalability, reliability, etc.).
•  Manage PostgreSQL databases running in containerized environments (Docker/Kubernetes).
•  Drive complex database migrations from Oracle to PostgreSQL.
•  Support PostgreSQL-to-PostgreSQL migrations, version upgrades, and replication strategies (nice to have).
•  Define and enforce best practices for backup, disaster recovery, and monitoring.
•  Collaborate with DevOps, application, and cloud teams to ensure seamless DB operations.
• Must-Have Skills:
•  6+ years of deep expertise in PostgreSQL internals and architecture.
•  Proven experience with performance tuning at scale.
•  Experience running PostgreSQL in containers (Docker/Kubernetes).
•  Strong background in Oracle to PostgreSQL migration strategies and tools (e.g., ora2pg, AWS DMS).
•  Expertise in database security, replication, and failover strategies.

Nice-to-Have Skills:Qualifications:

•  Experience with PostgreSQL-to-PostgreSQL migrations and upgrades.
•  Familiarity with cloud-native DB platforms (e.g., RDS, Aurora PostgreSQL).
•  Scripting skills (Python, Shell) for automation and tooling.
•  Bachelor’s or Master’s in Computer Science or a related field.
•  Relevant certifications (PostgreSQL, cloud, Kubernetes) are a plus.

Job Types: Full-time, Permanent

Schedule:

• Day shift
• Monday to Friday
• Night shift
• US shift

Experience:

• PostgreSQL: 1 year (Preferred)

Location:

• Pune, Maharashtra (Preferred)

Work Location: In person