About
Responsibilities
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.
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.
Prompt Engineering:
The ability to break down complex logic into specific prompts to get accurate results.
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 MSSQLs optimizer.
Experience
5+ years of experience with T-SQL (MSSQL) and advanced PL/PostgreSQL (v. 5+).
Experience from MSSQL to PostgreSQL.
Experience analyzing execution plans in PostgreSQL to optimize queries previously built for MSSQLs optimizer.
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job comes from a TieTalent partner platform. Click "Apply Now" to submit your application directly on their site.