The founding of Metropolitan dates to as early as 1898 and Momentum traces its roots to being established in 1966. Momentum Group was formed from the merger of Metropolitan and Momentum, two sizeable and diverse insurance-based financial services companies in South Africa and was listed on the Johannesburg Stock Exchange on 1 December 2010.
In order to grow its international footprint and diversify its revenue streams, Momentum Group actively pursues financially viable opportunities across the world. Aditya Birla Health Insurance Company Limited, a joint venture with Aditya Birla Capital Limited, was incorporated in 2015 and was our first expansion into India.
Having experienced India first-hand as a hub of both talent and chance, we set up Momentum Services in 2017, a wholly-owned Mumbai-based global in-house centre to leverage IT, ITES and Business support services to all our businesses worldwide.
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).
Duties & 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
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.
Competencies
Mandatory Skills:
? Deep SQL : 5+ years of experience with T-SQL (MSSQL)
and advanced PL/PostgreSQL (v. 5+). Must understand
complex data types, dynamic SQL, and set-based logic.
? Migration Experience: MsSQL to PostgreSQL.
? "AI-Literate" Development: Candidates must demonstrate the ability to effectively utilize AI/LLM tools for
code generation. This includes:
o Prompt Engineering: The ability to break down complex
logic into specific prompts to get accurate results.
o Critical Review: The capability to audit AI-generated code
for syntax errors, security flaws, and performance bottlenecks rather than blindly accepting the output.
? Performance Tuning: Experience analyzing execution
plans in PostgreSQL to optimize queries previously built
for MSSQL’s optimizer