Senior PostgreSQL Database Administrator

Persistent Systems; Pune District; À distance; INR 3 500 000 - 5 500 000; Plein temps

Avantages offerts par ce poste

Hybrid work

Flexible hours

Health insurance

Education sponsorship

Long Service awards

Résumé du poste

Persistent Systems is seeking a Senior PostgreSQL Database Administrator to own and manage a high-availability PostgreSQL platform across enterprise analytics, IAM, and monitoring services. The role involves end-to-end PostgreSQL administration, clustering, backups, security hardening, and observability within a Kubernetes-based environment.

You will collaborate with Product Engineering, DevOps, Platform, IAM, and Monitoring teams to ensure reliability, scalability, and security of

Qualifications

• 6 to 12 years of PostgreSQL experience
• Strong understanding of PostgreSQL internals and replication
• Experience with HA architectures and Kubernetes deployments
• Security practices and TLS/audit controls
• Automation scripting for operations

Responsabilités

• Lead major PostgreSQL upgrades and migrations with zero-downtime strategies
• Manage HA, replication, failover configurations
• Operate deployments on Kubernetes with Helm and lifecycle management
• Design geo-redundancy across regions
• Backup/DR planning using WAL, PITR
• Security, access controls, TLS enforcement
• Observability dashboards with Prometheus & Grafana
• Troubleshoot replication lag and performance issues
• Develop runbooks and standards
• Provide L3 production support

Connaissances

PostgreSQL administration

Kubernetes operations

Performance tuning

Backup and recovery

Security hardening

Observability

PgBouncer

WAL archiving

PITR

SQL optimization

Bash scripting

Python or Go tooling

Git/CI/CD

Terraform / IaC (conceptual)

Outils

PostgreSQL

Kubernetes

Helm

PgBouncer

Prometheus

Grafana

Git

CI/CD

Description du poste

We are looking for an experienced Senior PostgreSQL Database Administrator to own and manage the PostgreSQL high-availability platform that supports critical analytics, identity management, workflow orchestration, and monitoring services across the enterprise. The role involves end-to-end PostgreSQL administration, high-availability architecture, Kubernetes-based deployments, backup and recovery, security hardening, observability, database modernization, and operational excellence. The ideal candidate will have strong expertise in PostgreSQL administration, replication technologies, Kubernetes operations, database performance tuning, backup and recovery strategies, and infrastructure automation. You will work closely with Product Engineering, DevOps, Platform, IAM, and Monitoring teams to ensure reliability, scalability, security, and high availability of mission-critical services.

• Location: All Persistent Locations
• Experience: 6 to 12 Years
• Job Type: Full Time Employment

What You'll Do:

• Own and execute PostgreSQL major version upgrades using in-place, migration-based, and zero-downtime strategies.
• Plan, validate, and execute PostgreSQL migration activities while ensuring application compatibility and data integrity.
• Manage and maintain PostgreSQL High Availability environments, replication architectures, and failover configurations.
• Operate PostgreSQL deployments on Kubernetes, including Helm upgrades, configuration management, and platform lifecycle activities.
• Design and implement geo-redundancy solutions across multiple availability zones and regions.
• Execute storage migration initiatives, including Persistent Volume migrations, storage-class transitions, and rollback planning.
• Coordinate schema migrations, database deployments, and change management activities.
• Support and maintain PostgreSQL-backed enterprise platforms, including analytics, IAM, workflow orchestration, and monitoring systems.
• Configure and optimize PgBouncer connection pooling for high-performance application workloads.
• Design, implement, and validate backup and disaster recovery strategies using WAL archiving, base backups, and Point-in-Time Recovery (PITR).
• Manage database security, user access controls, credential rotation, audit logging, TLS enforcement, and vulnerability remediation.
• Develop and maintain monitoring dashboards, alerting frameworks, and operational reporting systems using Prometheus and Grafana.
• Diagnose and resolve performance issues related to replication lag, locking conflicts, long-running queries, autovacuum bottlenecks, and storage constraints.
• Develop operational runbooks, recovery procedures, upgrade documentation, and database standards.
• Collaborate with engineering and operations teams to improve database reliability, scalability, and operational efficiency.
• Provide advanced L3 production support and incident management for critical PostgreSQL environments.

Expertise You'll Bring:

• 6 to 12 years of experience in PostgreSQL Database Administration, Database Engineering, or Database Reliability Engineering.
• Strong understanding of PostgreSQL internals including WAL architecture, MVCC, transaction management, autovacuum, locking mechanisms, and connection lifecycle management.
• Hands-on experience with PostgreSQL High Availability architectures, replication, failover strategies, switchovers, and disaster recovery planning.
• Expertise in PostgreSQL major version upgrades using pg_upgrade, logical replication, and migration-based upgrade methodologies.
• Strong experience managing backup and recovery processes including pg_basebackup, WAL archiving, PITR, and disaster recovery testing.
• Advanced SQL expertise including schema design, indexing strategies, query optimization, and performance tuning using EXPLAIN ANALYZE.
• Strong knowledge of PostgreSQL security practices including RBAC, pg_hba.conf configuration, SSL/TLS enforcement, audit controls, and access management.
• Hands-on experience with PgBouncer configuration, optimization, connection scaling, and session management.
• Experience deploying and managing PostgreSQL on Kubernetes platforms.
• Expertise with StatefulSets, Persistent Volumes, storage migrations, and Kubernetes-based stateful workloads.
• Strong understanding of Helm deployment lifecycle management and configuration customization.
• Experience developing and maintaining PostgreSQL observability solutions using Prometheus and Grafana.
• Ability to troubleshoot replication lag, query performance issues, autovacuum bottlenecks, database locks, and resource constraints.
• Strong Bash scripting skills for automation, monitoring, maintenance, and operational activities.
• Familiarity with Python or Go for tooling, automation, and migration utilities.
• Experience with Git, CI/CD pipelines, Infrastructure as Code, and deployment automation.
• Excellent troubleshooting, analytical, and root-cause analysis skills.
• Strong documentation, stakeholder management, and communication capabilities.
• Experience working with globally distributed engineering, DevOps, and operations teams.
• Competitive salary and benefits package
• Culture focused on talent development with quarterly growth opportunities and company-sponsored higher education and certifications
• Opportunity to work with cutting-edge technologies
• Employee engagement initiatives such as project parties, flexible work hours, and Long Service awards
• Insurance coverage: group term life, personal accident, and Mediclaim hospitalization for self, spouse, two children, and parents

Values-Driven, People-Centric & Inclusive Work Environment:

Persistent is dedicated to fostering diversity and inclusion in the workplace. We invite applications from all qualified individuals, including those with disabilities, and regardless of gender or gender preference. We welcome diverse candidates from all backgrounds.

• We support hybrid work and flexible hours to fit diverse lifestyles.
• Our office is accessibility-friendly, with ergonomic setups and assistive technologies to support employees with physical disabilities.
• If you are a person with disabilities and have specific requirements, please inform us during the application process or at any time during your employment

Lets unleash your full potential at Persistent - persistent.com/careers

"Persistent is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind."