Directorate: Information Communication Technology
Position: Database Administration Manager
Ref: NCWSC2012-008
Location: Headquarters - Kampala Road Industrial Area
Grade: 3
Reporting to: ICT Director
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.
Interested candidates holding the necessary requirements are encouraged to send their hard copy application with clear reference of the job code on the envelope, detailed CV, names and contact of 3 referees, one of whom must be a former employer, copies of certificates, testimonials, current telephone number and email address on or before March 5 , 2012 to the address indicated below.
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.
Position: Database Administration Manager
Ref: NCWSC2012-008
Location: Headquarters - Kampala Road Industrial Area
Grade: 3
Reporting to: ICT Director
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.
Interested candidates holding the necessary requirements are encouraged to send their hard copy application with clear reference of the job code on the envelope, detailed CV, names and contact of 3 referees, one of whom must be a former employer, copies of certificates, testimonials, current telephone number and email address on or before March 5 , 2012 to the address indicated below.
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.