Postgres DBA - Consultant Technical Lead

Tata Consultancy Services; Bengaluru; On-site; INR 3,500,000 - 7,500,000; Full time

Job summary

Tata Consultancy Services in Bengaluru seeks a Senior PostgreSQL DBA (Consultant Technical Lead) with 9–15 years of experience to lead database operations and strategy. You will guard data integrity, drive performance improvements, and mentor a global team of engineers.

Responsibilities include incident management, automation, DR planning, backups, and migrations across on‑prem and cloud environments. AWS RDS experience is a plus.

Qualifications

• Hands-on with PostgreSQL 12–15 and architecture concepts.
• Experience in PITR, WAL archiving, and backups using PG_DUMP/PG_DUMPALL.
• Proficient in performance tuning and query optimization.
• Experience with RDS for PostgreSQL on AWS is a plus.
• Banking domain familiarity is preferred.

Responsibilities

• Provide round-the-clock PostgreSQL support, handle incidents and requests.
• Automate patch deployments and routine tasks to improve reliability.
• Design scalable database architectures and recommend infrastructure.
• Optimize storage, indexing and query performance across environments.
• Collaborate with developers and admins to enhance operations.

Skills

Incident management

Automation

Performance tuning

Database architecture

Collaboration

POCs for features

Troubleshooting complex problems

Education

Bachelor's degree or higher in CS/IS

Tools

REPMGR

PGBACKREST

pg_repack

pg_crypto

pg_audit

Data Wrapper

pg_bouncer

Job description

Role / Job Summary

Postgres DBA (Consultant Technical Lead)

Years of Experience

9 – 15 years

Key Responsibilities

• Providing round‑the‑clock database support, including handling incidents, requests, and changes.
• Automating regular patch deployments, installations, and other routine tasks.
• Designing and developing scalable database architectures to meet business requirements, along with recommending hardware and network solutions.
• Optimizing data storage, retrieval, and indexing for improved performance efficiency.
• Ensuring data integrity, security, and compliance with industry standards.
• Collaboration with application developers, system administrators and other teams to enhance database operations and support.
• Use of Performance Monitor, optimizing queries, and tracing long‑running queries, blockages, and deadlocks.
• Contribution towards automation of recurrent tasks.
• Ticket reduction through problem management.
• Hands‑on experience of using tools/extensions.
• Account management tasks include creating, deleting, and modifying profiles, as well as managing security and audit control parameters.
• Knowledgeable in index defragmentation, re‑indexing, updating index statistics and query tuning.
• Proficient to manage DR and Resiliency strategies and underlying infrastructure architecture knowledge.
• Proficient in troubleshooting & solving complex performance problems.
• Proficient in managing Patching, Upgrades & Migrations.
• Proficient in monitoring & performance analysis through open source tools.
• Working closely with application developers to optimize database interactions.
• Strong background to conduct proof of concepts (POCs) for new features and enhancements to reduce costs.
• Research and recommend new database technologies through POCs.
• Proficient in documenting database structures, policies, and procedures.
• Awareness to any of 2 public cloud platforms and responsible to integration designs from Tradi environments.
• Responsible for design implementation and manage cloud-based database solutions.
• Manage projects and ensure technical solutions meet business needs. Provide guidance and mentor the team members.
• Proficient in managing migration other databases like MSSQL/Sybase/Oracle to PostgreSQL.

Mandatory Skills and Experience

• Hands‑on experience with database standards and end user applications.
• Experience on PG version – PG 12, PG 13, PG 14 & PG 15.
• Excellent knowledge of PG RDBMS (all versions) architecture & design.
• Excellent knowledge of Architecture, Backup, Recovery (PITTR), Replication & Performance Tuning concepts.
• Experience in Backup and Recovery using PG_DUMP and PG_DUMPALL.
• Experience in setting up WAL archiving, Point in Time Recovery.
• Hands‑on experience of using tools/extensions – REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer.
• Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf (with knowledge on Parameter values).
• Scripting knowledge using Ansible and SHELL.
• Proficient in troubleshooting & solving complex performance problems.
• Proficient in managing Patching, Upgrades & Migrations.
• Proficient in monitoring & performance analysis through open source tools.
• Experience in handling Disaster Recovery tests & exercises.
• Certifications and experience of managing RDS for PostgreSQL on AWS.
• Experience in working on a large‑scale environment (at least 1000 + databases with bigger sizes).
• Working experience in banking domain (preferred).
• Expert knowledge of ITIL processes around Incident, Problem, Change, Quality Management and CSI.
• Exceptional coordination, communication and interpersonal skills to work across global teams and clients.
• Demonstrated ability to analyze, diagnose and assess problems; work with global stakeholders to derive tactical and long‑term solutions as appropriate.
• Demonstrable crisis management skills in a large, globally distributed environment.
• Experience working with or in an automated operation environment.
• Experience managing operations on core & cloud‑based infra environments – ‘AaS platform’ experience ideal.

Preferred Education, Skills and Experience

• Certifications and experience of managing RDS for PostgreSQL on AWS.
• Hands‑on experience of using tools/extensions – REPMGR, PGBACKREST, pg_repack, pg_crypto, pg_audit, Data Wrapper, pg_bouncer.
• Good understanding of configuration files such as Pg_hba.Conf, Postgresql.Conf.
• Experienced in backup and recovery using PG_DUMP and PG_DUMPALL, setting up WAL archiving, Point in Time Recovery.
• Experience in Ansible, Shell / Perl / Python Scripting.
• Proficient in managing Patching, Upgrades & Migrations.
• Proficient in monitoring & performance analysis through open source tools.