Data Centre: Oracle Database Administrator

**ROLE PURPOSE**

**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.
- Capacity management.
- Performance monitoring and tuning.
- Provide up-to-date documentation of all environments.
- 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**:

- Create and maintain comprehensive documentation for database configurations, processes, and procedures.

**QUALIFICATIONS & 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