Talent.com
PostgreSQL Database Administrator

PostgreSQL Database Administrator

Tata Consultancy Serviceswest bengal, west bengal, in
1 day ago
Job description

Greetings from TCS!!!

TCS is Hiring for PostgreSQL Database Administrator

Role - PostgreSQL DBA

Required Technical Skill Set - PostgreSQL Database Administrator

Desired Experience Range - 10-15 Years

Location of Requirement - Kolkata

Desired Competencies (Technical / Behavioral Competency)

Must-Have

  • Extensive hands-on experience with PostgreSQL (v11 and above).
  • Database installation, configuration, and upgrades on Linux / Unix platforms.
  • High Availability (HA) setup using streaming replication, Patroni, repmgr, etc.
  • Backup and recovery strategies using tools like pgBackRest, Barman.
  • Performance tuning and query optimization.
  • Strong knowledge of PL / pgSQL scripting and automation.
  • Experience in database monitoring and alerting tools (e.g., pg_stat_statements, Prometheus, Grafana).
  • Security hardening and compliance (role-based access control, SSL, encryption at rest / in-transit).
  • Disaster Recovery planning and execution.
  • Capacity planning and data growth forecasting.
  • Good understanding of cloud platforms (AWS RDS / Aurora, GCP Cloud SQL, or Azure PostgreSQL).
  • Good communication skills with both technical and management teams.

Good-to-Have

  • Experience with other databases (Oracle, MySQL, or NoSQL like MongoDB).
  • Experience with Kubernetes & PostgreSQL operators (e.g., Zalando, Crunchy).
  • Knowledge of Infrastructure as Code (Terraform, Ansible).
  • Experience with CI / CD pipelines for database changes
  • Experience with Databases (Oracle, DB2 & SQL server).
  • Exposure to PostgreSQL clustering and sharding.
  • Understanding of logical replication and change data capture (CDC).
  • Knowledge of network monitoring and tools
  • Excellent stakeholder management and cross-functional collaboration
  • Certifications (Optional but Preferred) : AWS Certified Database – Specialty

    • Role descriptions / Expectations from the Role

  • Database Architecture & Design : Design and maintain complex PostgreSQL database schemas.
  • Performance Tuning & Optimization : Advanced query tuning and index optimization. Analyze and resolve slow queries using EXPLAIN, ANALYZE, and pg_stat views.
  • Backup and Recovery : Implement and manage high-availability backup strategies. Test and document disaster recovery procedures.
  • Replication and High Availability : Set up and maintain replication (physical / logical). Experience with HA tools like Patroni, repmgr, or Pgpool-II.
  • Security Management : Implement role-based access controls, SSL / TLS, and audit logging. Monitor for vulnerabilities and apply patches.
  • Monitoring & Maintenance : Perform routine health checks and maintenance tasks (VACUUM, REINDEX, ANALYZE).
  • Upgrades & Migrations : Plan and execute PostgreSQL version upgrades with minimal downtime. Experience migrating from on-prem to cloud (AWS RDS / Aurora, Azure Database for PostgreSQL, or GCP).
    • Create a job alert for this search

    Database Administrator • west bengal, west bengal, in