PostgreSQL DBA

Tata Consultancy Services; Pune City; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Join a forward-thinking company as a PostgreSQL DBA, where you'll play a crucial role in managing databases across production, staging, and development environments. You will be responsible for implementing backup and recovery strategies, optimizing performance, and ensuring high availability through replication techniques. This role offers the chance to collaborate with cross-functional teams, enhancing database performance while adhering to security compliance. If you're passionate about database management and eager to contribute to innovative solutions, this opportunity is perfect for you.

Qualifications

• 5-12 years of experience in PostgreSQL database administration.
• Strong skills in performance tuning and backup/recovery strategies.

Responsibilities

• Install, configure, and manage PostgreSQL databases in various environments.
• Implement backup, recovery, and performance tuning strategies.

Skills

PostgreSQL Database Administration

Performance Tuning

Backup & Recovery

High Availability & Replication

Security & Compliance

Troubleshooting

Automation & Scripting

Database Design

Education

15 years of full-time education

Tools

PostgreSQL

Job description

TCS has been a great pioneer in feeding the fire of Young Techies like you. We are a global leader in the technology arena and there's nothing that can stop us from growing together.

We are Hiring For PostgreSQL DBA

Job Description

• Experience: 5-12 years

Required Responsibilities

• Database Administration: Install, configure, and manage PostgreSQL databases (versions 11, 12, 13, 14, 15/All Versions) in production, staging, and development environments.
• Backup & Recovery: Implement and manage backup, WAL archiving, and PITR (Point-In-Time Recovery) for data protection.
• Performance Tuning & Optimization: Use EXPLAIN ANALYZE, tuning, and indexing strategies for query optimization.
• High Availability (HA) & Replication: Configure and manage Streaming Replication, Logical Replication for HA clusters.
• Security & Compliance: Manage roles, implement SSL/TLS encryption, role-based access control (RBAC), auditing, and GDPR/security compliance.
• Troubleshooting & Issue Resolution: Analyze logs, resolve deadlocks, replication lag, slow queries, and performance bottlenecks.
• Automation & Scripting: Develop automation scripts for maintenance and monitoring tasks.
• Database Design & Capacity Planning: Support schema normalization, partitioning, and sharding for large-scale deployments.
• Patch Management & Version Upgrades: Apply PostgreSQL minor/major version upgrades and security patches with minimal downtime.
• Cloud & Hybrid Database Management: Manage PostgreSQL databases in on-premises and cloud environments.
• Cross-Team Collaboration: Work with developers, DevOps, and system administrators to optimize database performance and reliability.

Additional Qualifications:

• 15 years of full-time education

Disclaimer: We encourage you to register at www.tcs.com/careers for exploring an exciting career with TCS. Your personal data will be processed for recruitment activities and retained as per our policy. You may request exclusion from communication by contacting careers.tcs.com.

Additional Details

• Seniority level: Mid-Senior level
• Employment type: Full-time
• Job function: Information Technology
• Industries: IT Services and IT Consulting

Referrals increase your chances of interviewing at Tata Consultancy Services by 2x.

Get notified about new Database Administrator jobs in Pune, Maharashtra, India.