Job Description
About the Role
We are seeking an experienced Senior Database Developer to join our team in Johannesburg. The successful candidate will be responsible for converting complex MSSQL stored procedures into PostgreSQL functions using PL/pgSQL, ensuring functional equivalence. This role requires a strong understanding of database development, performance optimization, and AI-assisted tools.
Key Responsibilities
- Convert complex MSSQL stored procedures into PostgreSQL functions using PL/pgSQL
- Refactor and eliminate Linked Server (OPENQUERY) logic and four-part naming conventions
- Optimize 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
Requirements
- 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
Qualifications
- None specified
Salary & Benefits
- Not mentioned in the original job description.
How to Apply
Click the green “Go Apply” button below to apply directly online with the employer.
About IT / Computing / Software Jobs in Gauteng
In Gauteng, the IT and computing industry is a significant contributor to the province’s economy, with a steady demand for skilled professionals. Typically, this field is characterized by rapid technological advancements, innovative projects, and a high level of job satisfaction among employees. Generally, career prospects in this sector are strong, with a range of opportunities available across various industries.
Salaries for IT and computing professionals in Gauteng can vary widely depending on factors such as experience, company size, and industry sector. While it is common to see salaries ranging from R400 000 to R1,200 000 per annum, these figures are only a general guideline and actual salaries may differ significantly. For instance, senior executives or technical leads with extensive experience may command higher salaries, while entry-level positions may start at lower levels.
Common skills required for IT and computing roles in Gauteng include proficiency in programming languages such as Java, Python, or C++, knowledge of cloud platforms like AWS or Azure, and experience with agile development methodologies. Additionally, understanding of data analysis and interpretation, cybersecurity principles, and IT project management are often essential. Familiarity with popular software applications, such as Microsoft Office 365 or Google Workspace, is also beneficial.
The financial services sector, technology industry, manufacturing sector, and government departments are among the common industries that employ IT and computing professionals in Gauteng. These sectors require a range of skills and expertise, from data analysis to network administration, making them attractive options for career development.
For those seeking a career in IT and computing, there are numerous opportunities for professional growth and development. Typically, career progression involves moving into senior roles or specialized positions, such as technical lead, solutions architect, or data scientist. Opportunities for further education and training, such as certifications or postgraduate studies, can also enhance job prospects. Generally, a strong understanding of industry trends, networking, and continuous learning are essential for success in this field.
This information provides general career guidance. Actual salaries and requirements vary by employer.
GO APPLY NOW
Safe & secure application process
Explore More Opportunities
Get Similar Job Alerts
Job Seeker Tip
Learn the common software and tools used in your industry - stay current with technology.
How to Apply
Click “GO APPLY NOW” to visit the company’s application page.
Follow their instructions carefully.
JVR Jobs connects you with employers – we don’t process applications directly.
Latest Job Opportunities
Johannesburg: Short-Term Insurance Brokers – Commercial & Personal Lines
Key Responsibilities Build and manage a sustainable new business pipeline Conduct professional needs analyses with prospective clients Convert...
View JobSomerset West: Administrative Assistant
KEY RESPONSIBILITIES: Book and schedule client appointments efficiently. Arrange team logistics and manage daily routes. Handle client queries promptly and...
View JobCenturion: Centurion Pet Chauffeur
Centurion Pet Chauffeur Essential legal requirements: Must be a South African born citizen with a clean criminal background and a…
View JobSouth Africa: Immediately available Bookkeeper â Stikland
REQUIREMENTS Minimum 5 years hands-on bookkeeping experience Strong experience in small to medium-sized business environments Comfortable working in...
View JobDurban: Assistant Store Manager – The Workshop
Are you a results-driven leader with a passion for retail and people development? Join our dynamic team as an Assistant…
View JobSomerset West: Administrative Assistant / Personal Assistant
KEY RESPONSIBILITIES: Manage day-to-day administrative tasks efficiently with attention to detail Answer and respond to emails professionally and promptly,...
View Job
Browse Employers
Job Alerts