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