Job
Description
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
