SQL Database Assistant: Bloemfontein
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 Category | IT & Telecommunications |