Pune, Maharashtra
Job Summary

Skill

Technical Area

Must Have / Positive to Have

Rating (1–5)

Conceptual, Logical & Physical Data Modeling

Database Design

Must Have

5

Entity Relationship (ER) Design

Database Design

Must Have

5

Table Design, Keys & Constraints

PostgreSQL Core

Must Have

5

Normalization & Denormalization Techniques

Database Architecture

Must Have

4

Index Design & Optimization

PostgreSQL Performance

Must Have

5

Advanced SQL (CTEs, Window Functions)

PostgreSQL SQL

Must Have

5

Functions & Stored Procedures (PL/pgSQL)

PostgreSQL Programming

Must Have

4

Triggers & Database-Level Business Logic

PostgreSQL Advanced

Positive to Have

4

Query Optimization & Performance Tuning

PostgreSQL Performance

Must Have

5

Data Integrity, Scalability & Documentation

Database Governance

Must Have

4

Key Responsibilities
To be responsible for providing technical guidance to a team of developers,



enhancing their technical capabilities and increasing productivity.
To conduct comprehensive code reviews, establish and oversee quality assurance processes, performance optimization , implementation of best practices and coding standards to ensure successful delivery of complex projects.
To ensure process compliance in the assigned module| and participate in technical discussions/review as a technical consultant for feasibility study (technical alternatives, best packages, supporting architecture best practices, technical risks, breakdown into components, estimations).
To collaborate with stakeholders to define project scope, objectives, deliverables and accordingly prepare and submit status reports for minimizing exposure & closure of escalations.
body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-

📌 Senior Technical Lead Pune
🏢 HCLTech
📍 Pune