PostgreSQL SME

Tata Consultancy Services; Kolkata District; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

Tata Consultancy Services in Kolkata seeks a PostgreSQL SME to install, configure and manage PostgreSQL databases. The role requires 4-7 years of experience and hands-on expertise in administration, performance tuning, backup/recovery, and replication.

The candidate will work with cross-functional teams to ensure availability, security, and capacity planning, while documenting SOPs and procedures for operational excellence.

Qualifications

• Strong PostgreSQL database administration experience.
• Ability to tune performance and optimize queries.
• Hands-on backup, recovery, replication and DR processes.

Responsibilities

• Install, configure, administer, and maintain PostgreSQL databases.
• Monitor performance and tune for efficiency.
• Manage backup, recovery, replication, and DR activities.

Skills

PostgreSQL DBA

Performance tuning

Backup & DR

Replication

Monitoring

Linux/Unix

SQL/PLpgSQL

Security & access

HA solutions

Job description

Job Title: PostgreSQL SME

Location: Kolkata
Experience: 4-7 Years

Key Responsibilities

• Install, configure, administer, and maintain PostgreSQL databases.
• Monitor database performance and perform tuning to optimize system efficiency.
• Manage database backup, recovery, replication, and disaster recovery activities.
• Troubleshoot database issues and provide root cause analysis.
• Implement and maintain database security, user access, and compliance standards.
• Support database migrations, upgrades, and patching activities.
• Collaborate with application, infrastructure, and development teams for database-related requirements.
• Create and maintain database documentation, SOPs, and operational procedures.
• Ensure database availability, reliability, and capacity planning.

Required Skills

• Strong experience in PostgreSQL Database Administration.
• Database Performance Tuning and Query Optimization.
• Backup, Recovery, and Disaster Recovery Management.
• PostgreSQL Replication (Streaming Replication, Logical Replication).
• Database Monitoring and Troubleshooting.
• Linux/Unix Administration.
• SQL, PL/pgSQL, and Database Scripting.
• Database Security and Access Management.
• Experience with High Availability solutions.