6 months contract
Purpose:
- To provide a stable and secure production database environment which performs in alignment with predefined standards and is recoverable in case of hardware failure or disaster situations.
- To provide technical expertise and guidance to junior Database Administrators.
- Database Optimization
Qualifications / Experience:
- 3 years’ experience in the administration of Oracle databases. Alternatively, 5+ years’ experience in administration of other databases.
- Oracle, AWS or Azure cloud experience/certification, 1+ years, advantageous.
- Relevant Diploma or Degree in Information Technology or Computer Science or similar
- Alternatively, Grade 12 (NQF 4) with relevant IT certification
- Oracle 12c and higher certification desirable / advantageous
Duties:
- Data Base optimisation
- Compile and maintain the integrity of a Configuration Management Data Base in alignment with the Bank’s standards and using the Bank’s prescribed systems.
- Utilise the Bank’s Remedy system for request, incident and problem handling, rectifying and implementing preventative actions as and when required.
- Continuously monitor performance, analyse trends and tune database for optimum performance and record and build a known error database (KEDB) for Problem Handling (R&D).
- Build and maintain a network of support structures e.g. vendors, employees, user groups etc. for consultation purposes.
- Continuously stay abreast with the latest release versions and ensure approval of new versions through a user’s acceptance testing (UAT).
- Quality assurance (QA) process; design and execute a release implementation plan; maintain the Definitive Software Library (DSL); and install, maintain and report license issues as and when they occur.
- Continuously monitor and report on space utilisation, execute trend analysis, alerts and escalation; monitor memory utilisation and Central Processing Unit (CPU) at all times.
- Devise monitoring methodology and processes, utilise the appropriate toolsets and report on the availability or uptime.
- Identify, propose and implement appropriate toolsets for an effective back[1]up strategy to ensure continuity of services and monitor the back-up strategy on a continuous basis. Validate a DR Plan for the data base(s) under the data centre management, consider the replication, snapshots or remote copy as applicable.
- Checking Things; Examining Information; Exploring Possibilities; Following
- Procedures; Interacting with People; Managing Tasks; Meeting Timescales;
- Producing Output; Providing Insights; Team Working; Upholding Standards.
Desired Skills:
- Oracle DBA
Desired Work Experience:
- 2 to 5 years
Desired Qualification Level:
- Diploma