Senior PostgreSQL Database Administrator

Persistent

6–12 yrs Pune Full Time Hybrid (office + remote)
Persistent logo
Posted : today
Actively hiring

Job description

Join a leading AI-led digital engineering partner as a Senior PostgreSQL Database Administrator. This role is crucial for managing our high-availability PostgreSQL platform, supporting vital enterprise services like analytics and identity management. We seek a professional with extensive experience in end-to-end PostgreSQL administration, HA architecture, Kubernetes deployments, and operational excellence.

This position offers the opportunity to work with cutting-edge technologies and collaborate with cross-functional teams to ensure the reliability and scalability of mission-critical systems. We are committed to fostering a diverse and inclusive work environment, offering competitive compensation and robust benefits.

Responsibilities

Take ownership of PostgreSQL major version upgrades using various strategies, including zero-downtime methods. Plan and execute PostgreSQL migration activities, ensuring data integrity and application compatibility.

Manage and maintain PostgreSQL High Availability environments, replication architectures, and failover configurations. Operate PostgreSQL deployments on Kubernetes, handling Helm upgrades and lifecycle management.

Design and implement geo-redundancy solutions and execute storage migration initiatives. Coordinate schema migrations, database deployments, and change management processes.

Support enterprise platforms reliant on PostgreSQL, such as analytics and IAM systems. Configure and optimize PgBouncer for high-performance workloads. Design and validate robust backup and disaster recovery strategies.

Manage database security, user access, and vulnerability remediation. Develop and maintain monitoring dashboards and alerting frameworks using Prometheus and Grafana. Diagnose and resolve complex performance issues.

Create operational runbooks and recovery procedures. Collaborate with engineering and operations teams to enhance database reliability and efficiency. Provide advanced L3 production support and incident management.

Qualifications

A minimum of 6 to 12 years of dedicated experience in PostgreSQL Database Administration, Engineering, or Reliability Engineering is required.

Demonstrate a strong understanding of PostgreSQL internals, including WAL architecture, MVCC, transaction management, and autovacuum. Possess hands-on experience with PostgreSQL High Availability architectures, replication, failover, and disaster recovery planning.

Proficiency in PostgreSQL major version upgrades using pg_upgrade and logical replication is essential. Exhibit strong experience with backup and recovery processes, including pg_basebackup, WAL archiving, and PITR.

Advanced SQL expertise, including schema design, indexing, and query optimization with EXPLAIN ANALYZE, is expected. Solid knowledge of PostgreSQL security practices, RBAC, pg_hba.conf, and SSL/TLS enforcement is also necessary.

Experience with PgBouncer configuration and optimization is vital. Proven experience deploying and managing PostgreSQL on Kubernetes platforms, including StatefulSets and Persistent Volumes, is a must. Familiarity with Helm deployment lifecycle management and configuration is also required.

Develop and maintain PostgreSQL observability solutions using Prometheus and Grafana. Possess strong Bash scripting skills for automation and troubleshooting. Familiarity with Python or Go for tooling and automation is beneficial.

Experience with Git, CI/CD pipelines, and Infrastructure as Code is expected. Excellent troubleshooting, analytical, and root-cause analysis skills are crucial. Strong documentation, stakeholder management, and communication capabilities are also key.

Essential Skills

PostgreSQLLinuxKubernetesHelmPrometheusGrafanaBash ScriptingCI/CDGit

Good to Have

PythonGoPgBouncer

Highlights

  • Actively hiring

More Details

RoleSenior PostgreSQL Database Administrator
IndustryIT Services and Consulting
DepartmentDatabase Administration
Employment TypeFull Time, Hybrid (office + remote)

About the Company

Persistent Systems logo

Persistent Systems

IT Services and Consulting

Senior PostgreSQL Database Administrator at Persistent | SkillMX | SkillMX