Business Analyst

5 years

0 Lacs

Posted:7 hours ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

Position Title:

Experience:

Location:


Role Overview

PostgreSQL Database Administrator (DBA)


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).

Mock Interview

Practice Video Interview with JobPe AI

Start DevOps 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.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You

hyderabad, chennai, bengaluru