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