Group Database Administrator at CIC Insurance

PURPOSE:

• Reporting to the ICT Infrastructure Manager, the role holder will be responsible for recommending, implementing, and monitoring system databases as well as providing support to application system administrators and implementing best practice and procedures to manage company’s data and Information. They will provide DBA support for production, development, and test Database environments and resolve database performance issues. Maintain end-to-end responsibilities for the databases (Oracle, MS SQL Server, MySQL and PostgreSQL).

PRIMARY RESPONSIBILITIES:

• Responsible for installation, configuration, optimization, tuning, upgrade & maintenance of database instances including maintaining database backup and recovery infrastructure both on premise and offsite to meet Business Data Recovery objectives,
• Management of project implementation tasks and administering of Oracle Fusion Middleware (WebLogic, BI, ODI, Audit Vault, Database firewall), including patching and cloning WebLogic domains.  Manage and support high performance, highly available and mission critical database platforms (Oracle, MS SQL Server, MySQL, PostgreSQL, MariaDB) for the Insurance core applications and other systems.
• Working with both Internal and External auditors to ensure database systems adhere to the Company policies and licensing requirements and promptly addressing any violations raised and overseeing continuous service level improvement initiatives associated with core processes and mission-critical systems.
• Review and design database structures, Oracle RAC, Oracle Data Guard, ASM, SQL server transactional replication and MySQL group clusters to support business requirements including logical and physical database modelling.
• Implement and perform database backup and recovery strategies that meet recovery and availability requirements
• Making requested changes, updates and modifications to database structures and Migrating approved database changes from test into production environments, ensuring IT Change Management policies are adhered to.
• Manage and support Enterprise Data warehouse including the development of reports from the data warehouse platform
• Works with various teams to ensure that the associated hardware resources allocated to the databases and to ensure high availability and optimum performance
• Implement database security policies that are consistent with CIC group security policies.
• Implement best practices and incorporate them in DBA procedures

Key Skills, Knowledge, Experience and Behavioural Competencies

Academic and Professional Requirements

• Education    Bachelor’s Degree    ·        Bachelor’s degree in an ICT related field

Experience Required:

 Description    Required years of experience

• Relevant experience    Minimum of five (5) years relevant experience in database administration

Professional Qualifications;

• OCP/OCA database certification(s) will be an added advantage.
• In-depth knowledge of Linux/Unix and Windows server Operating systems.
• Strong knowledge of high availability configurations, clustering technologies.
• Good knowledge of WebLogic, Business Intelligence, ODI, IIS, Audit Vault, Database firewall and databases (Oracle, MS SQL Server, MySQL, PostgreSQL).
• Strong Knowledge of backup appliances such as Veritas NetBackup including backup and restore procedures for both databases and file systems will be an added advantage.
• Good working knowledge of server virtualized environment (VMWare & Oracle VM Manager)