Directorate: Information
Communication Technology
Position: Database Administration Manager
Ref: NCWSC2012-008
Location: Headquarters - Kampala Road Industrial Area
Grade: 3
Reporting to: ICT DirectorPosition: Database Administration Manager
Ref: NCWSC2012-008
Location: Headquarters - Kampala Road Industrial Area
Grade: 3
Supervises: Database Administration Coordinators and Officers
Broad Role: The Database Administration Manager (DBAM) is responsible for the performance, integrity and security of the Companies database. Additional role requirements are likely to include planning, development and troubleshooting.
Duties and responsibilities
- Organization’s
database server administration
- Assist
in the selection, installation, qualification, testing and validation of
enterprise database systems and applications
- Design
and develop databases, database users and database security and other
database objects. Maintain version control of custom database objects and
assist with the creation of entity relationship and modeling diagrams for
new custom databases
- Create
and maintain jobs/scripts with automated scheduling alerts, configuration
and monitoring for all current and future databases. Responsible for
monitoring the status of scheduled backups and database jobs
- Responsible
for database security and the analysis and application of database patches
and upgrades to database servers and components
- Optimization
and performance tuning for all current and future databases and assisting
the application team with application performance tuning
- Work
with the Information Security Office to ensure compliance. Participate in
audits by maintaining the necessary logs and providing reports or extracts
to the qualified resources as requested for the audits
- Perform
imports, exports and data conversion from one system to another as needed.
Migrate between database platforms as necessary
- Participate
in designing, setting up, implementing and testing business continuity and
disaster recovery installations
- Installing
and testing new versions of the database management system (DBMS).
- Ensuring
that storage, archiving, back-up and recovery procedures are functioning
correctly
- Communicating
regularly with technical, applications and operational staff to ensure
database integrity and security
- Oversee
backup, clustering, mirroring, replication and failover
- Implement
mechanisms for the restoration and recovery of databases
- Provide
24/7 support for critical situations.
Education, Professional Qualifications and Work Experience
- Degree
in ICT or related field and/or relevant professional certification
preferably Oracle Certified Professional (OCP)
- At
least 5 years experience in data base administration or data base
development
- Experience
of managing multiple RDBMS on large systems
- Practical
experience in monitoring and tuning a database to provide a high
availability service
- Practical
experience in managing the internal and external MS SQL database security
- Experience
of Transactional SQL, and DTS stored procedures.
Required Skills and Competencies
- Strong
self-sufficiency and initiative working on Database projects
- A
proven track record of driving and defining complex IT strategy
- Exceptional
communication skills are essential in order to explain complex IT concepts
to non technical colleagues
- In
depth experience of negotiating with and managing third parties
- Ability
to work under pressure and meet deadlines.
- Knowledge
of applicable data privacy practices and laws.
The Manager
Human Capital Advisory Services
The Kenya Institute of Management
P.O Box 43706 00100,
Nairobi Kenya
or dropped at
The Kenya Institute of management
2nd floor, Luther Plaza
Uhuru Highway/Nyerere Rd Roundabout
Only short listed candidates will be contacted.
Canvassing will lead to automatic disqualification.
Nairobi City Water & Sewerage Company (NCWSC) is an equal opportunity employer.