Tcs Hiring For Database Architect|| Chennai || 25-Sep-26

Dear Candidate,
Greetings from TATA Consultancy Services.
Thank you for expressing your interest in exploring a career possibility with the TCS Family.

We are delighted to invite you for a discussion to get to know more about you and your professional experience. The interview will be in person.

At this interview you will have a technical discussion followed by a management & HR round*. Feel free to ask any questions you may have about our hiring process, the position, or our company.

TCS is hiring for Database Architect Position.

Chennai Location.

Interview date : 25 -Sep-26 (Friday).

Experience Range : 15 years to 20 years. 
Mode: Virtual Interview.

Please find the below JD

. PostgreSQL Administration (Expert): 10+ years hands-on PostgreSQL 12/14/16 administration server configuration (postgresql.conf, pg_hba.conf), object lifecycle management, extension ecosystem (pg_partman, pg_cron, PostGIS, pgvector), and storage internals (TOAST, fsync, checkpoint tuning).

2. PostgreSQL High Availability & Replication: Deep expertise in streaming replication, logical replication (pgoutput/wal2json), synchronous_commit tuning, Patroni + etcd/Consul for automated failover, pgBouncer/PgCat connection pooling, and Citus for horizontal sharding.

3. PostgreSQL Performance Engineering: Expert-level query plan analysis using EXPLAIN (ANALYZE, BUFFERS, FORMAT JSON), index design strategies (B-tree, GIN, GiST, BRIN, partial, covering, expression), pg_stat_statements, auto_explain, lock/deadlock diagnostics, and work_mem / parallel query tuning.

4. PostgreSQL Backup & PITR: Production ownership of pgBackRest and/or Barman for full, incremental, differential backups with WAL archiving. Designing and testing PITR recovery scenarios with documented RTO/RPO SLAs. Experience with pg_basebackup and streaming base backup automation.

5. Google Cloud Spanner Administration: Hands-on experience provisioning, configuring, and managing Cloud Spanner instances (regional, multi-regional). Proficiency with Spanner SQL dialect, DDL management, schema design with interleaving and parent-child table relationships for locality optimization.

6. Cloud Spanner Performance & Scaling: Deep understanding of Spanner's TrueTime architecture, external consistency, and 2PC distributed transactions. Expertise in hotspot avoidance (UUIDs, bit-reversal, shard keys), query profiling

  Note : EX-TCS Employees are not eligible. 

Interested Candidate Please share the below Details:

1. Total Exp :

2. Relevant Exp:

3. Contact No. :

4. Current CTC :

5. Expected CTC:

6. Current Location :

7.  Agree with work Location :

8. Notice period :

9. Current Company :

10. Highest Qualification :       (Regular/Part Time): 

11. Any Gap (How Many Years) :

12. Duration of Gap:

13. Have you Earlier worked with TCS(Yes /No) :

Thanks & Regards,

Tripti Dhyani

Human Resources Talent Acquisition Group

Mail to:  tripti.dhyani@tcs.com