Responsibilities

 Specifically, the successful jobholder will be required to: 

  • Monitoring performance and managing parameters to provide fast query responses to front-end users ensuring performance of production databases.
  • Monitoring including systems logs, events and event correlation and maintaining performance statistics and setting baseline statistics.
  • Monitoring and managing the high availability components including storage and the underlying infrastructure for mission critical databases.
  • Developing, managing and testing back-up and recovery plans and ensuring that storage, archiving, back-up and recovery procedures are functioning properly.
  • Take lead role in the various I.T. audits in providing necessary information and enforcing closure of audit, change management and compliance issues.
  • Manage key IT risks for all database systems and ensure proper mitigation.
  • Take lead role in BCP and disaster recovery preparedness through periodic testing as scheduled and update of disaster recovery procedures and sharing the results with management.
  • Team up with applications support, development and infrastructure team in the development, implementation, management applications, infrastructure, and monitor system health in order to proactively identify weaknesses and address them.
  • Perform database tasks such as schema design, capacity planning, maintenance, trouble shooting, and change control activities.
  • Considering both back-end organization of data and front-end accessibility for end-users and further refining the physical design to meet system storage requirements.
  • Installing database management systems (RDBMS) using best practice; ensure compliance with RDBMS license agreements and maintain upgrades and critical patches
  • Database setup, configuration and administration of MSSQL, PostgreSQL.
  • Creating and maintaining database documentation, including data standards, procedures and definitions for the data dictionary (metadata) and maintain all technical documentation relating to database management.
  • Communicating regularly with technical, applications and operational staff to ensure database integrity and security.
  • Perform under limited supervision, maintain reliability of data and databases, and assist in developing and implementing standards for database maintenance and configuration.
  • Setting up and testing new database and data handling system 

Qualifications

The successful candidate will be required to have the following skills and competencies:

  • Bachelor’s degree in software engineering, Computer Science, Information Technology, or related discipline, or equivalent.
  • 2 – 3 years in database technology with experience deploying database and data warehousing technologies (e.g. High in production environments.
  • Oracle MSSQL and PostgreSQL with strong SQL and PLSQL skills including data warehouse objects.
  • Skills in Data Integration, Data Warehousing, Business Intelligence, OLAP, and Data mining Familiarity as well with ICT standards such as ITIL, COBIT.
  • Proficiency in various operating systems like Linux & windows.
  • Thorough knowledge on data profiling, data modeling and data validation and associated tools; Skills in Database Sizing, Storage. Performance, and Security Considerations.
  • Strong analytical skills: ability to analyze and correlate complex data and excellent knowledge on the Oracle Technology stack as well as excellent knowledge of ICT system architectures, platforms and Infrastructure.