An AI agent that applies to roles like this on employers' own sites. 25 applications free, no card needed.
AI summary of this job
Beta Read in 10 secondsA Database Developer role at Momentum Services Corp. in Navi Mumbai, Maharashtra for people with 5–7 years of experience. You'll convert complex T-SQL stored procedures from Microsoft SQL Server to PostgreSQL, optimize queries using execution plans, and utilize large language models and AI tools like ChatGPT for code generation.
- Navi Mumbai
- Work from office
- 5–7 years
What you'll do
- Transpile complex MSSQL stored procedures to PostgreSQL functions
- Refactor Linked Server Logic and temporary table usage
- Utilize Large Language Models for code generation
Good fit if you
- Have 5–7 years of experience
- Know T-SQL, PostgreSQL, and SQL
- Demonstrate ability to utilize AI and LLM tools
AI-generated from the job description. Check the full description before you apply.
Job Description
- 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 MSSQLs optimizer.
- Candidates must demonstrate the ability to effectively utilize AI/LLM tools
- Experience analyzing execution plans in PostgreSQL to optimize queries
previously built for MSSQLs 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
Skills
Large Language ModelsAiSqlLlmLlmsChatgptIf a job posting appears fraudulent, asks for payment, contains misleading information, or violates our guidelines, please report it immediately. Our team will review it promptly, Jobaaj does not charge any fee from the applicants.
About Company
Similar Jobs
View allLooking for something similar?
New Data Science Analytics & Machine Learning roles in Navi Mumbai.
One email a day. Unsubscribe any time.

