Data Centre: Oracle Database Administrator at Nexio

ROLE PURPOSE

This person will be responsible for leading the DBA team looking after Oracle and MySQL databases for the customer(s) according to best practice. This will include daily administration tasks, checks, reporting, upgrades, patching, etc, within this environment which includes oracle Internet application server (iAS) 10G.

ROLE REQUIREMENT

Additional Information:

• Installation, maintenance and tuning of Oracle and MySQL databases on RedHat Linux & UNIX platforms.
• Installation, configuration, and maintenance of Oracle Application server.
• Implementing backup and recovery strategies and perform data refreshes when required.
• Management of MySQL Master-slave replication.
• Provide 24X7 database administration support for about 90 production databases for clients.
• General database user & schema administration: password management, permissions, creating schemas, tables, procedures etc.
• Ensure stringent database uptime targets are met.
• Create shell scripts for task automation.
• Database security implementation and intrusion detection.
• Perform database upgrades (including applying security patches) for Oracle and MySQL environments.
• Capacity management.
• Performance monitoring and tuning.
• Provide up-to-date documentation of all environments.
• Apply application related patches supplied by 3rd Party vendors, for example Fuelplus, Pegasys & RAPID.
• Ensure seamless disaster recovery by testing and procedures.
• Team leader and mentoring of team members.
• Planning and implementation of projects.
• Oracle and MySQL database migrations to new hardware and new O/S versions.
• automated monitoring solution of Oracle and MySQL databases.
• Involved in set-up and testing of Veritas NetBackup software in conjunction with Oracle Recovery Manager.
• Involved in implementation of new systems for various clients.
• Consolidation of servers to accomplish maintenance and license cost savings.

TECHNICAL / PROFESSIONAL COMPETENCIES

Database Installation and Configuration:

• Install, configure, and upgrade Oracle database software to the latest versions.
• Implement and maintain database security measures to safeguard sensitive data.

Performance Tuning and Optimization:

• Monitor and optimize database performance to ensure maximum efficiency.
• Conduct regular performance analysis and implement tuning strategies.

Backup and Recovery:

• Develop and maintain database backup and recovery procedures.
• Perform regular backups and ensure the availability of recovery mechanisms.

Database Design and Capacity Planning:

• Collaborate with development teams to design and implement database structures.
• Conduct capacity planning to ensure the scalability of databases to meet future growth.

Security Management:

• Implement and manage database security policies, ensuring compliance with industry standards.
• Monitor and analyse database activity to identify and mitigate potential security risks.

Patch Management and Upgrades:

• Stay current with Oracle database releases, patches, and updates.
• Plan and execute database software upgrades as necessary.

Troubleshooting and Problem Resolution:

• Investigate and resolve database-related issues in a timely manner.
• Provide on-call support for critical database incidents.

Collaboration and Documentation:

• Work closely with cross-functional teams to support application development and integration efforts.
• Create and maintain comprehensive documentation for database configurations, processes, and procedures.

QUALIFICATIONS & EXPERIENCE

• Candidate should have a minimum of 8 years or more dedicated Oracle DBA experience.
• Oracle version 9.2 to 19c (or as close too)
• MySQL (version 5.7)
• Oracle Internet Application Server (iAS) 10G
• Experience in working in enterprise-scale environments.
• Shell scripting experience and good SQL, PL/SQL experience as well
• Oracle RAC, ASM, Dataguard, OEM experience
• Good Linux and “Unix” skills and Windows platforms knowledge as well
• Understanding of the integration layers, Applications/OS/Storage & assisting 3rd party and vendors (Developers/Application owners/Oracle)
• Backup and recovery knowledge/experience (RMAN / Veritas NetBackup)
• Good understanding of Security & Compliance
• Experience in Leading a DBA team and mentoring a bonus

LEADERSHIP COMPETENCY REQUIREMENTS

• Exceptional team management skills.
• Excellent verbal and written communication.
• Ability to delegate efficiently.
• Extensive industry knowledge with an eye towards the future.
• Diplomacy And Patience
• People Skills
• Strategic Thinking
• Listening
• The Ability to Set And Execute the Vision of the Company

Location: Midrand, Gauteng

Closing Date:  29 February 2024

 

HOW TO APPLY

Click Here to Submit your CV and Application on Company Website