Job Description

KINDLY TAKE NOTE: Applications may only be submitted online through the official UFS vacancy website: https://ufs.hua.hrsmart.com/hr/ats/JobSearch/viewAll - Applications submitted through any other platform will not be considered.
Please ensure that all relevant documentation is attached to your application. INCOMPLETE APPLICATIONS WILL NOT BE CONSIDERED.

• A detailed curriculum vitae and cover letter.
• Copies of qualifications (please provide the SAQA accreditation in the case of foreign qualifications).
• A copy of your identity document (ID).
• Proof of registration with a Professional Body (if applicable).
• A copy of your driver's license (if applicable).
• A service record of your current employer / last employer (only applicable to external applicants).

Duties and responsibilities:

• Technical development and implementation of databases.
• Consolidate and optimise available data warehouse infrastructure.
• Design and implement ETL procedures for intake of data from both internal and outside sources, as well as ensure data is verified and quality is checked.
• Design and implement ETL processes and data architecture to ensure the proper functioning of analytics lad, as well as client's or third-party's reporting environments and dashboards.
• Carry out monitoring, tuning and database performance analysis.
• Perform the design and extension of data marts, Metadata and data models.
• Ensure that all the data warehouse architecture codes are maintained in a version control system.
• Design and implement warehouse database structures.
• Create the database and database objects such as the tables, tablespaces, synonyms, views, triggers, stored procedures, defaults, domains and indexes.
• Analyse, review and write applications and programs based on customer needs and requirements.
• Conduct analysis of customer needs and develop solutions to software challenges.
• Assist with querying and extracting data from large databases.
• Produce data reports from complex data sets.
• Maintain confidentiality of work-related information and materials.
• Design and develop reports and analytics capability.
• Liaise with the data quality manager to identify and resolve data issues through the configuration of data cleansing and de-duplication software.
• Manage the database aspects of the reporting and analytics platform(s) to ensure that reporting jobs are successfully run and analytics data aligns with timeliness/completeness requirements.
• Liaise with database administrators to ensure that the data warehouse is tuned for optimal performance.
• Liaise with business analysts and project managers to develop and refine reporting and analytics requirements.
• Ensure that all technology solutions are properly architected and specified.
• Evaluate code to ensure its validity and operability.
• Ensure coding structures to predefined architecture.
• Build and maintain reusable code libraries.
• Code development in pre-defined coding languages that align with UFS development needs.
• Optimise applications in terms of speed, scalability, and operability.
• Work overtime as and when required.
• Transform design and user interface mock-ups into functional web applications and systems powered by CMS.
• Ensure that HTML / CSS is cross-browser and standards compliant and meets accessibility requirements.
• Integrate web applications and custom systems with existing applications on campus or third-party/open-source platforms.
• Resolve and or escalate issues in a timely fashion.
• Integrate data from various back-end services and databases.
• Determine technical requirements.
• Evaluate codes to ensure that it is valid, properly structured, meet industry standards and are compatible with browsers, devices, or operating systems.
• Ensure that all user input is validated before submitting to the back end.
• Manage timelines.
• Inform the supervisor of risks to projects.
• Code testing for sign-off.

Inherent requirements:

• A B.Sc. degree in Information Technology/ B.Tech. degree in Information Technology/ B.Com. degree in Information Technology/related B. degree on NQF level 7.

or xe2x80xa2 A 3-year National Diploma in Information Technology on NQF level 6.

• Two (2) years relevant working experience related to the duties and responsibilities.

Recommendation:

• Three (3) to four (4) years relevant experience.
• A minimum of three (3) years relevant experience in code development, data design, modelling and application/ implementation.
• Experience in web application development and restful technologies.
• Advance computer skills.
• Exceptional knowledge of Standard Web Languages like:

- HTML
- CSS
- JavaScript
- JQuery
- Bootstrap
- XML
- JSON
- .NET 4.5+ and .NET Core 3+
- C#
- T-SQL / SQL

• Exceptional knowledge in Main Development Languages like (but not limited to) C#.
• Exceptional knowledge of Database Technologies in MSSQL and Oracle SQL
• Knowledge of relational database systems, Object Oriented Programming, and web application development.
• Knowledge and experience in Development Frameworks like Entity Framework, MVC, .NET Core
• Background in creating complex stored procedures and SQL scripts.
• Knowledge of other SQL languages

- MariaDB
- Snowflake
- MySQL
- PostgreSQL

Competencies

Required competencies:

• Results Orientated:

- The ability to stick with tasks, not give up, and overcome obstacles in completing one's task.
- The ability to be reliable, responsible, dependable and to fulfil obligations.
- The ability to deal calmly and effectively with high stress situations.

• Strategic Thinking:

- The ability to deal with several activities at a time.
- The ability to carefully analyse information and use logic to address issues and problems at work.

• Business Acumen:

- The ability to adhere to rules and strictly follow work regulations.
- Proficient in using MS Office.

• Leading:

- The ability to be cooperative with others, display a good-natured attitude, and encourage people to work together.

• Building Coalitions:

- The ability to make decisions through consultation, collaboration, and working with close supervision.

Assumption of duties:
1 November 2023.

Closing date:
10 September 2023.

Salary:
The annual remuneration package, including benefits, is R 478,943.67 - R 582,283.31 per annum, depending on the budget available for the position, relevant work experience and qualifications.

Fringe Benefits:
(Subject to specific conditions): pension scheme, medical aid scheme, group life insurance, housing allowance, leave and sick leave, service bonus and study benefits.

Enquiries:
For enquiries, please feel free to contact me at 051 401 2979 or email at JardineS@ufs.ac.za or Recruit@ufs.ac.za. Additionally, kindly contact 051 401 9810 / 9813 / 9814/ 9848 for assistance.

General:

The UFS is a designated employer and is committed to the pursuit of excellence, diversity, and redress in achieving its equity targets in accordance with the Employment Equity Plan of the University and its Employment Equity goals and targets. Preference will be given to candidates from the under-represented designated groups, including candidates with disabilities. Our Employment Equity Policy is available at : https://ufsacza.sharepoint.com/:b:/r/sites/supportservices/hr/Employment Equity/EEA13_EE Plan UFS 1 March 2022 (003).pdf?csf=1&web=1&e=TjtoXH

The University processes personal information in line with its obligations under the Protection of Personal Information Act (POPIA) and any personal information provided to the University will be treated as confidential and processed in accordance with the rights provided to data subjects under POPIA.

The UFS reserves the right to not fill this post. The UFS will only consider applications of candidates who meet all the inherent requirements of the position. Applications that are incomplete will not be considered. Communication will be limited to shortlisted candidates only. Should you not be contacted within six weeks of the closing date for applications, you may assume that your application was unsuccessful.

University of the Free State