PostgreSQL Database Administrator

7 days ago


Kolkata, India Tata Consultancy Services Full time

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



  • Kolkata, India Tata Consultancy Services Full time

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


  • Kolkata, India Tata Consultancy Services Full time

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


  • Kolkata, India Tata Consultancy Services Full time

    PostgreSQL Database Administrator Experience- 8 to 16 years Location- Kolkata Responsibilities - 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...


  • Kolkata, India Tata Consultancy Services Full time

    PostgreSQL Database Administrator Experience- 8 to 16 years Location- Kolkata Responsibilities 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...


  • Kolkata, India Tata Consultancy Services Full time

    Greetings from TCS!!!TCS is Hiring for PostgreSQL Database AdministratorRole - PostgreSQL DBARequired Technical Skill Set - PostgreSQL Database AdministratorDesired Experience Range - 10-15 YearsLocation of Requirement - KolkataDesired Competencies (Technical/Behavioral Competency)Must-HaveExtensive hands-on experience with PostgreSQL (v11 and above)....


  • Kolkata, India Tata Consultancy Services Full time

    Greetings from TCS!!!TCS is Hiring for PostgreSQL Database AdministratorRole - PostgreSQL DBARequired Technical Skill Set - PostgreSQL Database AdministratorDesired Experience Range - 10-15 YearsLocation of Requirement - KolkataDesired Competencies (Technical/Behavioral Competency)Must-HaveExtensive hands-on experience with PostgreSQL (v11 and above)....


  • Kolkata, India Tata Consultancy Services Full time

    Greetings from TCS!!!TCS is Hiring for PostgreSQL Database AdministratorRole - PostgreSQL DBARequired Technical Skill Set - PostgreSQL Database AdministratorDesired Experience Range - 10-15 YearsLocation of Requirement - KolkataDesired Competencies (Technical/Behavioral Competency)Must-HaveExtensive hands-on experience with PostgreSQL (v11 and above)....


  • Kolkata, India Tata Consultancy Services Full time

    Greetings from TCS!!!TCS is Hiring for PostgreSQL Database AdministratorRole - PostgreSQL DBARequired Technical Skill Set - PostgreSQL Database AdministratorDesired Experience Range - 10-15 YearsLocation of Requirement - KolkataDesired Competencies (Technical/Behavioral Competency)Must-HaveExtensive hands-on experience with PostgreSQL (v11 and...


  • Kolkata, India Tata Consultancy Services Full time

    Greetings from TCS!!!TCS is Hiring for PostgreSQL Database AdministratorRole - PostgreSQL DBARequired Technical Skill Set - PostgreSQL Database AdministratorDesired Experience Range - 10-15 YearsLocation of Requirement - KolkataDesired Competencies (Technical/Behavioral Competency)Must-HaveExtensive hands-on experience with PostgreSQL (v11 and...


  • Kolkata, India Tata Consultancy Services Full time

    Greetings from TCS!!!TCS is Hiring for PostgreSQL Database AdministratorRole - PostgreSQL DBARequired Technical Skill Set - PostgreSQL Database AdministratorDesired Experience Range - 10-15 YearsLocation of Requirement - KolkataDesired Competencies (Technical/Behavioral Competency)Must-Have- Extensive hands-on experience with PostgreSQL (v11 and above).-...