Job Summary

Skill	Technical Area	Must Have / Good 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.

Skill Requirements

null

Other Requirements

null