PostgreSQL Database Administrator

1 week ago


New Delhi, India Tata Consultancy Services Full time

PostgreSQL Database Administrator Experience- 8 to 16 years Location- KolkataResponsibilitiesDatabase 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).Required SkillsExtensive 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.Preferred SkillsExperience 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.



  • New Delhi, India Innova ESI Full time

    Role: Database Administrator- PostgreSQL Experience: 4+years Location: PAN India Immediate joiners onlyOverview We are seeking an experiencedPostgreSQL Database Administrator (DBA)to design, optimize, and maintain mission-critical database systems. The ideal candidate will possess strong expertise in PostgreSQL administration, performance tuning, automation,...


  • Delhi, India Innova ESI Full time

    Role: Database Administrator- PostgreSQL Experience: 4+years Location: PAN India Immediate joiners only Overview We are seeking an experienced PostgreSQL Database Administrator (DBA) to design, optimize, and maintain mission-critical database systems. The ideal candidate will possess strong expertise in PostgreSQL administration, performance tuning,...


  • Delhi, India Innova ESI Full time

    Role: Database Administrator- PostgreSQLExperience: 4+yearsLocation: PAN IndiaImmediate joiners onlyOverviewWe are seeking an experiencedPostgreSQL Database Administrator (DBA)to design, optimize, and maintain mission-critical database systems. The ideal candidate will possess strong expertise in PostgreSQL administration, performance tuning, automation, and...


  • Delhi, Delhi, India Acesoft Labs Full time

    We have an immediate opportunity with one of our esteemed client Position - PostgreSQL DBA Exp - 5+ years Loc - Pan India NP - Immediate **Job Description**: **Must Have**: PostgreSQL BDR Sync replication Setup (must have) Backup and administration PostgreSQL Development (must have) Performance tuning (must have) **Nice to have**: User creation (nice...


  • New Delhi, India Tata Consultancy Services Full time

    PostgreSQL Database AdministratorExperience- 8 to 16 yearsLocation- KolkataResponsibilities- 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...


  • New Delhi, India Smart Source Full time

    We are looking for a highly skilled PostgreSQL Database Developer with deep expertise in designing, developing, and optimizing PostgreSQL databases. The ideal candidate will have hands-on experience with PL/pgSQL, performance tuning, and ensuring the reliability, scalability, and security of large-scale database systems.Key Responsibilities Design, develop,...


  • New Delhi, India LTIMindtree Full time

    Role: PostgreSQL Database AdminExperience: 8 years to 12 yearsLocation: PAN IndiaJob Description:- 12 years of IT experience and minimum of 5 years of experience on PostgreSQL database administration Should have worked with the team size of above 10 members technically guided the team Willing to provide 24x7 support flexible to work in the shiftsKEY...


  • New Delhi, India LTIMindtree Full time

    Role: PostgreSQL Database AdminExperience: 8 years to 12 yearsLocation: PAN IndiaJob Description:- 12 years of IT experience and minimum of 5 years of experience on PostgreSQL database administration Should have worked with the team size of above 10 members technically guided the team Willing to provide 24x7 support flexible to work in the shiftsKEY...


  • New Delhi, India LTIMindtree Full time

    Role: PostgreSQL Database Admin Experience: 8 years to 12 years Location: PAN IndiaJob Description:12 years of IT experience and minimum of 5 years of experience on PostgreSQL database administration Should have worked with the team size of above 10 members technically guided the team Willing to provide 24x7 support flexible to work in the shiftsKEY...


  • New Delhi, India LTIMindtree Full time

    Role: PostgreSQL Database Admin Experience: 8 years to 12 years Location: PAN IndiaJob Description:12 years of IT experience and minimum of 5 years of experience on PostgreSQL database administration Should have worked with the team size of above 10 members technically guided the team Willing to provide 24x7 support flexible to work in the shiftsKEY...