Job Description :
- Design, develop, and maintain PostgreSQL databases and related applications, ensuring adherence to best practices and industry standards.
SQL and PL / pgSQL Expertise :
Develop and optimize SQL queries, stored procedures, functions, and triggers using PL / pgSQL.Analyze and convert complex SQL Server stored procedures and functions to PostgreSQL, including built-in functions and procedural logic.Design and implement secure, optimized, and scalable SQL queries.Manage and optimize database performance using :
Indexes (clustered / non-clustered)Temp tables, in-memory tables, and materialized viewsCollaborate with development teams to integrate database logic with application architecture.Document converted procedures, security implementations, and optimization strategies.Follow and enforce database best practices, coding standards, and security protocols.ref : hirist.tech)