PostgreSQL Database Developer

Tata Consultancy Services; Bengaluru; On-site; INR 2,800,000 - 4,200,000; Full time

Job summary

Tata Consultancy Services in Bengaluru seeks an experienced PostgreSQL Developer to drive database development and optimization. The role emphasizes hands-on work with PostgreSQL, SQL, and PL/pgSQL, including creating procedures, functions, triggers, and materialized views, while optimizing performance.

The candidate will contribute within an Agile environment, leveraging Git and CI/CD practices to deliver robust database solutions.

Qualifications

• 7+ years of hands-on PostgreSQL Database Development experience.
• Strong expertise in PostgreSQL, SQL, and PL/pgSQL programming.
• Experience in creating and maintaining Stored Procedures, Functions, Triggers, Views, and Materialized Views.
• Expertise in query optimization, performance tuning, and execution plan analysis using EXPLAIN ANALYZE.
• Strong knowledge of PostgreSQL architecture, MVCC, WAL, Vacuum, and Autovacuum.
• Familiarity with Git, Agile/Scrum methodologies, and CI/CD practices.

Responsibilities

• 7+ years of hands-on PostgreSQL development responsibilities.
• Optimize queries and analyze execution plans using EXPLAIN ANALYZE.
• Develop and maintain procedures, triggers, views, and materialized views.
• Ensure robust PostgreSQL architecture understanding and maintenance.
• Collaborate within Agile/Scrum teams and CI/CD pipelines.

Skills

PostgreSQL

SQL

PL/pgSQL

Stored Procedures

Functions

Triggers

Views

Materialized Views

Query optimization

Explain Analyze

MVCC

WAL

Vacuum

Autovacuum

Git

Agile

Scrum

CI/CD

Tools

Git

CI/CD

Job description

Role & responsibilities

• 7+ years of hands-on experience in PostgreSQL Database Development.
• Strong expertise in PostgreSQL, SQL, and PL/pgSQL programming.
• Experience in creating and maintaining Stored Procedures, Functions, Triggers, Views, and Materialized Views.
• Expertise in query optimization, performance tuning, and execution plan analysis using EXPLAIN ANALYZE.
• Strong knowledge of PostgreSQL architecture, MVCC, WAL, Vacuum, and Autovacuum.
• Familiarity with Git, Agile/Scrum methodologies, and CI/CD practices.