Data Centre: Oracle Database Administrator - Midrand at Nexio

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