ENVIRONMENT:
A forward-thinking Software Specialist seeks a highly meticulous and technically strong Oracle DBA to fill a remote position where your core role will be the day-to-day administration of various Oracle database instances, applications and data loads / batch runs using a variety of functionalities and a range of associated products. You will also be responsible for ensuring the availability and performance of the databases by proactively monitoring and troubleshooting database issues and providing a sustainable solution to the problems within agreed SLA timelines. The ideal candidate must possess a Degree/Diploma in IT or Engineering or any relevant Database Administration Certification, have at least 3 years’ work experience in a similar role including proficiency with SQL, Oracle 11g/12c, UNIX/Linux scripting & ITIL. You will also require exposure to Oracle Http Server, NGINX, Apache and HTTPD including installations and DevOps methodology and tools Jenkins, Git, Nexus, SonarQube, Docker & Podman.
DUTIES:
Database preparation and set-up –
- Maintain databases on test, development, and production environments where applicable.
- Perform data imports and exports.
- Assist with database/data model design.
- Implement the data model required by the application.
- Create schema objects and implementing rules for data integrity.
- Refresh the database objects on test environments to align with the production system.
- Ensure that backups of environment specific data are maintained.
Database administration and analysis –
- Manage incidents, requests and deployments issues within agreed SLA timelines.
- Interface with various specialist groups – Operating system support, Network support, Data Centre Network Security.
- Support and core database administrators to support the platform.
- Maintain stable databases.
- Manage database objects such as tables, indexes, and views.
- Perform routine housekeeping to maintain tablespace sizes by cleaning out historic data that is no longer required.
- Troubleshoot and debug database failures – resolve issues within agreed SLA timelines.
- Monitor databases and raise awareness of any potential issues.
- Monitor and tune database performance.
- Perform database sanity checks and troubleshooting.
- Automate/script routine tasks where possible.
- Assist with capacity planning.
Database and data-related applications –
- Support and maintain applications across multiple databases.
- Deploy application-level database changes to production and non-production databases as required.
- Investigate and fix database and data-related issues.
- Ensure successful completion of batch loads.
- Assist the Development and Test teams as required with troubleshooting during the testing of maintenance releases.
- Perform mock release deployments to prepare changes for delivery to the production system.
- Ensure that the customer change management process is followed when making changes to the production system.
REQUIREMENTS:
Qualifications –
- Degree or Diploma in IT or Engineering or any relevant Database Administration Certification.
Experience/Skills –
- 3-5 Years relevant working experience.
- Best Practice in Database Administration or Application Server; ITIL & Quality Management Principles.
- Proven working experience on Oracle 11g/12c.
- Basic UNIX/Linux scripting and command line experience.
- SQL scripting working experience.
- Project Life Cycle and software development methodologies.
- Exposure to Web Servers e.g., Oracle Http Server, NGINX, Apache and HTTPD including installations.
- Exposure to DevOps methodology and tools (Jenkins, Git, Nexus, SonarQube, Docker, Podman).
- Install, configuration, connection setups and tuning.
- Must be able to work remotely from home.
- Be prepared to work after hours when required and fulfil stand-by duties when required (24/7 on a rotational basis).
- Be prepared to work from the client offices when required.
Advantageous –
- Exposure to Ingres 9.2/11.0 database servers.
- Telecommunications operations knowledge.
- Oracle APEX experience.
ATTRIBUTES:
- Strong problem-solving ability.
- Meticulous.
- Resilient.
- Confident, enthusiastic.
- Excellent communication and listening skills.
- Must be able to work independently as well as be a team player.
- Ability to work under pressure.
While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.
COMMENTS:
When applying for jobs, ensure that you have the minimum job requirements. OnlySA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please e-mail a word copy of your CV to [Email Address Removed] and mention the reference numbers of the jobs. We have a list of jobs on [URL Removed] Datafin IT Recruitment – Cape Town Jobs.
Desired Skills:
- Oracle
- DBA
- Remote