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
Good to Have
4
Query Optimization & Performance Tuning
PostgreSQL Performance
Must Have
5
Data Integrity, Scalability & Documentation
Database Governance
Must Have
4
Key Responsibilities
1. To be responsible for providing technical guidance to a team of developers,
enhancing their technical capabilities and increasing productivity.
2. 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.
3. 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).
4. 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