Database Administrator Job Vacancy at Invest & Grow (IG) Sacco Society Limited
💼 This is a job posting
Job Ref: 1126
Stand out: get a tailored cover letter in 60 seconds
We’ll auto-fill the job title and employer, and format it professionally for you.
Overall Responsibility.
The Database Administrator will ensure performance monitoring and management of database, data
warehouse components, supporting infrastructure and general ICT systems.
Key Responsibilities.
- Installing database management systems (DBMS) using best practice; ensure compliance
with DBMS license agreements and maintain upgrades and critical patches.
- Monitor database performance, identify bottlenecks, and implement optimization strategies
i.e indexing and query tuning to ensure efficient data access.
- Implement and manage database security, including user access control, roles, permissions,
and encryption, in line with security policies and regulatory requirements.
- Monitoring including systems logs, events and event correlation, maintaining performance
statistics and setting baseline statistics.
- Monitoring and managing the high availability components including RAC, Data guard,
RMAN, ASM and the underlying infrastructure for mission critical databases.
- Take lead role in the various I.T. audits in providing necessary information and enforcing
closure of audit, change management and compliance issues.
- 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.
- Conduct user training and provide information on revised and new applications.
Minimum Requirements.
- Bachelor’s degree in Computer Science, Software Engineering, Information Technology or
related discipline from a recognized institution.
- A minimum of three (3) years in database technology with experience deploying database
and data warehousing technologies (e.g. High Availability, Real Application Clusters,
ESBU Backups, Partitioning, Oracle DataGuard) in production environments.
- Oracle DBMS 11g/12c OCP certification as well as strong SQL and PLSQL skills including
data warehouse objects such as partitioning and materialized views.
Desired Skills and Competencies.
- Skills in Oracle DBMS 19c.
- Skills in Oracle Engineered Systems e.g. Oracle SuperCluster, Exalytics, Exadata Storage,
ZFS storage and SmartScan.
- Skills in Data Integration, Data Warehousing, Business Intelligence, OLAP, and Data
mining as well Familiarity with ICT standards such as ITIL, COBIT.
- Proficiency in various operating systems like AIX, Solaris, 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.