PostgreSQL Database Administrator

Guidepoint; Maharashtra; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Competitive compensation

Employee medical coverage

Casual work environment

Job summary

A leading enterprise software organization is seeking an experienced PostgreSQL Database Administrator to design and manage scalable PostgreSQL platforms aligned with cloud-native architectures. This hybrid role will involve optimizing for microservices, ensuring high availability, and executing modernization initiatives. The ideal candidate will bring over 8 years of experience in software architecture and possess strong expertise in Kubernetes and distributed systems. The organization offers competitive compensation, employee medical coverage, and a casual work environment.

Qualifications

• 8+ years in software architecture, cloud engineering, or platform engineering.
• Strong expertise in Kubernetes, microservices, and distributed systems.
• Experience with CI/CD pipelines and cloud-native design principles.

Responsibilities

• Design and operate PostgreSQL platforms for microservices.
• Architect and manage high-availability PostgreSQL solutions.
• Optimize PostgreSQL performance and scalability in cloud environments.

Skills

Managing connection pooling

Database design patterns

Troubleshooting PostgreSQL internals

Designing for microservices

Tools

Terraform

Azure DevOps

PgBouncer

Kubernetes

Job description

Overview

Guidepoint is an enterprise software organization embarking on a modernization strategy from a legacy monolith to a cloud‑native, Kubernetes‑based environment. With multiple product and platform teams delivering reusable services across the enterprise, we are seeking a highly experienced PostgreSQL Database Administrator and Architect to design, operate, and evolve PostgreSQL platforms that support cloud‑native, microservices‑based applications. This role is critical to ensuring our data layer is scalable, resilient, secure, and aligned with Kubernetes‑driven architectures.

This position is a hybrid role located out of our Pune office.

What You’ll Do

• Design, deploy, and operate PostgreSQL platforms optimized for microservices running on Kubernetes, ensuring scalability, isolation, and resilience
• Architect and manage Azure PostgreSQL Flexible Server and Hyperscale (Citus) for high availability, disaster recovery, and global scale
• Define database design patterns for microservices, including database‑per‑service, shared services, read replicas, and event‑driven data flows
• Partner with engineering teams to ensure PostgreSQL supports CI/CD pipelines, rolling deployments, and zero‑downtime releases
• Lead performance tuning and capacity planning across compute, storage, IOPS, memory, and network layers
• Troubleshoot advanced PostgreSQL internals including autovacuum, WAL, MVCC, locking, query planner behavior, and background processes
• Design distributed data architectures using replication, logical decoding, sharding, and multi‑region topologies
• Support PostgreSQL connectivity patterns for Kubernetes workloads such as connection pooling, PgBouncer, sidecars, and service mesh integrations
• Lead and execute cloud migrations and modernization initiatives from on‑prem or legacy platforms to cloud‑native PostgreSQL
• Implement enterprise‑grade security and compliance controls including Azure AD integration, encryption at rest and in transit, Private Link, and customer‑managed keys
• Build and maintain automation and infrastructure‑as‑code using Terraform, Bicep, Azure DevOps, and scripting with Python, Bash, or PowerShell
• Establish observability and monitoring using
• Define PostgreSQL standards and best practices, mentor engineers, and act as a senior escalation point for mission‑critical systems

Core Skills for a PostgreSQL Admin Supporting Microservices

• Designing PostgreSQL for stateless application tiers and horizontally scaled services
• Managing connection pooling and concurrency at scale using PgBouncer or similar tools
• Supporting high‑transaction, bursty workloads typical of microservices architectures
• Implementing schema evolution strategies compatible with continuous delivery
• Understanding data ownership, consistency models, and service boundaries in distributed systems
• Supporting event‑driven architectures and change data capture patterns

Required Technical Qualifications

• 8+ years in software architecture, cloud engineering, or platform engineering
• Strong expertise in:
• Kubernetes, containers, service mesh, ingress/egress patterns
• Microservices and distributed systems
• Domain‑driven design (DDD) and domain decomposition
• Cloud‑native design principles and modernization strategies
• Demonstrated proficiency in programming languages with the ability to assess current application structures and determine appropriate modernization approaches
• Authentication & identity (Auth0, OIDC, OAuth2, SSO)
• API architecture (REST, GraphQL, gateways)
• Event‑driven design, messaging platforms (Kafka, Azure Service Bus)
• Cloud‑native patterns such as CQRS, Saga, Event Sourcing, Circuit Breakers
• CI/CD pipelines, Helm charts, GitOps, and modern DevOps tooling
• Experience using AI‑powered tooling to support PostgreSQL administration, troubleshooting, and operational efficiency

What We Offer

• Competitive compensation
• Employee medical coverage
• Central office location
• Entrepreneurial environment, autonomy, and fast decisions
• Casual work environment

About Guidepoint

Guidepoint is a leading research enablement platform designed to advance understanding and empower our clients’ decision‑making process. Powered by innovative technology, real‑time data, and hard‑to‑source expertise, we help our clients to turn answers into action. Backed by a network of nearly 1.75 million experts and Guidepoint’s 1,600 employees worldwide, we inform leading organizations’ research by delivering on‑demand intelligence and research on request. With Guidepoint, companies and investors can better navigate the abundance of information available today, making it both more useful and more powerful. At Guidepoint, our success relies on the diversity of our employees, advisors, and client base, which allows us to create connections that offer a wealth of perspectives. We are committed to upholding policies that contribute to an equitable and welcoming environment for our community, regardless of background, identity, or experience.