Postgres Database Administrator

8 - 13 years

Pune

Posted:15 hours ago

Job Description

Responsibilities:

  • Install, configure, upgrade, and maintain

    PostgreSQL database environments

    across development, testing, and production systems.
  • Monitor database performance, identify bottlenecks, and perform tuning to ensure high availability and optimal response times.
  • Manage

    backup, recovery, disaster recovery (DR), and replication

    solutions to ensure data integrity and business continuity.
  • Implement and maintain

    database security

    , including user access management, encryption, auditing, and compliance controls.
  • Perform database migrations, upgrades, patching, and capacity planning activities.
  • Troubleshoot complex database issues and provide root cause analysis (RCA) for production incidents.
  • Design and maintain

    high-availability architectures

    using PostgreSQL Replication, Failover, Streaming Replication, and Clustering technologies.
  • Collaborate with application development, DevOps, and infrastructure teams to optimize database performance and reliability.
  • Develop and maintain scripts for automation, monitoring, and administrative tasks using

    Shell Scripting, Python, or SQL

    .
  • Support cloud-based PostgreSQL deployments on platforms such as

    AWS RDS, Azure Database for PostgreSQL, or Google Cloud SQL

    .
  • Ensure adherence to database administration best practices, change management processes, and operational standards.
  • Prepare and maintain technical documentation, SOPs, and operational runbooks.

Preferred Skills

  • PostgreSQL 12/13/14/15/16 Administration
  • Performance Tuning & Query Optimization
  • Backup & Recovery (pgBackRest, Barman)
  • Replication & High Availability (Patroni, Pgpool-II, Repmgr)
  • Linux/Unix Administration
  • AWS/Azure/GCP Database Services
  • Shell Scripting / Python
  • Monitoring Tools (Prometheus, Grafana, Zabbix)

Skills Required

Production support Database design Postgresql Database Administration Administration Architecture Production DBMS Postgresql

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Orcapod Consulting Services logo
Orcapod Consulting Services

Consulting

Mumbai

RecommendedJobs for You