Senior Database Developer

About the position

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