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.
