Senior Database Developer

Recruiter:

Psybergate (Pty) LTD

Job Ref:

PR000736/RN

Date posted:

Monday, February 9, 2026

Location:

Johannesburg, South Africa

Salary:

Monthly

SUMMARY:
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.

POSITION INFO:

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:

Similar jobs you might be interested in:

Senior Database Developer
Location: Johannesburg
Salary: Monthly
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.
Today

Senior Database Administrator (DBA)
Location: Johannesburg
Salary:
30 days ago

Graduate Software Engineer
Location: Centurion
Salary:
Kick-start your development career in a real-world, production environment working on modern surveillance systems. This is a hands-on graduate role where you’ll gain exposure to live systems, modern tech, and experienced developers who actually want to teach you.
3 days ago

Full Stack C# Developers
Location: Johannesburg
Salary: Monthly
I am currently working with experienced Full Stack C# developers who have a stable career track record, a completed degree, and hands-on experience with modern front-end frameworks and languages. My clients range from established enterprises to innovative technology-driven organisations, all offering opportunities to work on modern, scalable systems using C#, .NET, and contemporary front-end techn...
3 days ago

Senior DevOps Developer
Location: Centurion
Salary: 700000.00 Annually
POSITION: senior DevOps developerTYPE: Permanent, Full TimeLOCATION: Fully Remote (Head Office: Centurion)EXPERIENCE: 5 - 10 YearsREMUNERATION: Market-related (Approximately R700 000 – R850 000 per annum)CV SUBMISSION DEADLINE: 10 February 2025ROLE OVERVIEW:A strong background in the financial investment and insurance domain is essential. This exciting full-time opportunity requires 5–...
4 days ago

Python Developer
Location: Johannesburg
Salary: Monthly
We are seeking a highly motivated and proactive individual to join a dynamic, fast-growing start-up. The ideal candidate is passionate about technology, coding, and software development, thrives in a collaborative environment, and is committed to delivering high-quality results. Strong attention to detail, excellent communication skills, and the ability to meet deadlines are essential for success ...
4 days ago

Front-End Developer
Location: Johannesburg
Salary: Annually
Seeking a Front-end Engineer with strong expertise in React or Angular, with hands-on experience integrating AI / LLM Powered into web applications. With combined UI engineering skills with the ability to work with modern AI Frameworks, APIs and prompt engineering techniques.
5 days ago

Senior Full Stack Developer
Location: Centurion
Salary: Market Related Salary
senior, Full, Stack, developer
7 days ago

Senior Software Engineer
Location: Johannesburg
Salary:
A dynamic leadership role driving the design, development, and delivery of complex software projects. You’ll architect scalable solutions, write clean and efficient code, mentor junior developers, and collaborate across teams to ensure high-quality products. With expertise in C#, MAUI/Xamarin, SQL, and modern web technologies, you’ll shape robust software architecture, solve challengin...
14 days ago

Full Stack Software Developer
Location: Johannesburg
Salary:
14 days ago