Database Engineer - SQL Server

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 views

- Collaborate 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.