Business Alanyst

2 days ago

Jaipur, Rajasthan, India Cozzera Full time ₹ 5,00,000 - ₹ 12,00,000 per year

Position Title:
Database developer - PostgreSQL

Experience:
5+ Years

Location:
Jaipur (Onsite)

Role Overview

We are seeking a skilled
PostgreSQL Database Administrator (DBA)
with 5+ years of experience in managing, optimizing, and maintaining PostgreSQL environments. The ideal candidate will be hands-on with performance tuning, high availability, automation, and will work closely with developers and DevOps teams to ensure scalability, security, and reliability of mission-critical systems.

Key Responsibilities

Database Architecture & Strategy

  • Design, configure, and maintain highly available PostgreSQL environments (replication, partitioning, clustering).
  • Define standards, procedures, and best practices for PostgreSQL administration.

Performance & Optimization

  • Perform query tuning, indexing, and performance troubleshooting.
  • Plan capacity and ensure database scalability for large datasets.

Operations & Maintenance

  • Handle installation, upgrades, patching, and configuration management.
  • Ensure reliable backup/recovery processes and disaster recovery readiness.
  • Manage database security, access control, and compliance.

Automation & Monitoring

  • Implement monitoring tools, alerts, and dashboards for proactive database management.
  • Automate routine DBA tasks using
    Bash/Python/Ansible
    scripts.

Collaboration & Support

  • Work with developers to optimize queries and schemas.
  • Participate in on-call support, incident response, and RCA (Root Cause Analysis).
  • Support database deployments in CI/CD pipelines.

Required Skills & Qualifications

  • 5+ years of experience in
    PostgreSQL database administration
    .
  • Strong expertise in
    performance tuning, query optimization, and indexing
    .
  • Hands-on with
    replication, partitioning, HA solutions
    (Patroni, Pgpool-II, repmgr).
  • Experience with
    Linux/Unix environments
    .
  • Proficiency in
    SQL, PL/pgSQL
    , and scripting (Bash/Python).
  • Solid understanding of
    backup/recovery strategies and DR
    .
  • Knowledge of
    database security and compliance
    practices.

Good to Have

  • Experience with
    AWS RDS/Aurora, Azure, or GCP Cloud SQL
    .
  • Familiarity with
    containerized PostgreSQL (Docker/Kubernetes)
    .
  • Exposure to
    NoSQL (MongoDB, Redis)
    .
  • Understanding of
    CI/CD, DevOps, and IaC
    (Terraform/Ansible).