SQL Database Assistant: Bloemfontein

Full Time, Permanent
Bloemfontein, Free State
Posted 1 month ago

Salary: R35 000 Basic per month, plus Pension Fund after 3-month probation period

Minimum Requirements:

  • Grade 12
  • Diploma in Information Technology
  • Minimum 3 years working experience as a Database Assistant
  • SQL Database (server) and Query knowledge
  • Knowledge in N+, A+ and C++ Builder will be beneficial
  • Fluent in Afrikaans and English (Speak, read and write)
  • Valid Driver’s License and own reliable vehicle

Duties & Responsibilities:

  • Collaborate with the Chief Data Officer to transform raw data into meaningful visualizations and reports and automate data workflows and processing tasks to improve efficiency and accuracy
  • Conduct data quality assurance and validation to ensure data accuracy and integrity
  • Provide technical support to internal team members and external Samba members
  • Assist in the maintenance of IT infrastructure and networks
  • Assist in conducting research and testing new technologies
  • Customer service
  • Write and optimize basic SQL queries to retrieve data as per project requirements
  • Use SELECT, INSERT, UPDATE, and DELETE statements effectively
  • Develop simple stored procedures, views, and functions under supervision
  • Create ad-hoc reports for stakeholders using SQL
  • Use aggregation functions (SUM, AVG, COUNT, etc.) for summarizing data
  • Understand and write queries using GROUP BY, HAVING, and ORDER BY
  • Assist in maintaining existing database objects (e.g., tables, views)
  • Perform basic data imports and exports using tools like SSMS or flat files
  • Help monitor database size and report growth patterns to the team
  • Test SQL queries to ensure they produce accurate results
  • Debug errors in queries and suggest solutions
  • Assist in validating data integrity during testing phases
  • Work with senior developers to understand project requirements and deadlines
  • Support other team members in data-related tasks
  • Attend and contribute to team meetings to discuss progress and challenges
  • Run and Monitor Scheduled tasks on the in-house application – Checking accounts, pulling in transactions
  • Perform any other tasks given through by management

Job Features

Job CategoryIT & Telecommunications

Apply Online

A valid email address is required.
A valid phone number is required.