Specialist I: Database Administration (P10) (Information & Communication Systems: Enterprise Systems) (Re-advert)
Position Summary
Introduction
The University of Johannesburg (UJ) is a vibrant and cosmopolitan university, anchored in Africa and driven by a powerful strategy focused on attaining global excellence and stature (GES). With an emphasis on independent thinking, sustainable development and strategic partnerships, UJ is an international university of choice. The University is guided by the Vice-Chancellor’s vision of “Positioning UJ in the Fourth Industrial Revolution (4IR) in the context of the changing social, political and economic fortunes of Africa”.
Job description
- Manage user accounts, access privileges, and security settings within the database and application.
- Create and maintain user profiles, roles, and permissions to ensure data integrity and security.
- Grant and revoke user privileges as per business requirements and Oracle EBS user front-end support.
- Assist in identifying and resolving database and application-related issues, such as performance bottlenecks, connectivity problems, and data corruption.
- Collaborate with senior DBA and other IT teams to diagnose and implement appropriate solutions.
- Assist in installing and configuring Oracle database and application software and related tools.
- Identify and address performance issues and bottlenecks through performance monitoring and tuning techniques.
- Assist in optimizing SQL queries, database design, and indexing strategies.
- Monitor the performance and health of Oracle databases and Applications using appropriate monitoring tools.
- Perform routine maintenance tasks such as backup and recovery, data optimization, database tuning and applying patches, troubleshooting issues, and ensuring application availability and reliability.
- Monitor database growth and plan for future capacity requirements.
- Optimize database storage allocation and usage.
- Implement partitioning, compression, and other techniques to maximize database performance and efficiency.
- Review patch release notes, bug fixes, and security enhancements to determine the relevance and impact on the system.
- Plan and schedule patch deployments, considering system availability and minimizing disruption to users.
- Apply patches and updates to the Oracle database and applications software and associated components, following the recommended installation procedures.
- Conduct thorough testing and verification of the patched system to ensure stability and proper functioning.
- Perform application cloning operations to create copies of applications for various purposes, such as development, testing, or disaster recovery.
- Customize the cloned applications to match the target environment, ensuring consistency in application parameters, configurations, and schema objects.
- Test the cloned application to verify its functionality and integrity, addressing any issues or conflicts that arise during the process.
- Maintain accurate and up-to-date documentation of database and application configurations, procedures, and troubleshooting guides.
- Generate regular reports on database and application performance, capacity, utilization, and user activities for monitoring.
- Generate Database and Application health check reports for decision-making purposes.
- Assist in implementing and maintaining security measures, including access controls, encryption, and vulnerability assessments.
- Collaborate with the security team to address security risks and compliance requirements.
- Assist in implementing backup and recovery strategies for Oracle database and applications to ensure data protection and minimize downtime.
- Conduct regular backup tests to verify data integrity and participate in disaster recovery planning and execution.
Minimum requirements
- National Diploma: IT qualification (NQF 6)
- 3 to 5 years experience in IT
- Knowledge of Database Concepts
- Systems Administration Experience
- Effective communication skills
- Ability to solve technical issues
- Collaboration and team skills
- Detailed and Solution Orientated
- Ability to analyze and interpret data
- Research new technologies and trends
- Customer Focus
- Ability to identify and resolve problems
- Discipline Knowledge
- Teamwork – working cooperatively with others, as part of the immediate team, and across functions to meet business objectives.
- Demonstrated ability to work in teams with a collaborative interpersonal style
- Strong analytical, synthesis, and problem-solving skills
- Detail and solution-orientated
- Strong desire to learn and use new technologies
- Positive, proactive and motivated; “can-do” attitude and a team player
- Adjusts to work effectively within new work structures, processes, requirements, or cultures
- Creativity, innovation, and bent for thinking out of the box and learning something new.
Your application, comprising of a detailed Curriculum Vitae as well as the names and full contact details (including telephone numbers and e-mail addresses) of at least three traceable and credible referees must be uploaded before or on the closing date of the advertised post. Please also attach the following: a copy of your highest academic qualification, proof of registration with professional bodies you might belong to and if applying for an academic position, a list of accredited research output and/ or a portfolio of your creative output.
Please note that the University is obligated, in terms of recent amendments to the Criminal Law (Sexual Offences and Related Matters) Amendment Act 2021 (Act 13 of 2021), to assess all prospective employees (including applicants) against the National Register for Sex Offenders (NRSO). The outcome of such an assessment may have an impact upon possible employment with the University.
For more information, please review the following link: Justice/Criminal/NRSO.
If you require technical support / assistance on the UJ e-recruitment website, please contact our service provider PNET on the following contact details: 0861 227337/010 140 3099 or email ujsupport@pnet.co.za.
Candidates may be subjected to appropriate psychometric testing and other selection instruments.
In conjunction to merit on the basis of qualifications, experience and proven achievements the University of Johannesburg is committed to providing equal employment opportunities for persons with disabilities and those individuals from the historically disadvantaged groups. As necessitated by operational requirements the University reserves the right not to make an appointment to positions advertised. If you have not received a response from the University within 8 weeks of the closing date, you should assume that your application has been unsuccessful.
