Postgresql Database Administrator (Chennai)

Postgresql Database Administrator (Chennai)

17 Nov
|
Tata Consultancy Services
|
Chennai

17 Nov

Tata Consultancy Services

Chennai

Open Position- PostgreSQL DBA

Exp- 10+ years

Location- Chennai

Job Requirements*

- Deep knowledge of PostgreSQL architecture, internals, configuration parameters, and common system tables
- Expertise in identifying and troubleshooting performance issues, including query optimization, indexing strategies, analyzing execution plans, and managingautovacuumsettings and concurrency
- Hands-on experience with high-availability solutions (e.g., streaming replication,repmgr,pgpool,efm), backup strategies, and Point-In-Time Recovery (PITR) with tools likepg_dump,pg_restore, andpgBackRest
- Proficiency in day-to-day operations, including installation, configuration, minor and major version upgrades, patching, and routine maintenance tasks likeVACUUMandANALYZE
- Experience deploying and managing PostgreSQL databases in cloud environments such as GCP
- Solid scripting skills (e.g., Unix shell, Python,



PL/pgSQL) for automating maintenance, deployment, and monitoring tasks, with a preference for infrastructure-as-code tools like Ansible or Terraform

Key Responsibilities*

- Administering multi-terabyte, mission-critical databases in high-volume, 24x7 environments
- Leading complex database migration projects, often from other systems like Oracle to PostgreSQL
- Collaborating with development teams on schema design, query optimization, and implementing database security best practices
- Planning for capacity, forecasting future needs, and implementing scaling measures
- Participating in on-call support rotations and leading incident management and troubleshooting efforts

📌 Postgresql Database Administrator (Chennai)
🏢 Tata Consultancy Services
📍 Chennai

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: postgresql database administrator (chennai) / chennai

Subscribe to this job alert:

Get the latest job offers by email for: postgresql database administrator (chennai) / chennai