Role Purpose

We are seeking an expert-level Database Developer to lead the conversion of

complex T-SQL stored procedures from Microsoft SQL Server (MSSQL) to

PostgreSQL (PL/pgSQL).

Requirements

- 5+ years of experience with T-SQL (MSSQL) & advanced PL/PostgreSQL (v.

5+).

- Experience from MsSQL to PostgreSQL.
- Experience analyzing execution plans in PostgreSQL to optimize queries

previously built for MSSQL’s optimizer.

- Candidates must demonstrate the ability to effectively utilize AI/LLM tools

For Code Generation. This Includes

- Experience analyzing execution plans in PostgreSQL to optimize queries

previously built for MSSQL’s optimizer.

Duties and Responsibilities

KEY ACCOUNTABILITIES/KRAs/KPIs

- Code Conversion: Transpile complex MSSQL stored procedures to PostgreSQL functions (PL/pgSQL), ensuring functional equivalence.
- Refactor Linked Server Logic: Eliminate `OPENQUERY` and four-part naming conventions,



replacing them with direct, high-performance PostgreSQL

queries.

- Temp Table Optimization: Refactor extensive temporary table usage

(`#Temp`) to PostgreSQL-specific implementations (Temporary Tables,

CTEs, or Arrays) to optimize memory usage and execution speed.

- AI-Assisted Development: Utilize Large Language Models (LLMs) and automated SQL translation tools (e.g., ChatGPT, Claude, Ispirer, AWS SCT) to

generate initial code drafts, then manually refine and validate the output.

- Validation: Execute rigorous testing to ensure the converted procedures

return datasets identical to the legacy MSSQL output

As an applicant, please verify the legitimacy of this job advert on our company career page.

- 346021306

📌 Database Developer0-10 (Navi Mumbai)
🏢 Momentum Services
📍 Navi Mumbai