Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Home
>
Jobs in kolkata
>
Tata Consultancy Services
>
PostgreSQL Database Administrator

PostgreSQL Database Administrator

Tata Consultancy Services

10 - 15 years

0 Lacs

kolkata west bengal india

Posted:3 days ago| Platform:

Apply

Skills Required

postgresql database installation configuration linux unix replication backup strategies tuning query optimization scripting automation monitoring security compliance encryption rest planning data forecasting aws gcp sql azure communication management oracle mysql nosql mongodb kubernetes code terraform ansible server clustering sharding logical capture network collaboration certifications architecture design analyze resolve test controls audit logging maintenance checks

Work Mode

On-site

Job Type

Full Time

Job Description

Greetings from TCS!!!

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

More Jobs at Tata Consultancy Services

Tcs Hiring For GRC , Pan India

Pune, Bengaluru, Mumbai (All Areas)

7 - 12 yrs

INR 9 - 19 Lacs

Java / Spring boot with API Developer

Pune

5 - 10 yrs

INR 9 - 19 Lacs

SAP PP and QM Consultant

Pune

4 - 9 yrs

INR 8 - 18 Lacs

SAP BTP Consultant

Pune

4 - 9 yrs

INR 9 - 19 Lacs

Customer Service Associate

Pune

1 - 6 yrs

INR 1 - 5 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

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.