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
Get references ready before you need them - keep in touch with past managers and colleagues.
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
Germiston: Mechanical Design Engineer posted by Hire Resolve
A leading engineering and manufacturing firm based in Germiston is seeking a talented and driven Mechanical Design Engineer to join…
View JobGermiston: Mechanical Design Engineer posted by Hire Resolve
A leading engineering and manufacturing firm based in Germiston is seeking a talented and driven Mechanical Design Engineer to join…
View JobGermiston: Mechanical Design Engineer posted by Hire Resolve
A leading engineering and manufacturing firm based in Germiston is seeking a talented and driven Mechanical Design Engineer to join…
View JobGermiston: Mechanical Design Engineer posted by Hire Resolve
A leading engineering and manufacturing firm based in Germiston is seeking a talented and driven Mechanical Design Engineer to join…
View JobSomerset West: Support Service Manager posted by Hire Resolve
Are you a seasoned operations leader with a passion for creating seamless internal support environments? A leading company in the…
View JobSomerset West: Support Service Manager posted by Hire Resolve
Are you a seasoned operations leader with a passion for creating seamless internal support environments? A leading company in the…
View Job
Browse Employers
Job Alerts