Psybergate is an IT company that builds bespoke software solutions and provides highly skilled resources to its clients.

We are looking for a Senior Database Developer to join our client on a remote contract role.
What you will be doing:

  • Convert complex MSSQL stored procedures into PostgreSQL functions using PL/pgSQL, ensuring functional equivalence.
  • Refactor and eliminate Linked Server (OPENQUERY) logic and four-part naming conventions, replacing them with high-performance PostgreSQL queries.
  • Optimise extensive temporary table usage by redesigning logic using PostgreSQL temporary tables, CTEs, or arrays.
  • Leverage AI-assisted development tools (LLMs and SQL translators) to generate initial code drafts and refine them into production-ready solutions.
  • Perform detailed validation and testing to ensure migrated procedures produce identical outputs to the legacy MSSQL implementation.
  • Analyse and optimise PostgreSQL execution plans to improve query performance.
  • Simplify legacy logic by leveraging locally available PostgreSQL data instead of remote data calls.

What we are looking for:

  • 5+ years’ experience working with T-SQL (Microsoft SQL Server).
  • Strong hands-on experience with PostgreSQL and PL/pgSQL.
  • Proven experience migrating database logic from MSSQL to PostgreSQL.
  • Strong understanding of dynamic SQL, set-based logic, and complex data types.
  • Experience refactoring legacy SQL patterns into modern, performant database solutions.
  • Ability to effectively use AI/LLM tools for code generation, including:
    • Prompt engineering to translate complex logic.
    • Critical review of AI-generated code for correctness, security, and performance.

  • Solid experience with query performance tuning and execution plan analysis in PostgreSQL.
  • Strong problem-solving skills and attention to detail.
  • Ability to work independently in a remote environment.

Please note if you do not hear from us within 3 weeks, consider your application unsuccessful.

Follow for the Latest Vacancies
Join Psybergate Careers Channel here: Psybergate Careers

Desired Skills:

  • SQL
  • MSSQL
  • PostgreSQL Migration
  • Microsoft SQL Server
  • T-SQL
  • Database Migration

Learn more/Apply for this position