Senior PostgreSQL Database Specialist

1 week ago


kolkata, India beBeeDatabase Full time

Job Title: Senior PostgreSQL Database SpecialistThis role requires an expert-level understanding of PostgreSQL database management. The ideal candidate will have extensive hands-on experience with PostgreSQL (version 11 and above) and a proven track record of designing and implementing complex database schemas.Key Responsibilities:Design, develop, and maintain high-performance PostgreSQL databases.Implement advanced query tuning and index optimization techniques to improve database performance.Develop and execute backup and recovery strategies to ensure minimal downtime in the event of a disaster.Set up and maintain replication and high-availability configurations using Patroni, repmgr, or Pgpool-II.Implement and manage security controls, including role-based access controls, SSL/TLS encryption, and audit logging.Monitor and maintain database health through routine health checks and maintenance tasks.Plan and execute PostgreSQL version upgrades with minimal downtime and migrate databases from on-premises environments to cloud-based platforms.Required Skills:Expert-level knowledge of PostgreSQL (v11 and above).Experience with database installation, configuration, and upgrades on Linux/Unix platforms.Strong understanding of high-availability setup using streaming replication, Patroni, repmgr, etc.Knowledge of backup and recovery strategies using tools like pgBackRest, Barman.Performance tuning and query optimization skills.Strong knowledge of PL/pgSQL scripting and automation.Experience with database monitoring and alerting tools (e.g., pg_stat_statements, Prometheus, Grafana).Security hardening and compliance skills (role-based access control, SSL, encryption at rest/in-transit).Disaster Recovery planning and execution experience.Capacity planning and data growth forecasting skills.Good understanding of cloud platforms (AWS RDS/Aurora, GCP Cloud SQL, or Azure PostgreSQL).Excellent communication and stakeholder management skills.Preferred Skills:Experience with other databases (Oracle, MySQL, or NoSQL like MongoDB).Knowledge of Infrastructure as Code (Terraform, Ansible).Experience with CI/CD pipelines for database changes.Certifications (optional): AWS Certified Database – Specialty.



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

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


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


  • Kolkata, 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...


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